Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Huey462

    Ordering after a filter

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

    Ordering after a filter

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

    Center an item in a form with VBA

    Exactly what I needed. Thank you very much
  4. Huey462

    Center an item in a form with VBA

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

    Export Question

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

    Export Question

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

    Export Question

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

    Checkbox and Labels

    I will look into that. Thank you for the feedback =D
  9. Huey462

    Checkbox and Labels

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

    Checkbox and Labels

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

    Checkbox and Labels

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

    Export Question

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

    Help Hyperlinking in VBA

    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]"...
  14. Huey462

    Help Hyperlinking in VBA

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

    Export Question

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

    Import & Export question

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

    VBA and table contents deletion

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

    VBA and table contents deletion

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

Part and Inventory Search

Back
Top