Recent content by qwertybob

i have a form to edit customer details, my problem is if i edit a record so that it breaks validation / inputmask, then i get my error messages. is there anyway to prevent these messages from appearing until i click a command button to save the changes? i have on my form a command button to...

in order comply with the DPA - not keeping personal data longer than is neccesary.

i want to keep 'Closed' rentals in tblRentals because other parts of the database use both 'Open' and 'Closed' and its easier if old and new rentals are in the same table. I will give your suggestion a shot - sounds alot simpler than my botch job - using a hidden subform based on a select...

check table for records before deleting record from second table i hate trying to think of titles that make sence :confused: Anyway i have two tables tblCustomer and tblRental using a one to many relationship - no referential integrity. i want to delete a record from tblCustomer (which i can...

is this the kind of thing you mean ? Dim answer answer = MsgBox("?", vbYesNo) If answer = vbYes Then MsgBox "a" else msgbox "b" end if

that would have been fine except i forgot to mention that 'form a' uses a filter that obtained data from a third form and i would like to avoid keeping the third form open, sorry for not being clear. thankyou for your help

i need to be able to refresh the data on a form, when i click a button in a second form. the onclick events runs some sql that alters the data that form a is based on, then closes form b. The changes are not reflected on form a until the form is reopened or i use a button on the form a to...

hello, this is my first post here, and im in need of help i have some tables set up as shown in the included image i need a way to display data from tblCopy/tblMovie on a form, but excluding those records that have a related record in tblRental thankyou in advance for any assistance offered...