Hi,
I keep getting this error message, Compile Error: Method or Data Member not
found when trying to compile my access 2000 database ( I want to make an MDE
file) although I do not receive this error when compiling the code from the
same program in Access 2002 (XP)
I keep getting the error on Me.txtTracking, it DOES exist. I just can't get
my head around this problem, could anyone help me out?
code:
Private Sub cmdOk_Click()
Dim strsql As String
CurrentDb.Execute "Update [tblDownload] Set DESPATCHED = True, TRACKING =
""" & Me.txtTracking & """, DESPDATE = """ & Me.txtDate & """, TODAYDATE =
""" & Me.txtTodayDate & """, Courier = """ & Me.cmbDeliveryMethod & """
Where ID = " & Me.txtOrderNumber & ";", dbfailonerror
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & " DESPATCHED AND
ALLOCATED TRACKING #" & Me.txtTracking & "", 0
End Sub
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
7  2625 
Hi!
It's probably the .AddItem method, which wasn't
introduced until the xp (2002) version.
I think you'll need to populate the list/combo
trhough other means, for instance concatenate
this item with the rowsource of the list/combo
Roy-Vidar
Nick J wrote: Hi,
I keep getting this error message, Compile Error: Method or Data
Member not found when trying to compile my access 2000 database ( I want to make
an MDE file) although I do not receive this error when compiling the code
from the same program in Access 2002 (XP)
I keep getting the error on Me.txtTracking, it DOES exist. I just
can't get my head around this problem, could anyone help me out?
code:
Private Sub cmdOk_Click()
Dim strsql As String
CurrentDb.Execute "Update [tblDownload] Set DESPATCHED = True,
TRACKING = """ & Me.txtTracking & """, DESPDATE = """ & Me.txtDate & """,
TODAYDATE = """ & Me.txtTodayDate & """, Courier = """ & Me.cmbDeliveryMethod &
""" Where ID = " & Me.txtOrderNumber & ";", dbfailonerror
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & "
DESPATCHED AND ALLOCATED TRACKING #" & Me.txtTracking & "", 0
End Sub
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT
FOR REFERENCE +++
Blue Bell Trading
Hi Roy,
I see, thanks for your help.
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
"RoyVidar" <ro*******@yahoo.no> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com... Hi!
It's probably the .AddItem method, which wasn't
introduced until the xp (2002) version.
I think you'll need to populate the list/combo
trhough other means, for instance concatenate
this item with the rowsource of the list/combo
Roy-Vidar
Nick J wrote: Hi,
I keep getting this error message, Compile Error: Method or Data
Member not found when trying to compile my access 2000 database ( I want to make
an MDE file) although I do not receive this error when compiling the code
from the same program in Access 2002 (XP)
I keep getting the error on Me.txtTracking, it DOES exist. I just
can't get my head around this problem, could anyone help me out?
code:
Private Sub cmdOk_Click()
Dim strsql As String
CurrentDb.Execute "Update [tblDownload] Set DESPATCHED = True,
TRACKING = """ & Me.txtTracking & """, DESPDATE = """ & Me.txtDate & """,
TODAYDATE = """ & Me.txtTodayDate & """, Courier = """ & Me.cmbDeliveryMethod &
""" Where ID = " & Me.txtOrderNumber & ";", dbfailonerror
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & "
DESPATCHED AND ALLOCATED TRACKING #" & Me.txtTracking & "", 0
End Sub
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT
FOR REFERENCE +++
Blue Bell Trading
Hi Nick
You can get this error message if *any* of the controls referred to in this
statement are invalid. Access will often highlight one of the controls that
is too early.
For example, it could be txtDate that does not exist.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:Sq*******************@fe3.news.blueyonder.co. uk...
I keep getting this error message, Compile Error: Method or Data Member
not found when trying to compile my access 2000 database ( I want to make
an MDE file) although I do not receive this error when compiling the code
from the same program in Access 2002 (XP)
I keep getting the error on Me.txtTracking, it DOES exist. I just can't
get my head around this problem, could anyone help me out?
code:
Private Sub cmdOk_Click()
Dim strsql As String
CurrentDb.Execute "Update [tblDownload] Set DESPATCHED = True, TRACKING =
""" & Me.txtTracking & """, DESPDATE = """ & Me.txtDate & """, TODAYDATE =
""" & Me.txtTodayDate & """, Courier = """ & Me.cmbDeliveryMethod & """
Where ID = " & Me.txtOrderNumber & ";", dbfailonerror
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & " DESPATCHED AND
ALLOCATED TRACKING #" & Me.txtTracking & "", 0
End Sub
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
Hi Allen,
I have checked over doxens of times and they all exist.
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au... Hi Nick
You can get this error message if *any* of the controls referred to in
this statement are invalid. Access will often highlight one of the
controls that is too early.
For example, it could be txtDate that does not exist.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:Sq*******************@fe3.news.blueyonder.co. uk...
I keep getting this error message, Compile Error: Method or Data Member
not found when trying to compile my access 2000 database ( I want to make
an MDE file) although I do not receive this error when compiling the code
from the same program in Access 2002 (XP)
I keep getting the error on Me.txtTracking, it DOES exist. I just can't
get my head around this problem, could anyone help me out?
code:
Private Sub cmdOk_Click()
Dim strsql As String
CurrentDb.Execute "Update [tblDownload] Set DESPATCHED = True, TRACKING =
""" & Me.txtTracking & """, DESPDATE = """ & Me.txtDate & """, TODAYDATE
= """ & Me.txtTodayDate & """, Courier = """ & Me.cmbDeliveryMethod & """
Where ID = " & Me.txtOrderNumber & ";", dbfailonerror
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & " DESPATCHED
AND ALLOCATED TRACKING #" & Me.txtTracking & "", 0
End Sub
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
Suggestions to debug this.
1. Break the line into parts:
strsql = "Update [tblDownload] Set DESPATCHED = True, TRACKING = """ &
Me.txtTracking
If that works, comment it out, and try:
strsql = "DESPDATE = """ & Me.txtDate
and so on, until if finds the offender.
2. If you are referring to a field that is present in the form's
RecordSource but it is not also a control on the form, try a bang instead of
a dot, e.g.:
Me!txtDate
The compiler is less stringent with the bang. There are cases where you need
to refer to an AccessField object like that in order for the code to
compile.
3. If neither of the above can trace the problem, it may be a Name
AutoCorrect problem. Details: http://allenbrowne.com/bug-03.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:nN******************@fe3.news.blueyonder.co.u k... Hi Allen,
I have checked over doxens of times and they all exist.
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au... Hi Nick
You can get this error message if *any* of the controls referred to in
this statement are invalid. Access will often highlight one of the
controls that is too early.
For example, it could be txtDate that does not exist.
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:Sq*******************@fe3.news.blueyonder.co. uk...
I keep getting this error message, Compile Error: Method or Data Member
not found when trying to compile my access 2000 database ( I want to
make an MDE file) although I do not receive this error when compiling
the code from the same program in Access 2002 (XP)
I keep getting the error on Me.txtTracking, it DOES exist. I just can't
get my head around this problem, could anyone help me out?
code:
Private Sub cmdOk_Click()
Dim strsql As String
CurrentDb.Execute "Update [tblDownload] Set DESPATCHED = True, TRACKING
= """ & Me.txtTracking & """, DESPDATE = """ & Me.txtDate & """,
TODAYDATE = """ & Me.txtTodayDate & """, Courier = """ &
Me.cmbDeliveryMethod & """ Where ID = " & Me.txtOrderNumber & ";",
dbfailonerror
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & " DESPATCHED
AND ALLOCATED TRACKING #" & Me.txtTracking & "", 0
End Sub
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
Hi Allen,
Thanks for your help. I have failed on all accounts and I must put it down
to Access 2000 and AddItem. The first line is fine, it is the line below
that is the problem...
Me.StatusListBox.AddItem "ORDER # " & Me!txtOrderNumber & " DESPATCHED BY "
& Me!txtOrderNumber & "", 0
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42**********************@per-qv1-newsreader-01.iinet.net.au... Suggestions to debug this.
1. Break the line into parts:
strsql = "Update [tblDownload] Set DESPATCHED = True, TRACKING = """ &
Me.txtTracking
If that works, comment it out, and try:
strsql = "DESPDATE = """ & Me.txtDate
and so on, until if finds the offender.
2. If you are referring to a field that is present in the form's
RecordSource but it is not also a control on the form, try a bang instead
of a dot, e.g.:
Me!txtDate
The compiler is less stringent with the bang. There are cases where you
need to refer to an AccessField object like that in order for the code to
compile.
3. If neither of the above can trace the problem, it may be a Name
AutoCorrect problem. Details:
http://allenbrowne.com/bug-03.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:nN******************@fe3.news.blueyonder.co.u k... Hi Allen,
I have checked over doxens of times and they all exist.
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au... Hi Nick
You can get this error message if *any* of the controls referred to in
this statement are invalid. Access will often highlight one of the
controls that is too early.
For example, it could be txtDate that does not exist.
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:Sq*******************@fe3.news.blueyonder.co. uk...
I keep getting this error message, Compile Error: Method or Data Member
not found when trying to compile my access 2000 database ( I want to
make an MDE file) although I do not receive this error when compiling
the code from the same program in Access 2002 (XP)
I keep getting the error on Me.txtTracking, it DOES exist. I just can't
get my head around this problem, could anyone help me out?
code:
Private Sub cmdOk_Click()
Dim strsql As String
CurrentDb.Execute "Update [tblDownload] Set DESPATCHED = True, TRACKING
= """ & Me.txtTracking & """, DESPDATE = """ & Me.txtDate & """,
TODAYDATE = """ & Me.txtTodayDate & """, Courier = """ &
Me.cmbDeliveryMethod & """ Where ID = " & Me.txtOrderNumber & ";",
dbfailonerror
Me.StatusListBox.AddItem "ORDER # " & Me.txtOrderNumber & " DESPATCHED
AND ALLOCATED TRACKING #" & Me.txtTracking & "", 0
End Sub
--
Kind Regards...
Customer Services Team
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT
FOR REFERENCE +++
Blue Bell Trading
Maybe it's me, but I don't remember listboxes in A2K supporting the
..AddItem method. You'd have to bind the listbox to a table or
something and then refresh it. But then maybe I'm completely senile...
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bob Hairgrove |
last post by:
The following class contains start and end points of a range of
values. The range can have a direction which is implied from the
relative order of start and end, or it can be without direction. IOW...
|
by: Steven T. Hatton |
last post by:
In the following code, at what point is S::c fully defined?
#include <iostream>
using std::cout;
using std::endl;
using std::ostream;
class C {
int _v;
|
by: blueblueblue2005 |
last post by:
here is a friend function of Class Array, which has two private data
member: int size, int *ptr
// Array's public member function to return size
int getSize() const { return size; }
friend...
|
by: Thomas Paul Diffenbach |
last post by:
Can anyone point me to an open source library of /statically
allocated/ data structures?
I'm writing some code that would benefit from trees, preferably self
balancing, but on an embedded system...
|
by: Peter Olcott |
last post by:
I created an object that requires access to another objects data, yet have found
no good way to pass this data as a parameter because the member function that
requires this data must be a binary...
| | |
by: meetmaruthi |
last post by:
Hai i am searching a database (in ms access ) to validate user info.it has two fields username and password.
here is the coding and i get compile error:Method or data member not found.please help...
|
by: aarklon |
last post by:
Hi all,
this is a question which i saw in a book
typedef struct mall_li_header_ {
int refcnt;
uchar pool;
uchar flag;
ushort magic_no;
char data;
|
by: zaeminkr |
last post by:
I have class member data which is a pointer to class member function.
However, I'm fail to compile the code.
What is the correct grammar to make a function call by using static
member data...
|
by: almeister9 |
last post by:
I am hoping someone can help me as I've done this sort of thing before with no problems. I am using Access 2003 SP2 on WinXP prof SP2
I have an unbound form (single form view) with 18 unbound text...
|
by: akomiakov |
last post by:
Is there a technical reason why one can't initialize a cost static non-
integral data member in a class?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
