Here’s an updated way for you to add backup capability to an Access database. Access Archon #151 Introduction A few years ago, in Access Archon #115, I described a way to create backups of the current database, using several objects that you could import into a database, to make it easy to regularly save […]
How to back up database objects before making changes to them. Q: Jean H. writes: “I am constantly making changes to forms, reports and other database objects, and sometimes I find that a change doesn’t work, and I need to return to an earlier version. I do back up my databases, but it would be […]
How to develop applications using Access and deploy them as standalone applications. Q: Kamlesh Chand wants to develop applications using MS Access and deploy them as standalone applications (i.e., applications that can be run on machines that do not have MS Access installed on them). How can this be done? A: If you have the […]
How to get text values from the user’s selection of an option. Q: Julia H. writes: “I have an option group with choices for different areas of the country, and when the user clicks on one, I want to get the name of the area. But I can only assign numbers as default values to […]
How to add a specified number of records to a table. Q: Kacie Anderson writes: “I have two tables, one for Orders and one for Loads and both of which contain an OrderID field to link them together (the OrderID is autogenerated). For each order, there can be multiple loads. . . . But my […]