Re: ADO Recordset.Filter in Excel 2002

Tim
wasn't sure how best to 'post' the code so I have attached the xl file and
pasted the the vba code below.
Your help is much appreciated.
Dash
>>
Public Sub DisConnTest() 'based on 4guys example
Dim RS As ADODB.Recordset
Dim RcdCnt As Long
'call the function
strSQL = "SELECT * FROM Authors"
Set RS = GetRS(strSQL)
'What has to happen here in order to access and operate on RS??
'RS.Open

RcdCnt = RS.RecordCount
End Sub

Function GetRS(strSQL)
'this function returns a disconnected RS

'Set some constants
Const adOpenStatic = 3
Const adUseClient = 3
Const adLockBatchOptimistic = 4

'Declare our variables
' Dim oConn
' Dim oRS
Dim oConn As ADODB.Connection
Dim oRS As ADODB.Recordset

'Open a connection
Set oConn = New ADODB.Connection
' Set oConn = Server.CreateObject("ADODB.Connection")
' oConn.Open mydsn, Sean, Grimaldi
oConn.Open "PubTest", "test1", "test1"
'Create the Recordset object
' Set oRS = Server.CreateObject("ADODB.Recordset")
Set oRS = New ADODB.Recordset
oRS.CursorLocation = adUseClient

'Populate the Recordset object with a SQL query
oRS.Open strSQL, oConn, adOpenStatic, adLockBatchOptimistic

'Disconnect the Recordset
Set oRS.ActiveConnection = Nothing

'Return the Recordset
Set GetRS = oRS

'Clean up...
oConn.Close
oRS.Close
Set oConn = Nothing
Set oRS = Nothing
End Function
>>



"Tim Williams" <timjwilliams at gmail dot com> wrote in message
news:O$XzW2iFGHA.2012@xxxxxxxxxxxxxxxxxxxxxxx
> Post the code which doesn't work - it's easier than having us apply any
> changes you may have made to the original.
>
> Tim
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "Dash" <dshave@xxxxxxxxxxxxx> wrote in message
> news:%23dAjzqhFGHA.3984@xxxxxxxxxxxxxxxxxxxxxxx
>> Thanks Tim but I am still missing something!!
>> I used the 4guys example for a disconnected RS - as it in Excel VBA I
>> had
>> to 'type' the Dim statements.
>> If I try to use the returned RS I get error msg. 'Operation not allowed
> when
>> the object is closed.'
>>
>> If I comment out the lines in the 4guys function closing the oRS then the
>> returned rs is 'open'
>> i.e. RS.RecordCount returns without error.
>> but RS.Filter throws the same compile error 'invalid property assignment'
>>
>> I tried typing the returned RS as Recordset, ADODB.Recordset and Variant
>>
>> Anybody got any further thoughts??
>>
>> Dash
>>
>>
>> "Tim Williams" <saxifrax at pacbell dot net> wrote in message
>> news:e2m11sZFGHA.2036@xxxxxxxxxxxxxxxxxxxxxxx
>> > Make sure you set the RS "cursorlocation" to "client". I forget the
> exact
>> > syntax.
>> > Once the recordset is complete you can then disconnect it from the DB
>> > (unless you're doing updates in which case you might be better off
> leaving
>> > it connected).
>> >
>> > Good code sample here:
>> > http://www.4guysfromrolla.com/webtech/080101-1.shtml
>> >
>> >
>> > Tim
>> >
>> >
>> >
>> > "Dash" <dshave@xxxxxxxxxxxxx> wrote in message
>> > news:enH%23X6TFGHA.3944@xxxxxxxxxxxxxxxxxxxxxxx
>> >> Hi All
>> >> Have been using Excel to generate custom reports on data from remote
>> >> databases quite happily.
>> >> I now have a need to avoid making lots of calls to the DB by
> downloading
>> >> the complete table concerned and using a rsABC.Filter in a loop to do
> a
>> >> different multi-column FIND in each iteration to get the various
> records
>> >> I need.
>> >> However any statement as ' rsABC.Filter "..." ' throws a compile
>> >> error
>> >> 'Invalid Use of property' with the '.Filter' highlighted.
>> >>
>> >>
>> >> Any suggestions as to what I am missing will be much appreciated.
>> >>
>> >> TIA
>> >>
>> >> Dash
>> >>
>> >
>> >
>>
>>
>
>


