Minggu, 07 Februari 2016

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


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,


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)



Tidak ada komentar:

Posting Komentar