check to see if an append query has been run

[snipe]

Hey guys,



I am pretty stumped on this one. I have a table of data. Every week, on a Monday, an append query must be ran for the previous Monday-Sunday period. For instance, on 12/30 I will run the query for 12/23 - 12/29. That query can be ran anytime, not just on that Monday.

I want a pop-up to appear on load of my main form asking if the user wants to run the query. If yes, run it (takes about 3 minutes), if not just close the dialog box and ask again next time the form loads. I don't want this pop up to appear if the query has been be ran for the previous week already.

How can I code a statement to check if last weeks data is already in the table?

I can handle all of the dialog box code and all that. I just need the if/then bit to check if the data has been ran.

Here is a snippet of the table:

[pbaldy]

You could do a DCount looking for the previous Sunday's date. A formula like this should find that:

Date - Weekday(Date, vbMonday)

[snipe]

Never done a DCount. Could you elaborate a bit?

[pbaldy]

Same syntax as DLookup(). In code:

If DCount(...) > 0 Then
   it's already been run.
Else
  it hasn't
End If

[snipe]

Ah nice. Makes sense. I'll see if I can get this to work.

Appreciate it bud!

[snipe]

Working great! Thanks again man!

[pbaldy]

Happy to help!