Solved

vb6 error - Run-time error '3265':

Posted on 2014-02-17
3
450 Views
Last Modified: 2014-02-17
When I run a system we have that is written in VB6 and interacts with SQL Server 2008 R2, the error below occurs when trying to change a user password through he VB6 system.
Has anyone encountered this error before?  Any ideas on what causes this error? What should I check to resolve this problem?
Please see the attached file for screen shots and further clarification.
Thanks in advance for any help.

-Utilities
-Change Password
--Enter Password info
VB error occurs…
Run-time error ‘3265’:
Item cannot be found in the collection corresponding to the requested name or ordinal.

See screen shots below…
3265-run-time-error-screen-shot.docx
0
Comment
Question by:tesla764
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
advfinance earned 500 total points
Comment Utility
You've referenced a field that doesn't exist in your record set.

e.g. "SELECT Field1 FROM Table1"

Then later:

rs.Fields("Field2").Value

You'll get that error there.

Does that point you in the right direction?

--
Chris

(PS: You might want to consider posting your screenshots as images, not docx files. More people might view them.)
0
 

Author Comment

by:tesla764
Comment Utility
Possibly, I will check that out and let you know.
Thanks Chris
0
 

Author Closing Comment

by:tesla764
Comment Utility
Thanks Chris. Your suggestion helped me fix the problem.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
GridDataView 6 44
Visual Studio installation 5 32
Loop through Multiple Processes Async 2 15
Spacing between controls 4 15
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now