469,645 Members | 1,941 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

VB6 Report update problem

Hi, I have a report that I used the data designer to create and what happens
is that it does not update until the application is closed and opened again.
For example, you can enter a new record and then open the report and it will
not show the new record until the application is closed and started up
again. Anybody got any ideas how I can make the report update immediately?

Thanks for any help you can give.

Weblog: http://decentre.blogspot.com
Dec 3 '05 #1
1 3375
Hi

Try to open the recordset and close it again BEFORE you run the report.

Dim myset as Recordset
StrSql="Select * from ... ;"
Set myset = mydb.OprenRecordset(StrSql,dbOpenSnapshot,dbReadOn ly)
myset.close
set myset = Nothing

Svend
DK

"Red Hammer" <ch********************@inspire.net.nz> skrev i en meddelelse
news:43******@clear.net.nz...
Hi, I have a report that I used the data designer to create and what happens is that it does not update until the application is closed and opened again. For example, you can enter a new record and then open the report and it will not show the new record until the application is closed and started up
again. Anybody got any ideas how I can make the report update immediately?

Thanks for any help you can give.

Weblog: http://decentre.blogspot.com

Dec 7 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Grant Stanley | last post: by
3 posts views Thread by Paradigm | last post: by
5 posts views Thread by johnp | last post: by
2 posts views Thread by aldous scotch | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.