Re: Compile errors when using form control's "Control Source" property to refer to the control's value

From: Yarik Mezheritskiy (yarik_at_garlic.com)
Date: 11/04/04


Date: 4 Nov 2004 12:24:14 -0800

Thank you Allen! Your response is very helpful, indeed. (Especially
information about potential problems with using AccessField objects.)

There is at least one thing though that still is not clear to me: Why
could two installations of MS Access 2000 SP3 react differently on the
very same code in the very same project?

The code is in a subform and (as I know now) tries to reference an
AccessField object in the top-level form, like this:

    Me.PartID

Why one installation of MS Access 2000 SP3 accepts this expression
(and interpretes it as intended) at run-time, while the other
installation issues compile error? Maybe I need to install some
patch(es), service pack(s), whatsoever on the poor second computer?

FWIW: This is what I believe is currently installed on the "failing"
computer:

  - MS Access 2000 as a part of MS Office 2000 Professional SR-1
  - MS Office 2000 Service Pack 3
  - MS Office 2000 Developer SR-1

Maybe there is something else I need to install? Maybe I should have
been installing these things in some particular order or do some other
weird things (like, for example, installing MS Office 2000 Service
Pack 2 before installing MS Office 2000 Service Pack 3)?

Or is it simply a nature of quirks of MS Access compiler and
interpreter: to _rnadomly_ complain or not complain about certain
things?

Thank you,
Yaroslav.



Relevant Pages

  • Re: RANT ! SP2 !
    ... That's the bottom line and the service pack is only 3 months old and thus well within the tolerance window of not installing it on our systems. ... Open a command prompt. ... Server 2003 SP2 on a computer that is running Windows Small Business ...
    (microsoft.public.windows.server.sbs)
  • Re: services.exe nee fscan
    ... If your SQL SA password was blank, that makes me think you might not have ... the latest SQL service pack installed. ... Disabling NetBIOS and installing a firewall are like the first ...
    (microsoft.public.security)
  • Re: Unable to download Service Pack 3
    ... Things to do prior downloadin/installing SP3. ... 4.Run Disk Cleanup then run a Defrag session before installing SP3. ... Windows XP Service Pack 3 Overview ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Cant download SP2 -- IE 6 thinks Im off-line!
    ... you should ALWAYS have back-ups of all important data especially when installing something as major as a Service Pack. ... believe that installing SP2 is not unacceptably reckless. ... it started running on its own after the download. ...
    (microsoft.public.windowsxp.general)
  • Re: SP2 install
    ... > inconvenience, blah, blah and advising me that windows will restart. ... Did it boot and run after installing SP2 and then after some subsequent ... Windows XP Service Pack 2 Setup program is not completed successfully ... Get the Latest Updates and Information from Your PC Manufacturer Before ...
    (microsoft.public.windowsxp.general)