Hide Print button at report time...

[Addammer]

I would like to put a print button on a report.

When the user clicks the button the report will print without showing this button. I'm drawing a complete blank.

Thanks,
Adam

 

[RuralGuy]

Reports are not interactive. How about letting the user use File>Print?

 

[JEA]

I use a print button on my reports. I use the wizard to build it on a from, then copy and paste it on to the report. It works, but the button does print.

 

[Addammer]

I've disabled all my tool bars.

Would there be a way to automatically open the Print window when the report is displayed?

 

[JEA]

Try creating the button as I described above and using:

OtherControl.setfocus
ButtonName.Visible = False

In the On click event.

Can't claim credit for this. It's The_Doc_Man's and adsmmg's work here:

http://www.access-programmers.co.uk/forums/showthread.php?t=139417&highlight=code+hide+button+click

 

[Addammer]

OtherControl.setfocus
ButtonName.Visible = False

Just tried this. Awesome idea I never thought of that.

BUT when I view my report all I have for a cusor is a magnifiying glass.

 

[RuralGuy]

I've disabled all my tool bars.

Would there be a way to automatically open the Print window when the report is displayed?

See if this link helps a bit.

 

[Rich]

Create your own Custom toolbar and attach it to the Report

 

[Addammer]

Create your own Custom toolbar and attach it to the Report

Does anyone have a good link handy for this?

I'll start Googling.

 

[boblarson]

Does anyone have a good link handy for this?

I'll start Googling.

My website has a Quick Tutorial on creating a custom right-click menu but you should be able to figure out from it how to use it on a regular menu/toolbar as long as you don't do the part described where it says to select POPUP as the type.

See here:

http://www.btabdevelopment.com/main...rtcutmenuAccess20002003/tabid/62/Default.aspx

 

[JEA]

OtherControl.setfocus
ButtonName.Visible = False

Just tried this. Awesome idea I never thought of that.

BUT when I view my report all I have for a cusor is a magnifiying glass.

Is that because you're opening the report in print preview?
When I use the print button on my reports, it is in Report View. The button works for me in this view (Access 2007). All you need to do is add the above code to the on click event when you build the print button in a form, before copying and pasting on to the report.

 

[Addammer]

Is that because you're opening the report in print preview?
When I use the print button on my reports, it is in Report View. The button works for me in this view (Access 2007). All you need to do is add the above code to the on click event when you build the print button in a form, before copying and pasting on to the report.

Could my problem be that i'm in a runtime environment?

 

[boblarson]

Could my problem be that i'm in a runtime environment?

If you are using runtime you can't make any design changes. If you are using full Access to design for use in the runtime environment you can create your own menus, but if you are actually using Access in the runtime environment you can't (that's why runtime is available so that people without Access can use the database file but they can't make design changes).

 

[Addammer]

Sorry for the confusion.

I am the developer of this database. I can make any changes i'd like to.

I'm testing this as an end user in runtime. The only cursor given is a magnifying glass when in runtime.

 

[boblarson]

Which version are you using?