[AccessD] 2000 vs 97 - trim error

Andy Lacey andy at minstersystems.co.uk
Sun Mar 13 01:16:11 CST 2005


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
> 
> 




More information about the AccessD mailing list