Reports with Customize Reference No.

[joey0127]

Hi. Pls help me on how to create a Report with Customize Reference No.
Reference Number should be continuously adding 1 count every time a user will print report.
example:

On dec 16, morning..... reference no: THS-01 (1st print)
dec 16, afternoon...reference no: THS-02 (2nd print)
dec 17 morning.....reference no: THS-03 (3rd print)
dec 18 morning.....reference no: THS-04 (4th print) etc....

THS-XX is my reference number and it will continuously counting.
Is this possible in MS Access 2007 Report? If Yes? How can i do it?
Many Thanks in advance

 

[plog]

This is kind of complex, so I will layout the general framework of how this is to be accomplished. You should attempt my general steps and post back here any specific issues you are encountering.

1. You need to control how the users get to the report via a form. If you don't have a form with a button that users click to open the report, make one. And make it so that's the way they open the report.

2. Create a table that will log the report name and the date/time it was run.

3. Modify your report to include an unbound control that displays the reference number you want. You can prefix it with whatever you want ("THX-") and then for the number, you use a Dcount into the table I mentioned in Step 2. That Dcount will determine how many times that button in step 1 has been clicked and will display it on your form.

4. Using VBA, when that report button in step 1 gets clicked, you insert a record into the table in step 2 and then you open the report.

Implement those steps and you will achieve what you want. If you have specific questions, post back here with what you have tried, any error messages and what you are stuck with.

 

[joey0127]

Thank you for your reply.
I'm trying to do this step by step. I already done the 1st step.
But I don't know how to accomplish the 2nd step. Can u guide how to do it?
sorry i forgot to mentioned that i'm only a beginner and this is my 1st access db.

 

[plog]

No offense, but step 2 was the easiest of the bunch. Creating tables is the most fundamental step in building a database.

Start with this tutorial:

http://office.microsoft.com/en-us/training/get-to-know-access-RZ006118141.aspx

Or possibly get a beginner level book.