Want CurrentUser as default in parameter

B

Bonnie

Hi there! Using A02 on XP. Have a query for folks to view
notes for all contracts assigned to 'XXX' Technician.
Usually they are checking their own but sometimes need to
input different initials. I have the parameter [Which Tech
Initials? XXX] but would love to have it appear with the
current user's initials there as a default. They can just
hit Enter or key in something else.

Thanks in advance for any help or advice!
 
R

Rick B

If the current user initials is what they use to login to the access
database, then you couls use
=CurrentUser()

But, you can;t do that in a prompt. You would have to create a pop-up form
with a field in it, defualt in the current user, allow the user to type over
it, hae them click a button, hide the form and run the query.

Rick B
 
B

Bonnie

Hey Rick! I can do that! Thanks for the advice, I just
needed to be pointed in the best direction.

Much appreciation for you taking time to help others!
-----Original Message-----
If the current user initials is what they use to login to the access
database, then you couls use
=CurrentUser()

But, you can;t do that in a prompt. You would have to create a pop-up form
with a field in it, defualt in the current user, allow the user to type over
it, hae them click a button, hide the form and run the query.

Rick B

Hi there! Using A02 on XP. Have a query for folks to view
notes for all contracts assigned to 'XXX' Technician.
Usually they are checking their own but sometimes need to
input different initials. I have the parameter [Which Tech
Initials? XXX] but would love to have it appear with the
current user's initials there as a default. They can just
hit Enter or key in something else.

Thanks in advance for any help or advice!
Click to expand...


.
Click to expand...
 
B

Bonnie

Rick! I looked at an old date parameter I had, tweeked it,
and it works!!! In the criteria of my Tech field I put
this:

Eval("InputBox('Which Tech?','Sort By Box',CurrentUser())")

It is TOOO cool! Thought you might be able to use it.
-----Original Message-----
If the current user initials is what they use to login to the access
database, then you couls use
=CurrentUser()

But, you can;t do that in a prompt. You would have to create a pop-up form
with a field in it, defualt in the current user, allow the user to type over
it, hae them click a button, hide the form and run the query.

Rick B

Hi there! Using A02 on XP. Have a query for folks to view
notes for all contracts assigned to 'XXX' Technician.
Usually they are checking their own but sometimes need to
input different initials. I have the parameter [Which Tech
Initials? XXX] but would love to have it appear with the
current user's initials there as a default. They can just
hit Enter or key in something else.

Thanks in advance for any help or advice!
Click to expand...


.
Click to expand...
 
Top