Recent content by capn beanfart

Hi Wayne... Thanks for responding so quickly. At the moment, when the equipment is returned I click the yes/no box. This ables me to identify whether the equipment has been returned or not when looking through/searching the table. The problem with having returned and non-returned information...

Hi there everyone... I'm creating a database for an equipment sign out system in a college. At the moment, I have a form to type in the students details, equipment borrowed and date due back. When the student brings equipment back, I can bring up their details by searching for their name...

Hi there MatS That worked perfectly, thank you very much! I've now got a command button on my form that starts up the query, so it's looking good! Thanks both to you and mderby for taking the time to sort my troubles out!! Cheers Phil.

Oops that posted before i'd finished typing! Not my day... STUDENT ITEM1 - ITEM2 - ITEM3 - ITEM4 Jo Bloggs - Pentax - l. meter - lens - ext. tube fred smith - hotshoe - m. lens - pentax - tripod...

You were right the first time mderby! I'm looking for a single parameter search that will search through six fields. Sorry if i've not explained myself very well... For example: If i'm looking for a specific camera, eg 'Pentax' I want to be able to enter this as a parameter value and for it to...

I tried your suggestion which brought up separate parameter query windows, one after another meaning you have to type out the search repeatedly. This is better than before but what i'm looking for is to bring up one parameter query window, type in the query once and this will search through...

I tried your suggestion which brought up separate parameter query windows, one after another meaning you have to type out the search repeatedly. This is better than before but what i'm looking for is to bring up one parameter query window, type in the query once and this will search through...

Thanks for replying so quickly. Typically for my place of work, the computers are down so I can't try out your suggestion yet, but it sounds good. I'm creating a database so I can log the details of equipment hired out and by whom from our friendly photography department. I shall try your...

Is there a way of doing a parameter query that will search more than one field at a time? At the moment I can search one at a time using this method, but for what I'm trying to do this is too time consuming. There MUST be a way!!!