f



Changing, "FindFirst" to using the, "Seek" Method?

I ran a MS Access Analyzer program that suggested changing,
"rst.FindFirst strcriteria" to using the, "Seek" instead.  I
tried making the change. I get a Compile error that says, "Argument
is not optional". Does anyone have any ideas on how I should change
the FindFirst to using Seek the method?

0
2/7/2005 10:56:30 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
288 Views

Similar Articles

[PageSpeed] 58

"Seek" is limited to use on Tables in the opened Database. It cannot be used
on Linked Tables. And, in many, many cases, using a Query with Criteria to
limit the Records returned to just those that are needed is preferrable to
using either .Seek or .Find. Chances are high that would boost performance
even more.

..Seek and .Find are used to locate to a specific record, but not to navigate
sequentially through a recordset.

The .Find and .Move methods work with either local or Linked Tables, and
make it easy to navigate sequentially through a recordset.

Using criteria in a Query should be the first thing you investigate.

  Larry Linson
  Microsoft Access MVP

"jphelan" <jphelan2000@earthlink.net> wrote in message
news:1107816990.162000.202440@z14g2000cwz.googlegroups.com...
>
> I ran a MS Access Analyzer program that suggested changing,
> "rst.FindFirst strcriteria" to using the, "Seek" instead.  I
> tried making the change. I get a Compile error that says, "Argument
> is not optional". Does anyone have any ideas on how I should change
> the FindFirst to using Seek the method?
>


0
bouncer (4168)
2/7/2005 11:21:29 PM
Reply:

Similar Artilces:

about "++" and "--"
why this program snippet display "8,7,7,8,-7,-8" the program is: main() { int i=8; printf("%d\n%d\n%d\n%d\n%d\n%d\n",++i,--i,i++,i--,-i++,-i--); } > why this program snippet display "8,7,7,8,-7,-8" Ask your compiler-vendor because this result is IMHO implementation-defined. Check this out: http://www.parashift.com/c++-faq-lite/misc-technical-issues.html#faq-39.15 http://www.parashift.com/c++-faq-lite/misc-technical-issues.html#faq-39.16 Regards, Irina Marudina fxc123@gmail.com wrote: > why this program snippet display "8,7,7,8,-7,-8&q...

why "::", not "."
Why does the method of modules use a dot, and the constants a double colon? e.g. Math::PI and Math.cos -- Posted via http://www.ruby-forum.com/. On Oct 26, 2010, at 01:48 , Oleg Igor wrote: > Why does the method of modules use a dot, and the constants a double > colon? > e.g. > Math::PI and Math.cos For the same reason why inner-classes/modules use double colon, because = they're constants and that's how you look up via constant namespace. Math::PI and ActiveRecord::Base are the same type of lookup... it is = just that Base is a module and PI is a float....

"out" and "in out"
Hi i found the following explaination: In Ada, "in" parameters are similar to C++ const parameters. They are effectively read-only within the scope of the called subprogram. Ada "in out" parameters have a reliable initial value (that passed in from the calling subprogram) and may be modified within the scope of the called procedure. Ada "out" parameters have no reliable initial value, but are expected to be assigned a value within the called procedure. What does "have no reliable initial value" mean when considering the "out" parameter? By c...

