Andy Lacey
andy at minstersystems.co.uk
Thu May 20 02:15:22 CDT 2004
Hi Darren Sounds to me like a references issue. The failure of Left() and Len() functions is a classic symptom of References. Check for missing refs - if none, try unticking, saving, reticking and saving. I feel sure the problem's in there somewhere. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK > Sent: 20 May 2004 05:52 > To: AccessD List > Subject: [AccessD] A2K: Code Failures on Win 98 Machine > > > Hello all > I have 2 issues still outstanding with my latest app. On win > XP or Win 2000 boxes the > following code snips work fine. All machines are WIN 98 and > WIN2000 and > WIN XP boxes (No Win 95 or Win ME) all running Office 2000 > In fact the Office 2000 install is off the same MS Office > 2000 install disk - <sigh> But the code snips fails only on > the Win 98 machines > > Anyway here is the snip that fails in WIN 98 - but is cool in > WIN2000 and WINXP strSkinsPath = Left(CurrentDb.Name, > Len(CurrentDb.Name) - Len(Dir(CurrentDb.Name)) - 1) & > "\Skins\" & strSelectedSkin & "\" > > But of course the "hard coded" following snip below in place > of the one above does work on all OS's strSkinsPath = > "C:\Program Files\TruMan\Skins\" & strSelectedSkin & "\" > > Also I am getting failures with the bookmark property in the > Win 98 boxes. Same Access/Office version just different OS > > Basically I have a combo box on a student form to use for a > search tool. You pick a student name from the combo on the > footer of the Student Form Then using .findfirst and > .bookmark I can (normally) go to the record. > But it fails on the Win98 boxes and throws me out of the app > and on occasion needs a re-boot. So to that end - does anyone > have any .findfirst and .bookmark code that works with a WIN > 98 box? Even code to determine .AbsolutePosition would be > fine. I can then use docmd.gotorecord stuff Many thanks in advance > > Darren > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > >