Thank You Darrell. That was it.
Jim Wagner
On Thursday, June 12, 2014 12:17 PM, "'Embrey, Darrell' DEmbrey@bcbsm.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Unless you mistyped your expression, the syntax is incorrect. You are missing the quotes around the criteria string expression. It should be:
MsgBox "Records have been updated for " & DCount("*", "tblTUFMemoForOwnerReimbursedCellPhone", "ReceiveMemo = True") & " records"
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, June 12, 2014 2:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Save values entered for a parameter to a message box.
Sent: Thursday, June 12, 2014 2:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Save values entered for a parameter to a message box.
I updated my message box to the below and the message shows 0 records have been updated, yet 2 records have the check box checked.
MsgBox "Records have been updated for" & " " & DCount("[ReceiveMemo]", "tblTUFMemoForOwnerReimbursedCellPhone", ReceiveMemo = True) & " " & "records"
Jim Wagner
On Thursday, June 12, 2014 11:40 AM, "Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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
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.
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
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
__._,_.___
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 (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar