Access Option Selection Problem

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
James CoatsComputer Info. Sys. StudentAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
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
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.