Recording which reports been ran

[cocoonfx]

I have created a data base inwhich a user can run 6 reports. I then have a manager who has a administration form which i want the manager to see what reports have been ran and what day.

to run the reports the user hits a button in another form, which then exports a qry to excel.

All the buttons have been named and each report has its own marco name.

Is there a way i can do this simply??

 

[ghudson]

Just create a table to store the "report run" information when the user clicks the button to run [open] the report. Use an append query [sql] to add the fields and data you want captured. Like the users name, name of the report, the date and time, etc.

 

[cocoonfx]

thank you

Hello i am pretty new to access,

i know how to do a basic SQL but i have not got a clue how to get the user name etc....

Is there any tutorials you could point me to or give me an example of what the code should look like??

 

[ghudson]

Search the forum for the Environ() function. Add my user name to your search and see the examples I have posted.

 

[cocoonfx]

Help?

I am sorry but i have searched and i can not think how to do this...

Is it possible to have some example code, where apon i can see how it can be done!

So i have 3 buttons:

1 Button - when clicked opens opens in excel report 1
2 Button - when clicked opens opens in excel report 2
3 Button - when clicked opens opens in excel report 3

I then want to see in another form which is an overview screen:

Date Report User
01/01/2005 Report 1 Joe Bloggs
02/01/2005 Report 2 John Brown

Is there a simple code which i can record pull this information.

HELP???

 

[cocoonfx]

Help!

CAN ANYONE HELP? i have search the internet and spent 3 days trying to figure this out HELLLLLLLLLLLP?

 

[WIS]

CAN ANYONE HELP? i have search the internet and spent 3 days trying to figure this out HELLLLLLLLLLLP?

The following is one way to approach it. There would be several ways to do so.

1. Put a command button "Run A Report" on the form. In the Click event of the button have it open a pop up form with 2 combo boxes, cboReport and cboPersonnel.

2. In the pop up form:
cboReport data Report1, Report2 etc
cboPersonnel data Joe Bloggs, Fred Nerd etc

3. In the AfterUpdate event of the 2nd combo, (cboPersonnel) put code to:
Close the popup form.
Produce the report selected from cboReport.
Write data to a table, say tblReportRun, with the fields:
ReportRunID,Autonumber
DateReportRun, Date, Default value Date()
ReportRun, Text (from cboReport selection)
Personnel, Text (from cboPersonnel selection)

4. The Manager form can then read the data from tblReportRun.

This may look a bit cumbersome but it will enable you to change the no of reports and personnel very easily simply by changing the data source of the 2 combo boxes.