Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 141
  • Last Modified:

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
0
James Coats
Asked:
James Coats
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )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 CoatsAuthor 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 CoatsAuthor 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now