Microsoft Access 2003:  Why do drop downs not show all of the information selections that should be available to select from?

memewarren
memewarren used Ask the Experts™
on
A few of the dropdowns in Access database do not show all of the information they need to pick from in the first example.  At the top it says "Type" and has a reference of 174 that nobody knows where that comes from.  It should have "DLR, OEM, HYD" to choose from.  The second one says "Terms" with C.O.D. and the drop down has no more to choose from such as Cash in Advance, Credit Card, Net 30 days, etc.  Please refer to the image in the attachment:
Access-Errors-1.pdf
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
The properties of the drop downs control how many entries there are (list rows), how many columns (Column Count), which column(s) are shown (Column Widths), and which column is stored in the underlying field (Bound Column).

 Changing anything other than the number of list rows shown can have an impact on other programming that was done.

 Outside of saying that, your question is too general to offer more.   You'd need to dive into the details of what each drop is doing and the code/macros associated with its various events.

Jim.
John TsioumprisSoftware & Systems Engineer
Commented:
Its clear that you need to check the RowSource of these combo boxes and also check the code behind the form to see if the RowSource is manipulated by some other condition.
Distinguished Expert 2017
Commented:
Here are the properties you need to look at:
1. Bound column - this will normally be the first column of the RowSource.  It is the field that uniquely defines the items in the list.
2. Column count - this is the count of columns selected by the RowSource.
3. Column width - a string that gives a width to each selected column.  A width of 0, hides the column.  So, typically, the first column width is 0 to hide the numeric value.  Then the text value will be the first visible column.

Other:
Make sure that the RowSource query is sorted by the text field that the user sees.  If it isn't, then the type ahead feature will not work correctly.  The second combo also seems to have null entries so since this is pulling actual data rather than a preset list, you must use group by to get a single instance of each value and also you must use where the text field is not null
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
@Pat,

 You skipped John, and your comment is nothing more than a re-hash of what John and I said anyway.

Jim.
Distinguished Expert 2017

Commented:
Rehash? I guess you could call additional details a rehash.  Then award your own answer all the points if you think I didn't make a contribution ( i did offer specific suggestions for each combo but that's just details).  I couldn't figure out how to specify point splits thanks to the new close interface.  I didn't think John added anything additional.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<Rehash? I guess you could call additional details a rehash. >>

 That's what I'd call it.  You suggested nothing new over the first two comments that I can see, just added more detail.   I covered all the properties except for the Rowsource, which John caught and mentioned.

<<Then award your own answer all the points if you think I didn't make a contribution>>

 Additional details may have been helpful to the asker if it made things clearer to them, but without input from them we don't know that. But at the very least, it should have been an even split.  

 Even so, we really don't know if any of us answered the question.  We think we did (and most likely did as this is a simpler question than most), but we really don't know.

 But this is the very reason Expert's should not be closing their own questions.

 From my viewpoint, lacking input from the asker, the question should simply be deleted.

<< I couldn't figure out how to specify point splits thanks to the new close interface.  >>

 You could have asked.  If the process is un-clear to you as an Expert, or simply not working, then someone needs to know that.

 Note that I will be deleting the question.

Jim.
Distinguished Expert 2017

Commented:
Please do not award me any participation points.  You and John divvy them up.  If you are going to take the position that all contributions are equal, then why do manual closes at all?  Just do an automatic close and award participation points to every one and stop bugging me to look at abandoned questions to try to clean them up.  I have enough work to do.

I've looked at my last abandoned question.  If the owner can't be bothered, nether can I.  I'll still get my "participation points" because that's "fair".  Have at it.

PS - if EE hadn't changed the close interface, I would have awarded you the bulk of the points but that no longer seems possible.  You should be annoyed with them, not with me.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Delete
John TsioumprisSoftware & Systems Engineer

Commented:
Jim let it go..just split the points with Pat and lets move ahead...np by me

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial