Adding record to MDB

[Leif Hauge]

I have a problem with adding a record to my MDB database. I know how to add
products, but as soon as I use a checkbox to add "selected" or "not
selected", I get the message "Error desc. -> [Microsoft][ODBC Microsoft
Access Driver] Data type mismatch in criteria expression."

How do I add a checkbox value into my MDB database ? I have chosen a
"YES/NO" value to my field, and the rest of the fields worked before adding
this checkbox.

Best regards
Leif

[Ken Schaefer]

>> The error is on line 8

> How do you know? I didn't post any code

Exactly!

Cheers
Ken


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Leif Hauge" <leif76@online.no> wrote in message
news:%236b$rQFRDHA.3796@tk2msftngp13.phx.gbl...
: I have a problem with adding a record to my MDB database. I know how to
add
: products, but as soon as I use a checkbox to add "selected" or "not
: selected", I get the message "Error desc. -> [Microsoft][ODBC Microsoft
: Access Driver] Data type mismatch in criteria expression."
:
: How do I add a checkbox value into my MDB database ? I have chosen a
: "YES/NO" value to my field, and the rest of the fields worked before
adding
: this checkbox.
:
: Best regards
: Leif
:
:

[Bob Barrows]

Mosley wrote:

> "Leif Hauge" <leif76@online.no> wrote in message
> news:%236b$rQFRDHA.3796@tk2msftngp13.phx.gbl...

>> I have a problem with adding a record to my MDB database. I know how
>> to add products, but as soon as I use a checkbox to add "selected"
>> or "not selected", I get the message "Error desc. ->
>> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
>> criteria expression."
>>
>> How do I add a checkbox value into my MDB database ? I have chosen a
>> "YES/NO" value to my field, and the rest of the fields worked before
>> adding this checkbox.
>>
>> Best regards
>> Leif
>>

>
>
> don't use 'yes no',
>
> use a text field,
>
> a check box enters the word 'on'

Not necessarily. A checkbox either returns the word "on", or whatever word
you have set its value property to.

> into the database or nothing if it
> is not checked.

You can use a checkbox. Just use an If statement to process the user's
input. If the user checked the box, then its value will have a length
greater than 0:

Dim ChkBoxValue
ChkBoxValue=request.form("CheckBox")
If len(ChkBoxValue) > 0 then
ChkBoxValue = -1
else
ChkBoxValue = 0
end if

Now pass the value contained in ChkBoxValue to your SQL statement.

HTH,
Bob Barrows