Search results

  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...
  16. E

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

    Pat - thank you for the additional information.... I appreciate. Arne's solution works great, but I can definitely see the need for Concannon at some point. In such case, surrounding the double-quotes with single quotes will come in handy. Again, thank you for providing the additional info...
  17. E

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

    MajP: You are absolutely correct w/ your assessment of the 2 DB *examples*. Generally speaking, DB #1 and DB #2 (by themselves) are two completely different processes. Allow me to recap purpose/process for both example files: DB #1: - I found a generic template of DB#1 which has a sole...
  18. E

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

    "Awesome sauce"... thank you (in advance) for your kind support. :)
  19. E

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

    MajP -- thank you for the additional feedback. Goal is to tweak the code w/o having to link field names. Naturally, I can add an "admin" field which can be added to the VBA. Either way, would it be possible to post a DB #3 version that include your proposed changes? That is, I'm not...
  20. E

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

    MajP: Thank you for the very detailed response... I truly appreciate it. In principal, your line of thinking is accurate and would (does) give the results as envisioned. In actuality, however, the hard-coding of the fields (inside the VBA) is not practical. You can blame me for not...
Top Bottom