Sign in to follow this  
mrmrcoleman

OT Question about Access - Is this possible?

Recommended Posts

Hello, I realise this isn't exactly programming but I thought you guys would probably know the answer to my question. Basically I would like to maintain a list of records in a table in Access. Each day this table should be automatically checked, and based on this checking, emails can be sent to various addresses contained within the records. I am pretty sure that I could set-up a macro to check the table and send the emails (assuming this functionality is available in VBA), but I am not sure about the automatic checking at a given time each day. Does anybody know if this is achievable with Access and perhaps some VBA? The reason I ask is because I am considering doing this as a favour for somebody in another department, and if it is going to be a lot of work, I don't have time so I will have to say no. Thanks in advance for any help with this. Mark

Share this post


Link to post
Share on other sites
Quote:
I am pretty sure that I could set-up a macro to check the table and send the emails (assuming this functionality is available in VBA), but I am not sure about the automatic checking at a given time each day.

Your suspicions are correct; you can't do what you describe in Access without the aid of an external process. The macros cannot run if the file is not open. The usual way is to set a Scheduled Task that runs at the desired time.

Share this post


Link to post
Share on other sites
Another idea...

Is it possible for me to have Access automatically run on start-up, and provide it with some command line values to load a database.

Surely if I can get that working I can get a macro to automatically run when the DB is opened, right?

Mark

Share this post


Link to post
Share on other sites
Quote:
Original post by mrmrcoleman
Another idea...

Is it possible for me to have Access automatically run on start-up, and provide it with some command line values to load a database.

Surely if I can get that working I can get a macro to automatically run when the DB is opened, right?

Mark

That's certainly possible, but it's very fragile. The easiest and least secure way to do it is to use a shortcut to the Access executable with a command-line parameter corresponding to the file you'd like to load. For instance, you might set the shortcut to "C:\Programs\Access.exe" "Q:\Files\myFragileCompanyDatabase.mdb". Then you'd place this shortcut in the All Users\Startup folder.

If you want more information, try asking in the Microsoft newsgroups. There are some very knowledgeable people there, and the Office MVPs are more than willing to assist you.

hope that helps,

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this