Trying to update a recordset based on SQL

08-19-2004, 02:43 PM

my04accord my04accord is offline

Newcomer

Join Date: Aug 2004

Posts: 3

Trying to update a recordset based on SQL

I am trying to update a recordset that all of my textboxes in a form are bound to as the datamember. The recordset I am having problems with is a SQL view of a Acces table using VB6. The software is a problem ticket type software and I basically have a button the will check for new records and tell the user how many new tickets there were. I have gotten as far as telling the user how many new records there using the requery method but then i can not navigate through them. Thanks in advance, Joe.

08-19-2004, 04:18 PM

Shurik12

Steppe Walker

Retired Moderator
* Expert *

Join Date: Jul 2002

Location: Ukraine/Russia/Belgium

Posts: 7,227

Hi,

Well... I'm afraid one can't say what's going on without seeing the code.
One thing is sure: binding in in VB6 is a major pain in the neck. You'll really be better off using ADO and writing everyting in code (see FAQ section for more details if needed)

Regards,
Shurik.

__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules