accessaspire219
Registered User.
- Local time
- Today, 16:06
- Joined
- Jan 16, 2009
- Messages
- 126
Hi,
I want to design a database that will pickup a windows username and store it to a variable. Later on I want to reference to this variable as the parameter in a parameter query. In other words, in the parameter queries I have built so far I have always had the user enter the parameter in a form and then referenced the form in the parameter query to get the parameter. What I am looking to do is to reference a variable instead of a form in the parameter query.
Any idea on how this could be done?
Thanks!
I want to design a database that will pickup a windows username and store it to a variable. Later on I want to reference to this variable as the parameter in a parameter query. In other words, in the parameter queries I have built so far I have always had the user enter the parameter in a form and then referenced the form in the parameter query to get the parameter. What I am looking to do is to reference a variable instead of a form in the parameter query.
Any idea on how this could be done?
Thanks!