Re: [MS_AccessPros] Using Form Control Inputs in MS Access Query Problem

 

hi Greg,

the form has to be open and the controls need values (as the criteria is written)

ALSO: there needs to be a space before AND after &, which there is not

~crystal

On 1/30/2019 11:29 AM, xenon.blue@yahoo.com [MS_Access_Professionals] wrote:

Hi There!

I am experiencing a problem when trying to use 2 text box inputs in the criteria box of my query. I have modified the SL to declare Parameters as follows:

PARAMETERS [Forms]![frmQuery_By_Date]![txtLD] DateTime, [Forms]![frmQuery_By_Date]![txtUD] DateTime;
SELECT tblLabor.Work_Date, tblLabor.Employee, tblLabor.Project_No, tblLabor.Hours
FROM tblLabor
WHERE (((tblLabor.Work_Date) Between "&[Forms]![frmQuery_By_Date]![txtLD]&" And "&[Forms]![frmQuery_By_Date]![txtUD]&"));

I tried this yesterday and it worked fine, however today is not working. When running the query it prompts for manual entry dialog boxes. I find this disturbing that Access is not stable day to day.

Can anyone please help me with this?

Thank you, nd happy databasing,

Greg

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___