Search results

Hi, I am using command buttons on a report view. One each for: Print Preview Print Report Exit Report When I hit print report, access automatically sends it to the default printer and prints the entire report. However, I want to pop print options first (just like you get when you hit print...

Can you please provide the code for the option group?

Another question: DoCmd.Printout straightaway prints out the report. Is there a way to pop up print options before?

You mean print preview of the report that is linked to records on the form?

If I do put command buttons on report for print purposes, how can I not print the button too? I used (on click) Me.Visible = False DoCmd.Printout but it print out the command button too...

Is there a way to disable the shortcut menus (ONLY) through VBA? If yes can you provide the code for it?

I can do that on the form, but is it possible to have the option when one is in print preview of a report (User friendly...)?

I have used: DoCmd.ShowToolbar "Ribbon", acToolbarNo, to disable ribbons for non admin users. But I didn't think it through earlier - I just realized I would need print icon to be available to everybody (for the reports). Is there a way to work around the above line of code? Or would I either...

Re: Pop up a "Process Running" MsgBox and Close Automatically on Process Execution @madefemere The file you shared is exactly what I need. I have a quick question: So the button is supposed to open a query and has 2 lines of code. Should I insert those 2 lines as following...

That worked! Thanks

nevermind...I was using the wrong property (ViewNormal) :o also I had to minimize the form...I had typed acReport instead :D

Oh! Gotcha! I had to minimize the form :) But here's another problem. Instead of opening the report in print preview mode, the code somehow made it print the report. I got the dialog box suggesting "Printing report xyz to the printer..." I just want to view the report in print preview...any ideas?

That didn't work. I tried just that line, but that way instead of opening the report it began to print the report with a dialog box saying "now printing the report xyz to the printer...".

I didn't understand your post :o

So when I open a database a main form appears (like a switchboard). I have buttons which take me to several other forms (for multiple uses). There's a form which has buttons that are supposed to open queries and reports. Herem I'm using the following code to open a report. Private Sub...

I'm using the following code to open a report. Private Sub cmdFullTimersR_Click() DoCmd.SelectObject acReport, Me.Name DoCmd.Minimize DoCmd.OpenReport "Full Timer - Current Month", acViewNormal, , , acWindowNormal End Sub The code is embedded in the button on the form "Audit Tool Summary"...

Pop up a "Process Running" MsgBox and Close Automatically on Process Execution Hi, I have a form that loads when the database is open, and the form has buttons etc. that leads to queries and reports in the database. (Queries open in a form). Since most queries take a while to load, I was...

I didn't catch that. Do you mean as in Database options? If that's the case then yes I have specified it as the first form that should load on opening the database...

But please do let me know if you can figure out why that first line is needed?

I made it work by adding the highlighted part in the code below, although it doesn't make sense since this code runs on Form Load....(the code is part of what I have on frmMain...remaining code deals with opening other forms etc.) Option Compare Database Private intLogonAttempts As Integer...