Re: DAO peculiarity in A97?

MLH <CRCI@xxxxxxxxxxxxxx> wrote in
news:kb3dr1d96b5ale01csrm8mr8hjsn866l63@xxxxxxx:

> 140 With MyDB
> 170 Set qdfType17CorrespRecs = .CreateQueryDef("", "Select
> * FROM tblCorrespondence;")
> 180 With qdfType17CorrespRecs
> 210 ' Open Recordset from QueryDef.
> 220 Set rstType17CorrespRecs =
> .OpenRecordset(dbOpenSnapshot)
> 230 ' With rstType17CorrespRecs
> 231 ' If .BOF = True Then GoTo NoRecs
> 240 ' .MoveFirst
> 250 ' Do Until rstType17CorrespRecs.EOF

How do you set MyDB?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: cowboys and sheepherders
    ... other New Yorker URLs I have seen. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ... Prev by Date: ...
    (soc.motss)
  • Re: Christmas dinner update
    ... What's a "pasty?" ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ... Prev by Date: ...
    (soc.motss)
  • Re: Washington State Gay Rights bill passes
    ... <PLONK> ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ... Prev by Date: ...
    (soc.motss)
  • Re: Relinking problem
    ... > Here is a snippet of the code I have been using since 94. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: How to stop library mde being reused
    ... If you only run this MDE in a few locations, ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ... Prev by Date: ...
    (comp.databases.ms-access)