 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / August 2006Forms and option boxes information
I apologise for my lack of Access knowledge but this is my first attempt at setting up a database. I have designed a form to make it easier to put information into my main table but when i use the option box in my form the information that is transferred into the table it appears as a number. How can I get the information in the main table to show the selected option as a word?  SignatureThanks WoodyAccess The output values of Option Groups are numbers. Add a table with the values of the option group and the corresponding text value. An example of this is the Shipping Method table in the Northwind sample database that came with Access. Select help from the menu to open this database to look for the example. The Option Group will show on the Orders form. SignatureArvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access >I apologise for my lack of Access knowledge but this is my first attempt at > setting up a database. [quoted text clipped - 5 lines] > option > as a word? Also how can I get the option group to allow multiple selections and show therse selections in the main table SignatureThanks WoodyAccess > I apologise for my lack of Access knowledge but this is my first attempt at > setting up a database. [quoted text clipped - 4 lines] > How can I get the information in the main table to show the selected option > as a word? Option groups don't allow multiple selections. It is beginning to sound like you need to re-structure your tables and possibly add a related table to store your options. SignatureDuane Hookom MS Access MVP > Also how can I get the option group to allow multiple selections and show > therse selections in the main table [quoted text clipped - 9 lines] >> option >> as a word? OK! As I said this is my first database so I am learning from just having a go. What I am after is various options on availabilities (ie 6 boxes of Monday-Saturday). From these boxes I want users to be able to select any (from one up to all 6) of these boxes and for that data to be shown on a table. How would I go about putting this into a form for easier inputting into the table? SignatureThanks WoodyAccess > Option groups don't allow multiple selections. It is beginning to sound like > you need to re-structure your tables and possibly add a related table to [quoted text clipped - 13 lines] > >> option > >> as a word? I hope you aren't taking my (or Rick Brandt's) reply as being critical. We see this type of table structure quite frequently. Assuming you have a primary key field in your table [EmpID] you would create a table of availability: tblEmpAvail =================== EmpID DayNum Numeric (values like 2-7 for Mon-Sat) The combination of the two fields should be defined as a unique index. This could be implemented with a subform based on tblEmpAvail displaying a combo box for DayNum. The subform link master/child would be the EmpID field. SignatureDuane Hookom MS Access MVP > OK! As I said this is my first database so I am learning from just having > a go. [quoted text clipped - 25 lines] >> >> option >> >> as a word? > I apologise for my lack of Access knowledge but this is my first > attempt at setting up a database. [quoted text clipped - 4 lines] > How can I get the information in the main table to show the selected > option as a word? That's not how option groups work. Don't be concerned with how your data looks in tables. It's better to store the number and then in queries, forms, and reports, you can use an expression or a lookup against another table to display the corresponding text. If you build a simple SELECT query that has all the fields from your table plus a calculated field to give you the text version of your field them you can just use that query in all places where you would otherwise have used your table. That way you only need to write the expression one time. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Ok Rick thanks for that i won't be worried about how my data looks in the table but how can I allow multiple checks in my option group? I have 6 check boxes of which depending upon the selection 1, a few or all of them can be selected? How can I allow for say the 1st 3rd and 6th check box to be selected and that data appear in the table? SignatureThanks WoodyAccess > > I apologise for my lack of Access knowledge but this is my first > > attempt at setting up a database. [quoted text clipped - 14 lines] > use that query in all places where you would otherwise have used your table. > That way you only need to write the expression one time. > Ok Rick thanks for that i won't be worried about how my data looks in > the table but how can I allow multiple checks in my option group? > I have 6 check boxes of which depending upon the selection 1, a few > or all of them can be selected? How can I allow for say the 1st 3rd > and 6th check box to be selected and that data appear in the table? A basic database design rule is that you never put more than one value in a field. If your situation calls for that then you should have a separate table because what you have is a one-to-many relationship. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.