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 Rhinorhino 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
Joined
Aug 29, 2002
Messages
52
Location
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.
 
This does not have any effect, the database window is still unhidden
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top