My environment is Access 2.0, VB 4.0 16-bit.
I have an Access mdb with several queries defined that work fine in
Access. However, when I create a data control and refer to the Access
file in the DatabaseName property and then go to the RecordSource
property, I only see a few of the Access queries in the Access file.
The common item between the queries that don't appear is that they
contain a criteria field that is a function call. The criteria is a
variable. The only way I can see to refer to a variable is through a
function call. Then this query doesn't appear in the pick list in VB.
Any suggestions or leads.
FDC - Teleservices