Search results

can anybody else help with this problem?

its now coming up with a run time error '2001' 'You cancelled the previous operation'

"price of accomodation" is my field name in my table i will be searching

A error comes up "run time error '3075' syntax error (missing operator) in query experestion 'price of accomodation = '10" Me.RecordSource = "select * " & _ "From accomodation " & _ "Where price of accomodation = '" & Me.Text100 & "'"

Me.RecordSource = "Select * From query2 Where EnterLowestAmount = 'X' " I can't get this code to work i edited it but what happens when i enter a number in the box on the form e.g. "10" a dialog box pop's up with the title "Enter Parameter Value" it pops up 2-3 times then enter a value hit ok...

sorry i still don't understand you in the code what goes where like where do i specify what table/query i want it to goto and what field its meant to search? Me.RecordSource = is something meant to go here? "select * " & _ what about here? "From MyTable " & _ here? "Where MyKey = '" &...

Me.RecordSource = "select * " & _ "From MyTable " & _ "Where MyKey = '" & Me.MyTextBox & "'" Me.Requery Me.Refresh what do you fill in this code i entered it in and its all red and the complier brought up an error I am not an expert at visual basic so iam stuck

and how where do i use that code because i don't really know very much about the programming side of access. Me.RecordSource = "select * " & _ "From MyTable " & _ "Where MyKey = '" & Me.MyTextBox & "'" Me.Requery Me.Refresh

The query working fine but the Forms!MyForm!MyTextBox i don't know where to put it i tried it in the query criteria but i did not worked.

Does any know are you able to within a form to search your table? I want to know this to see if its wasting my time searching on how to do it

i need to some how have that in my form to allow the user to enter a price and for the form to go get that price range. Example if the user enters £50 it will get everything thats £50.00 £50.99 or from £50 to £60. Will that if the user enters that a price finds price they want and allow them...

Can anyone help? I don't have much time left to finish the database and microsofts help is not very good. Thankyou

But how will that query get the data from the user to find a price or the closest match

I have a price range from £31.52 up to £180.67

Hello i need help on how to put a box of sum sort in a form to be able to search a field in my table whats every typed in and without this box changing whats stored on the table. I want a user to be able to enter a price in and it finds hotels in that price range. Thanks