Search DaniWeb - movefirst

Re: (--)need what is the meaning of movenext,movefirst etc... 14 Years Ago by sidnei … forward ( [ICODE] obj.Move 3 [/ICODE] move 3 records forward); MOVEFIRST - point the first record in your dataset; MOVEPREVIOUS - point to…; MOVELAST - point to the last record in your dataset. While MoveFirst and MoveLast methods don't cause errors if you have… (--)need what is the meaning of movenext,movefirst etc... 14 Years Ago by jemz hello please help me on this i don't know what is the meaning of this movenext,movefirst, ,adoptimistic,aduserclient....please help me on this and how to use on this and the meaning of this...hoping for your positive responds..thanks in advance... Re: (--)need what is the meaning of movenext,movefirst etc... 14 Years Ago by jemz oki thanks for helping me...ahm what about the format currency?can i have also the peso sign format?.....what is the meaning for this i think this is for the currency,..correct me if i'm wrong..format (#,##0.00)...please help me on this hoping for your positive responds. Re: (--)need what is the meaning of movenext,movefirst etc... 14 Years Ago by vb5prgrmr Type in FormatCurrency and Press F1... [code] MsgBox FormatCurrency(12345678.9, 2, vbUseDefault, vbUseDefault, vbUseDefault) [/code] Good Luck Re: (--)need what is the meaning of movenext,movefirst etc... 14 Years Ago by jemz thanks for the reply and helping me..more power to you access to Datagrid...show in DBGrid 15 Years Ago by singoi …;Taetigkeit" '** Table name for Stundensatz tt.MoveFirst 'If tt.EOF = True Then tt.AddNew …adLockOptimistic se.CursorType = adOpenKeyset se.Open sSQL se.MoveFirst While (Not se.EOF) cmbp.AddItem se(&…quot;, dbOpenDynaset) If DBGrsd.RecordCount > 0 Then DBGrsd.MoveFirst Set DBGrsd = Nothing Fields = "Name_S" Recd… VB6 - Error: Loop Without a Do 16 Years Ago by tgifgemini …amp; M.qBW![TotalProg3Hrs] rsinPers.MoveNext Loop rsinPers.MoveFirst Do Until rsinPers.EOF If rsinPers![Name] = M…amp; M.qBW![TotalProg4Hrs] rsinPers.MoveNext Loop rsinPers.MoveFirst Do Until rsinPers.EOF If rsinPers![Name] = M… VB6 - Process not reaching EOF (End Of File) 16 Years Ago by tgifgemini …TotalProg3Hrs] End If rsinPers.MoveNext Loop rsinPers.MoveFirst Do Until rsinPers.EOF If rsinPers![Name…] End If rsinPers.MoveNext Loop rsinPers.MoveFirst Do Until rsinPers.EOF If rsinPers![Name… VB6 - "FindFirst" with multiple search Criteria 16 Years Ago by tgifgemini …amp; M.qBW![TotalProg3Hrs] rsinPers.MoveNext Loop rsinPers.MoveFirst Do Until rsinPers.EOF If rsinPers![Name] = M…amp; M.qBW![TotalProg4Hrs] rsinPers.MoveNext Loop rsinPers.MoveFirst Do Until rsinPers.EOF If rsinPers![Name] = M… Messed up Flex Grid code 11 Years Ago by Ayesha.Shahnawaz …"Service" If RSReceiptService.EOF Then Exit Sub RSReceiptService.MoveFirst RR = 1 Do While Not RSReceiptService.EOF() FlexReceipt.TextMatrix(RR… Sub Function ServiceName(Tname As String) As Integer RSservice.MoveFirst Do While Not RSservice.EOF If RSservice.Fields(1) … How can I refresh DataBase without closing Form Attached with my Coding 19 Years Ago by chan …If Data1.Recordset.RecordCount > 0 Then Data1.Recordset.MoveFirst Data1.Recordset.Edit Data1.Recordset.Fields("ID") =…If Data1.Recordset.RecordCount > 0 Then Data1.Recordset.MoveFirst Data1.Recordset.Delete MsgBox "Successfully Delete Data!",… conflict between save and search adodb 13 Years Ago by cavern … from Owner" rs.Open str, adoconn, adOpenDynamic, adLockPessimistic rs.MoveFirst cmbReg.Text = rs(0) txtDate.Text = rs(1) cmbTitle.Text… from Owner" rs.Open str, adoconn, adOpenDynamic, adLockPessimistic rs.MoveFirst cmbReg.Text = rs(0) txtDate.Text = rs(1) cmbTitle.… Generating Report Through ASP 12 Years Ago by dinilkarun ….Execute(sQueryH) if not rsQueryH.EOF then rsQueryH.MoveFirst dim rsQueryH2 dim sQueryH2 dim cCols sQueryH2 = …Execute(sQueryH2) if not rsQueryH2.EOF then rsQueryH2.MoveFirst sCols = rsQueryH2.Fields(0) rsQueryH2.MoveNext ….Execute(sQuery1) if not rsQuery1.EOF then rsQuery1.MoveFirst %> </head> <body&… Connecting 2 Flex Grids in One form? 11 Years Ago by Ayesha.Shahnawaz ….Open (sql4), conn, adOpenDynamic, adLockOptimistic rec.MoveLast rec.MoveFirst Dim RR As Integer FlexService.Clear FlexService.Rows = rec.RecordCount….Open (sql4), conn, adOpenDynamic, adLockOptimistic rec.MoveLast rec.MoveFirst Dim RR As Integer FlexPP.Clear FlexPP.Rows = rec.… Re: Connecting 2 Flex Grids in One form? 11 Years Ago by Ayesha.Shahnawaz ….Open (sqlS4), conn, adOpenDynamic, adLockOptimistic rec.MoveLast rec.MoveFirst recS.Close (sqlS), conn, adOpenDynamic, adLockOptimistic recS2.Close … (sqlPP4), conn, adOpenDynamic, adLockOptimistic rec.MoveLast rec.MoveFirst Dim RR As Integer FlexPP.Clear FlexPP.Rows = … operation is not allowed when the object is open.... 5 Years Ago by Meenakshi_2 …yyyy" End Sub Private Sub cmdFirst_Click() rs.MoveFirst extract End Sub Private Sub cmdLast_Click() rs.MoveLast… cmdPrevious_Click() rs.MovePrevious If rs.BOF Then rs.MoveFirst extract End Sub Private Sub cmdQuit_Click() End End… Re: VB6 - "FindFirst" with multiple search Criteria 16 Years Ago by tgifgemini … logic/Function and tell me what you think. M.qBW.MoveFirst rsinPers.MoveFirst Do Until M.qBW.EOF = True xlWksht.Cells(ii… Re: VB6 - "FindFirst" with multiple search Criteria 16 Years Ago by tgifgemini … and tell me what you think. [code] M.qBW.MoveFirst rsinPers.MoveFirst Do Until M.qBW.EOF = True xlWksht.Cells(ii, 1… Re: Connecting 2 Flex Grids in One form? 11 Years Ago by AndreRet …recPP4.Open (sqlPP4), conn, adOpenDynamic, adLockOptimistic rec.MoveLast rec.MoveFirst Dim RR As Integer FlexPP.Clear FlexPP.Rows = rec.RecordCount…; FlexPP.TextMatrix(0, 3) = "AmountPaid" rec.MoveFirst RR = 1 Do While Not rec.EOF() FlexPP.TextMatrix(RR… Re: VB6 - "FindFirst" with multiple search Criteria 16 Years Ago by QVeen72 Hi, It shud be some thing like this: [code] rsinPers.MoveFirst Do rsinPers.Find "Name='" & M.qBW![Personnel2] & "'" If rsinPers.EOF Exit Do Else xlWksht.Cells(ii, 5).Value = rsinPers![Initials] & Chr(10) & M.qBW![TotalProg2Hrs] End If Loop [/code] Regards Veena Accessing a Microsoft Access Database 15 Years Ago by WatsonPsykosis …;> 0 Then If rs.EOF = True Then rs.MoveFirst Do Until rs.EOF Combo1.AddItem Trim(rs!user_name) rs…;> 0 Then If rs.EOF = True Then rs.MoveFirst Do Until rs.EOF Combo2.AddItem Trim(rs!user_name) rs… how to update the text file into access file 15 Years Ago by vbgirl …rsId.Open "ID", cnName, adOpenKeyset, adLockOptimistic 'With rsId '.MoveFirst 'While Not .EOF 'MsgBox .Fields(0), vbOKOnly, "Access… file" '.MoveNext 'Wend 'End With With rsId .MoveFirst Dim d As Integer d = 0 For i = 0 To…(0) Then rsId.Update End If rsId.MoveNext Loop rsId.MoveFirst d = d + 1 Next[/COLOR] End With 'when… why the code only show out one data when update? 15 Years Ago by vbgirl …Open "ID", cnName, adOpenKeyset, adLockOptimistic 'With rsId '.MoveFirst 'While Not .EOF 'MsgBox .Fields(0), vbOKOnly, "… file" '.MoveNext 'Wend 'End With With rsId .MoveFirst Dim d As Integer d = 0 For i = 0…= a(i) rsId.Update End If rsId.MoveNext Loop rsId.MoveFirst 'd = d + 1 Next MsgBox "Done",… What's wrong with my "searching" code? 15 Years Ago by nor_d83 …Data1.Recordset.NoMatch Then 'if no match Data1.Recordset.MoveFirst 'go to first record End If End Sub] …Data1.Recordset.NoMatch Then 'if no match Data1.Recordset.MoveFirst 'go to first record End If End Sub]….Recordset.NoMatch Then 'if no match Data1.Recordset.MoveFirst 'go to first record End If End Sub]… How to handle null Resultset(zero rows) 15 Years Ago by Fionageo …rows in Resulset. rs = dataSource.performQuery(sqlstatement) rs.moveFirst() I dont know which condition has to be set … doesnt has any row. When I say rs.moveFirst() it sends me an error because there is … many things like: rs = dataSource.performQuery(sqlstatement) rs.moveFirst() while rs.moveNext: --------->This part doesnt work,it… help with (Either BOF or EOF is True) error 15 Years Ago by HB25 …the profind function code [code] Public Sub profind() dtacustomer.Recordset.MoveFirst While txtcustomer <> txtcustomerNo dtacustomer.Recordset.MoveNext Wend dtaRoom….Recordset.MoveFirst While txtroom <> txtroomNo dtaRoom.Recordset.MoveNext Wend … Syntax error(missing operator) in query expression '='" 12 Years Ago by dwiniers …() Adodc1.Recordset.Delete If Adodc1.Recordset.EOF Then Adodc1.Recordset.MoveFirst End Sub Private Sub cmdedit_Click() Adodc1.Recordset.Update End Sub…() Adodc1.Recordset.MovePrevious If Adodc1.Recordset.BOF Then Adodc1.Recordset.MoveFirst MsgBox "Beginning of file!", vbInformation End If Text6… code to locked the object textbox 12 Years Ago by dwiniers …Adodc1.Recordset.Delete If Adodc1.Recordset.BOF Then Adodc1.Recordset.MoveFirst End If End Sub Private Sub cmdedit_Click() Adodc1.Recordset.Update… Adodc1.Recordset.MovePrevious If Adodc1.Recordset.BOF Then Adodc1.Recordset.MoveFirst MsgBox "Beginning of file!", vbInformation End If … Re: loop problem 13 Years Ago by AndreRet [QUOTE]FeeTrans.MoveFirst 'StChk.MoveFirst[/QUOTE] It seems you keep on moving back to the first record within a loop. Remove the part "movefirst", because you WANT it to go to the next record as per your code at the end. Re: conflict between save and search adodb 13 Years Ago by cavern … * from Owner" rs.Open str, adoconn, adOpenDynamic, adLockPessimistic rs.MoveFirst cmbReg.Text = rs(0) txtDate.Text = rs(1) cmbTitle.Text…