using acpreview

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

I can preview my reports just fine when the database is located on my
machine. But, when it is located on the remote server, my users can't preview
a report. It just doesn't come up. The code is as follows:
doCmd.OpenReport "Sumrept", PrintMode
PrintReport acPreview

Does anyone have some clues as to why it doesn't work?

thanks -
 
To open the report in Preview mode, you should be using:

DoCmd.OpenReport "Sumrept", acPreview

PrintReport isn't part of Access: it must be a custom routine in your
application.
 
Yes, printreports is a function and it seems to work fine when the database
is not located on the other server.
 
I found the problem. The remote database was not pointing to the "dbo"
queries , but the old ones. Only on some though. thanks for your help.
 
Back
Top