Search results for query: *

I have a filter code that works wonderfully for allowing the end user to only display records that match criteria "X". The only problem is when the filter is applied, the ordering that is done when the form is initially loaded is undone. I’ve searched the forums and the web in general and found...

I have a background form (cleverly called "Background") that has a button on it to open the control panel if the end user manages to somehow close all of the other windows. Is there a way to have access automatically center this button after the form is maximized? The reason I want to do this...

I have a saved export called Export Temp that will save a database to "C:\Junk\Safety Self Inspection.xlsx". Is it possible to replace this predefined path with two entries from the following database? Database Name: Export File Location Column Name: Export Name 1 Ideally I'd like to leave...

I want to preface this with a disclaimer, I did search for a solution to this, but I am fairly new to designing access databases, so I really didn’t know what I was looking for…or may have stumbled across the answer without realizing it. I have a self-inspection checklist with more than 500...

I have a database that is going to be used by different shops, and because we do not all have access to the same drives, they need to be able to define the locations of their files. The file path and names are saved in two fields in the “Export Information” table “RDO Template” is the first and...

I have a saved import and export, created using the wizard that allows me to save the backup information as an Excel 2007 file. I cannot, however, determine how to do this with VBA using the “docmd.TransferSpreadsheet” I tried the following, but the resulting file cannot be opened...

I currently use the following VBA code to import and export the database to excel to make a backup copy: DoCmd.RunSavedImportExport ("Backup Export") and DoCmd.RunSavedImportExport ("Import Backup") On this form, I have four text boxes that the user can input their own path and...

I have a saved import to restore the database backup, however when this is run, the database size doubles because the old information was still in there. To prevent this, I would like to use VBA to clear out the table before it is repopulated with the import. [CODE] Private Sub...