Search results

I'm running Access 2003 split front end/ backend. I have been programming with access for about a year and was advised to use ADO. I have a form frmOrderEntry with a subform frmOrderDetail. The FrmOrderEntry contains the customer details and is unbound and populated via ADO. The frmOrderEntry...

I have an annoying problem with my programme that trips over once or twice a week. I have a form (customer) and subform (order detail) which uses an empty table (temp orders) as its recordsource. The subform (datasheet view) allows me to build up a new order detail for the customer. After hit...

Could someone advise me on the best time to make a connection through to a database I'm relatively new to VBA but started making connections through to the database successfully a few months ago. I now want to improve my understanding of the correct methodology. I find now that I am adding a...

Why is it that the following code works perfectly well. Within my program the form opens and waits for my selection. DoCmd.OpenForm "mainCustomerForm",, , "[PostCode]='" & customer & "'", , acDialog However when I change it to datasheet view the program continues on through failing to stop...