Autonumber function?

[wotamelon]

Is there a function for auto number?

eg. Current time: =Now()


How abt one for auto number?

 

[John Big Booty]

Have a look at the Dmax() function. You can us Dmax() +1 to create a custom auto incrementing number.

Check the attached for a practical example.

 

[wotamelon]

Have a look at the Dmax() function. You can us Dmax() +1 to create a custom auto incrementing number.

Check the attached for a practical example.

YAY! ur a champ, always helpful

 

[namliam]

You can also make an autonumber on table level by setting the column type to Autonumber

 

[John Big Booty]

You can also make an autonumber on table level by setting the column type to Autonumber

Ah of course I had assumed the OP was looking for Customs Auto Number.

 

[wotamelon]

Ok, I don't understand the ''Criteria''


DMax ( expression, domain, [criteria] )

I've got expression and domain. what's the criteria referring to? and why is it a number and what for?

 

[wotamelon]

nono, i am looking for a customise autonumber to create a continous invoice number flow

 

[John Big Booty]

Ok, I don't understand the ''Criteria''


DMax ( expression, domain, [criteria] )

I've got expression and domain. what's the criteria referring to? and why is it a number and what for?

From the link I provided;

criteria is optional. It is the WHERE clause to apply to the domain.

 

[John Big Booty]

You could use the Criteria argument to have a number of different auto incrementing number based on say the ClientID so that each client could have their own series of Invoice number.

 

[wotamelon]

this is the function in my txtbox

="TAX INVOICE #M1" & (Nz(DMax("INV","InvoiceNumber")+1))

It's currently sitting in my txtbox in my report.

The report is generated based on query (criteria is that I enter first name and last name of customer)

but when i gen the report, it's always with the same invoice number, even when i view all report. it's still the same invoice number

 

[John Big Booty]

If your using;

="TAX INVOICE #M1" & (Nz(DMax("INV","InvoiceNumber")+1))

INV Should be a Field in table InvoiceNumber

Your code should probably look like;

="TAX INVOICE #M1" & (Nz(DMax("INV","InvoiceNumber"),666)+1)

Where 666 represents your seed number, this should be your intended start number less 1, so in the example I've given here the first number in the invoice sequence will be 667 and would show as TAX INVOICE #M1667

 

[John Big Booty]

Sorry Just notice a flaw in the sample, there is no check to ensure that a record that already has a number is not reassigned the next number in the sequence. This can be rectified by changing the Form's On Current event to;

    If Me.Counter = 0 Then
          Me.Counter = Nz(DMax("Counter", "Table1"), 9910079) + 1
    End If

 

[wotamelon]

but then when i generate the report, it's all coming up as the same invoice number.

the invoice number textbox is in my PAGE HEADER in REPORT

 

[John Big Booty]

Are you creating a new record each time you run your report?

 

[John Big Booty]

The way I would do this is to have a form that represents you Invoice, and button on the form to allow the invoice to be printed. That way each time you you go to a new record you will in effect be generating a new invoice, with an associated new Invoice Number.

 

[wotamelon]

i get what ur saying now