Access 97 Programmically Compact on Close

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

Is there any code that I could use to have my front end compact on close automatically? I want this function to occur everytime a user closes out of a session of my application.

Many thanks in advance.
Carlee
 
I have done this ..... Here's the concept.

Using the windows task scheduler, create a task that opens
Access and a specific database (like when you create an
icon that opens a specific database). When this database
opens and your opening form, use the onOpen event (or
timer event), call a module that will prints the report
and then quit your applciation.

Mine runs at 6:30am it runs a specific report.

I think this is what your after.

SteveD
PS: this may sound complicated, but if taken in small
steps, it's not.
-----Original Message-----
Hi everyone,

Is there any code that I could use to have my front end
Click to expand...
compact on close automatically? I want this function to
occur everytime a user closes out of a session of my
application.
 
sorry - wrong thread ....SteveD
-----Original Message-----
I have done this ..... Here's the concept.

Using the windows task scheduler, create a task that opens
Access and a specific database (like when you create an
icon that opens a specific database). When this database
opens and your opening form, use the onOpen event (or
timer event), call a module that will prints the report
and then quit your applciation.

Mine runs at 6:30am it runs a specific report.

I think this is what your after.

SteveD
PS: this may sound complicated, but if taken in small
steps, it's not.

compact on close automatically? I want this function to
occur everytime a user closes out of a session of my
application.
.
Click to expand...
 
Take a look at the free TSI SOON (Shut One, Open New) add-in Michka has at
http://www.trigeminal.com/utility.asp?ItemID=8#8

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Carlee said:
Hi everyone,

Is there any code that I could use to have my front end compact on close
Click to expand...
automatically? I want this function to occur everytime a user closes out of
a session of my application.
 
Back
Top