Hi, I was given this code by a member on here but I am still stuck...I want
to be able to see if there is other orders in the table based on the email
address. But I keep getting #Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " &
DCount("From Email Address", "tblDownload", "From Email Address='" &
Me.Text13244 & "'") & " customers with this email address."
txtDuplicatesMessage = Text box that I want the above to appear in
From Email Address = Field Name
Text13244 = Email address text box on form bound to From Email Address
field.
TIA
--
Kind Regards,
Customer Services,
Blue Lagoon Products http://www.fastminimoto.co.uk
P.S. For us to answer your emails efficiently, please always include the
original message. Thank you. 11 2410
"N J" <in**@bluelagoonproducts.com> wrote in
news:rI*****************@fe2.news.blueyonder.co.uk : Hi, I was given this code by a member on here but I am still stuck...I want to be able to see if there is other orders in the table based on the email address. But I keep getting #Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " & DCount("From Email Address", "tblDownload", "From Email Address='" & Me.Text13244 & "'") & " customers with this email address."
txtDuplicatesMessage = Text box that I want the above to appear in From Email Address = Field Name Text13244 = Email address text box on form bound to From Email Address field.
TIA
Access is brain-dead when dealing with table names and field
names containing spaces. Delimit them with square brackets
inside the quotes.
DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'")
--
Bob Quintal
PA is y I've altered my email address.
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126378323.06183762127525c90dcb55210455ad6f@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:rI*****************@fe2.news.blueyonder.co.uk :
Hi, I was given this code by a member on here but I am still stuck...I want to be able to see if there is other orders in the table based on the email address. But I keep getting #Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " & DCount("From Email Address", "tblDownload", "From Email Address='" & Me.Text13244 & "'") & " customers with this email address."
txtDuplicatesMessage = Text box that I want the above to appear in From Email Address = Field Name Text13244 = Email address text box on form bound to From Email Address field.
TIA
Access is brain-dead when dealing with table names and field names containing spaces. Delimit them with square brackets inside the quotes.
DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'") -- Bob Quintal
PA is y I've altered my email address.
Oops..
Still doesn't work :(
DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" &
Me.Text13244 & "'")
Just keep getting #Name?
"N J" <in**@bluelagoonproducts.com> wrote in
news:t%******************@fe2.news.blueyonder.co.u k: "Bob Quintal" <rq******@sPAmpatico.ca> wrote in message news:1126378323.06183762127525c90dcb55210455ad6f@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:rI*****************@fe2.news.blueyonder.co.uk :
Hi, I was given this code by a member on here but I am still stuck...I want to be able to see if there is other orders in the table based on the email address. But I keep getting #Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " & DCount("From Email Address", "tblDownload", "From Email Address='" & Me.Text13244 & "'") & " customers with this email address."
txtDuplicatesMessage = Text box that I want the above to appear in From Email Address = Field Name Text13244 = Email address text box on form bound to From Email Address field.
TIA
Access is brain-dead when dealing with table names and field names containing spaces. Delimit them with square brackets inside the quotes.
DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'") -- Bob Quintal
PA is y I've altered my email address.
Oops..
Still doesn't work :(
DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'")
Just keep getting #Name?
where is the code located, in the form's code module or in a
global module or in the textbox's control source?
--
Bob Quintal
PA is y I've altered my email address.
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126380312.2a604ec5e89b8dd1bc612a062afa4741@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:t%******************@fe2.news.blueyonder.co.u k:
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message news:1126378323.06183762127525c90dcb55210455ad6f@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:rI*****************@fe2.news.blueyonder.co.uk :
Hi, I was given this code by a member on here but I am still stuck...I want to be able to see if there is other orders in the table based on the email address. But I keep getting #Name? what does this error mean?
Me.txtDuplicatesMessage = "You already have " & DCount("From Email Address", "tblDownload", "From Email Address='" & Me.Text13244 & "'") & " customers with this email address."
txtDuplicatesMessage = Text box that I want the above to appear in From Email Address = Field Name Text13244 = Email address text box on form bound to From Email Address field.
TIA
Access is brain-dead when dealing with table names and field names containing spaces. Delimit them with square brackets inside the quotes.
DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'") -- Bob Quintal
PA is y I've altered my email address.
Oops..
Still doesn't work :(
DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'")
Just keep getting #Name? where is the code located, in the form's code module or in a global module or in the textbox's control source?
-- Bob Quintal
PA is y I've altered my email address.
Text box.
Thanks.
"N J" <in**@bluelagoonproducts.com> wrote in news:i3IUe.47865
$2********@fe3.news.blueyonder.co.uk: where is the code located, in the form's code module or in a global module or in the textbox's control source?
-- Bob Quintal
PA is y I've altered my email address.
Text box.
Thanks.
remove the Me.txtDuplicatesMessage
just leave
= "You already have " &
DCount("[From Email Address]", "tblDownload", "[From Email
Address] ='" & Me.Text13244 & "'") & " customers with this
email address."
Note the presence of the = sign as the first character.
The issue is the me.txtDuplicatesMessage is necessary in the
form's code module and is confusing the compiler.when put
directly in the textbox named txtDuplicatesMessage.
#name indicates the confusion about the name.
--
Bob Quintal
PA is y I've altered my email address.
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126388000.b8e1b975824b0d89b09927ec71b4966e@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:i3IUe.47865 $2********@fe3.news.blueyonder.co.uk:
where is the code located, in the form's code module or in a global module or in the textbox's control source?
-- Bob Quintal
PA is y I've altered my email address.
Text box.
Thanks.
remove the Me.txtDuplicatesMessage just leave = "You already have " & DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'") & " customers with this email address."
Note the presence of the = sign as the first character.
The issue is the me.txtDuplicatesMessage is necessary in the form's code module and is confusing the compiler.when put directly in the textbox named txtDuplicatesMessage.
#name indicates the confusion about the name.
-- Bob Quintal
PA is y I've altered my email address.
Hi,
I'm using...
="You already have " & DCount("[From Email Address]","tblDownload","[From
Email Address] ='" & [Me].[Text13244] & "'") & " customers with this email
address."
and I still manage to get #Name? :-( , I've checked and all the names are
right. Just can not get my head around it.
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126388000.b8e1b975824b0d89b09927ec71b4966e@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:i3IUe.47865 $2********@fe3.news.blueyonder.co.uk:
where is the code located, in the form's code module or in a global module or in the textbox's control source?
-- Bob Quintal
PA is y I've altered my email address.
Text box.
Thanks.
remove the Me.txtDuplicatesMessage just leave = "You already have " & DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'") & " customers with this email address."
Note the presence of the = sign as the first character.
The issue is the me.txtDuplicatesMessage is necessary in the form's code module and is confusing the compiler.when put directly in the textbox named txtDuplicatesMessage.
#name indicates the confusion about the name.
-- Bob Quintal
PA is y I've altered my email address.
I have also tried it with a different field completly, but I get the same
error.
"N J" <in**@bluelagoonproducts.com> wrote in
news:9s*******************@fe3.news.blueyonder.co. uk: I'm using...
="You already have " & DCount("[From Email Address]","tblDownload","[From Email Address] ='" & [Me].[Text13244] & "'") & " customers with this email address."
and I still manage to get #Name? :-( , I've checked and all the names are right. Just can not get my head around it.
Neither can I, so let's try something else.
remove everything from the textbox, Select field [text13244] On
it's properties events tab, click the AfterUpdate event. Click
on the ellipsis (...) button that appears and put the code
there, including the me.DuplicatesMessage = part. Once it's
typed in, test that. see what error message it gives..
--
Bob Quintal
PA is y I've altered my email address.
Hi,
Me.DuplicatesMessage = DCount("[From Email Address]", "tblDownload", "[From
Email Address] ='" & Me.Text13244 & "'")
Just get the same old message #Name? :(
--
Kind Regards,
Customer Services,
Blue Lagoon Products http://www.fastminimoto.co.uk
P.S. For us to answer your emails efficiently, please always include the
original message. Thank you.
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126390112.0e8c1d535abd2f341cbe2b6fb7a489e2@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:9s*******************@fe3.news.blueyonder.co. uk:
I'm using...
="You already have " & DCount("[From Email Address]","tblDownload","[From Email Address] ='" & [Me].[Text13244] & "'") & " customers with this email address."
and I still manage to get #Name? :-( , I've checked and all the names are right. Just can not get my head around it.
Neither can I, so let's try something else.
remove everything from the textbox, Select field [text13244] On it's properties events tab, click the AfterUpdate event. Click on the ellipsis (...) button that appears and put the code there, including the me.DuplicatesMessage = part. Once it's typed in, test that. see what error message it gives.. -- Bob Quintal
PA is y I've altered my email address.
"N J" <in**@bluelagoonproducts.com> wrote in
news:yQ******************@fe2.news.blueyonder.co.u k: Hi,
Me.DuplicatesMessage = DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'")
Just get the same old message #Name? :(
Have not got a clue, and when I created a form with 2 textboxes,
named as above, and pasted the code in the AfterUpdate event of
text13244 it works perfectly.
Double check the name of your table, the field in the table and the
name of your two textboxes. There must be some typographical error.
--
Bob Quintal
PA is y I've altered my email address.
"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1126458751.7c76a0b87de7ab88640d991a64f978f4@t eranews... "N J" <in**@bluelagoonproducts.com> wrote in news:yQ******************@fe2.news.blueyonder.co.u k:
Hi,
Me.DuplicatesMessage = DCount("[From Email Address]", "tblDownload", "[From Email Address] ='" & Me.Text13244 & "'")
Just get the same old message #Name? :( Have not got a clue, and when I created a form with 2 textboxes, named as above, and pasted the code in the AfterUpdate event of text13244 it works perfectly.
Double check the name of your table, the field in the table and the name of your two textboxes. There must be some typographical error. -- Bob Quintal
PA is y I've altered my email address.
....I give up, I have tried with so many other fields and text boxes. Must be
my access, maybe is corrupted or something.
Thanks for your help..
Nick This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: jdph40 |
last post by:
I posted this problem previously and received excellent help from
Wayne Morgan. However, I still have an unanswered question. My form
(frmVacationWeeks) is opened from the OnClick event of a...
|
by: Megan |
last post by:
Hi Everybody-
I've been reading some of the posts about DCOUNT, and I haven't yet
found an answer; so, I'm posting this question.
I have a report that I'm trying to use DCOUNT on to compute...
|
by: Will |
last post by:
Hi, I had a DCount within a module on records in a table where CustSuffix =
0. I now need to DCount where CustSuffix = 0 and the type of cost Suffix
(Suffix in table) = G. I can't get both...
|
by: Mike Conklin |
last post by:
This one really has me going. Probably something silly. I'm using
dcount for a report to determine the number of different types of
tests proctored in a semester.
My report is based on a...
|
by: Paul T. RONG |
last post by:
Hi,
I have a problem with DCount, the following code doesn't work:
DCount("", "qryOrder", "( = Me! AND
= 'drink')" > 0
Please help.
Thank you.
|
by: BerkshireGuy |
last post by:
I am having difficulty with using the Dcount function. I am trying to
return the number of records from qryIndividualFeedbackDetail where the
TimelyManner field is set to 4.
So, in the new...
|
by: Kaspa |
last post by:
Hello I am trying to create dcount field but is not working I have
tried every way possible and I can't get it to work. here is my code:
=Dcount("","qryTotalscratched"," in (6,7,8,9) and
...
|
by: ChasW |
last post by:
Greetings,
I have a form that uses a query as its record source. In the form I
have a text box that uses this as its control source:
=DCount("", "qry_Search_by_Name")
The DCount function...
|
by: Wingz |
last post by:
Hiya,
Fairly new to Access and was wondering what the best way to perform Dcounts on groups in an Access report.
For example, I have 10 employees and the different instances of jobs they can...
|
by: Susan Bricker |
last post by:
I have used DCount() to determine the number of records in a recordset.
Silly me ... I just noticed that DCount returns an INTEGER, which can
hold a maximum value of 32,767. What if the recordset...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |