Fields to Access Database Fields

[frito212]

I have an Access database with numeric and Yes/No fields - when I add the fields to my form for these numeric and Yes/No fields - I can not get the data into the Access database.

On the insert record - I clarify the numeric as numeric and the Yes/No as Checkbox Y,N

Is there something else that I need to do?

[Newsgroup_User]

check your box and field names.

[frito212]

I matched the field names and boxes - I also checked that it was numeric on the insert record area.

[frito212]

If I make the Access fields text - it sort of works.

What I want to do is: I have radio group Yes No that I want to put the value into a field in the Access Database - if they select Yes, I want Yes (or a Y) to go into the field, if they select No, I want No (or a N) to be inserted into the Access Database field.

[Newsgroup_User]

We need to see any error message to be really clear on what is happening,
but basically a Yes/No field in Access stores a boolean value. Depending
upon the way that the database is set up this is either 0 -1 or True/False.
It is not Yes or No. If you want to have those types of entry in the field
then change it to a text field.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"frito212" <webforumsuser@macromedia.com> wrote in message
news:e365oo$9cg$1@forums.macromedia.com...
> If I make the Access fields text - it sort of works.
>
> What I want to do is: I have radio group Yes No that I want to put
> the
> value into a field in the Access Database - if they select Yes, I want
> Yes (or
> a Y) to go into the field, if they select No, I want No (or a N) to be
> inserted
> into the Access Database field.
>

[frito212]

I changed the field to text - I am no longer getting an error.

But - the value from the radio group is not correct when it goes into the database. If I select Yes - it might put N in the database or vice versa - doesn't seem to take the correct value that I select?

[frito212]

Here is the code - I'm not sure how to attach the data - but what I did was for the radio buttons, I selected N, Y, Y and it put Y, Y, Y in the database fields.

[frito212]

I'm not sure what I did, but I have it working -

Thank you

[frito212]

It seems to always put Y in the database field no matter if I select the Yes or No radio button.

[Newsgroup_User]

If the field is set to text then it should be getting whateever value you
have set in radio box. If it is not check that the database doesn't have a
default value set.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"frito212" <webforumsuser@macromedia.com> wrote in message
news:e3682n$btl$1@forums.macromedia.com...
>I changed the field to text - I am no longer getting an error.
>
> But - the value from the radio group is not correct when it goes into the
> database. If I select Yes - it might put N in the database or vice
> versa -
> doesn't seem to take the correct value that I select?
>

[Newsgroup_User]

can you post your source and the resulting database entries?