Search results

  1. I

    Time Stamp after clicking a Command Button

    re-query the field after updating the table.
  2. I

    Noobie on the scene

    Welcome to AWF!
  3. I

    Distractions, Distractions, Distractions

    I wish you the best in your PC upgrade, TV searching and kitchen repairs.
  4. I

    Hello all

    Welcome to AWF!
  5. I

    Macro to empty tables

    Use the RunCode action in a macro
  6. I

    Been around but just getting started!

    ++ Yes Welcome.
  7. I

    Run Access VBA code from .bat file

    Taking from GasMan's example, Here is what the code should look like when you run it from a single database. Sub TestSubInAnotherDB() Dim appAccess As Access.Application Dim strFileName As String Dim strDBFolder As String strDBFolder = "c:\test\db\" 'change the path...
  8. I

    Run Access VBA code from .bat file

    Please post the code you used so we can help you better.
  9. I

    Run Access VBA code from .bat file

    This may be of assistance: Windows batch script - How to filter files with defined extension https://stackoverflow.com/questions/17638648/windows-batch-script-how-to-filter-files-with-defined-extension
  10. I

    Run Access VBA code from .bat file

    your batch file would look something like this: "<path>\msaccess.exe" "<path>\MyDatabase.mdb" /x MacroName "C:\Program Files (x86)\Microsoft Office\root\Office16\msaccess.exe" "C:\Test\MyDB.accdb" /x MyMacro
  11. I

    Site down - out of memory

    Any word on the HTTP 500 errors lately?
  12. I

    Hello from Zimbabwe!

    Welcome to AWF!
  13. I

    Cascading combo-boxes in table form

    Can you post the code used to update the combo boxes please? It would help us find the error. Also, please verify the names of the combo boxes; it looks like you may have copied and pasted them so they may all be named the same thing causing this to happen (just a blind guess)
  14. I

    Start macro, or return to form after answering yes or no

    try something like this: Dim varResponse As Variant varResponse = MsgBox("Have you updated the link yet?", vbYesNo, "My Title here") If varResponse = vbYes Then 'run macros Else Exit Sub End If Edit: Beaten to the finish line
  15. I

    New to forumm

    Welcome to AWF and Happy coding!
  16. I

    New member here

    Welcome to AWF!
  17. I

    Event procedure not working on opening until VBA code is opened and closed

    Sometimes a decompile / recompile is needed to work these bugs out. Here's an example for you: "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\Users\C58148\Documents\EQR.Accdb" /decompile Edit for your database then perform a compact and repair.
  18. I

    Intro

    Welcome to the forums!
  19. I

    Milage recording

    The point is to create a paper definition so your report prints on the stock as needed. you can choose any printer other than win2pdf to get to the print server specifications. Another way is to use printui /s to get to the same interface instead of the long way shown in the tutorial.
  20. I

    Milage recording

    You may need to create the custom paper definition. Here's a quick tutorial. https://www.win2pdf.com/doc/pdf-custom-paper-windows-10.html
Top Bottom