Solved

Refresh a datagrid that is bound to a Designer - DataEnvironment

Posted on 2004-04-06
4
493 Views
Last Modified: 2013-12-25
Help!!!!!!!!!!

I have a DataGrid that is set up in this manner:

Datasource:      DataFEBCO_Systems
Datamember:    Current_Bids

I created the DataEnvironment using:   Add - More AxtiveX Designers - DataEnvironment
Then I created the DEConnection:   dataFEBCO_Database with a DECommand,     Current_Bids
So the tree to the data looks like this:
     DataFEBCO_Systems (DataEnvironment)
     dataFEBCO_Database(DEConnection)
     Current_Bids(DECommand)

Question:  How do I refresh the DataEnvironment, DEConnection, or DECommand - so that when I refresh the DataGrid, it will display the changes made to the database?
Need this ASAP!! - Thanks in advance :)
0
Comment
Question by:CMHamrick
  • 2
  • 2
4 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 10765942
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 10766284
0
 
LVL 29

Expert Comment

by:leonstryker
ID: 10766310
... and one more reason not to use DE. :)

Leon
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 10766339
Even if I'm not a fan of the DE, you would have the same problem using ADO objects!

You always need to refresh your ADO object before refreshing your GUI object!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB6 - Convert HH:MM into Decimal 8 63
MsgBox 4 68
Send outlook email from VBS Script 2 45
Collapse and expand table in Word 2010 2 37
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question