I keep a long list of domains in an access file with their expiry dates.
Without having to open Access, is there a way I can get Access to alert me that a domain is going to expire (say) 1 month before the expiry date.
I want to do this so that Access either autosends an email to a designated address or shows a popup alert when I start up my PC.
I don't want to have to start the Access software first.
To read data, make a decision and then perform an action, some sort of software will need to run.
I suggest making a little VB app that performs your check, set it to run hidden, compile it to an EXE, and place it in your startup folder. VB will let you connect to an MDB file and you won't need to open Access.
I think the "lightest" solution is probably vbscript. Paste the below into a vbs script and get windows scheduler to run when you log in.
Set dbE = CreateObject("DAO.DBEngine.36")
Set ws = dbE.Workspaces(0)
Set db = ws.OpenDatabase("C:\Test.mdb")
strSQL = "SELECT * FROM Table3 WHERE TheDate BETWEEN Date() AND DATEADD('m', 1, Date())"
Set rst = db.OpenRecordset(strSQL)
If rst.RecordCount > 0 Then
MsgBox "Domains going out of date!"
Set rst = Nothing
Set db = Nothing
Set ws = Nothing
Set sbe = Nothing
I use Scheduled Task To Kick a Msaccess program going
Then Use the Autoexec macro to Start a Custom Function
Then do it thing
Job Done Quit
Nice tick I do here same as above with the Autoexec to close the database
but turn on the Autocompact on close Great fo back end database runing in the we hours of the morning.
Last edited by myle; 06-14-06 at 20:24.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.