Re: Need VB code for add sequential records to table
- From: "Danny M" <prosoldier@xxxxxxxxxxx>
- Date: Mon, 14 Nov 2005 14:23:34 -0600
Keith
I put this code in the text box default value and received a error when i
pulled the form up.
"Keith W" <here@xxxxxxxxx> wrote in message
news:4378bb22$1_1@xxxxxxxxxxxxxxxxxxxxxxxxx
> "Danny M" <prosoldier@xxxxxxxxxxx> wrote in message
> news:OsxnEiT6FHA.3616@xxxxxxxxxxxxxxxxxxxxxxx
>>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
>
.
- References:
- Need VB code for add sequential records to table
- From: Danny M
- Need VB code for add sequential records to table
- Prev by Date: Re: KeyDown Event Question
- Next by Date: Re: Disable hitting function keys
- Previous by thread: Need VB code for add sequential records to table
- Next by thread: Re: Need VB code for add sequential records to table
- Index(es):
Relevant Pages
|
