Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: VBA Access function

    need a function to do:

    - Loop through all fields in a table (use tabledef) (use any table tablename should be a parameter for the function)

    - There needs to be a timestamp-field which is set on some records and not on others

    - For each textfield (only textfields ignore all others!) check if there are new values (compared between the ones with time-stamp and without ) without time stamp will be first default entry and with time stamps will be updated entry

    - If there are new values add the name of the field and the new values to a log-table

    - After looping through all textfields and putting the name of the field and the values into the log-table export the log table to Excel and show it in Excel. (alternatively you can log directly to Excel)


    The end result in Excel should look something like this:

    Fieldname1
    NewValue1
    NewValue2
    NewValue3

    Fieldname2
    NewValue1
    NewValue2

    Fieldname3
    NewValue1

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    probaly best to ask this in the Excel forum
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •