Prev: Query?? or something else?
Next: Variables in select statement
From: cheekyblue on 26 Jan 2010 06:07
Hello,

Ive got a database where staff login just using their name, and the login
button has a macro assigned as follows
Condition : Not IsNull([cboCurrentEmployee])
Action : SetTempVar
Arguments : CurrentUserID, [cboCurrentEmployee]

Certain contacts in my database are assigned to a member of staff and call
sheets are set up using a query that requests that member of staffs name. Is
there a way of automatically setting the criteria of the query to only show
clients that are assigned to the member of staff that has logged in?

Thanks, please let me know if i need to explain this further....
From: cheekyblue on 26 Jan 2010 10:35
doesnt matter, i've figured it out

"cheekyblue" wrote:

> Hello,
>
> Ive got a database where staff login just using their name, and the login
> button has a macro assigned as follows
> Condition : Not IsNull([cboCurrentEmployee])
> Action : SetTempVar
> Arguments : CurrentUserID, [cboCurrentEmployee]
>
> Certain contacts in my database are assigned to a member of staff and call
> sheets are set up using a query that requests that member of staffs name. Is
> there a way of automatically setting the criteria of the query to only show
> clients that are assigned to the member of staff that has logged in?
>
> Thanks, please let me know if i need to explain this further....
 | 
Pages: 1
Prev: Query?? or something else?
Next: Variables in select statement