Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access Option Selection Problem

Posted on 2015-01-21
4
Medium Priority
?
138 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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 85
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

719 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