Call function fOSUserName into Query 1

[Steven547]

I have a function: fOSUserName
This grabs the current user name. I want to store that username in a table along with the date, so I know immediately, who is in the database incase I have to have them log out. And when they log out, the table should be updated with the date and time of logging out as well.

I'm not that good with writing "SQL" code for appends in VBA, so i was going to start with a query. Obviously it would have to be an append query, but how would I call that function: fOSUserName to the query or how would you recommend going about this?

thanks.

 

[PHV]

Provided that fOSUserName is a public function in a standard code module:
INSERT INTO yourTable (usrName,sysDate,typLogging)
VALUES (fOSUserName(),Now(),'IN')

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

 

[Steven547]

Let me see if I understand this:

INSERT INTO yourTable (usrName,sysDate,typLogging)
VALUES (fOSUserName(),Now(),'IN')

yourTable: My table name obviously.

usrName,sysDate,typLogging): These are the field names in my table?

VALUES (fOSUserName(),Now(),'IN'):
fOSUserName: the user name
Now(): the current date

'IN': What would this be? Oh wait, would that be the "switch" that the user is "IN" (as opposed to "out") the system...

 

[PHV]

Seems you've understood well ...

 

[Steven547]

Thank you very much!

 

[Steven547]

OK..Update:

It doesn't seem to be updating my table...This is what I have:

Dim strSQL As String

strSQL = "insert into tblUsers(UserName,StartDate) Values (fOSUserName(), Now())"


(sorry, I'm still new to the DIM, etc)

 

[PHV]

Add the following line:
DoCmd.RunSQL strSQL

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

 

[Steven547]

I guess that would be the same as what I did. I wound up creating a query based on the "insert into". And on load of the form, I just docmd and run that query. So far so good. I'll have to look into the above suggestion. Would probably be more "convenient".