Helllo All:
I am a relativly new user to Access and as such have been visiting thebullitin boards for weeks now finding answers to some pretty simple questions as well as finding code and designs that suit the needs of my project. So thank you for all of the previous postings and for any help you can give on my current problem.
Currently I am developing a database for the collection and analysis of budget forecast data. I have adapted a username and password utility that was previously refrenced on this site. What I am am having trouble with is utilizing the userid to display within a listbox those projects that the user is responsible for.
I currently have a variety of tables set up including
tblUserDetails
tblUserLevel (this is used to limit access to various menus and functions)
tblProjectInfo
I know if I can load a page with the value of the current UserID i can then limit the list box to Projects whos owners UserID matches that current UserID
What I cannot figure out is how to get the form to fill that UserID field upon loading with the Current Users ID.
Please Note that I am not using the user managment system that is built in to excel there for CurrentUSer() command is not relvant (well at least that is my understanding)
Thank you in advance for any assistance.
Cheers,
Matthew
I am a relativly new user to Access and as such have been visiting thebullitin boards for weeks now finding answers to some pretty simple questions as well as finding code and designs that suit the needs of my project. So thank you for all of the previous postings and for any help you can give on my current problem.
Currently I am developing a database for the collection and analysis of budget forecast data. I have adapted a username and password utility that was previously refrenced on this site. What I am am having trouble with is utilizing the userid to display within a listbox those projects that the user is responsible for.
I currently have a variety of tables set up including
tblUserDetails
tblUserLevel (this is used to limit access to various menus and functions)
tblProjectInfo
I know if I can load a page with the value of the current UserID i can then limit the list box to Projects whos owners UserID matches that current UserID
What I cannot figure out is how to get the form to fill that UserID field upon loading with the Current Users ID.
Please Note that I am not using the user managment system that is built in to excel there for CurrentUSer() command is not relvant (well at least that is my understanding)
Thank you in advance for any assistance.
Cheers,
Matthew
