users retrieval

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 users accessing my dbase. I have a listbox where users select their
names before entering records in dbase

how can I know the number of records entered by each users on a specific
date or by time.

any help will be highly appreciated
 
Hi, Gerald.
how can I know the number of records entered by each users on a specific
date or by time.
Click to expand...

Your form also needs to save the date the record was created, so alter the
table to include the DateCreated field (Date/Time data type), and then create
a text box on the form bound to this field. Set the DefaultValue Property of
the text box to Date( ). This will save the date that any new record was
created.

To determine how many records were entered by a certain user on a certain
date, create a new query and try:

SELECT COUNT(ID) AS Num
FROM tblMyTable
WHERE ((DateCreated = #10/15/2005#) AND (UserName = "Gerald"));

.. . . where ID is the primary key of the record, tblMyTable is the name of
the table, DateCreated is the date the record was created by the user, and
UserName is the field containing the user's name as selected from the list
box when the record was created.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
The message was posted from his regular IP address, so you know this is
going to be one of those stories that starts out with:

"But officer! I can explain _everything_!!!"

So start 'splaining, Rob. ;-)

Gunny
 
Thanks, really appreciated.

one last q ? can I get the login username of the user in their shared dbase.
i.e. users need not select their name from list (field username), it displays
automatically as soon as they open the form in the username field
This will avoid others to change the username in their absence

hope there is a way

thanks
 
Hi Gerald,

Yes, you can. Try this link:

API: Get Login name
http://www.mvps.org/access/api/api0008.htm


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Thanks, really appreciated.

one last q ? can I get the login username of the user in their shared dbase.
i.e. users need not select their name from list (field username), it displays
automatically as soon as they open the form in the username field
This will avoid others to change the username in their absence

hope there is a way

thanks
 
Back
Top