Creating macro to run query only on saturdays

[GoldenFireTiger]

Hello.

I want to create an autoexec macro which will check if today is saturday each time the system is opened. If today is saturday, then I want it to run a query(qryLowStockLevels).

However, I do not know how to refer to the date? I understand that dates are stored as mnumbers i.e. 578932, and are formatted to display the date.

If this is the case (please correct me if I am wrong as I am relatively new to access), how could I create a macro that would check if today is saturday? Thanks!

 

[PHV]

A starting point (VBA):
If Weekday(Date, vbSunday) = vbSaturday Then
DoCmd.OpenQuery "qryLowStockLevels"
End If

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

 

[GoldenFireTiger]

PHV

Thank you for your help. Would this piece of coding run the query each saturday? and how would I set it as an auto exec? or does this go in the condition of a macro?