Search results

I have a form of clients details. Each client has a Client Number. When I open the form it is designed to open blank in all fields. However if I type in an existing Client Number the rest of his details do not automatically fill the fields. I assumed they would do. Can anyone explain why? The...

I have a Form that uses a BeforeUpdate event to offer the user the chance to undo changes before saving. The code below works however I do not wish the form to clear its contents once the user clicks yes as I would like the user to have the ability to then go onto add data into the subform...

Is it possible to delete records in a table if it has no matching records in another related table by using a delete querie. I can find plenty of info on deleting matched records but nothing on unmatched.

Can someone explain to me as I seem to be the missing link. I open a form which is linked to 1 table. The primary field is named Spin. My form opens blank which suits me. However I thought if I entered the spin vlaue for an existing record the rest of the fileds would automatically fill out on...

Thanks Thanks bob. worked great

Is there anyway to get MSCAL.Calendar.7 to open showing todays date in a form?

Hope someone can help. The attached code works fine however I am having problems with the Error part. The data is numerical and should non numerical data be placed in the search box it gives up the correct message EXCEPT when a non numerical charachter is placed first in the string. ie 123rt4...

Not sure how to create a dialog form. I have stuck this code on to a button on the form I want the search string to go to. The field I want to search is [Spin]. But its still not working. The box comes up when the button is clicked and when I enter the anything in the box it comes up with...

Hi Its the standard windows search/replace box with all the 'match case' etc stuff attached. . All I want is a box with a field to type the search criteria and ok cancel buttons. Perhaps a small form.

I have a button on my form which when clicked opens the search box and finds a record. However I am not too impressed with the search box Access throw up. Is there any way for the click to open up a custom designed box?:confused: