view report

[junkmale]

On my switchboard, i've placed a button to view a report.

The expression is as below.

Private Sub BooksbyAuthorbyYear_Click()

DoCmd.OpenReport "Author2"

End Sub

I receive a runtime error, telling me to install a printer first.
[my current compute is not connected to any printer]

How do i open a report just for viewing, and not to print out?

 

[namliam]

In order to preview a report i have found you need a printer installed as default printer... No other way i know off..

If your question is "how do i open it in preview"
Check out the access help on openreport (eg HIT F1)
Or simply:
docmd.OpenReport "report",acViewPreview

Regards

The Mailman

 

[junkmale]

yes, my question is simply "how do i open it in preview"

thanks!

 

[namliam]

Well then you got your answer

Regards

Hint: Try hitting F1 every now and again before posting a question on the board....

 

[junkmale]

Hint: Try hitting F1 every now and again before posting a question on the board....

sorry for that... but i only started coming into close contact with visual basic this few week. No formal learning at all about this. In fact, not even any formal learning in SQL. I pluck all my information from online resources which teach SQL from the start, ie,

"SQL is an ANSI (American National Standards Institute) standard computer language for accessing... ... "

and only teaches me a few of the basic syntax...

F1 brings up some useful help sometime, but when they explain some terms by using other terms, it gets incredibly difficult to comprehend. whereas the helpful guys on this forum type in more reader friendly format which hits the point.

Thanks for all you guys patience all this while.