![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I added all the tables, forms, reports and cmd buttons concerning an addition to a database. I entered data for Q1 in order to produce a report but received no output on my report. I tried the same thing for an addition that was fully functional and that I used as a template. Probably something in the qry for my report? Any ideas? I am in my 28 month at my job and there is SO much I still do not know! Thanks! Zuf |
#3
| |||
| |||
|
|
zufie wrote: I added all the tables, forms, reports and cmd buttons concerning an addition to a database. I entered data for Q1 in order to produce a report but received no output on my report. I tried the same thing for an addition that was fully functional and that I used as a template. Probably something in the qry for my report? Any ideas? I am in my 28 month at my job and there is SO much I still do not know! Thanks! Zuf There's one thing you could check. *In the Reports OnNoData event, enter * * * * msgbox "No Data" Now run the report. *Do you get that message? If so, open the Report's property sheet, click on data tab, and dbl-click on the ... button for the Recordsource. *Try to run the query. * * I would think something is wrong with the recordsource...perhaps the links. *For example, you have have two tables with a link line (Inner Join) between the two. *Maybe one of those tables don't return any records. *If you dbl-click on the link line, you can change it so all records from the main table are returned and matching records from the secondary table. *Maybe you have a filter that needs to be removed. Who Knewhttp://www.youtube.com/watch?v=cJmghwq7k2I- Hide quoted text - - Show quoted text - |
![]() |
| Thread Tools | |
| Display Modes | |
| |