Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

is possible add auto

Forum home » Delegate support and help forum » Microsoft Access Training and help » Is it possible to add an auto number to an unbound report?

Is it possible to add an auto number to an unbound report?

ResolvedVersion 2003

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

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

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

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

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.