Forms: Beginner, need to serch/filter by headers in a table

[ebernedo]

Hey guys... well I have a bit of a problem with forms..and my best explanation is here:

http://www.access-programmers.co.uk/forums/showthread.php?t=129855post#4

I posted this on another message board as well and post #4 is where I am at,
there I also uploaded my database and an example database to which I took some of my coding and progress from....

since this is a form all of the coding is circulated around the "search" button so if u go to properties on it...(on the form), and click on event tab..then go to on click then click on the "...." thats where all the coding ...
to put it simple..I need another drop down list that needs to be linked to the search button....the problem is the drop down list is not just a list from the table such as "size", its a list of headers I want to sort by...its kind of weird and I cannot figure it out

for a better explanation..go to the link above where I explain my issue...
and there you can download my database to look at it yourself,
dont pay too much attention to my first post on the thread..rather look more at post #4 because that shows my current progress and has the files you can download that are most recent

so if anyone could help me I would really appreciate it,

 

[ebernedo]

so can anyone help with this?

if guys get a chance..please take a look a link from the first post because there you can downloadm my database

and another way to put it simply:
I want to have a list box which u can select from
but I want the list not to be values from just one column..rather the list is supposed to be the column headers..
so if i have:
Row A.........Row B.........Row C.........Row D.....
5.................33..............45...........43.....
33.................23...........534...........433
34................343...........3434..........344

So in other words have the list box have:
Row A
Row B
Row C
Row D

and I want to apply this to my search criteria in the search button I created...what can I do?
and like stated earlier if you guys get the chance download my database from the link above to check it out..


thanks in advance

 

[ajetrumpet]

I don't think what you're trying to do is possible. You're talking about applying datasheet IDENTIFIERS as search criteria. Search criteria is associated with DATA.

Why are you wanting to do this anyway? Are you saying that you want to set up some sort of parameter query via code that is linked to your search button. I'm sure there is a way to do THAT! =)

 

[ebernedo]

^^^^^
Oh see the reason I am doing this is because if you look at the table from the database (which you can download from that above link),
if you look there,
the goal is this:
to search by a size and/or to also search by a pressure flow rate (header)
this is because each part # has a size, and all across it has possible flow rates given at certain pressures
some don't have flow rates at that pressure so I just wrote in NA (which you can write an IF statement about)

but anyway the goal is use a scenario like this:

give me all of the part numbers that are Size 3 and have a flow rate at 2600 psi flow rate,
that way the table inside of form will update and show only part numbers with size 3, and that have a valid value under that pressure


if you can't download my database heres a quick little example of the table


Part #.........Size.........3000psi.....2800psi....2700psi
1..................1...........0.56.........0.49.......0.43
2..................2...........0.63.........0.32.......0.23
3..................3...........0.54.........0.22.......0.6
4..................1...........0.61.........NA.......0.75

See under each pressure..say 3000psi...that column is a column of flow rates...
the reason I want the headers is because the person using the form is NOT going to know the flow rate off the top of their head

so on my form I already have a list that lists you select the 3 sizes available:

Size:
1
2
3

^^^
that list box lets me select and filter..so if I click 1, then click "search" on my form (there is a sub-form in the form), the sub-form table updates and only shows the part #'s with 1's

so now I want another list that says
Pressure:
3000psi
2800psi
etc....

which is a list of the headers because thats the criteria I need
so for example on the mini example above..If I want a size 1, with a flow rate available at 2800 psi, it only only show part #1, because part #4 (even though its size 1) has an NA listed under that criteria and won't show

so I need to find a way to make this search list from my table and integrate it into my form, so that it can be used to search and filter out all of the data

so if someone could help and let me know whats up, I'd really appreciate it
(note: if you get the chance go to the link in the first post and actually download my database so you can see exactly what i'm talking about)

once again,
thanks guys in advance

 

[ProgramError]

Hi erbernedo
you may want to take a look at this flash from datapig

regards
Ian Mayor

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[ProgramError]

http://www.datapigtechnologies.com/flashfiles/searchform.html

sorry here's the url

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.