Database Usage Counter in Main Form

[rkalapura]

Hai Guys,

I am using Access 2010 and I have a small database in our company network, which is using by many of my collegues. I wish to put a counter on the Main Menu Form, which gives how many times this database is opened. I mean, every time I close the database and re-open it again, the counter should increment by one. My form name is "Main Menu" where I want to put the counter on the top right corner to see how many times this database has been opened for use.

Thank you in advance for your help.


Regards

[pbaldy]

If all you want is a count, create a table with one Long Integer field. In the load event of your form:

CurrentDb.Execute "UPDATE TableName SET FieldName = FieldName + 1"

In a textbox on your form

=DLookup("FieldName", "TableName")

[rkalapura]

Thanks Paul for the reply. It gives error. "Cannot identify Current Db........"

Secondly I have already assigned a table to the main form. How can I assign the new table (I mean both tables) to my existing form?
Thanks

[pbaldy]

What I posted is VBA code; it would go here:

http://www.baldyweb.com/FirstVBA.htm

The method I gave would be independent of the table the form is bound to. You don't have to assign anything.

[rkalapura]

Thank you Paul. It works fine now. Thanks a lot.

[pbaldy]

Happy to help.