Click here to Skip to main content
15,918,049 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questioncapture keypress using windows services Pin
ramesh.samiappan5-May-06 5:36
ramesh.samiappan5-May-06 5:36 
QuestionChanging routing table Pin
mjackson115-May-06 5:19
mjackson115-May-06 5:19 
AnswerRe: Changing routing table Pin
Dave Kreskowiak5-May-06 5:48
mveDave Kreskowiak5-May-06 5:48 
GeneralRe: Changing routing table Pin
mjackson115-May-06 8:24
mjackson115-May-06 8:24 
GeneralRe: Changing routing table Pin
Dave Kreskowiak5-May-06 9:24
mveDave Kreskowiak5-May-06 9:24 
GeneralRe: Changing routing table Pin
mjackson115-May-06 12:20
mjackson115-May-06 12:20 
GeneralRe: Changing routing table Pin
Dave Kreskowiak6-May-06 4:15
mveDave Kreskowiak6-May-06 4:15 
QuestionAdding records in a datasheet form Pin
mjackson115-May-06 3:13
mjackson115-May-06 3:13 
This is in VB for Access, I don't know if it works the same in VB.NET.

I have a datasheet on a form who's datasource is a disconnected ADO recordset. I created the recordset in the form's open event method. It displays everything properly and I can delete/edit records but I adding them is broken. For example the datasheet last line is

ID SYMBOL DESCRIPTION
164 VM PJM OFF PEAK

When I go to line 165 and try to type in:

165 XXX TEST

It adds ten blank records to the dataset. Is there something I am missing about adding and editing record sets. Sorry but my prior experience is C++ financial so I don't know much about interfaces.

Thx

Mark Jackson

<----- Code here ----->

qStr = "SELECT Symbol, Legend FROM SymbolKey WHERE Symbol IS NOT NULL ORDER BY Symbol"
dbRS.Open qStr, dbConn, adOpenKeyset, adLockOptimistic

Set formRS = New ADODB.Recordset
formRS.Fields.Append "myID", adInteger, 8, adFldUpdatable
formRS.Fields.Append "Symbol", adChar, 10, adFldUpdatable
formRS.Fields.Append "Legend", adChar, 255, adFldUpdatable
formRS.Open , , adOpenDynamic, adLockOptimistic
i = 0
Do Until dbRS.EOF
formRS.AddNew
formRS.Fields("myID").Value = i
formRS.Fields("Symbol").Value = dbRS.Fields("Symbol").Value
formRS.Fields("Legend").Value = dbRS.Fields("Legend").Value
i = i + 1
dbRS.MoveNext
Loop
Set Me.Recordset = formRS
dbRS.Close
Set dbRS = Nothing


AnswerRe: Adding records in a datasheet form Pin
Dave Kreskowiak5-May-06 5:43
mveDave Kreskowiak5-May-06 5:43 
GeneralRe: Adding records in a datasheet form Pin
mjackson115-May-06 8:30
mjackson115-May-06 8:30 
QuestionDATAGRID Pin
Member 28660305-May-06 2:53
Member 28660305-May-06 2:53 
AnswerRe: DATAGRID Pin
Dave Kreskowiak5-May-06 5:34
mveDave Kreskowiak5-May-06 5:34 
Questioninfromation transfer, very urgent?????????? Pin
Waimba5-May-06 2:46
Waimba5-May-06 2:46 
AnswerRe: infromation transfer, very urgent?????????? Pin
Dave Kreskowiak5-May-06 5:31
mveDave Kreskowiak5-May-06 5:31 
Questionbutton property pls help Pin
vipinpaliwal19805-May-06 1:37
vipinpaliwal19805-May-06 1:37 
AnswerRe: button property pls help Pin
Dave Kreskowiak5-May-06 5:28
mveDave Kreskowiak5-May-06 5:28 
QuestionFlashing Minimized Form Pin
ADY0075-May-06 1:03
ADY0075-May-06 1:03 
AnswerRe: Flashing Minimized Form Pin
Yulianto.5-May-06 1:24
Yulianto.5-May-06 1:24 
AnswerRe: Flashing Minimized Form Pin
Dave Kreskowiak5-May-06 5:22
mveDave Kreskowiak5-May-06 5:22 
GeneralRe: Flashing Minimized Form Pin
ADY0075-May-06 7:47
ADY0075-May-06 7:47 
Questionwant a function Pin
pptadam5-May-06 0:13
pptadam5-May-06 0:13 
AnswerRe: want a function Pin
Chatura Dilan5-May-06 0:23
Chatura Dilan5-May-06 0:23 
AnswerRe: want a function Pin
J4amieC5-May-06 0:59
J4amieC5-May-06 0:59 
AnswerRe: want a function Pin
Rizwan Bashir5-May-06 1:11
Rizwan Bashir5-May-06 1:11 
Questioncannot grab data from ms access database into list view Pin
penin4-May-06 23:46
penin4-May-06 23:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.