ACCESS FEED: Re: [MS_AccessPros] Report building problem

Jumat, 12 Desember 2014

Re: [MS_AccessPros] Report building problem

Thanks Duane and John! I finally had time to make the change you guys suggested and it appears to be working.

Jessica

On Friday, December 5, 2014 10:41 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jessica-

It looks OK in your table because you probably have a Lookup defined. To display the associated name on your report, include the lookup table in the Record Source for the report (a query) and display the name directly from the lookup table in a text box. It's sloppy to use a combo box on a report.

Also read Problem With Lookups.doc in Files / Articles_Excerpts on the group website.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Dec 5, 2014, at 3:25 PM, Jessica Hoback hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Thank you Robert! I'm so happy I found this group!

Jessica

On Friday, December 5, 2014 7:42 AM, "'Robert Peterson' bob@alternatefinishing.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

You probably have a text box on the report bound to the ID number.

You can use combo boxes on reports the same way you do on forms to control what is displayed. Just change the display width of the bound column to 0" and give the description column the width you want.

Bob Peterson

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, December 05, 2014 8:19 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Report building problem

Thanks guys. That actually seems obvious now. Another question...

I have two fields in my report that are displaying a record ID number instead of the description. One field on my form/table is ControlTypeID and the other is ControlWeapon. The selection made in the ControlTypeID combo box determines what options, if any, are available in the ControlWeapon combo box. These are both displaying as a number, but I want to see the description on the report. The data is displaying the way I want it to in the table, so why is the report showing a number?

Thanks,

Jessica

On Tuesday, December 2, 2014 11:05 AM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Jessica,

John's advice is spot on (as usual). Your subreports on your main report are very much like your subforms on your main form. There are even the Link Master/Link Child properties for each. One mistake that I often see is including the detail level records of a subreport in the Record Source of the main report. If you closely match the main and sub record sources you should be okay.

Duane Hookom MVP
MS Access.

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 2 Dec 2014 17:39:22 +0100
Subject: Re: [MS_AccessPros] Report building problem

Jessica-

Because your report Record Source contains multiple 1-M relationships, you'll get the Cartesian Product of all the Resistance, Control, and Injury records for each ReportID. So, for example, if you have 3 Resistance, 2 Control, and one Injury record for a given ReportID, you'll get six records (3 * 2 * 1) for that report. You need to build subreports for each of the sub-types and use just the IncidentReports table as the Record Source of your outer report.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Dec 2, 2014, at 5:02 PM, hobackjessica@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good Morning Access Pros!

I'm afraid I can't find my previous thread that led me to this point in my project so I will summarize what I've done so that maybe someone can help me build my report.

I have built a database and forms (with much help from John V. and others thank you so much). My main form has three subforms on a tab control. Two of the subforms are continuous forms and on one of those I have fields that are visible or not depending on other selections made.

I now need to create a report that shows all of the data input into this form/subforms. I've successfully gotten all of the data from the main for m and the first subform into the report - no sweat!. The information from the continuous form subforms appears to be creating a separate report for each item that was entered in the original form. Ideally, they will all appear on one report but I haven't a clue as to how to do this - Please Help!

I will upload the db as well ("UOF - Copy"). There is information in the database that has been entered for testing purposes - this is all completely bogus information.

Thank you all!
Jessica