Adding data to table with code

[puforee]

I have some code, that I got from one of these forums, that will return the userID of the person logged in to my DB. I want to create a log (withing a table) that contains the UserID, Time/Date and store it in a new record in the table. In VB how to I add data to a table in a new record.

So, when a user logs on.... the code would put their userID and date/time into two fields in the table.

Thanks,

 

[PHV]

CurrentDb.Execute "INSERT INTO [your table] ([user ID field],[Date/time field])" _
 & " VALUES ('" & userIDvariable & "',#" & Now & "#)"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[puforee]

Thanks,

I will give this a try.

Thanks very much.

 

[puforee]

PHV,

I am trying your code and getting partial success...can you help a little more.

Fileds I need to store

UseID field from generated by Function...variable fOSUserName

Date/Time filed..I think your code shows this

Name field...I this will be a changing varriable depending on what button is pushed and will equal the button label.

Finally, can your code be part of the UserID Function...this contains API calls for userID. Or should it be seperate code that is run when I click a button.

Thanks,

 

[puforee]

OH, and one thing I forgot. The UserID field and the Name fields are formatted text. Of course the Date/Time filed is formatted for date and time.