PC Review


Reply
Thread Tools Rate Thread

How do I resolve ADODB.Field error

 
 
Me
Guest
Posts: n/a
 
      4th May 2009
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


 
Reply With Quote
 
 
 
 
rob^_^
Guest
Posts: n/a
 
      4th May 2009
GetManagersName = RS("Name")&""

"Me" <(E-Mail Removed)> wrote in message
news:0CBEFDEB-8F88-4D31-B5FE-(E-Mail Removed)...
> 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
>
>

 
Reply With Quote
 
Eric
Guest
Posts: n/a
 
      6th May 2009
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

"Me" wrote:

> 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
>
>

 
Reply With Quote
 
PA Bear [MS MVP]
Guest
Posts: n/a
 
      6th May 2009
Which was installed first, IE7 or SP3?

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


Eric wrote:
> 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
>
>> 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

 
Reply With Quote
 
Eric
Guest
Posts: n/a
 
      6th May 2009
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]" wrote:

> Which was installed first, IE7 or SP3?
>
> About IE7 (and IE8) and Windows XP Service Pack 3
> http://blogs.msdn.com/ie/archive/200...and-xpsp3.aspx
>
>
> Eric wrote:
> > 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
> >
> >> 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

>

 
Reply With Quote
 
PA Bear [MS MVP]
Guest
Posts: n/a
 
      6th May 2009
[crossposted to WinXP General]

Your other, related threads:

http://groups.google.com/group/micro...0a77760910a6a0

http://groups.google.com/group/micro...506dbeecf6fec0

http://groups.google.com/group/micro...82ce1dc17316d5

http://groups.google.com/group/micro...19d2f1b971a50f

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/200...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/200...lications.aspx
--
~Robear Dyer (PA Bear)
MS MVP-IE, Mail, Security, Windows Client - since 2002

Eric wrote:
> 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
>
> "PA Bear [MS MVP]" wrote:
>> Which was installed first, IE7 or SP3?
>>
>> About IE7 (and IE8) and Windows XP Service Pack 3
>> http://blogs.msdn.com/ie/archive/200...and-xpsp3.aspx
>>
>>
>> Eric wrote:
>>> 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
>>>
>>>> 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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB.Field error '800a0bcd' MS Office Outlook Error Microsoft Access 3 18th Sep 2009 04:17 PM
Re: How do I resolve ADODB.Field error PA Bear [MS MVP] Windows XP General 0 6th May 2009 05:39 PM
How to find full field name in ADODB ? Michel S. Microsoft Access 6 13th Aug 2006 10:54 PM
ADODB.Field error '80020009' =?Utf-8?B?TW9yZ2Fu?= Windows XP Internet Explorer 1 4th May 2006 03:23 AM
ADODB Field Error Steve H Windows XP Internet Explorer 0 16th Feb 2004 11:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:35 PM.