Forum home » Delegate support and help forum » Microsoft Access Training and help » Is it possible to add an auto number to an unbound report?
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Is it possible to add an auto number to an unbound report?
Resolved · High Priority · Version 2003
Reply Tue 19 Oct 2010, 08:53Delegate Joanne said...
Joanne has attended:
Access VBA course
Is it possible to add an auto number to an unbound report?
Is it poosible to add an auto number to a report that is not bound to any thing because its document that can be printed off by the user. But I want the report to have a new number each time it is printed off is this possible.
Thanks
jo
For upcoming training course dates see: Pricing & availability
RE: Is it possible to add an auto number to an unbound report?
Hi Joanne
Thanks for your question
An auto number is a data type, and therefore refers to a filed. As an unbound report has no fields behind it, the auto number cannot be used.
I suggest creating a table and storing the current report number as a long integer. I would the write code that runs when the report opens to increase the number by 1 and then update the number stored in the table
Regards
Stephen
Reply Wed 20 Oct 2010, 12:26Delegate Joanne said...
RE: Is it possible to add an auto number to an unbound report?
Do you know what the code is for this please?
thanks
Jo
Reply Wed 20 Oct 2010, 13:06Delegate Joanne said...
RE: Is it possible to add an auto number to an unbound report?
Hi just to let you know I have got this working with code etc
Thanks for your reply
Jo
|