Logging New Database entries in Access

[mab9981]

I have a database that i want to track users entries they have added. How can i do that?

[ChrisRC]

Depending on your environment, the simplest solution is to use the currentuser() function.

[madisonPete]

hi,
First.... you'll need an ADDDATE entry which can be generated every time a record is added to the data base.

Build a query based on that table.... then a report based on that query . . .

In the query for ADDDATE cell enter the
following into the "criteria" cell for ADDDATE:

Between [Beginning Date] And [Ending Date]

Then build a report that will access that query. . .

When you open that report, a box will pop up looking for a begining and ending date.

Access does this automatically when it sees the criteria as part of the report.

Fill in the begin - end date, enter and the report should appear on the screen.

To print . . use the ctrl + p key.
Should print to the printer.

Check out this link: http://www.gochipmunk.com/html/home.html

Top row of choices: click on "Type Manager" choice.
I won't go into long explanations here.

Need Acrobat reader on your machine. Get a free one at www.adobe.com .....

Click Type Manager choice on top row... then click choice on next screen. Examples of reports to view....
Have fun.
pete