Action List

[Guest]

Okay, I'm not sure if this is possible but I have a database that is being
used company wide. Each one of my forms that might need additional action I
have a field for "Next Action Required By:". What would be the simplest way
to create a query to search these fields in each form and create a action
list by user so that when they log in and I can create a button that would
get the "CurrentUser" and activate the query that way.

 

[Duane Hookom]

Do you have some table and field names that you could share? What do you
mean by "each one of my forms"? A "form" in Access is an object used to
display records and other stuff to users.

 

[Guest]

I've set up the field in each table and the text field on each form so that
when a user enters data they can enter the name of the next person who needs
to take action on an entry. Other than showing you the field, I'm not sure
what else I could share. I've been asked to create some type of list that
the user can see when they log in that will show them what entries require
their action. I thought the easiest way would be to create a button that
would execute a query to search these fields for the current user's name and
pull out any entries necessary. The ideal query would return the form name,
ID and description so they can find it easily.

 

[Duane Hookom]

How does Access know who a user is and how is the name stored? Are you using
their network lD?

Sorry to be dense but I can't figure out more than this:

SELECT *
FROM [tblNoNameGiven]
WHERE [fldNoNameGiven]= AFunctionReturningAName();

 

[Guest]

The user must log in and then access will pull the currentuser name from that
login. I've used this feature in other locations to hide things from
non-admins, and to "sign" form digitally. my concern in a standard query is
that if all fields aren't true, I get a blank screen.
--
Lori A. Pong

How does Access know who a user is and how is the name stored? Are you using
their network lD?

Sorry to be dense but I can't figure out more than this:

SELECT *
FROM [tblNoNameGiven]
WHERE [fldNoNameGiven]= AFunctionReturningAName();

 

[Guest]

Maybe you could create an additional table Actions to log any action needed,
by whom be when, in which form etc. Then when an action is needed, a new
record should be created in this table. It makes it clearer to log the
actions taken (you could also delete completed actions).

The user must log in and then access will pull the currentuser name from that
login. I've used this feature in other locations to hide things from
non-admins, and to "sign" form digitally. my concern in a standard query is
that if all fields aren't true, I get a blank screen.
--
Lori A. Pong

How does Access know who a user is and how is the name stored? Are you using
their network lD?

Sorry to be dense but I can't figure out more than this:

SELECT *
FROM [tblNoNameGiven]
WHERE [fldNoNameGiven]= AFunctionReturningAName();

--
Duane Hookom
MS Access MVP

I've set up the field in each table and the text field on each form so
that
when a user enters data they can enter the name of the next person who
needs
to take action on an entry. Other than showing you the field, I'm not
sure
what else I could share. I've been asked to create some type of list that
the user can see when they log in that will show them what entries require
their action. I thought the easiest way would be to create a button that
would execute a query to search these fields for the current user's name
and
pull out any entries necessary. The ideal query would return the form
name,
ID and description so they can find it easily.
--
Lori A. Pong


:

Do you have some table and field names that you could share? What do you
mean by "each one of my forms"? A "form" in Access is an object used to
display records and other stuff to users.

--
Duane Hookom
MS Access MVP

Okay, I'm not sure if this is possible but I have a database that is
being
used company wide. Each one of my forms that might need additional
action
I
have a field for "Next Action Required By:". What would be the
simplest
way
to create a query to search these fields in each form and create a
action
list by user so that when they log in and I can create a button that
would
get the "CurrentUser" and activate the query that way.