Re: SQL for Quering Access Tables from a Table/Field List Table
- From: "robboll" <robboll@xxxxxxxxxxx>
- Date: 18 Aug 2005 06:48:56 -0700
Ken,
When I enter a value that I know is in one of the test tables, it moves
from Do until .EOF to End With, and I am prompted to enter the value
again. Apparently when there is nothing in the record set it breaks
out of the loop.
.
- Follow-Ups:
- Re: SQL for Quering Access Tables from a Table/Field List Table
- From: Ken Snell [MVP]
- Re: SQL for Quering Access Tables from a Table/Field List Table
- From: Ken Snell [MVP]
- Re: SQL for Quering Access Tables from a Table/Field List Table
- References:
- SQL for Quering Access Tables from a Table/Field List Table
- From: robboll
- Re: SQL for Quering Access Tables from a Table/Field List Table
- From: Ken Snell [MVP]
- Re: SQL for Quering Access Tables from a Table/Field List Table
- From: robboll
- Re: SQL for Quering Access Tables from a Table/Field List Table
- From: robboll
- Re: SQL for Quering Access Tables from a Table/Field List Table
- From: Ken Snell [MVP]
- SQL for Quering Access Tables from a Table/Field List Table
- Prev by Date: RE: Acc2003: Exporting query objects results in loss of join
- Next by Date: RE: date formula in table
- Previous by thread: Re: SQL for Quering Access Tables from a Table/Field List Table
- Next by thread: Re: SQL for Quering Access Tables from a Table/Field List Table
- Index(es):
Relevant Pages
|