Autonumber

[Jake Bee]

I have a Request ID populate by AutoNumber. When the used
enters Log A New Request, we want the next sequenced AutoNumber to become visible (these are program assignements) so that the user can inform the programmer of the next program assignment number. I can not seem to make the AutoNumber visible. The only this that shows up in the field box is "AutoNumber". How can I make the next sequentail AutoNumber visible on log a new request?

Thanks!

Jake

[missinglinq]

I'm sorry, but I'm not sure of what you're actually saying. The actual AutoNumber will only become "visible" when a new record is initiated , i.e. when the first character is entered in any field of the new record.

Linq ;0)>

[Jake Bee]

I'm sorry, but I'm not sure of what you're actually saying. The actual AutoNumber will only become "visible" when a new record is initiated , i.e. when the first character is entered in any field of the new record.

Linq ;0)>

Do you mean upon entering a new request that that auto number will not become visibile until after the record is entered? Thanks! And these no way to determine the last record id and increment that value to generate the next auto number. Thanks again!

[NeoPa]

Do you mean upon entering a new request that that auto number will not become visibile until after the record is entered?

Yes.

And the[re's] no way to determine the last record id and increment that value to generate the next auto number.

That is possible. It is not consistent with using AutoNumbers though. It's also a little messy if ever you want the process to be multi-user.

[missinglinq]

As NeoPa indicated, you can determine the last AutoNumber generated, but adding one to that won't necessarily yield the next AutoNumber Access will generate! Any record that's deleted will leave a gap as will hitting <Esc> after starting a record. Adding records using an Append Query may leave a gap, often a huge one. All of these things can foul up any hack to retrieve the "last" number and add one to it to dsetermnine the "next" AutoNumber.

If, for example, the record with the AutoNumber 1001 is deleted, you then retrieve the last AutoNumber in the table, which is now 1000, and add one to it, you'll get 1001, but in actuality Access will generate 1002.

What, exactly, do you mean by "Entering a new request?"Linq ;0)>