dmax stop at 10 records

[Guest]

Hi All,

I have the following dmax on my form in the before insert event:

Me!vdrid = Nz(DMax("[vdrid]", "tblNewVendor") + 1

The vdrid field is a text field.

After adding a 1 to the next record, it stopped at 10.

How do I get it to continue to 11, 12, 13 etc.

Thank you all for your help.

 

[tina]

the simplest solution would be to change the vdrid field's data type from
Text to Number, with a size big enough to accommodate current and future
anticipated needs.

if you don't want to do that for some reason, try

Me!vdrid = CLng(Nz(DMax("[vdrid]", "tblNewVendor"), 0)) + 1

hth

 

[Granny Spitz via AccessMonster.com]

The vdrid field is a text field.

Make it a Long data type.

 

[Guest]

Thank you Tina and Granny Spitz. I will give it a try.

the simplest solution would be to change the vdrid field's data type from
Text to Number, with a size big enough to accommodate current and future
anticipated needs.

if you don't want to do that for some reason, try

Me!vdrid = CLng(Nz(DMax("[vdrid]", "tblNewVendor"), 0)) + 1

hth

Hi All,

I have the following dmax on my form in the before insert event:

Me!vdrid = Nz(DMax("[vdrid]", "tblNewVendor") + 1

The vdrid field is a text field.

After adding a 1 to the next record, it stopped at 10.

How do I get it to continue to 11, 12, 13 etc.

Thank you all for your help.

 

[Guest]

Sorry, Tina. It doesn't work. It stopped at the 10 records. I need the
field type to be text.

the simplest solution would be to change the vdrid field's data type from
Text to Number, with a size big enough to accommodate current and future
anticipated needs.

if you don't want to do that for some reason, try

Me!vdrid = CLng(Nz(DMax("[vdrid]", "tblNewVendor"), 0)) + 1

hth

Hi All,

I have the following dmax on my form in the before insert event:

Me!vdrid = Nz(DMax("[vdrid]", "tblNewVendor") + 1

The vdrid field is a text field.

After adding a 1 to the next record, it stopped at 10.

How do I get it to continue to 11, 12, 13 etc.

Thank you all for your help.

 

[Guest]

Hi, I don't think that Tina's advice will make a different.
The best way is to change the field type to number just as Granny suggested,
bu if you have to keep the field as text, then the convert should be inside
the DMax

Me!vdrid = Nz(DMax("CLng([vdrid])", "tblNewVendor"), 0) + 1

--
Good Luck
BS"D

Thank you Tina and Granny Spitz. I will give it a try.

the simplest solution would be to change the vdrid field's data type from
Text to Number, with a size big enough to accommodate current and future
anticipated needs.

if you don't want to do that for some reason, try

Me!vdrid = CLng(Nz(DMax("[vdrid]", "tblNewVendor"), 0)) + 1

hth

Hi All,

I have the following dmax on my form in the before insert event:

Me!vdrid = Nz(DMax("[vdrid]", "tblNewVendor") + 1

The vdrid field is a text field.

After adding a 1 to the next record, it stopped at 10.

How do I get it to continue to 11, 12, 13 etc.

Thank you all for your help.

 

[Guest]

Thank you Ofer Cohen for your help. It works beautifully.

Hi, I don't think that Tina's advice will make a different.
The best way is to change the field type to number just as Granny suggested,
bu if you have to keep the field as text, then the convert should be inside
the DMax

Me!vdrid = Nz(DMax("CLng([vdrid])", "tblNewVendor"), 0) + 1

--
Good Luck
BS"D

Thank you Tina and Granny Spitz. I will give it a try.

the simplest solution would be to change the vdrid field's data type from
Text to Number, with a size big enough to accommodate current and future
anticipated needs.

if you don't want to do that for some reason, try

Me!vdrid = CLng(Nz(DMax("[vdrid]", "tblNewVendor"), 0)) + 1

hth


Hi All,

I have the following dmax on my form in the before insert event:

Me!vdrid = Nz(DMax("[vdrid]", "tblNewVendor") + 1

The vdrid field is a text field.

After adding a 1 to the next record, it stopped at 10.

How do I get it to continue to 11, 12, 13 etc.

Thank you all for your help.