Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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.
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
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.
Oh, you have a subform in a subform - with the same name for the subform control.
Then it is:
Between
[Forms]![Navigation Form]![NavigationSubform].
[Forms]![Navigation Form]![NavigationSubform].
Then it is:
Between
[Forms]![Navigation Form]![NavigationSubform].
[Forms]![Navigation Form]![NavigationSubform].
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
Awarding to both of you for all the effort and putting up with my confusing you. That last suggestion worked perfectly.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.
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