Recent content by ashwah

Cheers for the insight Galaxiom, I've got something to go on now. I've been around the houses a little, changed the data object to DAO but that brought me back to an older problem of poor performance on doing a ctr + F search. So you're saying to create the sub form's recordset on the fly, so...

But I'm setting those properties of the subform, am I doing this correctly? The problem is the error that occurs when I try to set those properties. Am I missing something?

I have a form and subform. The main form shows some customer details, and the continuous sub form shows that customer's charity donations. The code below runs when the form opens, and binds ADO recordsets to the two forms. The binding appears to be successful. However whatever I do I can't...

My colleagues currently use an access database, FE and BE, to browse customer records. I'm looking into using a MySQL backend. I have set up the MySQL on the server on our LAN, and have transferred some test data. I'm now accessing the data from a client PC, in Access, through DSN, using MySQL...

I have noticed that when a table is in a password protected DB I have to enter that password when creating a linked table from another DB. This is fine but then the linked table can be used thereafter without entering a password. Can I force the input of a password each time data is viewed via...