Duane,
I realized that I probably should use the form for this after I sent the email. So my follow up question is that how would I show in the message box the count of how many records were updated? Below is my message box for the query to update a check box to true.
MsgBox "Records have been update for" & " " & DCount("[ReceiveMemo]", "qryUpdateToReceiveMemo", ReceiveMemo = True")
Jim Wagner
On Thursday, June 12, 2014 11:19 AM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim,
IMO, parameter prompts are never an adequate user interface. I recommend always using controls on forms for parameters.
What do you mean by "save the values"? If you use controls on a form, they can be bound to a table of parameter values.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 12 Jun 2014 11:15:38 -0700
Subject: [MS_AccessPros] Save values entered for a parameter to a message box.
IMO, parameter prompts are never an adequate user interface. I recommend always using controls on forms for parameters.
What do you mean by "save the values"? If you use controls on a form, they can be bound to a table of parameter values.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 12 Jun 2014 11:15:38 -0700
Subject: [MS_AccessPros] Save values entered for a parameter to a message box.
Is there a way to save the values of what was entered for a parameter to a message box. I know how to put the values onto a report. I have a start and end date for the query parameters.
Here is my query parameter
Between [Enter start date] And [Enter end date]
Thank You
Jim Wagner
__._,_.___
Posted by: Jim Wagner <luvmymelody@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar