creating reports with forms/subforms

60 pts.
Tags:
Access 2000
Access forms
Microsoft Access
Microsoft Access forms
Microsoft Access subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can I get each Employee ID number on a separate page from the next.
ASKED: April 16, 2009  5:51 PM
UPDATED: April 19, 2009  8:32 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

This looks like you have control element with data (emp.id) which absent from query underlying report.

To print on separate page the data for each Employee ID number, add group by this column and set a page break at the beginning of this group.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Have you tried running the report's query directly against the database with the same Emp. Id you entered when running the report from the form ? does it return rows ?
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following