By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

Change Reports and VBA code from a run-time DB

P: 1
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.
Feb 12 '08 #1
Share this Question
Share on Google+
1 Reply


mshmyob
Expert 100+
P: 903
Are you saying you cannot open your database file using Access so that you can see the source code?

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.
Feb 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.