Extracting data from fields

[orange]

dave,

Please give readers the 30,000 ft overview of what this application is about --no quasi-database terms.
What issues does the proposed database application solve? What questions will it answer?

ID	TUBE1	TUBE2	TUBE3	TUBE4	TUBE5	TUBE6
1	6H6	12SK7	73	0	27	01A

For example- what do tube1 and tube2 mean? Tube 5? Is this an inventory for repair/sale??

12SK7 -Tube 12SK7 or Röhre 12SK7 ID2637, Vacuum Pentode, Octal (Int.Octal, IO) K8A, USA 1935



12SA7 -Pentagrid converter designed to minimize frequency drift. They are intended for service as combined oscillators and mixers in AC, storage battery, ...

1941 Airline 148BR 736A

[madpiet]

The combobox/pulldown has a RowSource property (go to design view). It'll have some query... like this:

SELECT DISTINCT Sales_SalesOrderDetail.ProductID
FROM Sales_SalesOrderDetail
ORDER BY Sales_SalesOrderDetail.ProductID

Yours is likely missing the ORDER BY clause. just put the column you want to sort by in there.

[Minty]

With the form in design mode, double click on the pull down control (We call them combo boxes). That should open the properties window.
In the properties sheet window on the right hand side of the display , click the Data tab.

In the list of properties you will see Row Source.

Click the ellipses (three dots ... ) at the end. It should open the query designer.

In the query remove the Ascending sort from the TubeID and instead sort the TubeType column Ascending.

Close the query editor, save the form and switch back to Normal Form view.

Bob should now be your Uncle.

[daveone23]

Minty, I did what you said and it didnt work and I also lost that row source option. It wont sort on that pulldown.

[CJ_London]

That is the form properties, not the combo

[daveone23]

ok, got it to work. This is a VERY complicated program to use.

[Welshgasman]

ok, got it to work. This is a VERY complicated program to use.

Are you talking about Access or your App?

[madpiet]

Access? I'd have to agree. Unlike other Office apps, where you can fake it, you really can't do that very much in Access. There are a bunch of "rules" that nobody tells you about that you have to follow if you want your app to work. And NONE of it is in the manual. (Like Normal Forms, for example). And then when you get that down, your interface really needs some VBA to make it work... <g>

[Micron]

I liken it to it's easy enough to use a hammer. Now let's see you build a house with it. Access is just a tool. Unfortunately, some of its capabilities are (I think) included so as to make it easier for the masses to build something that lets you get by without a good foundation.