Recent content by Alg1961

No, 4.000.000 and more. The database is located on a server. And it looks like access opens the same menu several time a minute and does this for every user.

I decided to run the code "on open". Great logging. Exept after one hour the tbllog file was over 4.000.000 records. Had to remove it. My access database is used by about 35 people 24 hours a day. So I have to learn a bit more about how access behaves in a network. But it's like my colleage...

Learned a lot today. Problem solved. Thanks! :)

Thanks Ken. But what I am looking for is one query for more than one form. So in the query where "appLogForm1" is appended to the logvalue there should be the formname. // Alg

field mnu: [me].[name] append to menu Sorry tried that. Then I get the question "enter parameter value" [me].[name]

userlogging No just i a table in the same database.

logging I want to log the formname or the contents of a identifying field on the form to be able to see which user has used a form.

I want to record the form name and the username when a users opens a form. The username works with the getuser() function but the form name or any other identifying form item does not. On each form I also have put a hidden field called ID but even the value of this does not return to my query...