Data environment question

[tzachari]

I have a data report attatched to a data environment to display the contents of an access table. I have established the connection to the database in the data environment using its properties option. My problem is that the datareport does not dynamically display the report. ie.. If i have the application running, and I go in to my table and make dome changes, the datareport does not show the changes. It still displays the old copy. Is there some way I can refresh the connection between the Data environment and the table so that when the data environment is initialized, it always passes the latest data to the data report.
Thanks
Zack

[Forest Dragon]

Try to run the Command object before showing the report every time you make changes to the database.

Example:
DataEnvironment1.Command1
DataReport1.Show

Good Luck!!!

[ScottF]

I have try to add DataEnvironment to my VB5 so I can start to report with DataReport. Can you tell how you add it. I try to go to help but there is no imfo on it. I try going to "Project" then "Add ActiveX" nothing Help are tell me were I can get some help

[DrewDog_21]

tzachari - ALso try this:

In your Data Report's terminate routine:

Private Sub DataReport1_Terminate()

Set DataEnvironment1 = Nothing

End Sub

ScottF - about VB5 I am not really sure, but in VB6 under the Project menu is an option "Add Data Environment" so look for something similar in VB5.

later

Andrew

[Forest Dragon]

ScottF:

Unfortunately, you cannot add the DataEnvironment designer to VB5, because it doesn't support ADO. Nor can you add the DataReport, for the same reason.

[Edited by Forest Dragon on 03-24-2000 at 02:14 PM]