Autoexec question

[Cillies]

Hi, I was wonder if anyone knew how to manipulate access on start-up
to check a certain date field on a form, and if that date on the form
is the same date as the day the database was opened a message would
appear asking the user to take action or at least bring up the records
with the same date as 'today'.

i.e.
If I open the db today and I have several records within my db with
today's date written in a text box, then I would like access to make
me aware of this by form of a message and possibly bringing up the
records.

Hope this message is understandable, if not please do not hesitate to
contact me.

Thanks

[aland]

I'm not sure if I can help, but I'll try.
Going to Tool:startup you can specify a form to load on startup, then
using the Private Sub Form_Load() function you could make up some query
to help you.
Then something like:

Dim strSQL As String
Dim RS As DAO.Recordset
Dim todayDate as String
Dim dbDate as String

todayDate = now()

strSQL = "SELECT tblMain.txtDate FROM tblMain;"

Set RS = CurrentDb().OpenRecordset(strSQL)
With RS
.MoveFirst
dbDate = !txtDate
End With

if (dbDate = todayDate) Then
msgbox("Do something")
endif
I don't know, maybe the above is useless. Obviously you'd need to
expand that sql query so you can grab the primary key of whatever
you're looking for.

HTH