Recent content by Insane_ai

  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!
See more
Top Bottom