473,668 Members | 2,371 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3494
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.OprenRecor dset(StrSql,dbO penSnapshot,dbR eadOnly)
myset.close
set myset = Nothing

Svend
DK

"Red Hammer" <ch************ ********@inspir e.net.nz> skrev i en meddelelse
news:43******@c lear.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3705
by: Steve Thorpe | last post by:
Hi I am trying to write a report that calculates the average number of sales over 7, 14, 31 and 365 days for each hourly period of the day. the problem is it takes over 4 minutes to run. e.g. Average Xactions per Hour 7 Days 14 Days 31 Days 365 Days 00:00 - 01:00 1,141.6 579.2 261.6 28.8
4
1130
by: Grant Stanley | last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal Reports. When creating each report, crystal asks where the database to use is, so I specify our SQL server using the ADO option. The problem is that these database settings seem to get compiled into the report, so when we take the application to our client it won't work on their systems. Before running each report I run some code which is ment to reset the...
3
2731
by: ahaque38 | last post by:
Hello. Using A2K SP3, I am having the following problem with a report using "Sorting and Grouping". I have recently added a grouping in the reports for "Category2<>'CONTRACTS'". I have reports at the plan (overall totals), department and division levels which have sorting and grouping implemented with this new
4
5401
by: Mal | last post by:
I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a memo field When CAN GROW is set to NO everything works just fine. When CAN GROW is set to YES - watch out.... One record causes BIG
3
3112
by: Paradigm | last post by:
I have a contract document that is about 20 pages long with various data base fields in it. I cannot create an Access report that long so I have had to do it as 5 seperate reports. There are some pages where the text box is set to can grow because the users text could be lengthy. The number of pages in the report is therefore unknown because it depends on the users text. My problem is that I need to print all 5 reports with a continous page...
5
5167
by: johnp | last post by:
Hello Everyone, Someone asked me today if it was possible to update data in a table via a report. I saw one thread where someone indicated the solutions.mdb had a report that did it but I didn't see it. Does anyone have experience doing this? Any information is appreciated.
9
1773
by: MLH | last post by:
Trouble is, it doesn't happen every time. Yesterday, for example, it happened only once and not again afterward. Some days ago, a similar situation. Today, well - I tried 7 times straight to open the report and each time, A97 shuts down. The seemingly hit 'n miss nature of the error is intriguing. All I've been able to determine is that if I allow the report to be opened from within code using this line... DoCmd.OpenReport...
2
3065
by: aldous scotch | last post by:
I designed a Crystal Report .rpt from within Microsoft Development Environment 2003 Version 7.1.3088 (VB .NET IDE). I selected database fields from the left side Field Explorer onto the Details (Section3) of the .rpt. Also, I added a new web form myWebform.aspx and a web object CystalReportViewer - CrystalReportViewer1 and had a code behind in ReportSource
0
1925
by: nmsreddi | last post by:
Hello friends iam using asp.net2.0 and c#, i am developing ajaxenabled website ,where my project is mainly base on crystal reports ,i am placing crystalreport viewer in updatepanel show to avoid button click post backs and also page navigation post backs of crystalreport , but the problem when i place the report in update panel ,the print option and export option of the crystal report are not working , when i place the crystalreport...
0
8459
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8374
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8791
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6206
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5677
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4202
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4373
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2784
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1783
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.