MartyConnelly
martyconnelly at shaw.ca
Sun Mar 13 01:29:14 CST 2005
You could be right; might be pointing at DAO 3.6 from 2000 and DAO 3.51 for 97 Or a missing newer version of ADO if running on Win 95 Andy Lacey wrote: >Kathryn >Sounds to me like References. It's just not finding the Trim function. If >you pu, say, a Left function in one I'll bet you get the same. Check the >References. > >-- Andy Lacey >http://www.minstersystems.co.uk > > > >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >>Kathryn Bassett >>Sent: 13 March 2005 05:01 >>To: 'Access Developers discussion and problem solving' >>Subject: RE: [AccessD] 2000 vs 97 - trim error >> >> >>No recompile because I didn't use any macros etc so didn't >>think about it. Too late to do it in 2k as she's now making >>changed in 97 version. So, what menu and command needs to be >>one on the 97 version to "compile" it? >> >>-- >>Kathryn Rhinehart Bassett (Pasadena CA) >>"Genealogy is my bag" "GH is my soap" >>kathryn at bassett.net >>http://bassett.net >> >> >> >>>-----Original Message----- >>>From: accessd-bounces at databaseadvisors.com >>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >>>MartyConnelly >>>Sent: 12 Mar 2005 4:58 pm >>>To: Access Developers discussion and problem solving >>>Subject: Re: [AccessD] 2000 vs 97 - trim error >>> >>>I opened up the 97 version mdb, reports are okay on my >>>machine I am running WinXP Home Access 97 SR-2 and Jet SP 8 >>>It could be Service Packs or did you remember to do a full >>>recompile of 2000 before converting to 97 >>> >>> >>>Kathryn Bassett wrote: >>> >>> >>> >>>>Friend has Access97, and the data she's been using for a >>>> >>>> >>>couple years now has been working fine. She received a new >>>grouping of people, so I brought her 97 home, opened with 2k, >>>imported and set up the new table (members), made a query and >>>set up one of the reports. Everything working fine in 2k. Did >>>the save to previous version, went to her house and put back >>>on computer. Queries and forms work fine, but when I tried to >>>do reports, the all give me this trim error. >>> >>> >>>>http://www.ourwebsite.org/storage/misc/trimerror1.jpg and >>>> >>>> >>>here is what >>> >>> >>>>the design view looks like >>>>http://www.ourwebsite.org/storage/misc/trimerror2.jpg >>>> >>>>All the reports are similar, and give the same error, even >>>> >>>> >>>though I never touched them. So it must be something about >>>taking from 97 to 2k and back again that messed things up. >>>What's wrong and how do I fix? >>> >>> >>>>If you need to see the actual mdb, I've zipped both versions >>>> >>>> >>>and put them here: >>> >>> >>>>http://www.ourwebsite.org/storage/misc/pgch.zip >>>> >>>>Thanks, >>>> >>>>-- >>>>Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my >>>> >>>> >>>bag" "GH is my >>> >>> >>>>soap" >>>>kathryn at bassett.net >>>>http://bassett.net >>>> >>>> >>>> >>>> >>>> >>>-- >>>Marty Connelly >>>Victoria, B.C. >>>Canada >>> >>> >>> >>>-- >>>AccessD mailing list >>>AccessD at databaseadvisors.com >>>http://databaseadvisors.com/mailman/listinfo/accessd >>>Website: http://www.databaseadvisors.com >>> >>> >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >> >> >> > > > -- Marty Connelly Victoria, B.C. Canada