Unbound forms controlled by a recordset class
Posted on 2013-11-11
Ok MS Access guys I'm looking to develop unbound forms that make use of a custom built class to handle all the CRUD actions. I'm sure something like this already exists and if so I'd like to be pointed to such an example, otherwise I'd like to collaborate with someone else who might be interested in putting something like this together.
I've developed some basic vba code that loops through unbound controls and depending on what action is required, will (C)reate, (R)ead, (U)pdate or (D)elete. If anyone is interested I can upload an example of what I've done so far. If there is nothing else out there we could use this as a basis to develop it further. The reason I want to use CRUD is to minimise bandwidth requirement when working with attached/remote SQL Server tables. Also I want to make editing a more controlled operation where the user has to follow set steps when interacting with a record. The reason for developing a class to perform the CRUD operations is that this can then be implemented for any form and related recordsource and be ported to other Access applictations.
Does anyone know of some CRUD examples?