Recent content by master_dragon_1

Yeah. When I saw that, I nearly got a heart-attack! I was thinking "There has GOT to be an easier way of doing it!" And I found it! Thanks alot Monkeytunes!

Thanks alot, its working exactly how I wanted it to be. I was just asking so I knew how each of the commands worked. To be honest, I really got worried when I searched the forums and found this: http://www.access-programmers.co.uk/forums/showthread.php?t=63587&highlight=keyword+query What is...

But won't this search fore only 3 words, as there are 2 wildcards and one prompt?

Ok. Can you please explain each part of what you have written as a command? Like "*" & [Search by word:] & "*" What does this exactly tell Access to do?

Hi! I would like to make a query that searches for keywords instead of an exact match. Let's say that I have a record that has "mountain giant" as one of the fields. I want the query to pick this record out whether I put "Mountain", "Giant" or both, or only the some of the letters Thanks alot

Hi! It works!! Yay!!! Thanx alot. Just out of curiosity, why won't it work if you don't change the name of the control from Quantity to txtquantity or something like that? It does work with the same name if there is no expression. Thanx for our help!

Hi! I have a VERY simple problem, but I cannot solve it. I was struggling since last night! I have a table which contains items and their quantities in stock. Now, I have a query that contains all the items that are more than one in stock. Now, I want to create a report. When the report has...

thanx alot! It worked!

ok. Let me rephrase my question as so no one gets confused. I have linked my report to the query. It is working fine now. :) Let's say, i want a piece of text that gets what i had typed in to the query. For example, I have typed this information: Max height: 10 Max width : 5 Light needed: Lots...

this is what the control source for the max. height looks like: <= Specify the maximum height It doesn't seem to work :( What should it look like to be correct? Thanx

well, that's for the wuery itself :) When u have a query, and refer it to a report, the report runs its own query (in the control source) and that is where i want to change it :)

Ok, i have a query and a report that are linked to each other. On the report, it displays what has been looked for. For example, if i typed in 1.00 in the popup query box, it shows 1.00 when the report is opened. I am using the control source, to actually create a query for the report itself...

oh ok. Thanx alot guys :)

I am using this to make a quesry: Criteria: [Specify the height] When the popup question comes up, how to I enter this: Less than or equal to 1.5 And how do i enter this (another query): More than or equal to 0.5 Thanx guys

Im not very familiar with forms, so how do i actually do it?