Recent content by in22

  1. I

    Open print options before priniting a report through VBA

    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...
  2. I

    Limit access to a database to a few users.

    Can you please provide the code for the option group?
  3. I

    Limit access to a database to a few users.

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

    Limit access to a database to a few users.

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

    Limit access to a database to a few users.

    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...
  6. I

    Disable Design view

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

    Limit access to a database to a few users.

    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...)?
  8. I

    Limit access to a database to a few users.

    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...
  9. I

    Pop up a "Process Running" MsgBox and Close Automatically on Process Execution

    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...
  10. I

    Trying to use VBA to open a report - wouldn't work

    That worked! Thanks
  11. I

    Limit access to a database to a few users.

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

    Trying to use VBA to open a report - wouldn't work

    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?
  13. I

    Limit access to a database to a few users.

    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...".
  14. I

    Trying to use VBA to open a report - wouldn't work

    I didn't understand your post :o
  15. I

    Trying to use VBA to open a report - wouldn't work

    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...
See more
Back
Top Bottom