User Profile

Collapse

Profile Sidebar

Collapse
psdsen
psdsen
Last Activity: Oct 31 '11, 06:48 AM
Joined: Oct 22 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • psdsen
    replied to How do I Avoid Error 3021: No Current Record
    in Access
    @Stewart
    Its all for test purpose only. Please write the error free program.
    My Q2: how to add item in CBONAME combobox from ENAME field using loop.
    See more | Go to post

      Leave a comment:

    • psdsen
      started a topic How do I Avoid Error 3021: No Current Record
      in Access

      How do I Avoid Error 3021: No Current Record

      Please help me for the following program problem.
      When I Click Next button, at the last record, it Shows --Run time error '3021': Either BOF or EOF......

      Code:
      Option Explicit
Dim strsql As String
Dim con_data As ADODB.Connection
Dim rs_Data As ADODB.Recordset

Private Sub Form_Load()
  Set con_data = New ADODB.Connection
  Set rs_Data = New ADODB.Recordset
  con_data.Provider = "Microsoft.jet.oledb.4.0;Data
      ...
      See more | Go to post
      Last edited by NeoPa; Oct 22 '11, 11:42 AM. Reason: Stewart - Added code tags & NeoPa - Please don't SHOUT.
      No activity results to display
      Show More
      Working...