Need VB code for add sequential records to table

[Danny M]

I need the code for adding sequential records to a table.

My table name is "WiresOut"
My field for updating is "Number" and is a text field
My field on the form is "Number"
My Starting number "B0000"

Any help would be appreciated

 

[Keith W]

I need the code for adding sequential records to a table.

My table name is "WiresOut"
My field for updating is "Number" and is a text field
My field on the form is "Number"
My Starting number "B0000"

Any help would be appreciated

You can have sequential numbers by setting a textbox default value to (IIRC)
"=DMax([MyNumberField])+1". You'd need to handle nulls if you're supplying
an empty database to your user(s). If the alpha part of the "number" is
always the same then there's no need to store it. BTW I wouldn't user
"Number" as a field name as it may cause confusion when you come to write
code.

HTH - Keith.
www.keithwilby.com

 

[Danny M]

Keith

what is (IIRC)

I need the code for adding sequential records to a table.

My table name is "WiresOut"
My field for updating is "Number" and is a text field
My field on the form is "Number"
My Starting number "B0000"

Any help would be appreciated

You can have sequential numbers by setting a textbox default value to
(IIRC) "=DMax([MyNumberField])+1". You'd need to handle nulls if you're
supplying an empty database to your user(s). If the alpha part of the
"number" is always the same then there's no need to store it. BTW I
wouldn't user "Number" as a field name as it may cause confusion when you
come to write code.

HTH - Keith.
www.keithwilby.com

 

[Danny M]

Keith

I put this code in the text box default value and received a error when i
pulled the form up.

I need the code for adding sequential records to a table.

My table name is "WiresOut"
My field for updating is "Number" and is a text field
My field on the form is "Number"
My Starting number "B0000"

Any help would be appreciated

You can have sequential numbers by setting a textbox default value to
(IIRC) "=DMax([MyNumberField])+1". You'd need to handle nulls if you're
supplying an empty database to your user(s). If the alpha part of the
"number" is always the same then there's no need to store it. BTW I
wouldn't user "Number" as a field name as it may cause confusion when you
come to write code.

HTH - Keith.
www.keithwilby.com

 

[Larry Linson]

IIRC = If I Recall Correctly

Keith

what is (IIRC)

I need the code for adding sequential records to a table.

My table name is "WiresOut"
My field for updating is "Number" and is a text field
My field on the form is "Number"
My Starting number "B0000"

Any help would be appreciated

You can have sequential numbers by setting a textbox default value to
(IIRC) "=DMax([MyNumberField])+1". You'd need to handle nulls if you're
supplying an empty database to your user(s). If the alpha part of the
"number" is always the same then there's no need to store it. BTW I
wouldn't user "Number" as a field name as it may cause confusion when you
come to write code.

HTH - Keith.
www.keithwilby.com

 

[Keith W]

Keith

I put this code in the text box default value and received a error when i
pulled the form up.

What *exactly* did you put in the box and what error did you receive?

 

[Danny M]

Keith

I put the following code

"=DMax([Control])+1"

i took your suggestion and changed the field to Control
The error is #error in the field when i pull the form up
i also tried it like this =DMax([Control])+1

thanks
danny

 

[Keith W]

Keith

I put the following code

"=DMax([Control])+1"

i took your suggestion and changed the field to Control
The error is #error in the field when i pull the form up
i also tried it like this =DMax([Control])+1

My apologies, the correct format is

DMax("[FieldName]","TableName")+1

If the table empty then try using the null to zero function:

nz(DMax("[FieldName]","TableName"),0)+1

HTH - Keith.
www.keithwilby.com