 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / August 2007user level security
i have built a database with my own menu to navigate it. on the menu is a combobox to select who you are. once you have picked who you are how can that be used through out the program, ie. id like to use it as you would use current user. so when making a new record i could store the current user in one of the fields so i would know who made it. thanks In one of the modules of your database declare something as a global variable, i.e., global glUsername as string In the afterupdate procedure of the combo box, you could set glUsername = me.combobox then anywhere you want to use the username, you would reference glUsername > i have built a database with my own menu to navigate it. on the menu is a > combobox to select who you are. once you have picked who you are how can that > be used through out the program, ie. id like to use it as you would use > current user. so when making a new record i could store the current user in > one of the fields so i would know who made it. thanks thanks, one oter question: where do you declare global variables? thanks > In one of the modules of your database declare something as a global > variable, i.e., [quoted text clipped - 8 lines] > > current user. so when making a new record i could store the current user in > > one of the fields so i would know who made it. thanks In your database window, the bottom row under objects is called modules. Create a new module. Under Option Compare Database Option Explicit is where you would type " global glUsername as string" Then save the module (name really isn't important, as you won't refer to it anywhere, you could call it modBasic) > thanks, one oter question: where do you declare global variables? thanks > [quoted text clipped - 10 lines] > > > current user. so when making a new record i could store the current user in > > > one of the fields so i would know who made it. thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.