Thank you very much, Eric. I appreciate your help. Jim
--- In AccessDevelopers@yahoogroups.com, "Eric Douglas"
<[EMAIL PROTECTED]> wrote:
> Sure. If you have an AutoExec macro, open the form "HiddenForm"
along
> with your other actions, but in "hidden" mode. If you have a form
set
> to open when users open your DB, add this line to the Open
property of
> that form:
>
> DoCmd.OpenForm "HiddenForm", , , , , acHidden
>
> In the Timer property of your hidden form, put
>
> If Now < CDate(Date + 0.99) Then ' Date + .99 is approximately
11:45PM
> "today"
> DoCmd.Quit
> End If
>
> And in the Timer Interval property of your hidden form, put the
number
> of seconds you want it to wait between checking. So if you put
6000, it
> will check that If statement every 10 minutes.
>
> Let me know if you have more questions.
>
> Eric
>
>
> > -----Original Message-----
> > From: AccessDevelopers@yahoogroups.com
> > [mailto:[EMAIL PROTECTED] On Behalf Of jmw95823
> > Sent: Tuesday, July 19, 2005 11:58 AM
> > To: AccessDevelopers@yahoogroups.com
> > Subject: [AccessDevelopers] Re: Application.Quit Based on Time
of Day
> >
> > Thanks, Eric. Would appreciate some example code if anyone
> > has it handy. Jim
> > --- In AccessDevelopers@yahoogroups.com, "Eric Douglas"
> > <[EMAIL PROTECTED]> wrote:
> > > Jim,
> > >
> > > You can have open a hidden form with code in the Timer
property to
> > > periodically check what time it is, and quit the app if it
> > succeeds.
> > >
> > > Eric
> > >
> > >
> > > > -----Original Message-----
> > > > From: AccessDevelopers@yahoogroups.com
> > > > [mailto:[EMAIL PROTECTED] On Behalf Of
jmw95823
> > > > Sent: Tuesday, July 19, 2005 7:23 AM
> > > > To: AccessDevelopers@yahoogroups.com
> > > > Subject: [AccessDevelopers] Application.Quit Based on Time
of Day
> > > >
> > > > I set up a daily (nightly) backup of a backend .mdb via XP's
> > > > Scheduled Tasks utility and it ran fine last night at 11:45
pm.
> > > > I've noticed that sometimes the lock file (.ldb) is there
> > and would
> > > > like to get rid of it before the backup occurs (even
> > though you can
> > > > set the backup to run while files are still being written
> > to). Can
> > > > I run code to quit the application based on time of day? I
would
> > > > want the file closed (with no .ldb) just before the
> > backup occurs.
> > > > Thanks for any help.
> > > > Jim
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Please zip all files prior to uploading to Files section.
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> >
> >
> >
> >
> >
> > Please zip all files prior to uploading to Files section.
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
