Advertisement

05.14.2008 at 03:03PM PDT, ID: 23403328
[x]
Attachment Details

Sequential Number - In Addition To Autonumber

Asked by alliedtech in Access Forms, Microsoft Access Database, Access Coding/Macros

Tags: Microsoft, Access, 2007

I have a table that contains bid information.

BidId - Autonumber
BidNumber - I want this to be a sequential number, but without skipping numbers.

Me!BidNumber = Nz(DMax("BidNumber", "tblBidLog"), 0) + 1

I originally placed the above code in the before update of the data entry form.  The code works, but the "Bid Number" field is left blank since the code does not fire until the record is saved.  In an attempt to fix the problem, I tried placing the code in OnCurrent, On Open, OnLoad, etc, but with no success.

I want the data entry form to open and have the next number in line in the bid number field, but when I open the form, it skip the next number and assigns what should be the next number to bid #1.  Example...

Dmax is 362.  The form should open to bid #363, but instead opens to bid #364.  Bid # 1 is somehow converted to Bid#363, thus explaining why 364 becomes the new max number.

Start Free Trial
 
Keywords: Sequential Number - In Addition To Au…
Title
1 AutoNumber
2 Autonumbers
3 Delete out-of-range AutoNumber Pri…
4 How can i reset the AutoNumber in a t…
5 "autonumber"
6 autonumber
 
Loading Advertisement...
 
[+][-]05.14.2008 at 03:20PM PDT, ID: 21569210

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.14.2008 at 03:24PM PDT, ID: 21569226

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.14.2008 at 04:27PM PDT, ID: 21569526

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 06:03AM PDT, ID: 21573076

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Forms, Microsoft Access Database, Access Coding/Macros
Tags: Microsoft, Access, 2007
Sign Up Now!
Solution Provided By: JDettman
Participating Experts: 3
Solution Grade: A
 
 
[+][-]05.16.2008 at 01:05PM PDT, ID: 21585988

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 01:47PM PDT, ID: 21586319

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 02:05PM PDT, ID: 21586441

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.16.2008 at 02:42PM PDT, ID: 21586685

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 02:43PM PDT, ID: 21586690

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 10:48AM PDT, ID: 21593401

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.19.2008 at 07:46AM PDT, ID: 21598244

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 07:54AM PDT, ID: 21598329

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628