Hi Brett, I had similar problems when installing Access 2000 under Windows XP and after the matter. The problem was the Tech support made some changes to the server and one change I know that took place was "paths". Hope this helps
Mando................... --- In [email protected], Brett Collings <[EMAIL PROTECTED]> wrote: > Hi guys, another screwy problem with an installation has reared its head. > > We've been beating ourselves up for 3 weeks on this now, needless to say, > the client is not amused. In all that time, I thought we had an error in > our code, am beginning to think that's not possible. > > Client previously had Off97 on which our App worked fine. Off97 machine > died, new machine installed with WinXP and Off2003. Client is 600 miles > away. Computer guy installed our programme against instructions > in C:\Documents & Settings\[usename]\Application Data\ ...etc ...etc > > We converted the Acc97 version to 2002-2003 version. > We checked references on client machine, none missing, all the ones ticked > here on development machine match those on client machine. > Project is compiled. > > Programme halts with the following message > "The expression After Update you entered as the event property setting > produced the following error: You can't go to the specific record. VBA > encountered a problem while attempting to access a property or method. The > problem may be one of the following. > - reference missing > - an expression is misspelled." > > The break point is when trying to set focus on the subform with the > following code > > Sub cboLocationID_AfterUpdate() > ' Find the record that matches the control. > Me.RecordsetClone.FindFirst "[LocationID] = " & Me! [cboLocationID] > Me.Bookmark = Me.RecordsetClone.Bookmark > Me![cboLocationID] = " " > Forms!frmLocReadings!cldsfmLocReadContainer.SetFocus > Forms!frmLocReadings!cldsfmLocReadContainer.Form! cboSelTable.SetFocus > End Sub > > The application works perfectly on two WinXP/Off2003 machines we have here. > > The ONLY things I can think of now is > - Security settings on client machine > - They have some other Access version on there as well (what was that Font > issue?) > - The installed directory is causing the path to the object to exceed 256 > characters and somehow halting the programme. > > Guys, I am stuck and in a bad place with this now. > > Brett > > ------------------------------------------------------------------ > Be adventurous, be bold, be careful, be a star > > Brett Collings, Management Systems Developer > Managing Director > Corporate Arrangements Ltd > +64 21 414 196 > > > > > > > > > > > > > > > > > > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.323 / Virus Database: 267.8.11/44 - Release Date: 08/07/05 Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
