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

Best Black Friday Deals 2017

Black Friday Deals for Designers & Artists: Adobe, Apple, Corel Painter, Microsoft Surface, Wacom &e…

Best Black Friday Apple Deals 2017

Black Friday 2017 : date, sites participants & bonnes affaires