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

 

 hi Greg,

(sorry this appears twice -- my message didn't pick up previous stuff so I moved it up, and am posting again ... and changed it slighly too)

glad it is working ... BUT! removing & is not the solution. You need & to concatenate,  but it needs to be delimited with spaces.

Please remember to KEEP previous responses when posting so we can follow the discussion. For reference, I have pasted in what was said previously

~crystal

--- previous posts:
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, greg [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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

On 1/30/2019 3:24 PM, xenon.blue@yahoo.com [MS_Access_Professionals] wrote:

Hi Crystal,

Thank you for your reply. I have removed the &'s and all is working well again. Strange because I started out with out them and had the problem. Seems to be one of those twilight things :)

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 (5)

---

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

.

__,_._,___