January 9, 2009 01:22am pst

1. LSMCons... 2,500
2. RobSamp... 2,000
3. Dabas 500

1. leonstryker 663,946
2. angelIII 320,840
3. emoreau 302,208
4. acperkins 265,882
5. Dhaest 197,159
6. TimCottee 162,377
7. Arthur_... 153,935
8. MYLim 135,434
9. Sethi 112,456
10. Dabas 110,481
11. mdougan 101,810
12. ryancys 98,083
13. leclairm 93,623
14. mlmcc 93,143
15. LSMCons... 91,568
16. jimhorn 91,332
17. capricorn1 86,338
18. aikimark 83,779
19. rockiroads 71,034
20. harfang 64,790
21. spongie 60,226
22. jkaios 46,350
23. GrahamSkan 43,758
24. Michael_D 42,870
25. CarlWarner 41,949

09.17.2003 at 09:24AM PDT, ID: 20741473

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.2

runtime error 3021

Asked by claracruz in VB Database Programming

Tags: error, 3021, runtime

novice needs help!!!!!!!
I am getting error 3021, (either BOF or EOF is true, or the current record has been deleted. requested operation requires a current record with this code.) i have a form that dispalys info from the recordset in text boxes, and the branch code automatically displays branch name in a textbox.this works fine on form load.
the problem is once the branch code changes, i get the above error. i know i am missing something very obious, but for the life of me i can't figure out what it is.
the sql statement also gives me a syntax error(missing operator) when i try to clear the contents of the textboxes.
ps; branch number datatype is text.

Private Sub txtBranchNo_change()
Dim con As ADODB.Connection
Dim rec As ADODB.Recordset
Dim strName As String
Set con = New ADODB.Connection
Set rec = New ADODB.Recordset

strName = "Select PHARMACYBRANCHCODES.[Branch No],PHARMACYBRANCHCODES.[Branch Name] From PHARMACYBRANCHCODES Where PHARMACYBRANCHCODES.[Branch No] =" & txtBranchNo.Text & ""
con.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\fyfy\hguyg.mdb"
rec.Open strName, con
If rec.RecordCount <> 0 Then
rec.MoveFirst
txtBranchName.Text = rec.Fields("Branch Name")
End If

End SubStart Free Trial

Keywords: runtime error 3021

	Title
1	Either EOF or BOF is true
2	ADODB.Field error '80020009…
3	Why do I get BOF or EOF error?
4	Detecting BOF/EOF
5	BOF and EOF Error
6	EOF and BOF

Loading Advertisement...

20080924-EE-VQP-38

runtime error 3021

Asked by claracruz in VB Database Programming

Tags: error, 3021, runtime

About this solution