Urgent need """""""""""INFORMATICA DEVELOPER"""""""""""""
Hello Partners, How are you ? Please find the requirements below. Title: Database/ETL Developer Duration: 6 months Location: NY Exp: 7+ Locals preferred Database/ETL requirements (Mandatory) Candidate must have worked with financial instruments, preferably Mutual Funds but, Equities are also ok. PL/SQL - packages, Stored procs, Functions, Aggregate functions, Pipelined Functions Informatica 8.6 - especially complex mappings, complex maplets, complex workflows, transformations Oracle 10g/11g Unix/Linux shell scripting Database/ETL requirements (Optional) Data warehousing experience Threading and job concepts in 10g/11g Cost based Optimizer concepts in 10g/11g Must : Experience with XML files and partitioning concepts in Oracle, Collections, Material Views Note : No phone calls please. : send Resumes to karthik@bhaninfo.com Thanks & Regards Karthik BhanInfo karthik@bhaninfo.com ...

how to change "/" to "\"
iam new to shell scripting and i have plz can anyone help in changing the pattrern "/" to "\" using the sed command. olympie@gmail.com wrote: > iam new to shell scripting and i have plz can anyone help in changing > the pattrern "/" to "\" using the sed command. sed 's/\//\\/g' will replace all '/' with '\' srp -- http://saju.net.in Saju Pillai <saju.pillai@gmail.com> wrote: >> iam new to shell scripting and i have plz can anyone help in changing >> the pattrern "/" to "\" using ...

"In" "Out" and "Trash"
I just bought a new computer and I re-installed Eudora Light on my new computer. But when I open Eudora, the "In", "Out" and "Trash" links are not on the left side of the screen the way they were on my old computer. How can I get these links back on the left side of the screen? Thank you. On 25 Mar 2007 09:49:22 -0700, "abx" <abfunex@yahoo.com> wrote: >I just bought a new computer and I re-installed Eudora Light on my new >computer. But when I open Eudora, the "In", "Out" and "Trash" links >are ...

When to use "." and when to use "!"
I'm still confused about this and I can't find anywhere that explains it properly. I have the MS book "Access 2003" in front of me and I'm reading Part 5 about VB and so on. It's telling me about how to refer to a specific database and has the example:- Dim dbMyDb As DAO.Database Set dbMyDb = DBEngine.Workspaces(0).Databases(0) but, but, but, but - what do those dots (periods, full stops, call them what you will) mean? (OK, it appears to be the same usage as C/C++/Java when referring to class/structure members, but I wish it would tell me that somewhere) Why are there dots used in referring to object members in this case but when referring to controls on forms (for example) one uses "!". Surely there must be somewhere that helps one understand this basic syntax. -- Chris Green Generally, a dot exposes properties and methods and a bang (!) exposes members of a collection. So forms!frmMyForm.Visible refers to the visible property of frmMyForm, which is a member of the forms collection. What makes this harder (or easier, depending on your perspective) to grasp, is that Access has gotten more and more forgiving about using the "wrong" notation. usenet@isbd.co.uk wrote in news:44316bba.0@entanet: > I'm still confused about this and I can't find anywhere that explains > it properly. > > I have the MS book "Access 2003" in front of me and I'm reading Part 5 > about VB and so on....

Urgent JAVA Requirement in """"""NEW YORK"""""""""
Hello Partners, How are you ? Please find the requirement below. Location : NY Duration : 8 mnths Rate :Open Job description: Java/J2EE Web Service Developer =B7 (4+ years of application development experience in Java/J2EE and Web service technologies. =B7 Experience with spring & Hibernate. =B7 Experience with J2EE Application Server (preferably Web logic). =B7 Preferable Aqua logic DSP Experience =B7 Preferable Sonic ESB Composite Service experience Experience working in UNIX environment. Good working knowledge of Oracle RDBMS and PL/SQL) Note : Please send your updated resume along with contact no to Karthik@bhaninfo.com. Thanks & Regards Karthik BhanInfo karthik@bhaninfo.com # 1572, 7 th Floor Suites, 1 Blue Hill Plaza Pearl River,NY-10965 www.bhaninfo.com ...

Question about "sprintf" "@" "do for"
Hello, this works: A1=3D1 A2=3D2 A3=3D3 i=3D1 vari=3Dsprintf("A%.f",i) print vari,"=3D",@vari i=3Di+1 vari=3Dsprintf("A%.f",i) print vari,"=3D",@vari i=3Di+1 vari=3Dsprintf("A%.f",i) print vari,"=3D",@vari do for [i=3D1:3]{ vari=3Dsprintf("A%.f",i) print vari } But I want to have "print vari,"=3D",@vari" in the loop. But it dosen't=20 work. Why can't I use "print vari,"=3D",@vari" in the loop? Is there a=20 solution for? J=C3=B6rg Jörg ...

puts "\\".gsub("\\", "\\\\")
Hello, I have a mini-ruby quiz. Guess what this line of code writes to the console, then try it for yourself: puts "\\".gsub("\\", "\\\\") Why is that so? Martin From: martinus [mailto:martin.ankerl@gmail.com]=20 # Hello, I have a mini-ruby quiz. Guess what this line of code writes to # the console, then try it for yourself: # puts "\\".gsub("\\", "\\\\") puts "\\".gsub("\\", "\\\\") \ #=3D> nil # Why is that so? faq. escaping the escape in sub/gsub. search the archives. maybe you want somethin...

