RE: [AccessDevelopers] Modify query WHERE statement based on a form text box

Mon, 17 Oct 2005 18:08:21 -0700

Title: [AccessDevelopers] Modify query WHERE statement based on a form text box
Toby,
 
What would the syntax be to generalize
    [Forms]![FormName]![txt_Date]
 
for use by any form that calls the query, given that
    [Forms]![Me]![txt_Date]
 
which seemed like the obvious generalization, doesn't quite get the job done.
 
Far
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Toby Bierly
Sent: Monday, October 17, 2005 7:34 PM
To: [email protected]
Subject: Re: [AccessDevelopers] Modify query WHERE statement based on a form text box

You can reference the text box in the query:
 
SELECT Name, Company
FROM Contacts
WHERE ContactDate > [Forms]![FormName]![txt_Date];
 
HTH,
Toby
----- Original Message -----
Sent: Monday, October 17, 2005 3:46 PM
Subject: [AccessDevelopers] Modify query WHERE statement based on a form text box


I have a form that calls a query with a command button.  The query tells me the most recent contacts I have made.

The query (which actually has a join to handle the 1:m relationship between people and the contacts made with them) is basically:

SELECT Name, Company
FROM Contacts
WHERE ContactDate > #10/17/2005#;

I have a text box in the form that supplies the date for the WHERE staement.

I am using a querydef to rewrite the SQL to insert the date, but I've got to believe there's an easier way to do it.

Does anyone have any ideas?

TIA

Far Farley




Please zip all files prior to uploading to Files section.



SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

YAHOO! GROUPS LINKS



Reply via email to