Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hidden Access unhiding on VBA export

Status
Not open for further replies.

lestatdelioncourt

Programmer
Aug 29, 2002
52
BN
Ok here is the problem.

I have hidden the access application, so only the form shows. On the form I have a button that runs the following code:

DoCmd.OutputTo acReport, cmbreport, acFormatRTF, "c:\" & cmbreport & ".rtf", True

This works great and loads MSWord with the report. However it also unhides the database and then allows the user to access the advanced features in access, and looks very messy.

I have tried to hide the Access application after the above code but this does not wrok.

Any ideas on how to prevent this?
 
Make sure in Tools Startup you have the checkboxes unchecked.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top