begin 666 disConnectTest060111a.xls
MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````!
M`````0``````````$ ```@````(```#^____``````````#_____________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M_______________________]____" ```!4````$````!0````8````'````
M"0```!(````*````"P````P````-````#@````\````0````$0```!,````7
M````% ```!@```#^_____O___S ````9````&@```!L````N````'0```!X`
M```?````( ```"$````B````(P```"0````E````_O___R<````H````*0``
M`"H````K````+ ```"T````6````+P```#$```#^____,@```/[_________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M_____________________________________________U(`;P!O`'0`( !%
M`&X`= !R`'D`````````````````````````````````````````````````
M```````````6``4`__________\"````( @"``````# ````````1@````"6
M* 5)Q!;&`2 O4US-%L8!`P```( O````````5P!O`'(`:P!B`&\`;P!K````
M````````````````````````````````````````````````````````````
M`!(``@$3````__________\`````````````````````````````````````
M````````````````!PD```````!?`%8`0@!!`%\`4 !2`$\`2@!%`$,`5 !?
M`$,`50!2````````````````````````````````````````````(@`!`0$`
M```1````$ ``````````````````````````````4 /<6\T6Q@$@+U-<S1;&
M`0```````````````%8`0@!!````````````````````````````````````
M```````````````````````````````````````````(``$`__________\(
M``````````````````````````````!0`]Q;S1;&`4!(1US-%L8!````````
M`````````0````(````#````! ````4````&````!P````@````)````"@``
M``L````,````#0````X````/````$ ```!$````2````$P```!0````5````
M%@```!<````8````&0```!H````;````' ```!T````>````'P```" ````A
M````(@```",````D````_O___R8````G````* ```"D````J````*P```"P`
M```M````+@```"\````P````,0```#(````S````- ```#4````V````-P``
M`/[___\Y````.@```#L````\````/0```#X````_````0 ```$$```!"````
M0P```$0```!%````1@```$<```!(````20```/[___]+````3 ```$T```!.
M````3P```% ```!1````4@```%,```!4````50```%8```!7````6 ```%D`
M``!:````6P```/[___]=````7@```%\```!@````80```&(```!C````9 ``
M`&4```!F````9P```&@```!I````:@```&L```!L````;0```/[___]O````
M< ```'$```!R````<P```'0```!U````=@```'<```#^____>0```'H```#^
M____? ```'T```!^````?P```( ````)"! ```8%`$88S0?!@ ``!@(``.$`
M`@"P!,$``@```.(```!<`' ``0``(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @($(``@"P
M!&$!`@```, !```]`08``0`"``,`TP```+H!#P`,``!4:&ES5V]R:V)O;VN<
M``(`#@`9``(````2``(````3``(```"O`0(```"\`0(````]`!(`X $8`$PL
M_"0X```````!`%@"0 `"````C0`"````(@`"````#@`"``$`MP$"````V@`"
M````,0`:`,@```#_?Y !````````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y !
M````````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y !````````!0%!`'(`:0!A
M`&P`,0`:`,@```#_?Y !````````!0%!`'(`:0!A`&P`,0`:`* ```#_?Y !
M````````!0%!`'(`:0!A`&P`'@0<``4`%P``(B0B(RPC(S!?*3M<*"(D(B,L
M(R,P7"D>!"$`!@`<```B)"(C+",C,%\I.UM2961=7"@B)"(C+",C,%PI'@0B
M``<`'0``(B0B(RPC(S N,#!?*3M<*"(D(B,L(R,P+C P7"D>!"<`" `B```B
M)"(C+",C,"XP,%\I.UM2961=7"@B)"(C+",C,"XP,%PI'@0W`"H`,@``7R@B
M)"(J(",L(R,P7RD[7R@B)"(J(%PH(RPC(S!<*3M?*"(D(BH@(BTB7RD[7RA
M7RD>!"X`*0`I``!?*"H@(RPC(S!?*3M?*"H@7"@C+",C,%PI.U\H*B B+2)?
M*3M?*$!?*1X$/P`L`#H``%\H(B0B*B C+",C,"XP,%\I.U\H(B0B*B!<*",L
M(R,P+C P7"D[7R@B)"(J("(M(C\_7RD[7RA 7RD>!#8`*P`Q``!?*"H@(RPC
M(S N,#!?*3M?*"H@7"@C+",C,"XP,%PI.U\H*B B+2(_/U\I.U\H0%\IX `4
M``````#U_R ``````````````, @X `4``$```#U_R ``/0``````````, @
MX `4``$```#U_R ``/0``````````, @X `4``(```#U_R ``/0`````````
M`, @X `4``(```#U_R ``/0``````````, @X `4``````#U_R ``/0`````
M`````, @X `4``````#U_R ``/0``````````, @X `4``````#U_R ``/0`
M`````````, @X `4``````#U_R ``/0``````````, @X `4``````#U_R `
M`/0``````````, @X `4``````#U_R ``/0``````````, @X `4``````#U
M_R ``/0``````````, @X `4``````#U_R ``/0``````````, @X `4````
M``#U_R ``/0``````````, @X `4``````#U_R ``/0``````````, @X `4
M```````!`" ``````````````, @X `4``$`*P#U_R ``/@``````````, @
MX `4``$`*0#U_R ``/@``````````, @X `4``$`+ #U_R ``/@`````````
M`, @X `4``$`*@#U_R ``/@``````````, @X `4``$`"0#U_R ``/@`````
M`````, @DP($`!" `_^3`@0`$8 &_Y,"! `2@ 3_DP($`!. !_^3`@0``( `
M_Y,"! `4@ 7_8 $"````A0`.`,L%``````8`4VAE970QA0`.`-\&``````8`
M4VAE970RA0`.`/,'``````8`4VAE970SC `$``$``0#!`0@`P0$``%2-`0#\
M``@```````````#_``(`" `*````"0@0```&$ !&&,T'P8 ```8"```+`A `
M````````````````@P8```T``@`!``P``@!D``\``@`!`!$``@```! `" #\
MJ?'236)0/U\``@`!`"H``@```"L``@```((``@`!`( `" ```````````"4"
M! ````@!@0`"`,$$% ```!4```"#``(```"$``(```"A`"(````(`0$``0`!
M``0``````````````. _````````X#\``%4``@`(```"#@``````````````
M`````#X"$@"V!@````! ```````````````=``\``P````````$`````````
M[P`&``4`-P```+H!"0`&``!3:&5E=#$*````"0@0```&$ !&&,T'P8 ```8"
M```+`A `````````````````EP<```T``@`!``P``@!D``\``@`!`!$``@``
M`! `" #\J?'236)0/U\``@`!`"H``@```"L``@```((``@`!`( `" ``````
M`````"4"! ````@!@0`"`,$$% ```!4```"#``(```"$``(```"A`"(````(
M`0$``0`!``0``````````````. _````````X#\``%4``@`(```"#@``````
M`````````````#X"$@"V``````! ```````````````=``\``P````````$`
M````````[P`&``4`-P```+H!"0`&``!3:&5E=#(*````"0@0```&$ !&&,T'
MP8 ```8"```+`A `````````````````JP@```T``@`!``P``@!D``\``@`!
M`!$``@```! `" #\J?'236)0/U\``@`!`"H``@```"L``@```((``@`!`( `
M" ```````````"4"! ````@!@0`"`,$$% ```!4```"#``(```"$``(```"A
M`"(````(`0$``0`!``0``````````````. _````````X#\``%4``@`(```"
M#@```````````````````#X"$@"V``````! ```````````````=``\``P``
M``````$`````````[P`&``4`-P```+H!"0`&``!3:&5E=#,*````````````
M````````````````````````````````````````````````````````````
M`````````18!``(``0``/ ,``.0````0`@``:@,``'@#``#,`P````````$`
M``!)+%N[``#__R,!``"(````M@#__P$!`````/____\`````__\\`/__``!B
MF5U.9);K0JCL(8E?N=[(&0@"``````# ````````1@``````````````````
M```!````@;\M[%#+HTR+?"/[';"MI! ````#````!0````<```#_________
M_P$!" ```/____]X````"(&_5 !H`&D`<P!7`&\`<@!K`&(`;P!O`&L`````
M`````````````````````````````````````````````````!H``@'_____
M"P```/____\````````````````````````````````````````````````E
M````A@0```````!3`&@`90!E`'0`,0``````````````````````````````
M````````````````````````````````````````#@`"`0P```#_________
M_P```````````````````````````````````````````````#@```!^! ``
M`````%,`: !E`&4`= `R````````````````````````````````````````
M```````````````````````````````.``(!!0````<```#_____````````
M````````````````````````````````````````2@```'X$````````4P!H
M`&4`90!T`#,`````````````````````````````````````````````````
M``````````````````````X``@'_______________\`````````````````
M``````````````````````````````!<````?@0````````M[%#+HTR+?"/[
M';"MI&*974YDENM"J.PAB5^YWLC__P````!-10``________`````/__````
M`/__`0$`````WP#__P````#_____________________________________
M____________________________________________________________
M____________________________________________________________
M________________* ````(`4TS_____```!`%,0_____P```0!3E/____\`
M````-B+_____``#__P$!``````$`3@`P`'L`, `P`# `,@`P`#@`,0`Y`"T`
M, `P`# `, `M`# `, `P`# `+0!#`# `, `P`"T`, `P`# `, `P`# `, `P
M`# `, `T`#8`?0`'````_____P$!H ````* _O______$ #__R@````"`?__
M``````````#__________P`````=````)0```/____\``````H/^______\(
M`/__8 ``````________`````/__________`````!T`# `E````@J 4`O__
M___^____D ````(`___^____`````/__________`````!T`# `E````____
M_V ````````````!````````````________________`````/__________
M________________`````/_______________V@````X``````````````!
M``0``````!0#% /_____________________________" `!`# ```#77R]%
M*0`!) `J`%P`4@!F`&8`9@!F`"H`. !"`#0`-0`R`&8`-0!F`#8`,P#?`0``
M````_____S0`````````````````````````````````````````````````
M``````````````````````````````````#^R@$```#_____`0$(````____
M_W@```#_____```!L+ `071T<FEB=70`92!60E].86T`92 ](")4:&D`<U=O
M<FMB;V\0:R(-"@J,0F%S`0*,,'LP,# R,% X,3DM`! P`PA#!P`4`A(!)# P
M-#9]@0U\1VQO8F%L`= 04W!A8P&21F%L!'-E#&1#<F5A= AA8FP5'U!R9620
M96-L80`&260`L0A4<G4-0D5X<&\$<V44'%1E;7!L`&%T941E<FEV`P(2DD)U
M<W1O;6D&>@1$`S(`````````````````````````````````````````````
M`````````````````````````````````18!``(``0``/ ,``.0````0`@``
M:@,``'@#``#,`P````````$```!)+"B.``#__R,!``"(````M@#__P$!````
M`/____\`````__\\`/__``"5%_=$W[F@1YM'A!$Q7@K7( @"``````# ````
M````1@`````````````````````!````;[\RX?RK?4FME6V']4Q/#! ````#
M````!0````<```#__________P$!" ```/____]X````"&^_,N'\JWU)K95M
MA_5,3PR5%_=$W[F@1YM'A!$Q7@K7__\`````344``/_______P````#__P``
M``#__P$!`````-\`__\`````____________________________________
M____________________________________________________________
M____________________________________________________________
M_________________R@````"`%-,_____P```0!3$/____\```$`4Y3_____
M`````#8B_____P``__\!`0`````!`$X`, ![`# `, `P`#(`, `X`#(`, `M
M`# `, `P`# `+0`P`# `, `P`"T`0P`P`# `, `M`# `, `P`# `, `P`# `
M, `P`# `- `V`'T`!P```/____\!`: ````"@/[______Q `__\H`````@'_
M_P``````````__________\`````'0```"4```#_____``````*#_O______
M" #__V ``````/_______P````#__________P`````=``P`)0```(*@& +_
M_____O___Y ````"`/___O___P````#__________P`````=``P`)0```/__
M__]@`````````````0```````````/_______________P````#_________
M_________________P````#_______________]H````. `````````!````
M0 `$```````\`CP"_____________________________P@``0`P````UU\O
M12D``20`*@!<`%(`9@!F`&8`9@`J`#@`0P`T`#4`,@!F`#4`9@`V`#,`WP$`
M`````/____\T````````````````````````````````````````````````
M````````````````````````````````````_LH!````_____P$!" ```/__
M__]X````_____P```:BP`$%T=')I8G5T`&4@5D)?3F%M`&4@/2 B4VAE0&5T
M,2(-"@KH0@1A<P)T,'LP,## ,C X,C M`" $" Y#`!0"' $D,# T-@)]#7Q'
M;&]B86PA`<13<&%C`9)&80AL<V4,9$-R96$0=&%B;!4?4')E(&1E8VQA``9)
M9!$`JU1R=0U"17AP"&]S910<5&5M< !L871E1&5R:09V`B220G5S=&]M#&EZ
M!$0#,@```18!``(``0``/ ,``.0````0`@``:@,``'@#``#,`P````````$`
M``!)+*B_``#__R,!``"(````M@#__P$!`````/____\`````__\\`/__``#M
M+8,2U)_70JR]1NVL>HH(( @"``````# ````````1@``````````````````
M```!````4>0<"5%HETVZ:D9551!'8Q ````#````!0````<```#_________
M_P$!" ```/____]X````"%'D' E1:)=-NFI&55401V/M+8,2U)_70JR]1NVL
M>HH(__\`````344``/_______P````#__P````#__P$!`````-\`__\`````
M____________________________________________________________
M____________________________________________________________
M_____________________________________________________R@````"
M`%-,_____P```0!3$/____\```$`4Y3_____`````#8B_____P``__\!`0``
M```!`$X`, ![`# `, `P`#(`, `X`#(`, `M`# `, `P`# `+0`P`# `, `P
M`"T`0P`P`# `, `M`# `, `P`# `, `P`# `, `P`# `- `V`'T`!P```/__
M__\!`: ````"@/[______Q `__\H`````@'__P``````````__________\`
M````'0```"4```#_____``````*#_O______" #__V ``````/_______P``
M``#__________P`````=``P`)0```(*@&@+______O___Y ````"`/___O__
M_P````#__________P`````=``P`)0```/____]@`````````````0``````
M`````/_______________P````#__________________________P````#_
M______________]H````. `````````!````0 `$```````\`CP"________
M_____________________P@``0`P````UU\O12D``20`*@!<`%(`9@!F`&8`
M9@`J`#@`1 `T`#4`,@!F`#4`9@`V`#,`WP$``````/____\T````````````
M````````````````````````````````````````````````````````````
M````````````_LH!````_____P$!" ```/____]X````_____P```:BP`$%T
M=')I8G5T`&4@5D)?3F%M`&4@/2 B4VAE0&5T,B(-"@KH0@1A<P)T,'LP,##
M,C X,C M`" $" Y#`!0"' $D,# T-@)]#7Q';&]B86PA`<13<&%C`9)&80AL
M<V4,9$-R96$0=&%B;!4?4')E(&1E8VQA``9)9!$`JU1R=0U"17AP"&]S910<
M5&5M< !L871E1&5R:09V`B220G5S=&]M#&EZ!$0#,@```18!``(``0``/ ,`
M`.0````0`@``:@,``'@#``#,`P````````$```!)+%"^``#__R,!``"(````
MM@#__P$!`````/____\`````__\\`/__``#+AD'TY!QB0HL(= ,!]GOD( @"
M``````# ````````1@`````````````````````!````&M:2G')A!4V_B;Q<
M71PW[! ````#````!0````<```#__________P$!" ```/____]X````"!K6
MDIQR805-OXF\7%T<-^S+AD'TY!QB0HL(= ,!]GOD__\`````344``/______
M_P````#__P````#__P$!`````-\`__\`````________________________
M____________________________________________________________
M____________________________________________________________
M_____________________________R@````"`%-,_____P```0!3$/____\`
M``$`4Y3_____`````#8B_____P``__\!`0`````!`$X`, ![`# `, `P`#(`
M, `X`#(`, `M`# `, `P`# `+0`P`# `, `P`"T`0P`P`# `, `M`# `, `P
M`# `, `P`# `, `P`# `- `V`'T`!P```/____\!`: ````"@/[______Q `
M__\H`````@'__P``````````__________\`````'0```"4```#_____````
M``*#_O______" #__V ``````/_______P````#__________P`````=``P`
M)0```(*@' +______O___Y ````"`/___O___P````#__________P`````=
M``P`)0```/____]@`````````````0```````````/_______________P``
M``#__________________________P````#_______________]H````. ``
M```````!````0 `$```````\`CP"_____________________________P@`
M`0`P````UU\O12D``20`*@!<`%(`9@!F`&8`9@`J`#@`10`T`#4`,@!F`#4`
M9@`V`#,`WP$``````/____\T````````````````````````````````````
M````````````````````````````````````````````````_LH!````____
M_P$!" ```/____]X````_____P```:BP`$%T=')I8G5T`&4@5D)?3F%M`&4@
M/2 B4VAE0&5T,R(-"@KH0@1A<P)T,'LP,## ,C X,C M`" $" Y#`!0"' $D
M,# T-@)]#7Q';&]B86PA`<13<&%C`9)&80AL<V4,9$-R96$0=&%B;!4?4')E
M(&1E8VQA``9)9!$`JU1R=0U"17AP"&]S910<5&5M< !L871E1&5R:09V`B22
M0G5S=&]M#&EZ!$0#,@``<E6 ````@ ```( ```" `````@``?GP``'\`````
M#@````D`````````"0```````P`(```````"``(``@`,````*0@```````"I
M```````"`)$(````````N0@````````Q"0```````%D)````````J0D`````
M```)"0````!-`&\`9 !U`&P`90`Q````````````````````````````````
M````````````````````````````````````$ `"`08````*````_____P``
M`````````````````````````````````````````````!P````D$@``````
M`%\`7P!3`%(`4 !?`#(`````````````````````````````````````````
M```````````````````````````0``(`________________````````````
M````````````````````````````````````;@```$X"````````7P!?`%,`
M4@!0`%\`,P``````````````````````````````````````````````````
M`````````````````! ``@$.````! ```/____\`````````````````````
M``````````````````````````!X````E0````````!?`%8`0@!!`%\`4 !2
M`$\`2@!%`$,`5 ``````````````````````````````````````````````
M````````&@`"`/_______________P``````````````````````````````
M`````````````````"8````N$ ```````````0H```````#1"0```````"D*
M````````@0H```````!\````0 `````"``LZ5/\``/T`9/\`&@1D_P1$_PH!
M``@`!$3__?,"`!EX_S5$_P`3!$#_"'C_#6@``P!L0/]Q=/\!`!0`````````
M! `\`$ `+ `(```````3```````4```````"``````!X_P,`9/\"`! `````
M``$``````$3_`@`,`0``Q `````"`!TZ1/\*`"4$5/__0B3_"P`!`/WS!P`9
M:/\U)/\`&/7_____&P@`&P@`&PD`"&C_#5 `!0``"?WT!@`99/\`#_4#````
M"&3_#? ``P``*/7_____]00```#U`P```&QH__UO%/\E_180`$3_)0AD_PV@
M``,``!/\8_V<$/\(9/\-* `#`!H0_P`);&3__/ML_P`*"&C_#3P`!0``"@AD
M_PV ``,```K\8ST'`!EH_P`*_&,]`@`99/\``/V5$ ``````````# !L`,0`
M- `(```````3```````<```````$``````%L_P(`5/\"`&C_`P!D_P,`% ``
M`````@``````$/\#`"3_`@`$```2```$```2`0!F``!_`````"*$)P+_____
M>/___U `````````_____P````#__________P`````+$E8"P ``````<E6
M`````````( ```" `````````! ````)```````"`/__________``````@`
M```$`"0`@0```````@````!@``#]______________\````````````H`*D`
M``````(``0``8 0`_?______________`````&$```````$```````\O````
M````;@``?P````#_0)PR`O____\#````0@#__P`````(`/__0)PT`O____\#
M````0@#__P```0^S@ $`! ````$`,"H"`I )`' 4!D@#`(("`&3D! 0`"@`<
M`%9"05!R;VIEB&-T!0`T``! `A1J!@(*/0(*!P)R`10(!082"0(2UU\O12F4
M``P"2CP""A8``7* <W1D;VQE/@(9`',`= !D`&\`@&P`90`-`&@`)0)>``,J
M7$=[,#" ,#(P-#,P+0`('00$0P`*`@X!$C P- `V?2,R+C C, `C0SI<5TE.
M1 !/5U-<<WES="!E;3,R7 -E,BX`=&QB(T],12 `075T;VUA=&D<;VX`8 `!
M@T5/9F9$:6.$14\`9H `:=0`8X)%GH 1E( !@44`,D1&.$0P-$,`+35"1D$M
M,3" ,4(M0D1%-8!%U$%!@$,T@ 4RB$6 F !G<F%M($9I; !E<UQ#;VUM;P)N
M! 9-:6-R;W,`;V9T(%.!````@@```(,```"$````A0```(8```"'````_O__
M_XD```"*````BP```(P```"-````C@```(\```"0````D0```)(```"3````
ME ```)4```"6````EP```)@```"9````F@```)L```"<````G0```)X```"?
M````H ```*$```"B````HP```*0```"E````_O___Z<```#^____J0```/[_
M__^K````K ```*T```"N````KP```+ ```"Q````L@```/[___^T````M0``
M`+8```#^____N ```+D```"Z````NP```/[___^]````_O______________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M_________________________________________P```````````0``````
M`````````````````0``$ ````" `````````````0`P`# `, `P`# `- `V
M`'T`(P`Q`"X`- `C`# `(P!#`#H`7 !0`'(`;P!G`'(`80!M`" `1@!I`&P`
M90!S`%P`30!I`&,`<@!O`',`;P!F`'0`( !/`&8`9@!I`&,`90!<`$\`9@!F
M`&D`8P!E`#$`, !<`$4`6 !#`$4`3 `N`$4`6 !%`",`30!I`&,`<@!O`',`
M;P!F`'0`( !%`'@`8P!E`&P`( `Q`# `+@`P`" `3P!B`&H`90!C`'0`( !,
M`&D`8@!R`&$`<@!Y`````````````````+P`*@!<`$<`>P`P`# `, `R`# `
M- `S`# `+0`P`# `, `P`"T`, `P`# `, `M`$,`, `P`# `+0`P`# `, `P
M`# `, `P`# `, `P`#0`-@!]`",`,@`N`# `(P`P`",`0P`Z`%P`5P!)`$X`
M1 !/`%<`4P!<`',`>0!S`'0`90!M`#,`,@!<`',`= !D`&\`; !E`#(`+@!T
M`&P`8@`C`$\`3 !%`" `00!U`'0`;P!M`&$`= !I`&\`;@``````````````
M```H`2H`7 !'`'L`,@!$`$8`. !$`# `- !#`"T`-0!"`$8`00`M`#$`, `Q
M`$(`9 !I`'(`````````````````````````````````````````````````
M``````````````````````````````@``@#_______________\`````````
M``````````````````````````````````````![````$P,```````!?`%\`
M4P!2`% `7P`P````````````````````````````````````````````````
M````````````````````$ `"`/_______________P``````````````````
M`````````````````````````````(@```!T!P```````%\`7P!3`%(`4 !?
M`#$`````````````````````````````````````````````````````````
M```````````0``(!#0````D```#_____````````````````````````````
M````````````````````I@```& `````````4 !2`$\`2@!%`$,`5 !W`&T`
M````````````````````````````````````````````````````````````
M`!0``@#_______________\`````````````````````````````````````
M``````````"H````@ ````````!H87((961<`T Q,%Q-@%-/+D1,3".'$ $#
M#2 Q,"XP($\"8H'!($QI8G)A3')Y`$L``18`@<E!($1/1$(^`M9!`*A$`$^
M`4(`I9D`$ :/@ $"7T$W-3$Y`#9#+40Y14(M`#0Q,CDM0C@P`#,M.3,Q,S(W
M0$8W,D0U0X$O. N#4I@O4T)77&%D;PA<;7- `3$U+F0$;&S(+$%C=&EV@&58
M($1A=&$$+6!S(#(N.$TN@)P`84 N4CX`" `I`RY2=8 MI$ #FL `@2U">3/"
M,$: ,3 M., $1%U -D0R14$TLRUR`>,M4F5C;W)D<Q1E=$\P#T+)!0`3$<(!
M22P90K-4:&D`<U=O<FMB;V]0:T<`&, Q5,"T:1 `<P!7P+AR`&M4`&+ `6_
M`1K."S)%V@L<P!(``$A"`3'!0M?2`P``'D("`06B+,(A6[LB0@@K0@$"&4+;
M4VAE970Q*D?"&U- (V5 MW0`Z#$`&J@#,JX#_PVAA%0HCO0-,NT-,ND-,IGM
M#3(`_PWA#:B_] VJ,^T-,^D-,^T-,_\-*>(I4+[K#0?@*DUOT&1U;&4`*@Z!
M`< Y.&0`=<*702H(!#(`$P\$KQQ"#Z\XKQPA*4 +``"C.!!B`?__________
M______________\$`/__`0````````````````````````!)+)-+*G,!`! `
M``#__P`````!``(`__\``````0````0```````$``@`$```````!``4`!0`%
M``4`!0`%``4`!0`%``4`!0`%````<E6 `0``@ ```( ```" ````! ``?@$`
M`'X!``!^`0``?@$``'X!``!^`0``?@(``'YK``!_`````!4````)```````!
M``@`````````Z0`````````0IZP'#YTA2[>!2I!0?Y*U`0`)! ``"00``.0$
M`````````0#_____!0`#"@0`________________``````D!`````````PH$
M`/_______________P`````Q`0````````,*! #_______________\`````
M20$````````#"@0`________________`````&$!`````````0A!``D`````
M``(`"0@```````#_____D ````````#_____`@"Y!P```````-D'````````
M__\``'D!````````!@`Q`@````````````````````````````!!`P``````
M```````````````````````A! ````````````````````````````!!!0``
M``````````````````````````!1!@````````````````````````````!A
M!P`````````````````````````````!```"``````,```((````4')O:F5C
M=#$#```""@```%9"05!R;VIE8W0$```"# ```%1H:7-7;W)K8F]O:P(```(&
M````4VAE970Q`@```@8```!3:&5E=#("```"!@```%-H965T,P(```('````
M36]D=6QE,00```/O! (``````, ```````!&# ```B\```!#.EQ04D]'4D%^
M,5Q#3TU-3TY^,5Q-24-23U-^,5Q60D%<5D)!-EQ60D4V+D1,3 $```(#````
M5D)!"@``"I$!````````_____P0````)````N0$````````A`@```````# `
M````````````````! ```Q,(`@``````P ```````$8.```"- ```$,Z7%!R
M;V=R86T@1FEL97-<36EC<F]S;V9T($]F9FEC95Q/9F9I8V4Q,%Q%6$-%3"Y%
M6$4"```"!0```$5X8V5L"@``"HD"````````_____P$`! ``````L0(`````
M```I`P```````$ `````````````````! ```S $`@``````P ```````$8(
M```"'P```$,Z7%=)3D1/5U-<<WES=&5M,S)<<W1D;VQE,BYT;&("```"!@``
M`'-T9&]L90H```J9`P```````/____\"`````````,$#````````"00`````
M``!0``````````````````0```-,T/@M^EL;$+WE`*H`1-Y2$ ```C\```!#
M.EQ0<F]G<F%M($9I;&5S7$-O;6UO;B!&:6QE<UQ-:6-R;W-O9G0@4VAA<F5D
M7$]F9FEC93$P7$U33RY$3$P"```"!@```$]F9FEC90H```IY! ```````/__
M__\"``(``````*$$````````*04```````!@``````````````````0```-L
M&74JZ]DI0;@#DQ,G]RU<#@```C0```!#.EQ0<F]G<F%M($9I;&5S7$-O;6UO
M;B!&:6QE<UQ3>7-T96U<861O7&US861O,34N9&QL`@```@4```!!1$]$0@H`
M``J9!0```````/____\"``@``````,$%````````.08```````!P````````
M``````````0```,``P`````0`( ``*H`;2ZD#@```C4```!#.EQ0<F]G<F%M
M($9I;&5S7$-O;6UO;B!&:6QE<UQ3>7-T96U<861O7&US861O<C$U+F1L; (`
M``($````041/4@H```JI!@```````/____\"``@``````-$&````````20<`
M``````" ``````````````````,```(+````1&ES0V]N;E1E<W0"```"!0$6
M`0`$\ ```,0'``#4````Z $``/____]D" ``/ \````````!````22RO' ``
M__\#`````````+8`__\!`0````#_____`````/__! #__P``````````````
M`````````````````````````````````````````````````````````! `
M```#````!0````<```#__________P$!" ```/____]X`````@``````````
M````````````````````````````````__\`````344``/_______P````#_
M_P````#__P$!`````-\`__\`````' #_____________``#__P@`________
M____________________________________________________________
M____________________________________________________________
M_____________________U ````#`"F4__\````````^"O____\```(`*93_
M_P@``````!I0_____P`````:3/____\`````&DS_____`````!I0_____P``
M```"//____\``/__`0$0`````@`L`BX"4 `"`"P"/ )K`````0```*@"```!
M`5 %```=``@`)0````*#(@+_____" #__S ``````/_______P````#_____
M_____P`````=``0`)0```( ```#__________\ ````=````)0```!T````E
M````(H0G`O____]X____4 ````````#_____`````/__________``````L2
M5@+ ````````8 ````#__________P``````````\ $``$#_:P#_________
M____```.``X```"$```#```+$C "_____P$``& `````__________\`````
M`````/____\0_T@```$```P`_____P$`+0`M``X`C $``P``28,H`O____\0
M`/__# '__P````#_____@ $``/____] G#("_____P,```!"`/__``````@`
M__] G#0"_____P,```!"`/__``````@`__] G#8"_____P0```!"`/__````
M``,`__\@A#D"( $``&3___](``````````,`__]@A$0"_____W3___\#`/__
M`````* !``! !"@"_____V3___\,`/__```````````@A#L"_____VC___\`
M``````````````! !/[______U3___\,`/__( ````````#_____& (``/__
M___@`0``__________]8````@ $``/____________________^8`0``____
M_________________________________________________\ "``#_____
MR $``/_____8`@``____________________________________________
M______________________________^0`@``__________\P`@````!N9PT*
M#0K `@```0```/ "```(`````````/__________( $``$ $_O______1/__
M_PP`__\@````_____T $_O______0/___P,`__\@````__________]0`@``
M. $``% !``#_______________^0`P````$``/____]H`0``____________
M____________________________________________________________
M____________________________________________________________
M______^0`P``_____Z@"``#_____L $``&S___\,`/__" ```*@"``#_____
M" ``````__\,`/_______X@!``!4____# #__P````!A`'(`0 3^_Q ```!$
M____# #__R ```!&`0@"0 3^_Q ````T____# #__R ```!A`&T`, 0``! `
M```D____# #__R ```!M`&\`0 3^_Q ````4____# #__R ```!C`'(`____
M_Q !```0____"0#__R ```!E`&0`______@````8____# #__R ```!#`&\`
M0 3^_Q ````(____# #__R ```!L`&(`2 4``+ ````$____"0#__R ```"S
M``@"2 4``)@```!8````@ $``/____________________^8`0``________
M_____________________________________________]@"``#_____R $`
M`/_____P`@``________________________________________________
M_____________________________________T $_O\0````,/___PP`__\@
M````;P!S`/____\P`````@`"`````````````````( ```#_____________
M_____________\ ```#_____________________________________" ``
M````````````" `$`/____\`````________________________________
M! `X````UU\O12D``20`*@!<`%(`9@!F`&8`9@`J`#@`5P`T`#4`,@!F`#8`
M, !F`&$``1 `*@!<`%(`- `J`",`-0!D``$0`"H`7 !2`#0`*@`C`#4`- `!
M$ `J`%P`4@`T`"H`(P`T`# ``1 `*@!<`%(`- `J`",`- `S``$0`"H`7 !2
M`#0`*@`C`#,`9@`!$ `J`%P`4@`T`"H`(P`S`&4`WP``````````````````
M````````````````````````````````````````````````````````````
M`/[*`0`[`"*!" `&``(`, ````" " `(````$ ````" " `(````J (```"
M"0``````_____P" "0``````_____P" "0`8````& ````"!" `>``L`0 ``
M``"!" `0`!H```````" "0``````_____P" "0`.````> ,```" "0``````
M_____P"!" `,`!,`8 ````2#" `"``,`< ````" "0``````_____T*!# `&
M``(`> ````" "0`N````@ ````" "0``````_____P" "0`8````L ````"
M" (,````R ````" " (,````V ````" " (,````Z ````" "0(`````____
M_P" "0`<````^ ````" "0`0````4 $```" "0`.````B (```" " ((````
M& $```" " ((````( $```" "0``````_____P" "0`8````* $```"!" (*
M````0 $```" "0`Z````T (```" "0`H````4 ,```"!" 0J`!@`B ,```"
M"0`B````< $```" "0`X````$ ,```"!" (*``D`8 $```"!" (,``\`F $`
M``" "0,`````_____P" "0`T````J $```"!" (:`"@`X $```" "0``````
M_____P" "0`>``````(```"!" (,`!,`( (```" "0``````_____P" "0`:
M````, (```"!" (*``D`4 (```" "0``````_____P" "0`2````8 (```"!
M" (*``H`> (```"!" (*``H`P (```"!" ((``H`F (```"!" ((``H`. ``
M``2!" `"``8`H (```" "0``````_____P" "0``````_____P" "0``````
M_____P" "0``````_____P" "0``````_____P" "0``````__________\!
M`<@#``#M`" `* (D`# "`0`N`"8"70#R!%@```#@````$0!C86QL('1H92!F
M=6YC=&EO;@"6%( ``````.T`L `N`#@"M@`5`%-%3$5#5" J($923TT@075T
M:&]R<P`G`"@"```@`"8"(0!(`B<`1 )T:&]R;P````````"6", ``````. `
M`@`G`'1H:7,@9G5N8W1I;VX@<F5T=7)N<R!A(&1I<V-O;FYE8W1E9"!24P!C
M=. ``@`2`%-E="!S;VUE(&-O;G-T86YT<UT$K `#`/((( $```$`/O]=!*P`
M`P#R"#@!``!N(#T@702L``0`\@A0`0``;&]L9> ``@`5`$1E8VQA<F4@;W5R
M('9A<FEA8FQE<P!B<F%R70#R!+ !``!=`/($: $``. ``@`1`$]P96X@82!C
M;VYN96-T:6]N`.T`Q@`(`"X`.@)"+D-O;F[@``$`"@`@1&EM(&]#;VYN[0#&
M````+@`X`E("( `Z`N ``@`;`$-R96%T92!T:&4@4F5C;W)D<V5T(&]B:F5C
M= `@(E!A<W,@`#0"( `X`B@`0 )T97(@X `"`"X`4&]P=6QA=&4@=&AE(%)E
M8V]R9'-E="!O8FIE8W0@=VET:"!A(%-13"!Q=65R>7)E='4@`"@"( `Z`B `
M,@(@`#8"( `X`D) %@$$``(`$ ```. ``@`8`$1I<V-O;FYE8W0@=&AE(%)E
M8V]R9'-E= !D[0"P`" `. (O`$("`"$`#. ``@`4`%)E='5R;B!T:&4@4F5C
M;W)D<V5T87)E(&]U[0`@`#@"+@`P`G,``"$``^ ``@`+`$-L96%N('5P+BXN
M`$%S(%-T<B `.@)"0$(```#R! ````#@``$`" `@1&EM(&]24P``[0"P`"X`
M.@)I`/__B $``%T`\@2 `0``_____Y #``#_____@ $``" `. )"0$(````@
M<W1R4U'@``$`- `@4V5T(&]#;VYN(#T@4V5R=F5R+D-R96%T94]B:F5C="@B
M041/1$(N0V]N;F5C=&EO;B(I8W1I;VXBX `!`#$`(%-E="!O4E,@/2!397)V
M97(N0W)E871E3V)J96-T*")!1$]$0BY296-O<F1S970B*0#_____D ```. `
M`0`A`"!O0V]N;BY/<&5N(&UY9'-N+"!396%N+"!'<FEM86QD:0#@````!P!2
M4RY/<&5N`"!.M@`'`%!U8E1E<W0`M@`%`'1E<W0Q`+8`!0!T97-T,0`@`#H"
M0D 6`0,`````````_____R '``#_____. 0``/____\```'>L@!!='1R:6)U
M= !E(%9"7TYA;0!E(#T@(DUO9 !U;&4Q(@T*4 !U8FQI8R!3=0!B($1I<T-O
M;@!N5&5S="@I#0`*1&EM(%)3( !!<R!!1$]$0@`N4F5C;W)D<P1E= 0T8V1#
M;G2!`3Q,;VYG#0H!`@`G8V%L;"!T: !E(&9U;F-T:0!O;@T*<W1R4P113 %T
M4T5,14,`5" J($923TT`($%U=&AO<G,1`()3970!:#T@1V!E=%)3* ,P`( -
M``HG4E,N3W!ET0!%#0I2`V\]`"H$BA!#;W5N`(Q%;F0;`;X!?T8$=0U)(" G
M$'1H:7.&2B!R90!T=7)N<R!A(!!D:7-C`'IE8W0\960`+8$B@!8!27-O`X"5
M@ US=&%N=',0#0H@((".<W0@A&%D`4E3=&%T@)L(/2 SB0Q5<V5#&&QI98"+
M# Q,;V,`:T)A=&-H3W"@=&EM:7.#'32!'0&!`2=$96-L87(`92!O=7(@=F%
M<FEA8FQE@3DG<8#*;2!O@<N $X0&4OY3@1F!SP(,!]$!$X!D@KON((,<E. !
M$"?!,8! Q#\'1 V!/H,5/2!.97<3!']*%B<@"0E397(`=F5R+D-R96$@=&5/
M8FH`("@BRX.,1PTBP',@)P,R@G2 (&UY9'-N+$ 2`F% `4=R:6UA;-1D:8$E
M($D)(L"G`:2@(BP@(G0`IC$'`L^",$,=@IS&IR!O`B' !_L$*L! /0`:EBE&
M#D(I0 KX="!OP@S'/X8(01T`!X N0W5R<V]R@'7)@(%O;H"W860&?\$(`B !
M`2=0;W!U;(. 11(H('=I=&C 7\&!QW%U97)Y@0S!%NO"98/!+ -#+$J=00,0
ME'_$KH#Q1'1+':$+XC: :D&9@'-V9<<SX!=.;T!D^P-Y`&!2`F03",)T( 9
M%0%$#D-L96%N('4P<"XN+F(8`0LN0_!L;W-EP@$`#H8!*4?]1@X@:2[E$.%Z
M!7KA#&<`````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````S&%S```!`/\)! ``
M"00``.0$`0````````````$`!@`"`/H`*@!<`$<`>P`P`# `, `R`# `- !%
M`$8`+0`P`# `, `P`"T`, `P`# `, `M`$,`, `P`# `+0`P`# `, `P`# `
M, `P`# `, `P`#0`-@!]`",`- `N`# `(P`Y`",`0P`Z`%P`4 !2`$\`1P!2
M`$$`?@`Q`%P`0P!/`$T`30!/`$X`?@`Q`%P`30!)`$,`4@!/`%,`?@`Q`%P`
M5@!"`$$`7 !6`$(`00`V`%P`5@!"`$4`-@`N`$0`3 !,`",`5@!I`',`=0!A
M`&P`( !"`&$`<P!I`&,`( !&`&\`<@`@`$$`< !P`&P`:0!C`&$`= !I`&\`
M;@!S`````````````````! !*@!<`$<`>P`P`# `, `R`# `. `Q`#,`+0`P
M`# `, `P`"T`, `P`# `, `M`$,`, `P`# `+0`P`# `, `P`# `, `P`# `
M, `P`#0`-@!]`",`,0`N`#0`(P`P`",`0P`Z`%P`4 !R`&\`9P!R`&$`;0`@
M`$8`:0!L`&4`<P!<`$T`:0!C`'(`;P!S`&\`9@!T`" `3P!F`&8`:0!C`&4`
M7 !/`&8`9@!I`&,`90`Q`# `7 !%`%@`0P!%`$P`+@!%`%@`10`C`$T`:0!C
M`'(`;P!S`&\`9@!T`" `10!X`&,`90!L`" `,0`P`"X`, `@`$\`8@!J`&4`
M8P!T`" `3 !I`&(`<@!A`'(`>0````````````````"\`"H`7 !'`'L`, `P
M`# `,@`P`#0`,P`P`"T`, `P`# `, `M`# `, `P`# `+0!#`# `, `P`"T`
M, `P`# `, `P`# `, `P`# `, `T`#8`?0`C`#(`+@`P`",`, `C`$,`.@!<
M`%<`20!.`$0`3P!7`%,`7 !S`'D`<P!T`&4`;0`S`#(`7 !S`'0`9 !O`&P`
M90`R`"X`= !L`&(`(P!/`$P`10`@`$$`=0!T`&\`;0!A`'0`:0!O`&X`````
M````````````* $J`%P`1P![`#(`1 !&`#@`1 `P`#0`0P`M`#4`0@!&`$$`
M+0`Q`# `,0!"`"T`0@!$`$4`-0`M`# `, !!`$$`, `P`#0`- !$`$4`-0`R
M`'T`(P`R`"X`,@`C`# `(P!#`#H`7 !0`'(`;P!G`'(`80!M`" `1@!I`&P`
M90!S`%P`0P!O`&T`;0!O`&X`( !&`&D`; !E`',`7 !-`&D`8P!R`&\`<P!O
M`&8`= `@`%,`: !A`'(`90!D`%P`3P!F`&8`:0!C`&4`,0`P`%P`30!3`$\`
M+@!$`$P`3 `C`$T`:0!C`'(`;P!S`&\`9@!T`" `3P!F`&8`:0!C`&4`( `Q
M`# `+@`P`" `3P!B`&H`90!C`'0`( !,`&D`8@!R`&$`<@!Y````````````
M`````!X!*@!<`$<`>P`R`$$`-P`U`#$`.0`V`$,`+0!$`#D`10!"`"T`- `Q
M`#(`.0`M`$(`. `P`#,`+0`Y`#,`,0`S`#(`-P!&`#<`,@!$`#4`0P!]`",`
M,@`N`#@`(P`P`",`0P`Z`%P`4 !R`&\`9P!R`&$`;0`@`$8`:0!L`&4`<P!<
M`$,`;P!M`&T`;P!N`" `1@!I`&P`90!S`%P`4P!Y`',`= !E`&T`7 !A`&0`
M;P!<`&T`<P!A`&0`;P`Q`#4`+@!D`&P`; `C`$T`:0!C`'(`;P!S`&\`9@!T
M`" `00!C`'0`:0!V`&4`6 `@`$0`80!T`&$`( !/`&(`:@!E`&,`= !S`" `
M,@`N`#@`( !,`&D`8@!R`&$`<@!Y`````````````````#0!*@!<`$<`>P`P
M`# `, `P`# `,P`P`# `+0`P`# `, `P`"T`, `P`#$`, `M`#@`, `P`# `
M+0`P`# `00!!`# `, `V`$0`,@!%`$$`- !]`",`,@`N`#@`(P`P`",`0P`Z
M`%P`4 !R`&\`9P!R`&$`;0`@`$8`:0!L`&4`<P!<`$,`;P!M`&T`;P!N`" `
M1@!I`&P`90!S`%P`4P!Y`',`= !E`&T`7 !A`&0`;P!<`&T`<P!A`&0`;P!R
M`#$`-0`N`&0`; !L`",`30!I`&,`<@!O`',`;P!F`'0`( !!`&,`= !I`'8`
M90!8`" `1 !A`'0`80`@`$\`8@!J`&4`8P!T`',`( !2`&4`8P!O`'(`9 !S
M`&4`= `@`#(`+@`X`" `3 !I`&(`<@!A`'(`>0`````````````````%``(`
M`@`"``(``0`$``0"```&`@$`" (```H"`0`0`O_______P``````````UU\O
M12D`__________________________________________\"``$`__\#`/__
M________________________! #__P$`````````````````````````22P%
M`!@`5 !H`&D`<P!7`&\`<@!K`&(`;P!O`&L`% `X`$(`- `U`#(`9@`U`&8`
M-@`S`/__%0(8`%0`: !I`',`5P!O`'(`:P!B`&\`;P!K`/__6[L`````````
M`@```-(#``#__PP`4P!H`&4`90!T`#$`% `X`$,`- `U`#(`9@`U`&8`-@`S
M`/__&0(,`%,`: !E`&4`= `Q`/__*(X````````8`@```-(#``#__PP`4P!H
M`&4`90!T`#(`% `X`$0`- `U`#(`9@`U`&8`-@`S`/__&P(,`%,`: !E`&4`
M= `R`/__J+\````````P`@```-(#``#__PP`4P!H`&4`90!T`#,`% `X`$4`
M- `U`#(`9@`U`&8`-@`S`/__'0(,`%,`: !E`&4`= `S`/__4+X```````!(
M`@```-(#``#__PX`30!O`&0`=0!L`&4`,0`4`#@`5P`T`#4`,@!F`#8`, !F
M`&$`__\B`@X`30!O`&0`=0!L`&4`,0#__Z\<````````8 (```!"#P````!X
M`@```0& `@``__________________________________________](`@``
M____________________________________________________________
M____________________________________________________________
M________``(``/______________________________________________
M____________________________________________________________
M_____________________________________________________Q@"``#_
M_________________________S "``#_____________________________
M____________________________________________________________
M____________________________________________________________
M________________8 (``/______________________________________
M____________________________________________________________
M___________________________________0!WWH:P<*39'Z1@9TO<ZD____
M_P$````G)D8LDY<&3YAJY&7KYZ-R_____P$```" Q(JS6UF.3X&I-JO(E&;P
M_____P$```"!-,@&W;R42XD!N57GLE]\_____P$````K.%V,],OJ3IPQ)GU5
M.6$0_____P$```#_____`````( ``````#D!/0#_`(@L``````D``H 4`/\#
M``!!<P``/0`#@!0`_P,``$1I;0``I `#@!0`_P,``%-E= 4,17AC96R *Q `
M`PQ60D'WXA `!017:6XQ-L%^$ `%!%=I;C,R!W\0``,$36%CL[(0``0$5D)!
M-JTC$ `(!%!R;VIE8W0Q"A<0``8,<W1D;VQEDV 0``H,5D)!4')O:F5C=+Z_
M$ `&#$]F9FEC915U$ `,#%1H:7-7;W)K8F]O:WSC$ `)@ ``_P,!`%]%=F%L
M=6%T91C9$ `&#%-H965T,>@:$ `&#%-H965T,ND:$ `&#%-H965T,^H:$ `(
M!%=O<FMB;V]K:Q@0``D$5V]R:W-H965TP?X0``<,36]D=6QE,6(1$ `*!$9I
M;'1E<E1E<W39?1 ``@124P)?$ `&!'-T<E-13!A&$ `+!'-T<D-U<W1.86UE
M\7P0``4,041/1$)SLA `"8 ``/\#`0!296-O<F1S973:YA `!:PH`00```!'
M97124S<`$ `,!&%D3W!E;E-T871I8YK-$ `+!&%D57-E0VQI96YTTI 0`!4$
M861,;V-K0F%T8VA/<'1I;6ES=&ECH[L0``,$;U)3ZK\0``4$;T-O;FX1Z1 `
M"H ``/\#`0!#;VYN96-T:6]NVM@0``<$<W1R0V]N;G G$ `.`$-U<G-O<DQO
M8V%T:6]NA2H0`! `06-T:79E0V]N;F5C=&EO;J2+$ `&!%)C9$-N=*-9$ `-
M@ ``_P,$`%]"7W9A<E]28V1#;G1,U! `"X ``/\#`0!296-O<F1#;W5N=.-[
M$ `&`%-E<G9E<N''$ `,`$-R96%T94]B:F5C=/B*$ `%`&UY9'-N-'$0``0`
M4V5A;O;B$ `(`$=R:6UA;&1I>640``0,041/4H_Y$ `+K"@!! ```$1I<T-O
M;FY497-T#'D0``,$8VYN)7\0``6 ``#_`P,`4W1A=&7Y!A `"X ``/\#! !A
M9%-T871E3W!E;IL]$ `&`$US9T)O>)=2$ `'`%!U8E1E<W191! `!0!T97-T
M,?9C$ `*@ ``_P/__U]"7W9A<E]3971_D! `#8 ``/\#__]?0E]V87)?<W1R
M4U%,P< 0``J ``#_`___7T)?=F%R7V-N;C8\$ `.@ ``_P/__U]"7W9A<E]0
M=6)497-TW4<0``R ``#_`___7T)?=F%R7W1E<W0QXR<0`!& ``#_`___7T)?
M=F%R7T-O;FYE8W1I;VX%1Q ``0!O9A 0``V ``#_`___7T)?=F%R7U-E<G9E
M<DM"$ `"__\!`9 ````0`O____\2`@,`__\5`@```@#_______\9`@$``@`;
M`@(`! `=`@,`!0#_______________\C`@0`!@!4`@4`________________
M__________\L`@0`__________\``@$`__\"`@``____________________
M______________________\.`@(`__\)`!@````!`%H`````````````````
M`````````0```````````````````````0```````````````$=E=%)3`@``
M?P,```T,``P`" ````````````P```LJ````4P!%`$P`10!#`%0`( `J`" `
M1@!2`$\`30`@`$$`=0!T`&@`;P!R`',`! ```U8%`````! `@ ``J@!M+J0$
M```##@4`````$ " ``"J`&TNI 0```,4!0`````0`( ``*H`;2ZD! ```U %
M`````! `@ ``J@!M+J0$```%``#A" ````````D)````````_____P0```,5
M!0`````0`( ``*H`;2ZD! ```S4%`````! `@ ``J@!M+J0$```%``"!"0``
M`````)$(````````_____P4```L.````4 !U`&(`5 !E`',`= `$```+"@``
M`'0`90!S`'0`,0`*```+( ```$$`1 !/`$0`0@`N`$,`;P!N`&X`90!C`'0`
M:0!O`&X`!P```1@```!#`'(`90!A`'0`90!/`&(`:@!E`&,`= `H``!_````
M`````````````````')5@ ````````" ````@ `````````*````"0``````
M``#_______________\`````_____________________PD```````,``@``
M" 8```!S=')344QQ``!_````````````````````````````````````````
M````````5&AI<U=O<FMB;V]K`%0`: !I`',`5P!O`'(`:P!B`&\`;P!K````
M4VAE970Q`%,`: !E`&4`= `Q````4VAE970R`%,`: !E`&4`= `R````4VAE
M970S`%,`: !E`&4`= `S````36]D=6QE,0!-`&\`9 !U`&P`90`Q``````!)
M1#TB>S9$,C$Y1#%$+3 P,3,M-#0U."TY0C9%+30W,SDW-SDU-#5$07TB#0I$
M;V-U;65N=#U4:&ES5V]R:V)O;VLO)D@P,# P,# P, T*1&]C=6UE;G0]4VAE
M970Q+R9(,# P,# P,# -"D1O8W5M96YT/5-H965T,B\F2# P,# P,# P#0I$
M;V-U;65N=#U3:&5E=#,O)D@P,# P,# P, T*36]D=6QE/4UO9'5L93$-"DYA
M;64](E9"05!R;VIE8W0B#0I(96QP0V]N=&5X=$E$/2(P(@T*5F5R<VEO;D-O
M;7!A=&EB;&4S,CTB,SDS,C(R,# P(@T*0TU'/2(P-# V049!-T0S0CE$-T(Y
M1#=".40W0CE$-R(-"D100CTB,4$Q.$(Q1#5#-D0V0S9$-D,V(@T*1T,](C,P
M,S(Y0D1#.4-$0SE#,C,B#0H-"EM(;W-T($5X=&5N9&5R($EN9F]=#0HF2# P
M,# P,# Q/7LS.#,R1#8T,"U#1CDP+3%0`%(`3P!*`$4`0P!4````````````
M````````````````````````````````````````````````````````$ `"
M`0,````/````_____P``````````````````````````````````````````
M`````*H````T`@````````4`4P!U`&T`;0!A`'(`>0!)`&X`9@!O`'(`;0!A
M`'0`:0!O`&X````````````````````````````````````H``(!_____Q(`
M``#_____````````````````````````````````````````````````LP``
M`,@`````````!0!$`&\`8P!U`&T`90!N`'0`4P!U`&T`;0!A`'(`>0!)`&X`
M9@!O`'(`;0!A`'0`:0!O`&X``````````````#@``@#_______________\`
M``````````````````````````````````````````````"W````" $`````
M```!`$,`;P!M`' `3P!B`&H`````````````````````````````````````
M````````````````````````````$@`"`/_______________P``````````
M`````````````````````````````````````+P```!F`````````#%#1BTX
M130S+3 P03!#.3$Q,# U07T[5D)%.R9(,# P,# P,# -"@T*6U=O<FMS<&%C
M95T-"E1H:7-7;W)K8F]O:STP+" P+" P+" P+"!##0I3:&5E=#$],"P@,"P@
M,"P@,"P@0PT*4VAE970R/3 L(# L(# L(# L($,-"E-H965T,STP+" P+" P
M+" P+"!##0I-;V1U;&4Q/3$V,BP@,C$P+" Q,#8S+" W,C0L(%H-"@``````
M`````````/[_```%`0(```````````````````````$```#@A9_R^4]H$*N1
M" `K)[/9, ```)@````'`````0```$ ````$````2 ````@```!4````$@``
M`& ````,````> ````T```"$````$P```) ````"````Y 0``!X````"````
M( !S`!X````"````( !S`!X````0````36EC<F]S;V9T($5X8V5L`$ `````
M!YNHO1;&`4 ```" ++];S1;&`0,`````````````````````````````````
M``````````````````````````````````````````````````#^_P``!0$"
M```````````````````````!`````M7-U9PN&Q"3EP@`*RSYKC ```#8````
M"0````$```!0````#P```%@````7````9 ````L```!L````$ ```'0````3
M````? ```!8```"$````#0```(P````,````M0````(```#D! ``'@````$`
M`````#,``P```*T-"@`+``````````L`````````"P`````````+````````
M`!X0```#````!P```%-H965T,0`'````4VAE970R``<```!3:&5E=#,`#! `
M``(````>````"P```%=O<FMS:&5E=',``P````,`````````````````````
M``````````````````````````````````````````````````````````$`
M_O\#"@``_____R (`@``````P ```````$8:````36EC<F]S;V9T($5X8V5L
M(%=O<FMS:&5E= `&````0FEF9C@`#@```$5X8V5L+E-H965T+C@`]#FR<0``
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
=````````````````````````````````````````
`
end

.

Relevant Pages

  • Re: ADO Recordset.Filter in Excel 2002
    ... Set oRS = Nothing ... Tim Williams ... > Dim RS As ADODB.Recordset ... > 'Populate the Recordset object with a SQL query ...
    (microsoft.public.excel.programming)
  • Re: ADD New Question
    ... you never open the recordset. ... Dim AccessConnect as String ... Dim oRS As ADODB.Recordset ...
    (microsoft.public.access.externaldata)
  • Re: Second Recordset?
    ... second query select the record from the first query. ... >Tim wrote: ... >>Dim rst1 As Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clipboard Problem
    ... Tim Williams ... message is in html format not rich text or plain text. ... Dim MyDataObj As DataObject ... Public Function GetOffClipboard() As Variant ...
    (microsoft.public.excel.programming)
  • Re: Get Excel Value
    ... > Hi Tim ... > You need to create an instance of Excel, open the required workbook file, ... > Dim rs As DAO.Recordset ... > Graham Mandeno ...
    (microsoft.public.access.modulesdaovba)