Link to home
Start Free TrialLog in
Avatar of tutor_al
tutor_al

asked on

How to Create MDE and suppress all Windows & Print dialog boxes.

I am able creating an MDE file with Access. However, but I do not want Access to open up to the Access Enviornment. All I'd like to do is run the .MDE, let it run its code (it prints PDF reports) without any windows or print boxes to open or be displayed. Much like a batch file with echoes off ( no screen messages).

I did read somewhere about setting the Application.object to hide or something like that and I also need to hide the print dialog box. I open to any suggestions.


ASKER CERTIFIED SOLUTION
Avatar of nmilmine
nmilmine

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Have a look here to hide the database window:
http://www.mvps.org/access/api/api0019.htm
Avatar of tutor_al
tutor_al

ASKER

Thanks for the code. I have trouble running the Function. Whats the easiest way to run it?

The only thing really left to do is suppressing the print box when the PDF reports are printing. Let me know if there is a method to do that.

FYI: Another way to hide the Access window was to set the Application property to Usercontrol = False.
Found in the help section. Have you ever used that before?
Thanks again.