Adding toolbar/menu bar

[Guest]

I have a form that views a report. I want to add a toolbar to the report so
the user can print the report out once the report come sup on screen. I
figured out I was in the run-time version so right click properties don't
work. How do you do this?

Specifically the print button, maybe print preview

 

[Rick Brandt]

I have a form that views a report. I want to add a toolbar to the
report so the user can print the report out once the report come sup
on screen. I figured out I was in the run-time version so right
click properties don't work. How do you do this?

Specifically the print button, maybe print preview

You have to create a totally new custom toolbar in the app and then in the
Report's Design view you can specify that the custom toolbar be displayed
when the report is previewed by placing its name in the Toolbar property of
the report.

 

[PC Datasheet]

Here's the code for the custom toolbar Rick describes --
Function RptClose()
DoCmd.Close
End Function

Function RptPrint()
On Error Resume Next
DoCmd.RunCommand acCmdPrint
End Function

Put these functions in a standard module. You need a Print button and a
Close button on the custom toolbar. Put =RptPrint() in the action property
of the Print button and = RptClose() in the action property of the Close
button.

 

[StopThisAdvertising]

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve:
Over 370 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R