This is an example of very simple code you can copy and paste - the command button should have something like the following in the 'On Click' properties:
Private Sub Run_Report_Click()
On Error GoTo Err_Run_Report_Click
Dim stDocName As String
stDocName = Me.lstReport...
Hi Fred,
Try this link:
http://www.5star-shareware.com/Business/MS-OfficeAdd-Ins/ms-snapshot.html
You should be able to download a free, working copy of Snapshot Viewer at this site. I tested the download earlier and it works.
mk
As an alternative...if this report will be going to the same printer all the time, you can also accomplish this without code if you would like. While editing the report, 1)click "File" 2)then "Page Setup" 3)then the "Page" tab 4)then "Use specific...
I've seen this discussed before, maybe the following can help:
FAQ181-37
Thread701-496962
Thread181-250502
Thread702-539377
I have not had reason(yet) to use any of the code examples, but they do offer various solutions.
Good luck
mk
If you save your Access report as a snapshot, you can actually drag and drop that file into your presentation. Your report will then populate the target slide. The image might require some slight tweaking, but you should get the results you're looking for. I hope that helps.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.