Autonumbering Reports

[uselessataccess]

Hey there,

I want to number reports for auditing purposes. is there any way to this? I know i can do it manually with a prompt box but is there anyway to auto generate it? So, I would want the first report i produce numbered one, 2nd one numbered 2 etc...

Thanks A mill,

C.

 

[dkinley]

So ... you want something that is fire and forget?

If that is so, you can set a control on your report, set it's default value to 1, and use a running sum so it will do this.

I am not sure if this is what you want, not enough information. The next time you run this same report - it will start from 1 again and have no memory of the previous running of the same report.

-dK

 

[uselessataccess]

So ... you want something that is fire and forget?

If that is so, you can set a control on your report, set it's default value to 1, and use a running sum so it will do this.

I am not sure if this is what you want, not enough information. The next time you run this same report - it will start from 1 again and have no memory of the previous running of the same report.

-dK

Sorry if I was unclear and thanks for your attempt at understanding!

I want something that DOES remember what has gone before it...its not a biggy I can just get the prompt but I thought an autonumber would be more elegant!

 

[dkinley]

You are correct, an autonumbering of sorts would be more elegant. If you wanted to track who ran the report, then a normal autonumber field would work (a new record would be added for the who field thus incrementing your autonumber field).

I've never done what you are requesting, but perhaps a report tracking table that has a report name field and a field that you would increment manually. I am not sure if there is a better way, but let's suppose you went this route.

When the user clicks the button to print a report, then a new form (pop-up) displays on the screen which shows the appropriate record from the appropriate table with both fields (locked controls so the user can't manipulate them) but visible so they can see it. When they press a button on this form "Print" then the code on the on-click button would take the print count field and increment it by one.

On the report, you can then put a reference to this pop up form on unbound controls if you want it displayed on the report (where the data source = Forms!PopupForm!txtControlName).

Again, just spitballing at my initial approach because I've never done anything like this. You might be able to do this all on the report, but that is beyond my knowledge. I just use reports to collate and give dashboard style information.

-dK