creating a log file with MS Access

I currently have a database that uses MS Access, with a login system. I
used the built in security system of access to do this, which is in
(.MDW) format.

The problem i have now is that I want to create a log file of all the
people that logged in the database. Which means, it would display:
There username, date/time they logged in etc. My system also has a
splashscreen and a switchboard.

"snipersix" wrote in message
oups.com...
I currently have a database that uses MS Access, with a login system. I
used the built in security system of access to do this, which is in
(.MDW) format.

The problem i have now is that I want to create a log file of all the
people that logged in the database. Which means, it would display:
There username, date/time they logged in etc. My system also has a
splashscreen and a switchboard.

And your question regarding that is?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

well my question is, how do i create a log file given this situation,
like what are the codes necessary to do this.


Rick Brandt wrote:
"snipersix" wrote in message
oups.com...
I currently have a database that uses MS Access, with a login system. I
used the built in security system of access to do this, which is in
(.MDW) format.

The problem i have now is that I want to create a log file of all the
people that logged in the database. Which means, it would display:
There username, date/time they logged in etc. My system also has a
splashscreen and a switchboard.

And your question regarding that is?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"snipersix" wrote in message
oups.com...
well my question is, how do i create a log file given this situation,
like what are the codes necessary to do this.

Create the table with the desired fields. In your startup code run an append
query to add a row to that table.

EXAMPLE:

INSERT INTO TableName (UserNameField, LoginTimeField)
VALUES(CurrentUser, Now())

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

where do i insert the code in my splash screen or in the table?


Rick Brandt wrote:
"snipersix" wrote in message
oups.com...
well my question is, how do i create a log file given this situation,
like what are the codes necessary to do this.

Create the table with the desired fields. In your startup code run an append
query to add a row to that table.

EXAMPLE:

INSERT INTO TableName (UserNameField, LoginTimeField)
VALUES(CurrentUser, Now())

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"snipersix" wrote in message
oups.com...
where do i insert the code in my splash screen or in the table?

If you have a form that is automatically opened at startup you can execute the
query in the Open or Load event of that form.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

another question, what is the code for called an append query in a
form?


Rick Brandt wrote:
"snipersix" wrote in message
oups.com...
where do i insert the code in my splash screen or in the table?

If you have a form that is automatically opened at startup you can execute the
query in the Open or Load event of that form.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"snipersix" wrote in message
ups.com...
another question, what is the code for called an append query in a
form?

If you create a saved query you can use...

CurrentDB.Execute "QueryName", dbFailOnError

As an alternative the same command above could be used with a SQL statement
substituted for the query name.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Sorry i meant, whats the code for calling an append query in a form?




snipersix wrote:
another question, what is the code for called an append query in a
form?


Rick Brandt wrote:
"snipersix" wrote in message
oups.com...
where do i insert the code in my splash screen or in the table?

If you have a form that is automatically opened at startup you can execute the
query in the Open or Load event of that form.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

where do you place this code

INSERT INTO TableName (UserNameField, LoginTimeField)
VALUES(CurrentUser, Now())



snipersix wrote:
Sorry i meant, whats the code for calling an append query in a form?




snipersix wrote:
another question, what is the code for called an append query in a
form?


Rick Brandt wrote:
"snipersix" wrote in message
oups.com...
where do i insert the code in my splash screen or in the table?

If you have a form that is automatically opened at startup you can execute the
query in the Open or Load event of that form.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com