Search results

  1. E

    Solved Need to add new field to Log (table)

    Hello: Several weeks ago, expert @MajP helped me create a log file. @MajP's solution works great! At this time, however, I'd like to obtain some help with slightly modifying the existing VBA in order to insert a new field into the working routine. Attached are 2 ACCDB files. Version #1 -...
  2. E

    Solved Existing VBA sorts fields (in table) in ASC order... need to slightly modify code to include table name

    Good morning: I need some assistance with slightly modifying a **working** VBA solution which sorts field names in various selected tables. Please see attached DB with contains the working solution. Background: - Attached DB includes 7 tables. - Table "00_Excluded_Tables" includes table...
  3. E

    Add "Progress Meter" to a working VBA routine

    Good afternoon: In a different post (https://www.access-programmers.co.uk/forums/threads/vba-modification-to-allow-listboxs-multi-select-extended.318906/), I received some fantastic help from expert **MajP**. In his final solution, MajP included a progress meter. I find this progress meter so...
  4. E

    VBA modification to allow listbox's multi-select = "Extended"

    Good morning: I am curious to learn if someone has a specific recommendation for modifying existing (working) VBA code IOT to integrate two (2) independent processes. Attached are 2 sample DBs. ==== DB #1 ============================ "01 Loop" - Background: - Table...
  5. E

    VBA syntax error "... cannot find input table..."

    Good morning... I'm running into a syntax error. I'm sure the fix is simple (i.e., changing order of single or double-quotes). Any suggestions would be appreciated. Please see the From / To below: From (this works fine): Set rs_Before = db.OpenRecordset("Table_1", dbOpenDynaset) Set...
  6. E

    Throw different message box when same function is called 2nd time

    Hello: I use an AutoExec routine which does the following: 1. Imports 10 tables where table names have prefix "Step_4_*" 2. Renames those 10 tables and removes prefix "Step_4_*" so that table names now start with "tbl_*" 3. Re-Imports same 10 tables (again) but now leaves prefix intact. As a...
  7. E

    Compare 2 Tables Function -- identifies all value changes EXCEPT if value was = NULL

    Experts: I need some assistance with identifying a process flaw in an overall well-working function. Allow me to provide some background first. Background: - I need to compare two (2) tables: "Before" and "After". - Initially, the "After" table is a replica of the "Before" table. - At some...
Top Bottom