Gary Sokolich """"""
"""""""""" http://www.manta.com/c/mmlq5dm/w-gary-sokolich W Gary Sokolich 801 Kings Road Newport Beach, CA 92663-5715 (949) 650-5379 http://www.tbpe.state.tx.us/da/da022808.htm TEXAS BOARD OF PROFESSIONAL ENGINEERS February 28, 2008 Board Meeting Disciplinary Actions W. Gary Sokolich , Newport Beach, California �V File B-29812 - It was alleged that Dr. Sokolich unlawfully offered or attempted to practice engineering in Texas (...) Dr. Sokolich chose to end the proceedings by signing a Consent Order that was accepted by ...

when should one use "and" and "or"
Hi All, just got hit w the ff > case > when x==1 or x==2 > print "yeoh!" > end SyntaxError: compile error (irb):17: syntax error, unexpected kOR, expecting kTHEN or ':' or '\n' or ';' when x==1 or x==2 ^ "or" and "and" both exhibit the behaviour in ruby1.8/1.9. workaround 1 put parens around the condition (not again) 2 replace or/and with ||/&& i believe there are other similar quirks when using "and/or".. has ruby relegated the use of "and/or"....? best regards -botp On Feb 4, 9:55=A0pm, botp <botp...@gmail.com> wrote: > Hi All, > > just got hit w the ff > > > case > > when x=3D=3D1 or x=3D=3D2 > > =A0 print "yeoh!" > > end x =3D 5 =3D=3D>5 case x when 2,3 p 'no' when 4,5 p 'yes' end "yes" =3D=3D>nil On Fri, Feb 5, 2010 at 1:45 PM, w_a_x_man <w_a_x_man@yahoo.com> wrote: #> x =3D 5 #> =A0 =A0=3D=3D>5 #> case x #> =A0when 2,3 #> =A0 =A0p 'no' #> =A0when 4,5 #> =A0 =A0p 'yes' #> end of course i know that ;-) im talking about the second type of "case", eg > case > when x.baz and y.foo .... best regards -botp botp wrote: > i believe there are other similar quirks when using "and/or".. > has ruby relegated the use ...

Use "range," not "for"?
Thanks to everyone who suggested ways to get a proc to recognize all variables in the global scope--here's why I wanted to know. (Maybe someone has done this better already--if so, don't hesitate to let me know!) I've found that a simple "foreach" loop fairly often won't do the jobs I want done, and I need to use "for"--ugh! Well, I recently read at least part of a book about Python. It didn't look like an improvement over Tcl for the most part, but it has at least a few good features, one of which is the "range" expression. I thought a "range" procedure in Tcl might be a good substitute for the clumsy "for." So, here's my first effort. Instead of writing this: for {set i 1} {$i<= 10} {incr i} {puts "$i. \"for\" is ugly!"} you can write this: range i 1 to 10 {puts "$i. \"range\" is beautiful!"} Or, if you have a list called "lum," instead of writing this: for {set i 0} {$i < [llength $lum]} {incr i} {puts [lindex $lum $i]} you can write this: range i 0 no [llength $lum] {puts [lindex $lum $i]} To go backward, skipping every other number, instead of this: for {set i 10} {$i >= 0} {incr i -2} {puts $i} you can write this: range i 10 to 0 -2 {puts $i} The usage is pretty obvious: "range var start cutoff end ?incr? body." In other words, (1) the word "range"; (2) a vari...

Invalid use of "." "!"
In writing a sql statement I get the error "invalid use of "." "!"......... this is apparently coming because the where clause of the sql statemt refers to a combo box with sales persons names in it. All the names are listed first initial followed by a "." and last name. I am assuming the error i am getting is coming from the "." in the combo box. How do I get around the invalid use of the "." ? Thanks Never mind..... didnt have enough quotation marks. "Learning" <texson552000@yahoo.com> wrote in message news:DQELg.10308$o42.364@tornado.texas.rr.com... > In writing a sql statement I get the error "invalid use of "." "!"......... > this is apparently coming because the where clause of the sql statemt refers > to a combo box with sales persons names in it. All the names are listed > first initial followed by a "." and last name. I am assuming the error i am > getting is coming from the "." in the combo box. > > How do I get around the invalid use of the "." ? > > Thanks > > ...

"==" is NOT TRUE "==", WHY?
[CODE START] x=5; y=8; if (x + y + 1E-15 == 13) a = 3 else a = 8 end [CODE END] When x + y + 1E-15, the code above returns a = 8. When x + y + 1E-16, the code above returns a = 3. Why? Kindly advise. Thanks. "onemilimeter Chen" <onemm@example.com> wrote in message <g7adrj$5tr$1@fred.mathworks.com>... > [CODE START] > x=5; > y=8; > if (x + y + 1E-15 == 13) > a = 3 > else > a = 8 > end > [CODE END] > > When x + y + 1E-15, the code above returns a = 8. > When x + y + 1E-16, the code above returns a = 3. > > Why? ...

Re: "out" and "in out"
"no reliable initial value" means, you cannot rely on the value, but it may have a value. This depends on the parameter passing mechanism, which is _not_ related to the parameter mode (contrary to what many people think). So the parameter mode is there (nearly) solely for the information of the reader. The parameter passing mechanism for all kinds of parameters is defined in the RM. There are parameters passed by copy (in and out), by reference; for some it is explicitly left undefined. In your case, the passing mechanism is by reference, so you get what you get. But don't rely...

"A" is not equal "A"?
I was trying to convert String Array to String A through cycle and than compare the result with String B but eventhough results were the same it returned false. I'am working in BlueJ 3.1.0 Code is: public boolean Method () { String[] Example = {"a","b","c"}; String A = ""; String B = "abc" for (int i = 0; i<3 ; i++) { A = A + Example[i]; } if (A == B) { return true; } } never got true... I appreciate any suggestions how to solve this Den 08.04.2014 10:06, skrev 245dav@gmail.com:...

what does the "+" and the "-" mean?
I recently read what the "+" and the "-" signs mean for compact discs. Of course, a friend has just asked me and I now forget. I've searched all over the place with no results. Anyone know? TIA! .. -------------------------------------- Mike Richter, were you born with "Scam Artist" emblazoned on your face? -------------------------------------- roscoe james wrote: > > I recently read what the "+" and the "-" signs mean for compact discs. Of > course, a friend h...

why have both "." and "->" ?
I used to remember why c++ needed both ? Could somebody help me here ? For example class A{ f(); }; A* aa; You could do either "aa->f()" or "(*aa).f()". So why does C++ need both operators. Raj "raj" <rajkumar@hotmail.com> schreef in bericht news:d7fee6d0.0406230748.694b966b@posting.google.com... > I used to remember why c++ needed both ? > Could somebody help me here ? > > For example > > class A{ > f(); > }; > > A* aa; > > You could do either "aa->f()" or "(*aa).f()". So why does C++...

"plot", "imshow" and "quiver"
Hi all. So recently I made the discovery that when use "imshow" command, the YDir parameter under Axis Properties is set to "reverse" by default. To me this seems counter intuitive. Why wouldn't YDir be "normal" by default? When set at "normal" it turns out that my image is actually flipped upside down. On the contrary, when use "quiver" command to plot a vector field, the YDir is set at "normal" by default. Even though this makes more sense to me, because "reversed" YDir is the correct way to display an image (as in "imshow"), the result of "quiver" is that the vector fields this time depict the objects as if they are upside down... So every time I use "quiver" I always add the following line to revert the objects back to its normal orientation... set(gca, 'YDir', 'reverse')... In addition, "plot" uses "normal" setting for YDir. The only issue I have is that I use these commands fairly frequently in my job and sometimes they can get a little bit confusing in terms of display. So I wonder why MATLAB hasn't standardized them so that the objects always get displayed the same way. It's just a comment I have. Thank you. "Clare " <flyingclare@gmail.com> wrote in message news:hefvdk$3md$1@fred.mathworks.com... > Hi all. So recently I made the discovery that when use "imshow" command, > the ...

Is there any """Anti Stringizing operator #"""
Hi everybody:D I've a string that contains the name of a class. Some members told that I can use """Stringizing Operator (#)""", but the problem is here, that I have the string, & I want something vice- versa. As we know with """Stringizing Operator (#)""", we can get the stirng name of a class or ... str <--- #ClassA But I want to instantiate a class that I have just it's name as a string. ClassA * clsA = new ??? <--- Str ??? How can I do it? I don't want to use """HardCoding"&qu...

