Search results

Um.... something has happend and i dont know how it did! On one of my forms, which i haven't done anything to in a while, wont let me enter any new information. The computer just makes a noise when i try to type in a text box. I don't know whether i have changed something accidentally, but i...

I'm afraid I don't really understand this. sorry.

Is there any way to make a form that will allow me to select the query which i wish to use, rather than just having a different button that will execute each query individually?

Is there any way to make a form that will allow me to select the query which i wish to use, rather than just having a different button that will execute each query individually?

Thanks you both very much. both ways have helped my development of database and my understanding. :)

Ok, dave, tried this, but when i try to put in my field name + : in the next available field it come up with a warning box which says: 'the expression you have entered contains invalid syntax'. Your help is much appreciated by the way. :)

Thanks. I'm trying both these ways out now. One thing, Dave, what do you mean by adding another field and making it equal? where abouts do i put (left[Customer],1) in the Query Design? do i insert a blank column and put it in the field cell? or the criteria or sort cell? or do it put under...

sort by first letter? ok, thanks, yh that worked, on the most part, but not for all entries as when i typed in 'd' for instance, top of the list of results was 'AGD'. Is there any way of sorting by the first letter of, say, the customer name?

I'm currently developping a database and in the process of re designing my queries for my users needs. one of these is to be able to search entries of the database determinable by their first letter (e.g. find all customers whose name begins with 'A'). Can anyone help me with how to do this. So...