Access Query Help

  Master.mind 08:48 24 May 2005
Locked

How can I create a append query that adds a line to a table with one of the fields being the current date and time?

Thanks.

  Master.mind 08:54 24 May 2005

Think I've done it.

  Master.mind 08:58 24 May 2005

Now is it possible to write something that will run this query every five minutes (for example)?

  Rand Al Thor 10:33 24 May 2005

Yes, you can either do it from within access or use the Windows Task Scheduler.

  ggudge 14:57 24 May 2005

Try this:-
Create a form
In design mode open the form properties and set Timer Interval to 300000 (5 mins).
Create a procedure in “On timer” to run the query - DoCmd.OpenQuery ("YourQueryName").
When the form is open your query will run every 5 minutes.

  Rand Al Thor 08:23 25 May 2005

Only problem with that method is that the DB has to be open all the time. One reason I suggested the windows task scheduler.

  Access Moron 10:12 25 May 2005

one question that has to be asked is why do you want to do this?

  Master.mind 18:40 04 Jun 2005

Thanks for all the help.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?