Auto update table on Form Load

J

Jologs

Hi:

I have a splash screen (form) bounds to a tblLogin. The form has a txtbox
for userid (automatically captured network id) and currentdate (default value
=now()). I want to update my tblLogin everytime the Form loads. Thanks.

Allan
 
J

Jeff Boyce

Are you limiting yourself to only when the form loads? Why?

Have you tried explicitly saving the record when the splash screen closes?

Good luck

Jeff Boyce
<Access MVP>
 
J

Jologs

Your assumption was correct, I'm tracking the user's login. I'll try to
incorporate your codes. Thank you very much.
 
J

Jologs

Hi:

I'm having a problem with your codes, it cause 'Variable not defined' for
the 'dbFailOnError'. And when I omit it, the error is "Syntax Error in
INSERT INTO statement'. Sorry, but I'm just a beginner, so I need a complete
codes. Thanks.


Jologs said:
Your assumption was correct, I'm tracking the user's login. I'll try to
incorporate your codes. Thank you very much.

--
Allan


Pringle9984 said:
Not quite sure what happened there... lets try again :)

strSQL = "INSERT INTO [tblLogin]
(userID, date) VALUES ('" & txtUserID &
"', '" & txtDate & "');"
DBEngine(0)(0).Execute strSQL, dbFailOnError


That's better :)
Click to expand...
Click to expand...
 
Top