How to populate User ID and Date into a Data Entry form

S

Sighman

Hi All
I'm trying to build a Data Entry form that populates User Id and
today's date field on a record to we don't have to enter it every time.
I first thought of building an unbound from with a Combo Box and
Calendar to set what the variable should be but I have no experience in
getting those values into fields in another form.
Is this the best way or is there something easier? There will be more
than one user using the database at a time so will that make any
difference?
Any help will be massively appreciated.
 
T

Tom Wickerath

Hi Sighman,

To get the login name (NT UserID), you can use the method shown in this
article:

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

To get today's date, you can use either the Date() function or the Now()
function. Date returns the system date with the time component set to zero
(midnight), whereas Now() returns the date + time.
There will be more than one user using the database at a time so
will that make any difference?
Click to expand...
The MOST important thing that you should plan on doing is splitting the
database into two databases: a front-end (FE) and back-end (BE) database.
Each user should have their own copy of the FE database installed on their
local hard drive. The BE database is placed on the file server. This DB
includes only the shared tables.

There are many "gotchas" that are commonly encountered when going from
single-user JET databases to multi-user JET databases. I have a list of items
that one should pay attention to when going multi-user, which I am willing to
share with you, if you send me a private e-mail message with a valid reply
address. This list includes 5 attached Word documents, and is approx. 468 KB
in size.

Here is a "munged" form of my e-mail address. Whatever you do, please do not
post your real e-mail address to the newsgroup (at least not without
obscuring it). Otherwise, the spammers will love you to death.


Tom

QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi All
I'm trying to build a Data Entry form that populates User Id and
today's date field on a record to we don't have to enter it every time.
I first thought of building an unbound from with a Combo Box and
Calendar to set what the variable should be but I have no experience in
getting those values into fields in another form.
Is this the best way or is there something easier? There will be more
than one user using the database at a time so will that make any
difference?
Any help will be massively appreciated.
 
Top