On Timer Help

[MadMax7]

I hope someone can help an point me in the wright direction.

I have been asked to build a database that will automatically check a specific location on our local drive (H\OvernightReports\AutoStats\ for a report that can be generated at any time and a number of reports can be generated throuhout the night.What i need the database to to do is collect the information (txt file) from the location and input it into a table within the database, delete the txt file nad be ready for the next file and then re run the process again

hope this is clear

 

[PHV]

What have you so far ?
You may consider the Dir and Kill VBA functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MadMax7]

I know how to import the file and sort the data out once in access, the only part i don't know how to do is to check every couple of minutes if the file is present and if it is execute the import code, but if its not check a couple of minutes later

 

[PHV]

Have a look at the Timer event procedure and the TimerInterval property of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886