Search results

Having problems trying to get rid of the blank records which automatically appear in my subforms. I have 2 subforms embedded within my main form, and usually either one or the other contains information and in certain cases both do. however there is only ever one instance of each information...

I have decided to use tab controls, as my forms were getting complicated. However I am not use to using them and am having a couple of problems. On page1 I have a search page which uses a query to list all the customers within a list box. From here, previously, I have use a command button to...

How can I display a MsgBox showing a warning if the user violates a multiple index and enters repeating data?

How can I display a MsgBox which tells the user they have broken a multiple index rule and entered repeated data?

Wonder if you can help me regrding the relationships in my Database which I think are affecting my forms. I have a table with a primary key called customerID and 2 foreign keys called acting and not acting. Therefore, as the information is stored, a customer has either an acting or not acting...

I am having problems with the code below because I would like to add a condition which states If txtbox = "certain data entry" then open form1 else open form 2 but I can not seem to get my syntax right, here is my code: Private Sub open_estate_Click() On Error GoTo Err_open_estate_Click...