Table default value question

[Silvio]

Can a table default value be the value from a loaded form? Here is my
dilemma, whenever I create a new record via a form, I have codes to detect
the user’s LAN ID and store this information in a field called CreatedBy.
However, now I can collect data via e-mail and automatically upload the
information into Access and you already know what there will not be a
CreatedBy data. Therefore, I think if I could place the CreatedBy default
value directly from the table to look up the user name already loaded in the
database “Welcome Screen†that will save user LAN ID regardless how the data
was entered. Can it be done? Any suggestion? I have tried what normally works
for form default value but it does not work from the table.

Thank you,
Silvio

 

[GBA]

thinking out loud ; you know the ID but it isn't in the email data...

varying a table's field default property seems unfeasible...

can't you either make a query that joins in the ID to the email data....or
do an UpdateQuery right after the email data entry to move that ID value into
the correct record?

 

[pietlinden]

Can a table default value be the value from a loaded form? Here is my
dilemma, whenever I create a new record via a form, I have codes to detect
the user’s LAN ID and store this information in a field called CreatedBy.
However, now I can collect data via e-mail and automatically upload the
information into Access and you already know what there will not be a
CreatedBy data. Therefore, I think if I could place the CreatedBy default
value directly from the table to look up the user name already loaded in the
database “Welcome Screen” that will save user LAN ID regardless how the data
was entered. Can it be done? Any suggestion? I have tried what normally works
for form default value but it does not work from the table.

Thank you,
Silvio

If the user is submitting his data via e-mail, can you not use his e-
mail account to derive/determine his network login/username? Then you
could just update the records that are e-mailed.

Okay, so you can grab the user's domain account name and write it to
the DB if you use a form to enter data. If the user has e-mailed his
data, then you should be able to