dbTalk Databases Forums  

Access report

comp.databases.ms-access comp.databases.ms-access


Discuss Access report in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
zufie
 
Posts: n/a

Default Access report - 02-28-2008 , 08:56 AM






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

Reply With Quote
  #2  
Old   
Salad
 
Posts: n/a

Default Re: Access report - 02-28-2008 , 10:37 AM






zufie wrote:
Quote:
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 Knew
http://www.youtube.com/watch?v=cJmghwq7k2I


Reply With Quote
  #3  
Old   
zufie
 
Posts: n/a

Default Re: Access report - 02-28-2008 , 02:09 PM



On Feb 28, 10:37*am, Salad <o... (AT) vinegar (DOT) com> wrote:
Quote:
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 -
Thanks. The copy of the database I was working on was corrupted as I
received a healthy copy of it from the end user.

I will have to repeat all my work, but I learned a lot and thank you
for your help!

Zuf


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.