Search results

the first one mie give me works fine. how would i make the results displayed on a form that i create ? instead of showing the results in a table

click the button icon and make a button, then use the command button wizard that appears and it has a delete button in there under record navigate. you should now have a delete button :D

cheers Mile-O-Phile that worked great. Thing is tho i aint using a form to put this on, it would just be a case of opening the query from the query section of access. Would i still be able to use the calender or not ? if so how cheers in advance :D

I want a user to enter a start date and a finish date using a msg box so that it displays all the date between them dates using a query, how would i go about doing that

I have made a query where u search for a reference number and it displays certains information linked with that reference. When i enter a reference number that isn't on the database it just displays an empty table. Is there a way of stopping this and just maybe displaying a message box saying...

I want to make it look more professional and plus, not every customer has a rented house, so its a waste of form and space for the people that own there own house.. any ideas

got a new question I want to be able select a value from a combo box on my form. But when i select a certain value i want it to show some fields ie/ when i select lanlord from the combo box, it would make my landlord field appear on my form. but if it aint selected, the lanlord field stays...

lol cheers, i must have taken my stupid pills this morning :confused: i sorted it now hehe

i just went to implement what you just said and in the form properties and the navigation buttons property isn't there ??? I'm currently using MS Access 2000 In my property list for format, it has the following properties. Force New Page New Row Or Col Keep Together Visable Display When Can...

thank you very much

Is there a posibilty where i can add a find button to my form, so i can search my fields ? I know you can use ctrl + F or click the binoculars but my form is pretty big and so i had to remove the Form View toolbar. Also it makes my form abit more professional :D.. Last question is, i know this...