Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Dallas, Texas, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    History or Find/Replace (Access 97 and 2000)

    Does anyone have any code or macro that makes a history table of all activity in a table in Access 97? I want to track changes in my tables in Access and right now I take table over to Word to do it. Access 2002 has it I think but I cannot find an actual program already written for 97.

    Also, I found a program for find/replace that does not find what I want. Any other ideas for find/replace?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: History or Find/Replace (Access 97 and 2000)

    Unfortunately, changes made at the table level in Access 97 cannot be tracked. Form events can be used to do that, but unless you lock the user out of the tables, you will have missed changes. In Access 2000/2002, if you choose to use the MSDE or SQL Server, you can do that sort of tracking regardless of how the data is changed by using a trigger, but if you use the Jet (.mdb) back-end, you can't track changes with them either. I'm a bit curious how you are tracking changes in tables using Word <img src=/S/question.gif border=0 alt=question width=15 height=15>

    <<Also, I found a program for find/replace that does not find what I want. Any other ideas for find/replace?>>
    What are are you trying to find with a find/replace, in what kind of file, and what program doesn't work to your satisfaction?
    Wendell

  3. #3
    New Lounger
    Join Date
    Sep 2002
    Location
    Dallas, Texas, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: History or Find/Replace (Access 97 and 2000)

    To track the changes of my Access table, I made a report for it and used the Word link in report area. Then in Word under track changes I use compare documents. I compare that new Word file containing my info with the previous version that I had already saved and I have my changes. I am working with a company who wants to see my work in Word. I have not used it much but so far, so good. Hope that makes sense.

    See below for find/replace program. The program did not find all of what I asked for. Maybe it would work better if it were a registered copy...
    http://www.rickworld.com/products.html <small><font color=blue>edited by Wendell to activate link 9-Sep 5:15 MDT</font color=blue><small>

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: History or Find/Replace (Access 97 and 2000)

    The Find/Replace utility is intended to find things like field names and object names and change them accordingly - is that what you were trying to do, or were you trying to find data of a certain kind?

    The solution of using Word to track changes is a clever one <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> I hadn't thought of, but seems like it would quickly get out of hand if you have more than a few records to deal with. Of course if there are several changes between the time you create one Word link and the time you do the next, you will only see the total change and not the intermediate ones.
    Wendell

  5. #5
    New Lounger
    Join Date
    Sep 2002
    Location
    Dallas, Texas, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: History or Find/Replace (Access 97 and 2000)

    I wanted to edit text contained in my fields but I can just use the find/replace feature when I take it to Word. Just like you said, using Word for track changes can get tricky...I wanted to make all the changes I could in Access without doing much in Word.

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: History or Find/Replace (Access 97 and 2000)

    If you want to change text in fields, there are several options. One is to use the find and replace command in Access - it works much like the one in Excel, but you can do all sorts of wild cards and filters as well. The second is to use the filter command which will let you find all the records that match a particular string you specify. The third is to use queries to display a selection of the data, which you can then apply an action query against to change a given set of the data. My view is that the editing capabilities of Access are considerably greater than what you can do in Word. In fact, one of our clients produces a several 100 page Word document, but we store and edit the data in Access, and then use Automation to create a current copy of the data in a highly formatted Word document. Hope this expands your horizions with respect to Access.
    Wendell

  7. #7
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: History or Find/Replace (Access 97 and 2000)

    I came across the following on "The Access Web" site, http://www.mvps.org/access/modules/mdl0021.htm. <font color=blue>Edited by Wendell 14-Sep-02 14:31 MDT to activate hyperlink</font color=blue>

    "The History Table routine described below is designed to write history records that track the changes made to fields in one or more tables. The tracking includes the currently logged on user's name, the date and time, information identifying the record(s) being changed, and bitmaps that indicate which fields were modified. Optionally, the user may add a comment. Depending on where else in the application the developer calls the WriteHistory procedure, virtually any user action can be identified by setting an action code. This allows creation of history records for other reasons than data changes.
    Download History.zip (72,698 bytes)"

    Does this have utility for what you're trying to accomplish?

    Elizabeth

Posting Permissions

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