closing an opened database from another database

G

GeorgeMar

I have a FE apps that has a form with a button that opens a Reports database
to display a report based on parameters set in the FE apps.

I use OpenCurrentDatabase to open the Reports database and display the
report in Preview mode. The Reports database remains visible, alongside the
FE apps, until the user closes the Reports database. The problem is that the
Reports database can remain open if the user forgets to close it. Moreover,
the user can initiate multiple instances of the Reports database, whenever
they click the button.

Is there a way for me to close the Reports database whenever the user closes
the FE apps? Or perhaps a way to find out if the Reports database is open
and close it?

Thanks
George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing a form in an opened database from a different database 2
After server upgrade some command buttons do not work? 1
Preview report causes database to crash 2
Access 2007 Close button disappears.. 2
Opening Report Closes Database 1
Split Database Distribution Errors 2
Access 2010 Visible Property having no effect 1
After overwriting, FE will not function properly until 2nd re-open 29

Top