Print tabbed form

[Lisa]

I have a tabbed form (just two tabs) with a Print command button on each. It
correctly opens up the Report associated with the form, and gives me the
current record only. Problem is, no matter what I do, only the first tab
will print.

I realize I need to do something to reference the second tab, but am not
sure where to do this. I am not a programmer, so I was hoping I wouldn't
have to write any code.

Thanks.

 

[Jeff Boyce]

Lisa

Are those <Print> buttons located on each tab, or is there just one, located
on the main form?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lisa]

Jeff -

There was one on each tab, referencing two separate reports (goofy, I know).
I also tried two print buttons, both referencing the one report. Any ideas?
Thnx.

 

[Jeff Boyce]

Lisa

I'm not visualizing how your <Print> buttons can be "referencing two
separate reports", but the one isn't "separate"!

What happens if you try running the reports directly from their report
definitions?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lisa]

I can't even get the report definition to show the data on the second tab.
To illustrate further, if I do a "Save Object as Report" from the second tab
on the form, it still only creates the report for the first tab data.

The only way the second tab's data ever shows up is if I do a Print Preview
right from the form itself, while sitting on the second tab. But then, of
course, I get all the records.

I've attached macros, with a Where condition to ensure I only get the
current record, to the Print button on the form. This calls the report, but
again, for the first tab only.

 

[Jeff Boyce]

Lisa

Let me step back for a minute and shift into "teacher" mode ... you may
already know this...

Access tables store data.

Access forms display data.

Access queries return data.

Access reports display (print out) data from either queries (preferred) or
tables (directly).

There's no way your "report" would "know" about the data that's display on
the form unless you tell it.

Whatever data you have displayed on the form, you need to tell Access to use
that in the report.

Are you already doing all this?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mark Han[MSFT]]

Hi Lisa,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that even we click the print bottom on
the second tab, the first tab will be printed.
If I have misunderstood, please let me know.

in order to better assist you with the issue, i would like to reproduce the
issue in homw. So, please send the backup file of the access database file
to me. once I reproduce the issue in home, it will be easier for us to sum
up an appropriate resolution to you. my email address is
(e-mail address removed) (please remove "online").

If there is anything unclear, please do not hesitate to let me know. Have a
nice day!

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Lisa]

Thank you, Mark. Creating a report off the second tab (and referencing it
via a command button with a "Where" condition in the macro to filter the
records) worked perfectly. I don't know why I was having so much trouble but
I understand now. Thanks again.