Access 97 Programmically Compact on Close

[Carlee]

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

 

[SteveD]

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

compact on close automatically? I want this function to
occur everytime a user closes out of a session of my
application.

 

[SteveD]

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.
.

 

[Douglas J. Steele]

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)

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.