Fields to Access Database Fields

Forum|Forum|19 years ago
May 1, 2006
7 replies
512 views

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?

Server side applications

This topic has been closed for replies.

N

Newsgroup_User

Inspiring

can you post your source and the resulting database entries?

N

Newsgroup_User

Inspiring

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?
>

F

frito212Author

Known Participant

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

F

frito212Author

Known Participant

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?

F

frito212Author

Known Participant

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.

F

frito212Author

Known Participant

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

Thank you

N

Newsgroup_User

Inspiring

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.
>

F

frito212Author

Known Participant

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.

N

Newsgroup_User

Inspiring

check your box and field names.