Recent content by EEH_Help

  1. E

    Solved Need to add new field to Log (table)

    That worked great! Thank you, @MajP.
  2. E

    Solved Need to add new field to Log (table)

    Thank you @moke123...I appreciate the info. I edited the original post to include the tag.
  3. 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 -...
  4. E

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

    Solved it.... Set db = CurrentDb sTable = "tbl_Charlie" Set tdf = db.TableDefs(sTable) For Each fld In tdf.Fields Select Case fld.Name Case "ID" 'Always move [ID] into 1st...
  5. 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...
  6. E

    Add "Progress Meter" to a working VBA routine

    Copy... thank you, MajP. I'll with lines will have to be integrated in my DB. Cheers!
  7. E

    Add "Progress Meter" to a working VBA routine

    MajP -- thank you... copy all. The attached sample file is very helpful. I'll try to integrate in the other process. Thanks again for both the sample file and URL. Cheers!
  8. E

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

    MajP -- I love this "progress meter"... it's absolutely perfect. I opened a new post where I'd like to also include it. I scanned through the VBA code to see where it might be calling the progress meter modules and/or form. Apparently, I didn't get it to work. Any chance you may have a...
  9. 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...
  10. E

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

    MajP's solution is simply perfect! It met all of the requirements AND more!! :) (y)
  11. E

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

    Oh, wow!!! To quote McDonald's (fast food)... "I'm loving it!!!" This is absolutely stunning... thank you so much for providing me this latest version. Final question (I hope)... what's the purpose of "Query1"? Must I keep it or can it be deleted?
  12. E

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

    MajP: "Sleep deprivation" is a "b i _ _ h"... sorry... didn't mean to be vulgar. I was working it in the middle of the night (on a few hours of sleep) and I did NOT import "table pairs" for which business rules had been applied. I starting re-checking it about 30 min ago and noticed my...
  13. E

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

    MajP: First of all, let me re-iterate that I really really like your new version. (y) Once I integrated my actual data into this solution, I experienced an issue though. Hopefully INDEXING may solve it. Attached are 3 DBs... they are as follows: *** "Comparison Report v01 (Original)"...
  14. E

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

    MajP - great. I'll look into making Changed_Record_ID and FieldName a unique index once I migrate the solution into my actual DB. I'll keep you posted.
  15. E

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

    MajP: Wow!!! This is absolutely beautiful!!! I had a quick look and completed the following validation tests: 1a. Added new before/after tables *without* changes. No records shown... great! 1b. Made a few changes to the new before/after table. All changes are reflected... great! 2. Added...
See more
Top Bottom