transferring a variable or data type

[jhahes]

Is there anyway to do the following?


2 scenarios

1. if i have a login form is there anyway to transfer a number to a query

for example

right now, each agent enters their id for the query parameter, but there is no password, so any agent can enter any id and they can see the other agents data.

So if i have a login, can I transfer their id to the query parameter to pull up their form with their records (based on the query parameter)

2. kind of the same question, but based on the agent id, can I autopopulate the agents name for each additional record they create....so they don't have to pick the agent every time. They are obviously the agent....


thanks for any help


Josh

 

[boblarson]

One suggestion (of many possible) -
What you can do is create a table with the NT login id's of each person and then you can set a variable (or even a form - maybe a hidden form to keep it out of the way) that holds the NT login id of the person when they open the database (just set it using Environ("username") and then set the criteria of the query to the form textbox or variable.

 

[jhahes]

little more detail if possible

I am a novice, beginner


what does NT stand for?


Could you explain the steps in a little bit more detail if possible


thank you for your help and patience


Josh

 

[boblarson]

NT login is their network login; the login that someone uses normally in the business world when they start up their computer and connect to the network. I'm not sure exactly what the NT stands for. It came about when Microsoft came out with networking versions of Windows. Windows NT, which was the successor to Windows for Workgroups was, and I may be slightly off here as my memory of that is kind of fuzzy (it was a long time ago), really the first TRUE network operating system that Microsoft came out with. Then Windows 2000 was built off of Windows NT and Windows XP was an updated, redesigned Windows NT product.

 

[john471]

Windows NT

Wikipedia proffers an interesting theory on the meaning on NT, refer to the section in the link titled "'NT' designation".

 

[boblarson]

Much better, and much more accurate, description than what I gave - for sure.