By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Autonumber

P: 6
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
May 13 '08 #1
Share this Question
Share on Google+
4 Replies


missinglinq
Expert 2.5K+
P: 3,532
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)>
May 13 '08 #2

P: 6
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!
May 13 '08 #3

NeoPa
Expert Mod 15k+
P: 31,489
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.
May 14 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
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)>
May 14 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.