473,320 Members | 1,884 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DCount.

N J
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.
Nov 13 '05 #1
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.
Nov 13 '05 #2
N J
"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?
Nov 13 '05 #3
"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.
Nov 13 '05 #4
N J
"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.
Nov 13 '05 #5
"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.
Nov 13 '05 #6
N J
"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.
Nov 13 '05 #7
N J
"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.
Nov 13 '05 #8
"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.
Nov 13 '05 #9
N J
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.

Nov 13 '05 #10
"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.
Nov 13 '05 #11
N J
"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
Nov 13 '05 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
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...
1
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...
4
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...
6
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...
2
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.
3
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...
2
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 ...
2
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...
2
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...
8
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...
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
1
isladogs
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...
0
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...
1
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)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.