Search results

  1. 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...
  2. E

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

    Wow... I figured it was a simple one. Thank you so much for your assistance, arnelgp. I appreciate it! :)
  3. 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...
  4. E

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

    CJ_London -- excellent alternative!! Thank you!
  5. E

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

    theDBguy -- that's the perfect solution. Works like a charm! Many thanks.
  6. E

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

    My line of thinking was exactly that where n = 1 during the 1st loop and n would be = 2 during the 2nd execution. Apparently, that did not work. How do I declare n or any TempVar so that its value will be stored?
  7. E

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

    Certainly... how/where would I set it? In a different function/module?
  8. 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...
  9. E

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

    CJ - thank you for chiming in. Ultimately I did not find a solution to the question on the other site. Thus I was hopeful I might find an answer here. I apologize for not incl. the cross-reference to the other forum. I meant no harm by it. BTW, there no need to compare records based on...
  10. E

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

    PERFECT SOLUTION!!!!
  11. E

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

    MajP -- absolutely beautiful!!!! Thousand thanks for helping me solve this! Cheers, Tom
  12. 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...
View older results
Back
Top Bottom