RE: [MS_AccessPros] InputBox in Expression Builder in a query

 

Katie,

IMO, there is no place in Access user interface for parameter prompts. I would always use a control on a form for grabbing user input.

However, if you want to do this, you can use something like this assuming you want to add a year to the entered date:

DateAdd("yyyy",1,[Enter Date of Production])

The user will only be prompted once since the same parameter is used twice.

Duane Hookom, MVP
MS Access

---

From: MS_Access_Professionals@yahoogroups.com
To: MS_Access_Professionals@yahoogroups.com
Date: Sun, 7 Feb 2016 12:16:12 -0800
Subject: [MS_AccessPros] InputBox in Expression Builder in a query



I am looking for a way have a query to ask a user enter a date, use the date that they enter and output the date they enter plus a fixed amount. i.e. Expression field ProductionDate       [Enter Date of Production], they enter 2/7/16, and have the expression add 365 days to output 2/7/17.
I came across the function for InputBox, and have successfully had it output   [Enter Date of Production], but have been unable to have accept the input, and output the expression ProductionDate + 365.


Any Help would be greatly appreciated.
Thanks so much,
Katie

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___