Solved

Gridex - How to save the user's edit to database

Posted on 2008-06-16
1
459 Views
Last Modified: 2012-05-05
I am using a gridex in vb6 and binding it to a ado recordset within vb.

If the user edits a record without moving to a new record or hitting the enter key before moving off the grid, the change is not saved.  Is there a way to programmatically save the change?

Dim rc as adodb.recordset
set rc = new adodb.recordset
rc.open "select * from table", consql, adoOpenstatic, adLockOptimistic
Set Me.grid1.ADORecordset = rc

Open in new window

0
Comment
Question by:Delta7428
1 Comment
 
LVL 10

Accepted Solution

by:
Clif earned 500 total points
ID: 21796728
Try:

Me.grid1.Update
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to compare ms sql hashbytes results within vb6 5 75
get most recent and second most recent date in SQL Server 24 90
vbModal 12 53
Addition to SQL for dynamic fields 6 38
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

809 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