Expression for annual file purge

[driver7408]

This is probably easy. Need to have access purge all files from one of my tables annually on the very beginning of q3 (October 1st) of each year. I understand I need to use a delete query. What is the expression for specifying this same date each year to run this query?

 

[vbaInet]

Will the database be opened on October 1st of every year?

 

[driver7408]

Yes, either on that date or very shortly after that date.

 

[vbaInet]

So will records be entered into the table after that date?

Do each of the records in the table have a date?

 

[driver7408]

Yes. The table is a list of files that are read by employees. Each of these files does have a date, and they are also marked automatically by which quarter they are submitted, based on the date. This whole entire reading file simply needs to be deleted on Oct 1 of every year, because it is reset. After Oct 1st, new reading files will be added in.

 

[vbaInet]

It would be good if a button was clicked every 1st October for this to happen. You would check the date of the file and delete. Here's a good link:

http://www.techbookreport.com/tutorials/fso1.html

 

[driver7408]

I appreciate it, but I thought there was just a simple expression that could be created with the expression builder that could simply specify this date?

 

[Brianwarnock]

I think that there is some confusion here.
Do you want to delete files from your system, I think not , or
do you want to delete records of those files from a table?

If the latter is your question how to run the delete query automatically?

Brian

 

[vbaInet]

I'm actually thinking it could be both. Post #5 made me think it had to do with deleting the files as well as deleting the records. Not sure Brian.

Hopefully the OP would clarify.

 

[driver7408]

I think that there is some confusion here.
Do you want to delete files from your system, I think not , or
do you want to delete records of those files from a table?

If the latter is your question how to run the delete query automatically?

Brian

I wish to delete all of the records from a table, leaving the table blank, as it was after I first created the table. Need this action to be done 1 Oct of each year.

 

[vbaInet]

If Month(Date()) = 10 and Day(Date()) = 1 Then
    .... Delete statement goes here
End If