Discussion:
How do I resolve ADODB.Field error
(too old to reply)
Me
2009-05-04 18:37:03 UTC
Permalink
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^_^
2009-05-04 21:01:54 UTC
Permalink
GetManagersName = RS("Name")&""
Post by 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
Eric
2009-05-06 00:01:01 UTC
Permalink
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
Post by 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
PA Bear [MS MVP]
2009-05-06 00:05:20 UTC
Permalink
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
Post by 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
Post by 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
Eric
2009-05-06 09:38:01 UTC
Permalink
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
Post by 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
Post by 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
Post by 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
PA Bear [MS MVP]
2009-05-06 16:39:45 UTC
Permalink
[crossposted to WinXP General]

Your other, related threads:

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_frm/thread/4819a3047993ffa7/bb0a77760910a6a0

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_frm/thread/97c89df4f67b568/07506dbeecf6fec0

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_frm/thread/fe24f6f4a73b7c93/9782ce1dc17316d5

http://groups.google.com/group/microsoft.public.windowsxp.general/browse_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
--
~Robear Dyer (PA Bear)
MS MVP-IE, Mail, Security, Windows Client - since 2002
Post by 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
Post by 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
Post by 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
Post by 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
Loading...