Writing a "String#jindex" method to do the same for "index" as "String#jlength" does for "length"
So I've been using the 'jcode' library to get UTF-8 support and wanted to add a convenience method called "jindex" that would work with multi- byte characters in much the same way that "jlength" does. The basic idea is to call the real "index" method to do the work, and then convert the returned byte-count index into a character-count index before returning it to the user. This works fine, but the problem is that I can't find a way to propagate $~ back to the user. That is, after calling this: 'foo'.index /foo/ $~ is set and $~[0] is &q...

["a", "b", "c", "d"] to "a, b, c, d"?
I want to process each element of an array, but the last element should be handled special. Here is an example: def p_ary(ary) str = "" ary.each do |elem| str << elem << ", " end str.chomp!(", ") str end so p_ary(["a", "f", "x", "test"]) produces "a, f, x, test". The code works, but isn't there an easier and more general way for this behaviour? martinus On Tue, 06 Apr 2004 04:23:22 -0700, Martin wrote: > I want to process each element of an array, but the last ele...

Using "fsolve": How to control iteration using "residuals" and "norm of step"??
Hello Everyone, I am using fsolve to solve a system of linear equations and it&#8217;s working fine. However, I have a coupe of issues: (i) Even when the solution (alpha) converges, I am getting the message to choose a new point. I am guessing that it has to do with &#8220;norm of step&#8221; as probably the code is trying a smaller step. I am using option like this: options = optimset('Jacobian','on', 'algorithm', 'Levenberg-Marquardt','Display','iter-detailed', 'MaxFunEvals', 10000, 'MaxIter', 10000,'TolX'...

Web resources about - Changing, "FindFirst" to using the, "Seek" Method? - comp.databases.ms-access

Resources last updated: 3/21/2016 11:42:34 AM