Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to print a snapshot report from access in VBA

Status
Not open for further replies.

romnew

Programmer
Feb 27, 2002
44
ZA
Hullo everyone,
I am sent a snapshot report by email.
How do I print this report from Access using VBA?
Another question please: How does one import a table into a Database from another database using VBA?
Your help is greatly appreciated
Thanks
Piet
 
Perhaps the method here thread705-941954 might do?

But I think the snapshot viewer may pop up a print dialog, and not print directly. Perhaps try the "dreaded" sendkeys?

Take a look in the helpfiles on the TransferDatabase method of the docmd object for import/link of tables from external sources.

Also perhaps have a look at faq181-2886 on how to get the most out of the membership.

Roy-Vidar
 
Thanks Roy-Vidar for your directions.
Will try it out.
Also GingerR
Thanks again.
 
Hi. I guess I misread your question. How about just printing the Access report using VBA?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top