QUERY PROBLEMS

[Paul Martin]

Hi All,
I have just upsized an Access (2000) project to an ADP file using the built
in wizard (this is my first attempt at this). I stupidly thought that this
would be all I needed to do! However, throughout the application I have many
combo boxes and list boxes with their own queries restricting the list to
whatever is relevant for a particular form. I have therefore used queries
such as:

SELECT tblCustContacts.ContactID, tblCustContacts.FullName,
tblCustContacts.JobTitle, tblCustContacts.WkPhone
FROM tblCustContacts
WHERE (((tblCustContacts.CustID)=[Forms]![frmEditCust]![txtCustID]) AND
((tblCustContacts.Deleted)=0))
ORDER BY tblCustContacts.Primary, tblCustContacts.LastName;

The problem I have is that they simply do not work in the ADP file, whereas
they work perfectly with an mdb file. The problem appears to be the
reference to the form, but everything I have tried to get around this has
also failed.
I would really appreciate any guidance on this as it is driving me nuts!
Regards,
Paul

 

[Tom Vianese]

I am using a book that answers that question as well as many others. The
book is "Microsoft Access Projects with Microsoft SQL Server" from Microsoft
Press.

Tells how to rewrite queries, use forms, subforms, combo boxes, etc. in a
project.

 

[Paul Martin]

Hi Tom,
Thanks for this, I'll check it out.
Regards,
Paul

I am using a book that answers that question as well as many others. The
book is "Microsoft Access Projects with Microsoft SQL Server" from Microsoft
Press.

Tells how to rewrite queries, use forms, subforms, combo boxes, etc. in a
project.

Hi All,
I have just upsized an Access (2000) project to an ADP file using the built
in wizard (this is my first attempt at this). I stupidly thought that this
would be all I needed to do! However, throughout the application I have many
combo boxes and list boxes with their own queries restricting the list to
whatever is relevant for a particular form. I have therefore used queries
such as:

SELECT tblCustContacts.ContactID, tblCustContacts.FullName,
tblCustContacts.JobTitle, tblCustContacts.WkPhone
FROM tblCustContacts
WHERE (((tblCustContacts.CustID)=[Forms]![frmEditCust]![txtCustID]) AND
((tblCustContacts.Deleted)=0))
ORDER BY tblCustContacts.Primary, tblCustContacts.LastName;

The problem I have is that they simply do not work in the ADP file, whereas
they work perfectly with an mdb file. The problem appears to be the
reference to the form, but everything I have tried to get around this has
also failed.
I would really appreciate any guidance on this as it is driving me nuts!
Regards,
Paul