QUERY PROBLEMS

  • Thread starter Thread starter Paul Martin
  • Start date Start date
P

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
 
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 Tom,
Thanks for this, I'll check it out.
Regards,
Paul

Tom Vianese said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top