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" <AllenBrowne@SeeSig.Invalid> wrote in message
news:4261ff7d$0$9233$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
> 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" <bluebelltrading@blueyonder.co.uk> wrote in message
> news:nNa8e.53400$mV1.9783@fe3.news.blueyonder.co.u k...[color=green]
>> 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" <AllenBrowne@SeeSig.Invalid> wrote in message
>> news:4261326f$0$18110$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=darkred]
>>> 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" <bluebelltrading@blueyonder.co.uk> wrote in message
>>> news:Sq68e.52955$mV1.51900@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[/color][/color]
>
>[/color]
