Search results for query: *

dhookom, Thank you, it works just like I needed =D

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...

Exactly what I needed. Thank you very much

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've decided to go with function over form on this one. Here is the code incase it can help anyone else. Private Sub ShopOpBackup_Click() 'Defines variables Dim rs As DAO.Recordset Dim FPath As String Dim FName As String Set rs = CurrentDb.OpenRecordset("SELECT t.[File...

The code does work, but doesn't export with any formatting. This is fine, but I think the export with formatting looks more professional. I was trying to see if it was possible to use a similar reference in the saved export so the end user can pick the destination (just an example...I have no...

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 will look into that. Thank you for the feedback =D

I should have explained further. I want the end user to be able to select multiple categories and statuses at the same time. i.e. Category [x] Tools [ ] Section Supervisor [x] Software Status [x] Open [x] Verified [ ] Does Not Apply When the user clicks "Submit" all records with either Tools...

I had thought of doing that, and may implement it in the meantime, but wanted to be able to select multiple criteria to filter the records that will be displayed by.

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...

Works like a champ, my only other question is if it is possible to keep the formatting like the saved export does? 'Defines variables Dim FPath As String Dim FName As String FPath = "C:\Junk\" FName = "Testbackup.XLSX" DoCmd.TransferSpreadsheet acExport, 10, "Master", FPath...

After some mucking around (and a bit of Divine intervention I'm sure) I figured the following out, and it works. My question now is, how can I change this to have the path and file name in two seperate fields? ' Defines variables Dim QLink As String QLink = DLookup("[Custodian Log]"...

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...

Exactly what I needed =D Thank you so much -Huey

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...