Data Environment / Data Report / Changing database file at run time

Data Environment / Data Report / Changing database file at run time

Post by Steve Jeffel » Sun, 02 Jan 2000 04:00:00



Doe anyone know of anyway to chase the underlying access database at run
time? I have built a data report using a data environment and would like the
report to be used by a number of different Acces .mdb files at run time. Is
there anyway that I can do this?

Many thanks for your help.


 
 
 

Data Environment / Data Report / Changing database file at run time

Post by Bjorn van den Brin » Mon, 03 Jan 2000 04:00:00


Hi,

You can use the following command :

Private Sub DataEnvironment_Initialize()

Me.Name accessdb.ConnectionString = App.Path & "\Data\name.mdb"

End sub

Hope this helps you.

Bjorn van den Brink

If you ain't dutch, you ain't much. ;-)

Steve Jeffels heeft geschreven in bericht

>Doe anyone know of anyway to chase the underlying access database at run
>time? I have built a data report using a data environment and would like
the
>report to be used by a number of different Acces .mdb files at run time. Is
>there anyway that I can do this?

>Many thanks for your help.




 
 
 

1. MNS VB 6.0 Data Environment and Data Report Run time problem

I have two problems with my VB 6.0 application project.

1)      In my project I needed to product some invoices to
bill customers and some aging accounts reports from time
to time.
If I install my application on a computer that does not
have VB 6.0 Development software package I will not be
able to run my reports or print any invoice. I get the
following message:

RUN TIME ERROR 713
APPLICATION DEFINED OR
OBJECT DEFINED ERROR

What should I do? I thought it might be because I did not
include the right DDL for the Data Environment or the Data
Report.  I do not know what and where they will be.

2)      If I go around the first problem and install my VB
6.0 development software on any computer and install my
application package, I can run my reports and print my
invoices.
-       However, the problem occurs when after printing
one invoice, I close the UI and open it up again to print
another invoice the text box that contain the invoice
information will not work anymore.  If I type in the
invoice number in the text box, as soon as the text box
looses focus the invoice number I typed in DESAPPEARS. I
checked the lost focus subroutine and every thing else I
do not seem to identify the problem.

PLEASE HELP

2. Help: Get recordcount of detailtable

3. Data Environment Report Wont Run a 2nd Time

4. How can I save date & time to a table in a single field ?

5. Setting Data Environment at run-time

6. Net.DATA and problems with codepages

7. Data Environment - bind at run time

8. Intermediate Java programmer just starting with JDBC

9. Data Environment @ run-time

10. Updating a data environment and flex-grid at run-time

11. How do I set Data Environment connection at run time

12. Data Environment at Run Time

13. ADO Data Control - Design Time/Run Time database locations