Solved

Access Option Selection Problem

Posted on 2015-01-21
4
133 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 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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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 Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 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