Solved

Access Option Selection Problem

Posted on 2015-01-21
4
130 Views
Last Modified: 2015-01-21
I am having an issue with this lesson. I can't seem to select the "text' option for the table Dependents on field "fldDepGneder". I select it and it reverts back to "Check Box".

I have saved the table and it still reverts back. I can select and save the "Combo Box" option which is strange.

Also in the General tab I am required to enter the following ( ;"male"[Blue];"female"[Red] ) I enter this information and save it but it will revert back to "Yes/No" The " ( ) " are not entered in the General field box.

I have also deleted this table recreated it and I still have the same issue
241JRC-TutB1.accdb
0
Comment
Question by:James Coats
  • 2
  • 2
4 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40562220
fldDepGender is a Boolean field, and the only "Lookup" control for that is a Checkbox.

If you change the Datatype to something other than Yes/No, you can change the Lookup.

Of course, this begs the question - WHY are you setting Lookups in Design view of a Table? This is a bad idea, regardless of the need.

Also in the General tab I am required to enter the following ( ;"male"[Blue];"female"[Red] )
You can't enter data like that in a Boolean field, so (again) you'd have to change the Data Type.

But that goes back to my earlier comment - you should not be doing this anyway.
0
 

Author Closing Comment

by:James Coats
ID: 40562279
Dear Scott,

Thank you, I knew that someone here would have an answer. In answer to your question I am in school in a local community college where I have a moron professor teaching the class. I can't wait for the public education industry to go the way of  the Post Office.

It's really rather tragic. I'm in this class via my employer but most of what I have learned was from my own use of Access and by using YouTube and Experts Exchange.

So far a lot of what the "kollege" has presented to me is more of an impediment rather than enlightenment.

Thanks again.
0
 
LVL 84
ID: 40562308
Most of those guys follow the book, and the "book" often shows the wrong way to handle these things.

To make matters worse - after being awarded as an MVP for a couple of years, I reached out to my local community college, where they have a couple of Access classes, and told them I'd be more than happy to help out with those classes. I provided my MVP link, etc etc ... and got a somewhat terse email stating there we no positions open, and that all instructors were required to complete xx courses before being considered as such. I wasn't asking to be paid, but rather to just let me come and help with the courses from a "real world" perspective.

In other words - they're far more interested in maintaining the status quo than in actually helping those people learn how to use the products most effectively.
0
 

Author Comment

by:James Coats
ID: 40562383
Scott,

It's probably best you didn't help them. What really gets me is that they get a lot of kids deep in debt often with little prospects of a good paying job to service that debt. Most of those kids are clueless due to their youth. I think the schools are immoral and often hurtful. I'm 63 and have been around the block several times so this won't happen to me.

I will talk to my employer and tell him if I can just get some study time at home with a little compensation he'll save money and I'll learn more in the long run.

Thanks again.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question