cause right now
i checked all my stuff but if i choose like 2 out of four options, it returns null.
so if i get this right i have to have a value in all four to return a result?
kpouya
Last Activity: Mar 25 '09, 04:43 AM
Joined: Feb 18 '09
Location:
-
hey OldBirdman
were you able to select one option from every combobox and run the query and see if that works?Leave a comment:
-
well i have done that
as soon as insert a second crieteria it doesnt return anythingLeave a comment:
-
hey
well i wrote this in my SQL of the Query i am running
SELECT Libary.Title, Libary.LastName , Libary.FirstNam e, Libary.Company, Libary.Industry , Libary.Organiza tionLayout, Libary.MajorPro ccess, Libary.SubProcc ess, Libary.Summary, Libary.Attachme nt
FROM Libary
WHERE (((Libary.Indus try)=[forms]![SearchByMore]![Industry]) AND ((Libary.Organi zationLayout)=[forms]![SearchByMore]![Organizational Layout]) AND ((Libary.MajorP roccess)=[forms]![SearchByMore]![Major...Leave a comment:
-
ok thanks i will try that and let you know.Leave a comment:
-
i guess this would be it...
SELECT Libary.Title, Libary.[Last Name], Libary.[First Name], Libary.Company, Libary.Industry , Libary.[Organization Layout], Libary.[Major Proccess], Libary.[Sub Proccess], Libary.Summary, Libary.Attachme nt
FROM Libary
WHERE (((Libary.Indus try)=[forms]![SearchByIndustr y]![Industry]));Leave a comment:
-
"Create a query that references all three ComboBoxes."
how do you do that?
whats the code/macro to take values from the combobox and put it in into a query to run.
I was able to get with one cascading box going. when i try to do the second on, it just returns no result.Leave a comment:
-
i already know how to the cascading!
i want to know how take the values from the the drop downs and run query with it.Leave a comment:
-
yes that right.
so they choose first option
then second option which its selection is based on first combo box
then choose third option which its selection is based on second combobox selection
i know how to do the filtering based on the selection.
what i need to know is how to send the selection from the combobox to the query and run it.
are you able to give me step by step on how to do this?Leave a comment:
-
yeah my bad, i forgot to include that!
there is RecordID AutoNumberLeave a comment:
-
because of the amount of the text that needs to be put in there. some of the articles titles are more then 255charactersLeave a comment:
-
Query with Multi inputs
I am going to be as clear as possible about what i got right now and what i want to achieve
Table1: Libary
Title - memo
Last Name - memo
First Name - memo
Company - memo
Year - number
Type - memo
Industry - memo
Organizational Layout - memo
Major Processes - memo
Sub Processes - memo
Summary - memo
Keywords - memo
Table 2: IndustryIn... -
Hello PianoMan64
Thank you for your replay. I will try to give you a better description this time.
i have built the following items:
tbl_articles
this is where all the articles information gets recorded.
article_name
article_year
article_author
article_publish er
article_field (business, science, social science, arts, etc)
article_subfiel d (so let say i got choose...Leave a comment:
-
replay to Joe P.
Hey Joe P.
So what i am trying to develop is a knowledge database. i will try my best to explain the structure i got..
tbl_articles
article name
article year
article author
article publisher
article field (business, science, social science, arts, etc)
article subfield (so let say i got choose business, then i would have like accounting, marketing, management,...Leave a comment:
-
Query
Anyone could tell me how i could have a form, that runs a query and returns the result in a report form? it seems simple but i can't get it to work.
so basically the criteria for the form should be a Drop down Menu, that gets its information (Drop down) from another table, and from that information, runs the query.
Also
if you could tell me how i could with words, rather drop down menu. So basically using...
No activity results to display
Leave a comment: