PC Review


Reply
Thread Tools Rate Thread

Adding toolbar/menu bar

 
 
=?Utf-8?B?ZGFsYXc=?=
Guest
Posts: n/a
 
      13th Feb 2006
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
 
Reply With Quote
 
 
 
 
Rick Brandt
Guest
Posts: n/a
 
      13th Feb 2006
dalaw wrote:
> 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.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


 
Reply With Quote
 
PC Datasheet
Guest
Posts: n/a
 
      13th Feb 2006
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.

--
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 Removed)



"dalaw" <(E-Mail Removed)> wrote in message
news:F8BF324A-E7E3-4297-91F9-(E-Mail Removed)...
>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



 
Reply With Quote
 
StopThisAdvertising
Guest
Posts: n/a
 
      14th Feb 2006

"PC Datasheet" <(E-Mail Removed)> schreef in bericht news:kK8If.10869$(E-Mail Removed)...
> --
> 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 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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Adding new menu bar/toolbar in Access 2007 Klaus-Dieter Gundermann Microsoft Access Forms 0 30th Jan 2009 12:32 PM
Adding a drop down menu to toolbar button Sujoan Microsoft C# .NET 1 4th Apr 2006 06:47 PM
adding tool to toolbar & menu rahul via DotNetMonster.com Microsoft Dot NET 1 5th Feb 2005 07:32 AM
Adding a toolbar object to the Menu Bar guiguy Microsoft Excel Misc 1 21st Apr 2004 01:01 AM
Adding toolbar/menu command to Excel using C# Aaron Queenan Microsoft C# .NET 0 29th Oct 2003 07:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:57 AM.