Data Report Needs som refresh or something like this
I had a similiar problem. Under the assumption that you're using a
data environment to build your report... question: What method are
you using to add your data to the "temp{*filter*}table" in the Access
database?
If you are using anything other than the same data environment
connection, the problem is that your data environment is not in sync
(and won't be unless you force it) with your "other connection".
Here's what I did... I was using a connection in my code to add the
data for the report to a table (i.e. dim db as connection), while my
Data Reports were based on tables in a Data Environment connection. I
had the same problem when I opened the report. To fix this, I...
1) Set up my own connection
2) Opened the data environment
3) Set my connection TO the data environment connection
(set db = DataEnvironment1.Connection1)
By doing this, my code and the reports were using the same connection,
and I didn't have to change all of my code to use the
DataEnviroment.Connection1 connection.
This may not be the best way to go about this, I'd welcome any other
suggestions, but it works. I haven't had a problem since.
Dan
On Tue, 05 Dec 2000 05:23:13 -0500, Maribel Ortiz
Quote:
>I have a definde query with parameters that fills a temp{*filter*}table on
>MS-Access 97.
>This table is the data source of my data report.
>Sometimes works fine the first time... the next time repeat the same
>data (even when they have to change) it's like if data report needs some
>refresh.... (The refresh method doesn't work i've already tried)
>Other times it shows a blank page (even when it has to show data)...
>Is a problem from Data Report or Data Environment?
>How can I fix that?
>Please I really need your help