Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Why can't get query to return records
I have a form named frmAuditData which is a NavigationSobForm on the form "Navigation Form". On the frmAuditData I have two fields... txtStartDate and txtEndDate.
Then in a query design I have this code which is supposed to display the records in tblAuditData but it doesn't work:
Between [Forms]![frmAuditData]![tx
I've also tried:
Between Forms![Navigation Form]!frmAuditData.Form!tx
But that doesn't work either. When I run the query I get an enter parameter value form twice.. once for txtStartDate and once for txtEndDate
Nota that the date fields in the table look like: 9/8/2015 1:42:39 PM if that matters.
Then in a query design I have this code which is supposed to display the records in tblAuditData but it doesn't work:
Between [Forms]![frmAuditData]![tx
I've also tried:
Between Forms![Navigation Form]!frmAuditData.Form!tx
But that doesn't work either. When I run the query I get an enter parameter value form twice.. once for txtStartDate and once for txtEndDate
Nota that the date fields in the table look like: 9/8/2015 1:42:39 PM if that matters.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
My latest attempt:
Between [Forms]![Navigation Form]![AdminPage].[Form]![
The main form is [Navigation Form] and the 1st subform is [AdminPage] and the subform the date fields are on is frmAuditDate
Between [Forms]![Navigation Form]![AdminPage].[Form]![
The main form is [Navigation Form] and the 1st subform is [AdminPage] and the subform the date fields are on is frmAuditDate
try this syntax
Between Forms![Navigation Form]![NavigationSubform].
Between Forms![Navigation Form]![NavigationSubform].
Stripped down version attached. Please unzip, Open front-end file. Runtime error - Click [End]. Go to "Admin Page'. Go to [Audit Trail]. Enter 9/8/2015 in both date fields.
The result should be four records that show up in a query window. Instead, I get enter parameter value.
???
Example.zip
The result should be four records that show up in a query window. Instead, I get enter parameter value.
???
Example.zip
You have to use the correct reference for the controls:
SELECT
...
FROM
audCustomer
WHERE
(audCustomer.audDate
Between
[Forms]![frmAuditData]![tx
And
[Forms]![frmAuditData]![tx
ORDER BY
audCustomer.audDate;
/gustav
SELECT
...
FROM
audCustomer
WHERE
(audCustomer.audDate
Between
[Forms]![frmAuditData]![tx
And
[Forms]![frmAuditData]![tx
ORDER BY
audCustomer.audDate;
/gustav
Rey: There is only one table -- audCustomer. That is the only table I am querying.
Gustav: I tried this and it still doesn't work:
SELECT audCustomer.audID, audCustomer.audType, audCustomer.audDate, audCustomer.audUser, audCustomer.Customer_ID, audCustomer.UPC, audCustomer.Description, audCustomer.Package, audCustomer.Brand, audCustomer.CaseQty, audCustomer.VenCode, audCustomer.Sub_Dept, audCustomer.Customer_Type_
FROM audCustomer
WHERE (((audCustomer.audDate) Between [Forms]![frmAuditData]![tx
ORDER BY audCustomer.audDate;
Gustav: I tried this and it still doesn't work:
SELECT audCustomer.audID, audCustomer.audType, audCustomer.audDate, audCustomer.audUser, audCustomer.Customer_ID, audCustomer.UPC, audCustomer.Description, audCustomer.Package, audCustomer.Brand, audCustomer.CaseQty, audCustomer.VenCode, audCustomer.Sub_Dept, audCustomer.Customer_Type_
FROM audCustomer
WHERE (((audCustomer.audDate) Between [Forms]![frmAuditData]![tx
ORDER BY audCustomer.audDate;
Using this?....
SELECT audCustomer.audID, audCustomer.audType, audCustomer.audDate, audCustomer.audUser, audCustomer.Customer_ID, audCustomer.UPC, audCustomer.Description, audCustomer.Package, audCustomer.Brand, audCustomer.CaseQty, audCustomer.VenCode, audCustomer.Sub_Dept, audCustomer.Customer_Type_
FROM audCustomer
WHERE (((audCustomer.audDate) Between [Forms]![frmAuditData]![tx
ORDER BY audCustomer.audDate;
SELECT audCustomer.audID, audCustomer.audType, audCustomer.audDate, audCustomer.audUser, audCustomer.Customer_ID, audCustomer.UPC, audCustomer.Description, audCustomer.Package, audCustomer.Brand, audCustomer.CaseQty, audCustomer.VenCode, audCustomer.Sub_Dept, audCustomer.Customer_Type_
FROM audCustomer
WHERE (((audCustomer.audDate) Between [Forms]![frmAuditData]![tx
ORDER BY audCustomer.audDate;
I've attached the working form and query - using dates of 2015-09-01 and 2015-10-01.
/gustav
Example.accdb
Example_BE.accdb
/gustav
Example.accdb
Example_BE.accdb
Yes. If I just open the form, frmAuditData it works. But if I go to Navigation Form > Admin Page > [Audit Trail] and enter 9/8/2015 in both date fields it does not work.
@steve
you have to use the syntax like what i posted at http:#a40967894
just check the names of the controls, subform control name and apply to the syntax accordingly.
you have to use the syntax like what i posted at http:#a40967894
just check the names of the controls, subform control name and apply to the syntax accordingly.
I see. The form is opened as a subform in the navigation form.
Then you must use the syntax as Rey explained.
/gustav
Then you must use the syntax as Rey explained.
/gustav
Frustrated. I tried:
Between [Forms]![Navigation Form]![frmFirstPage].[Form
and
Between [Forms]![Navigation Form]![frmAuditData].[Form
And neither one works.
Between [Forms]![Navigation Form]![frmFirstPage].[Form
and
Between [Forms]![Navigation Form]![frmAuditData].[Form
And neither one works.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial