dcsimg

Search:

Type: Posts; User: rasheedraj@gmail.com

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: 3021: Either BOF or EOF is True, or the current record has been deleted.

    txtEord.text is a number
  2. Re: 3021: Either BOF or EOF is True, or the current record has been deleted.

    Private Sub displ_eord()
    Dim oRS As ADODB.Recordset
    Dim sQuery As String

    Set oRS = New ADODB.Recordset
    sQuery = "Select * from payment where orde ='" & txtEOrd.Text & "' and bal <>...
  3. Re: 3021: Either BOF or EOF is True, or the current record has been deleted.

    Paid Also belong to same table
  4. Re: 3021: Either BOF or EOF is True, or the current record has been deleted.

    Record.Open "Select * from payment where orde ='" & txtEOrd.Text & "' and bal <> 'paid'", Connect, 3, 3
    Did not display any data
  5. 3021: Either BOF or EOF is True, or the current record has been deleted.

    Private Sub displ_eord()
    Set Record = New ADODB.Recordset
    Record.Open "Select * from payment where orde ='" & txtEOrd.Text & "' and bal <> paid", Connect, 3, 3
    If Not Record.EOF Then
    ...
  6. Replies
    6
    Views
    443

    Re: Data Report Error

    Report is not working
  7. Replies
    6
    Views
    443

    Re: Data Report Error

    Error as attachment showed for this code "Aurgments are of the wrong type,are out of acceptable range


    Private Sub cmdPrint_Click()
    Set Recordset = New ADODB.Recordset
    With Recordset
    ...
  8. Replies
    6
    Views
    443

    Data Report Error

    This is my code, i want to make summary of area wise in a report.


    Private Sub cmdPrint_Click()
    Set Record = New ADODB.Recordset
    Record.Open "Select distinct cit,sum(toamount) from payment...
  9. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    @Zvoni Thanks alot for switiching my mind button....its clear...Actually UserDelete is pointing some other field., i changed, its working now.....Thanks alot @Zvoni,@PGBSoft,@DataMiser
  10. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    As suggested by you i have followed all , but debug report not seen any
  11. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    @PGBSoft, same problem, even i changed filed name as suggested by you.
  12. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    @PGBSoft, Same Error
  13. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    Sir
    I Don't want to add new record, wanna update the some fields in that record
  14. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    Sir
    I Don't want to add new record, wanna update the some fields in that record
  15. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    Private Sub cmdSave_Click()
    If UserDelete = vbNullString Then
    MsgBox "Please choose a record in the list to Update.", vbExclamation, "Warning!"
    Exit Sub
    Else
    ...
  16. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    Private Sub cmdSave_Click()
    If UserDelete = vbNullString Then
    MsgBox "Please choose a record in the list to Update.", vbExclamation, "Warning!"
    Exit Sub
    Else
    ...
  17. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    No Output in Debug also
  18. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    @Zvoni i have done as mentioned by you
    But,still same error msg
  19. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    Nothing Returns Breaks on 3201 Error
  20. Replies
    25
    Views
    1,005

    Re: Run Time Error 3201

    Sorry Sir
    Error on this line !paid = Text1.Text
  21. Replies
    25
    Views
    1,005

    [RESOLVED] Run Time Error 3201

    Private Sub cmdSave_Click()
    If UserDelete = vbNullString Then
    MsgBox "Please choose a record in the list to Update.", vbExclamation, "Warning!"
    Exit Sub
    Else
    ...
  22. Re: item cannot be found in the collection corresponding

    Private Sub cmdPrint_Click()
    Set Record = New ADODB.Recordset
    Record.Open ("SELECT " _
    & "(SELECT COUNT(*) FROM [Ord] WHERE [OrderNo] like'" & lblOrderNo.Caption & "'" _...
  23. item cannot be found in the collection corresponding

    Private Sub cmdPrint_Click()
    Set Record = New ADODB.Recordset
    Record.Open "SELECT orno,qty,rate,tamount,Edate,cname,cmob,city,gst,pack,ck (SELECT COUNT(*) FROM Ord C2 WHERE C2.prodname <=...
  24. Replies
    1
    Views
    331

    Run Time Error 3201

    Private Sub cmdSave_Click()
    If TxtDesc.Text = vbNullString Then Exit Sub
    If txtQty.Text = vbNullString Then Exit Sub
    If txtCustomer.Text = vbNullString Then Exit Sub
    Dim zSI, zDesc, zqty, zPack,...
  25. Re: Serial number in Data Report is not starting from 1,2...

    i don't want any filter, i want all records of table show in report
  26. Re: Serial number in Data Report is not starting from 1,2...

    ("SELECT " _
    & "(SELECT COUNT(*) FROM [Customer]," _
    & "AND [ID] <= [T].[ID]) AS [SerNo],"), Connect, 1, 3


    Syntax Error
  27. Re: Serial number in Data Report is not starting from 1,2...

    Thanks alot or kind help
    Its working
  28. Re: Serial number in Data Report is not starting from 1,2...

    Not working
    Even after i change C to S
    same error
    Sample for Ms Access plz
  29. Re: Serial number in Data Report is not starting from 1,2...

    i have products with different codes
    then what to do???
  30. Re: Serial number in Data Report is not starting from 1,2...

    No
    What should be C
  31. Re: Serial number in Data Report is not starting from 1,2...

    SELECT InvoiceNo,Qty,Price,TotalAmount,DateCreated,CustomerName,ProductCode,ContactNo,Address,City,Tin,Dist,Packing, (Select Count (*) FROM [SalesInvoice] as X WHERE [X].[ProductCode] >"c" AND...
  32. Re: Serial number in Data Report is not starting from 1,2...

    Chrise sir
    i am using MS Access 2003 database
    is the command is same???
  33. Re: Serial number in Data Report is not starting from 1,2...

    actually i need serial number count like 1,2 for records displayed in Report.
    But i am getting 13,14 like this
    148901
  34. Re: Serial number in Data Report is not starting from 1,2...

    (SELECT COUNT(*) FROM SalesInvoice C2 WHERE C2.ProductCode <= C.ProductCode) AS SerNo FROM SalesInvoice C

    Here i am using count for Serno
  35. Re: Serial number in Data Report is not starting from 1,2...

    148899
    Here i am using SerNo ..???
  36. Serial number in Data Report is not starting from 1,2...

    Private Sub cmdPrint_Click()
    Set Record = New ADODB.Recordset
    Record.Open "SELECT...
  37. Replies
    20
    Views
    1,060

    Re: No Records found

    Private Sub cmdPrint_Click()

    Dim cnview As New ADODB.connection
    Dim rsview As New ADODB.Recordset

    txtEdate.Text = Format("MM/DD/YYYY")
    txtEdate.tag = Int(Date) ' The actual date value

    ...
  38. Replies
    20
    Views
    1,060

    Re: No Records found

    Private Sub cmdPrint1_Click()
    Dim sQuery As String

    Dim cnview As New ADODB.connection
    Dim rsview As New ADODB.Recordset

    Call connection(cnview, App.Path & "\Seeyou.mdb",...
  39. Replies
    20
    Views
    1,060

    Re: No Records found

    No Result on

    Debug.Print sQuery
  40. Replies
    20
    Views
    1,060

    Re: No Records found

    Private Sub cmdPrint1_Click()
    Dim sQuery As String

    Dim cnview As New ADODB.connection
    Dim rsview As New ADODB.Recordset

    Call connection(cnview, App.Path & "\Seeyou.mdb",...
Results 1 to 40 of 110
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width