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/
