Recent content by toffer67

Yeah totally off base, i have a form with name, number date etc... i have a search button, click the search button and search for a number, the number is found and added to the form with a name date etc.. i want to search again but need to clear the data in the form when i previously...

haud the bus, how else can i search, if i dont clear the other record that i have found then how can i add other records into the form?? What problems do you mean??

The same record may need to be shown more than once at different times. I think i am sorted, i am using the new blank record button at the bottom of the screen before searching again and it is finding the record. Thanks for your help

So how do you search for the same record again??

No, when i search for a record it shows on my form, but when i search again it has dissapeared from my database??

Hi guys, As a few of you know (rural guy in particular) i have created a database and form to input the data into. Now, when im using a search button i have created on the form it is finding the record but also seems to be deleting the record. is there any way of just finding the record...

Ok, im learning all the time, how do you do that? when i am creating the query it does not give me the option of formatting

Because it wont show the percentage rate

Ok, no-one but me needs to see the calculation, so if i create a different form can i create a calculation on it. the calculation will take in how many quotes have been converted into orders. how do i create i calculation??

Im not sure, (advice would be appreciated) Would i be best to create another form to do this?? so i could have a drop down menu with agents names in it then when you select one i could have another calculation button that will show the final calculation. Is this possible??

the exact calculation that i need is the total quotes / total orders so i can see the percentage of quotes that is converted into orders by each individual. Would i need to create another another table with all the users in the table or could i do this by creating another form?? i dont...

P.S I need to add in a calculation at some point as well calculating the orders/quotes, any tips........

You sir are a genius :) All i need now is to work out how i get this on a shared drive so many users can update data at the same time, i have a few leads on how to do this and will be giving it a bash. Thanks very much for all your help along the way RuralGuy your help has been very much...

no probs about not getting back to me, i was on holiday, lucky me back to this!! What im looking for is to add a record to the database through the form, this was working until i added the search button, but now when you get to the button of the record it just jumps onto the search button...