Search results

A form i have gains its records from a query. I know that the number of records found is displayed down the bottom, but is it possible to have a text box displaying this, so i can choose where on the form i have it? TIA Dusp

I have a button on Form1 that when clicked opens Form2. I want Form2 to be a certain size everytime it opens. I can't seem to get this to happen, it always resizes depending on Form1 being maximised or not. Dusp

Within my table I have about 20 fields. I want to do a keyword search that checks through all the fields. I have tried to do this in design view, copying =[enter keyword] into a separate row for each field. Access doesn't seem to like this - maybe because i have too many fields? Is there a way...

thanks for your reply. All my data is now in one table :) So my next question is when I run queries on this data, different queries to search through different columns, how do I manage to get all the queries to output to the same form? Only one query will be run at a time, the form would then...

Thanks, that works fine :-)

Right, I think this is a quick and easy one....just not for me! I have a combo box with a list of names. I want to use whichever name a user selects as criteria for a query. What do I need to type in the query criteria box or as SQL?

I have a combo box with a list of names in, and a table for each of those people. When one of these names is selected, i want the contents of the corresponding table to display in a form. Easy Enough. But...how do I get these tables displaying in one form depending on which name is selected...