Access Query Help

  Master.mind 08:48 24 May 05

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?


  Master.mind 08:54 24 May 05

Think I've done it.

  Master.mind 08:58 24 May 05

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

  Rand Al Thor 10:33 24 May 05

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

  ggudge 14:57 24 May 05

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 05

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 05

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

  Master.mind 18:40 04 Jun 05

Thanks for all the help.

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

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now