473,399 Members | 3,106 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

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.
Feb 12 '08 #1
1 1550
mshmyob
904 Expert 512MB
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

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

Similar topics

13
by: Andrew | last post by:
I use conditional compiler constants, set through the VBA IDE in Tools, <projectname> Properties, that I refer to throughout my code to control which code is used during development, and which...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
1
by: fecket | last post by:
The following code is used in my db to change the sort order of the report to various fields. I want to take this one stage further and use maybe a Case Select to give 2 or 3 different options to...
3
by: mehul | last post by:
Hi, I am trying to use Active Reports v1.1 (Build 1.1.0.84) in a ASP.NET application. Is it possible to use it through the COM interlop as Crystal Reports for .NET which comes built in with...
2
by: B.Newman | last post by:
I've got some VB.NET code that *should* get a list of reports from an Access MDB and populate a list box with them. It doesn't detect any of the reports at all. oAccess.Reports.Count comes up as...
16
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report,...
3
by: joelpollock | last post by:
I'm having trouble continuously page numbering a large report in MS Access. The report is made up of three separate Access reports which I join together at the end. In the past I have opened the...
0
by: hemu4hemang | last post by:
Hi Friends I m working on one application in Vb.net and Sql server and crystal report 9.0. This application works fine and all reports are open...
1
newnewbie
by: newnewbie | last post by:
Hi, Our vendor has a database that I connect to via ODBC. I work in Access. All the tables are "informix". The reports I run are rather painful to run due to the size of the original database and...
3
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.