Re: Disable help file

Tom van Stiphout wrote:

On Sun, 09 Apr 2006 23:36:29 -0230, Tim Marshall
<TIMMY!@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Not in all situations.
If you have to look up in the help file for example some basic
Properties and Methods of the Recordset object, that tells me
something about your abilities in that area.

Had to resend this - hopefully it stays in the thread!

I guess that could justify it... 8) But in my mind, only if you are
looking both for developers who do a specific method and do it your (the
interviewer's) way.

I see lots of code here by people who are doing things a bit differently
from me but ultimately we are doing the same thing. I never use
dbengine, for example, but I see lots of examples here where it's used
do do things that I do a different way.

Nope, even with the awful help files post-A97, for pretty standard
stuff, I sometimes review what I'm doing to make sure I'm getting the
arguments right or whatever. OTOH, there's lots more I do just by the
seat of my pants or with the object browser and/or the intelli-sense.
But again, if faced with different methods, I might want to check to be
sure. here's a quick example I just thought of:

I do mostly work with Oracle and PTQs. The DAO openrecordset method
must be used with a queryobject, not the database object and as you
know, the syntax is different. I do these recordsets lots and lots, but
when I'm occasionally working with jet, I can save myself the extra
steps needed to create even a temporary PTQ dao.querydef by just opening
the recordset against the currentdb and include the SQL. In such a
situation, if I hadn't done this in Jet for a long time, I'd check help.

It separates the "I can
do this in my sleep" candidates from the "Give me Google and the help
file, and I can probably figure this out".

If there's no time limit involved.

Anyway, my opinion, I'd never do what the OP is contemplating. 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

.

Relevant Pages

  • Re: Temporary Pass-through Query as Rowsource for Listbox?
    ... with each call to get row data, you return the appropriate data from the ... recordset, and in the "finish up" section you close the recordset. ... I think if you look up RowSourceType in the Access 97 help file -- the last ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Simple query/form help?
    ... FindFirst methods of the recordset object. ... Also look at the DLookup function in the Help file to see if you want to use ... > I want to have a way of an end user typing a postcode in such as: ...
    (microsoft.public.access.gettingstarted)
  • Re: Temporary Pass-through Query as Rowsource for Listbox?
    ... The function gets called at various stages in the combo box's querying process, including once to initialize it, once to get the number of rows, and once for each row to be returned. ... So in the initialize section, you'd open a static recordset, and MoveLast and MoveFirst to make sure the RecordCount is known so that you can return it when called to do so. ... Then with each call to get row data, you return the appropriate data from the recordset, and in the "finish up" section you close the recordset. ... I think if you look up RowSourceType in the Access 97 help file -- the last really good help file for Access -- you'll be able to find a help topic explaining how to do it. ...
    (microsoft.public.access.formscoding)
  • Re: Passing a recordset to a form
    ... I notice that a) the Recordset variable is declared as Public* ... The help file says this means that this action is normally ... > Dim rst As New ADODB.Recordset ... > Dim stDocName As String ...
    (microsoft.public.access.formscoding)
  • Re: Fun and games instaling VB6 and MSDN!
    ... full text search then I get the Jet msg ... Most keyword explanations come straight up without the vb/vba choice box ... Vb documentation, and the long list of Mikesqillion (try that, spell ... Bad use interface, that one, especially for a help file! ...
    (microsoft.public.vb.general.discussion)
Loading