Want CurrentUser as default in parameter

  • Thread starter Thread starter Bonnie
  • Start date Start date
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!
 
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
 
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...
 
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...
 
Back
Top