|
|
Microsoft Access, Please help!
|
|
|
|
Mac Elite
Join Date: Jul 2002
Location: Syracuse
Status:
Offline
|
|
Yes I know, wrong forum. However, I don't belong to any PC forums and I'm sure some of you have to use this at work. Here is what I want to do:
I need to create a form where users can input data that is then written to the table. I want to have questions such as these: Gender, with radio buttons for male, female. I will have fields in my table that are gender_male and gender_female. If they click male, it will print a 0 to female and 1 to male, and visa versa. I also want to have checkbox questions, in which they can click as many options as they want, similarly printing 0 and 1 as yes/no responses in their respective fields of the data table.
I can make checkbox and option button questions in the form wizard, but I cant figure out how to link each response to its own field in the table. All it lets me do in a multiple response question is assign a 1, 2, 3, 4 etc to each variable, and link that to one field of the table. Please help!
|
Imac Core Duo 1.83/1.5 GB/20 inch cinema, ibook G4 1 ghz
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Nov 2001
Status:
Offline
|
|
c'mon, dude. Access doesn't even RUN on the Mac.
Maybe you could Join a windows forum :-P
|
|
|
|
|
|
|
|
|
Addicted to MacNN
Join Date: Jul 2005
Location: Cooperstown '09
Status:
Offline
|
|
Interesting thread.
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Apr 2005
Status:
Offline
|
|
Create your table first. When you specify the name of the fields in the table, you also set the properties (i.e. text, number, date, or yes/no). To do what you want, set the field property to 'yes/no'. Once the table is complete, then go to the form wizard and tell it to create the form based on your table.
Alternatively, if you create the form first, right-click on the radio button/checkbox and select 'properties -> control source' and then select the appropriate table and field that you want to link the widget to.
This is pretty basic stuff, you may want to pick up a book on designing Access DB's if you're doing this for work.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|