Change Reports and VBA code from a run-time DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sprt2002
    New Member
    • Feb 2008
    • 1

    Change Reports and VBA code from a run-time DB

    Have inherited a project so I don’t have all the history.
    We send out a run-time 2000 DB to approx. 300 reps. every year.
    Some of the reps has Access Pro installed from Office Pro.
    The Access Pro can be 2000, 02, 03…
    The rep’s OS range from 98SE to Vista, with most of them 2000 or XP
    There are 2 things wrong with the DB that needs to be fixed.
    1. There are 2 reports that has the wrong email address within a label/caption
    2. There is 1 piece of VBA code that has a bad for loop, starts at the wrong point. I know how to fix.
    I need to create something, VBS, Access DB burned on CD (run-time I assume) to correct both of these.
    I have attempted to use a DB to open the database, but I can not get it to let me address either of the items mentioned above.
  • mshmyob
    Recognized Expert Contributor
    • Jan 2008
    • 903

    #2
    Are you saying you cannot open your database file using Access so that you can see the source code?

    Originally posted by sprt2002
    Have inherited a project so I don’t have all the history.
    We send out a run-time 2000 DB to approx. 300 reps. every year.
    Some of the reps has Access Pro installed from Office Pro.
    The Access Pro can be 2000, 02, 03…
    The rep’s OS range from 98SE to Vista, with most of them 2000 or XP
    There are 2 things wrong with the DB that needs to be fixed.
    1. There are 2 reports that has the wrong email address within a label/caption
    2. There is 1 piece of VBA code that has a bad for loop, starts at the wrong point. I know how to fix.
    I need to create something, VBS, Access DB burned on CD (run-time I assume) to correct both of these.
    I have attempted to use a DB to open the database, but I can not get it to let me address either of the items mentioned above.

    Comment

    Working...