using acpreview

M

Maggie

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 -
 
D

Douglas J. Steele

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.
 
M

Maggie

Yes, printreports is a function and it seems to work fine when the database
is not located on the other server.
 
M

Maggie

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.
 
Top