Problem with "mcrHide", can't view queries and reports.

[gibben]

Hi there,
For those that are familiar with this macro I am using it to hide the database window to keep users out from behind the scenes. All is working well except that I have some pre-prepared queries that users can run, problem is when the database window is hidden the query results can not be seen.

Also under start-up I have de-selected all the options, I am ahappy with the way it is working except the fact users can't preview the query results before exporting them out to excel. Also the fact the reports are hidden with the database window as well.

Any thoughts would be appreciated.

Thanks

 

[danvlas]

You could list all the objects you want on a form, then double-click the object to open it.

Try ftp://ftp.artrom.ro/Switch.mdb
It's a form that does it. Looks ugly, but you can change it.

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html