Is there a way to set a procedure to run on startup? I have some code that finds the windows login id and want to use that to create an audit trail for logins as well as control access to various form elements based on the logged in user. I know you can setup access to load a form on start-up and that’s where I currently have the user id code running (form OnLoad) but it would be better to abstract the code to grab a login ID outside of any particular form. In general, some way to load a var globally on startup would, i think, make a cleaner design and easier one to maintain.
FWIW I’m trying NOT to setup Access security as I am trying to avoid yet another userID/pwd schema. Access to the db will be controlled on the share drive folder permissions so I am more interested in controlling form control display/availability and implementing some audit trails. I know there’s some overlap here but I’m trying to make the application’s behaviour transparent to a given user, if ya know what I mean.
