How do I resolve ADODB.Field error

[Me]

I have a function -

Function GetManagersName(xxx)
Set RS = Conn.execute(localSQLString)
GetManagersName = RS("Name")
RS.close
SET RS= nothing
end function
---------------------
If it cannot find a name, I would like to put blank.

call is made to get record set from the database.

Database can't find the record as a result I get the error

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.

Thank you,
-Me

 

[rob^_^]

GetManagersName = RS("Name")&""

 

[Eric]

The personal application cannot be updated for SP3 and IE7, but XP is updated
with SP3 and IE7, so I need to uninstall both service pack.
Does anyone have any suggestions on how to uninstall them?
Thanks everyone very much for any suggestions
Eric

 

[PA Bear [MS MVP]]

Which was installed first, IE7 or SP3?

About IE7 (and IE8) and Windows XP Service Pack 3
http://blogs.msdn.com/ie/archive/2008/05/05/ie-and-xpsp3.aspx

 

[Eric]

I have no idea, do you have any suggestions on how to determine which one
install first? If IE7 is installed first, what should I do? and if SP3 is
installed first, what should I do?
Thanks in advance for any suggestions
Eric

 

[PA Bear [MS MVP]]

[crossposted to WinXP General]

Your other, related threads:

http://groups.google.com/group/micr..._frm/thread/4819a3047993ffa7/bb0a77760910a6a0

http://groups.google.com/group/micr...e_frm/thread/97c89df4f67b568/07506dbeecf6fec0

http://groups.google.com/group/micr..._frm/thread/fe24f6f4a73b7c93/9782ce1dc17316d5

http://groups.google.com/group/micr..._frm/thread/1f176e87210774e6/d619d2f1b971a50f

To avoid confusion, please post all further follow-up in replies to this
thread. Thanks.

PLEASE NOTE that uninstalling SP3 and/or IE7 may not resolve your problem
and probably won't be necessary! See
http://kb2.adobe.com/cps/192/tn_19203.html

That being said...

If the REMOVE button for "Windows Internet Explorer 7" (in Add/Remove
Programs) is unavailable, you installed SP3 after you installed IE7:

About IE7 (and higher) and Windows XP Service Pack 3
http://blogs.msdn.com/ie/archive/2008/05/05/ie-and-xpsp3.aspx

To be able to uninstall IE7, you'd first have to uninstall WinXP SP3.

How to remove Windows XP Service Pack 3 from your computer:
http://support.microsoft.com/kb/950249

Uninstalling IE7
http://www.ie-vista.com/kbase2.html

[Only use the "spuninst.exe" Command if you cannot uninstall "Windows
Internet Explorer 7" via Add/Remove Programs *after* you've uninstalled SP3;
It's safe to ignore any "Such-and-such might not work..." warnings; Ignore
any reference to Vista on the above page]

IE7 (Un)Installation and Anti-Malware Applications:
http://blogs.msdn.com/ie/archive/2006/10/11/IE7-Installation-and-Anti_2D00_Malware-Applications.aspx