Trim text box causing error?

[lawsonium]

Hi all, this is my first post, I'll try and make it a good one

System:
Windows 2000
Office 2000

I have a small network of PC's here which have access to our central database. I have a simple form created using the label wizard which is used to print address labels for mailing lists.
On most of the PC's here it works fine but on one or two (which have no obvious difference in thier setup) I get an "ODBC--Call Failed" error and it won't run the report????
I have puzzled over this for a while when I decided that I would remove the Trim function from the lines of the address fields on the label, these are put in automatically by the label wizard. This stopped the error message and the reports now run.
I don't know why this is happening but I am hoping someone will.

Thanks,

Matt.

 

[MaliciousMike]

before anyone else says it:

You shouldn't give more than one person access to the same database.
Use the database you have currently as a backend, and create a front end (a replica) which links to the tables in the backend.

This probably has nothing to do with your problem, but having more than one person accessing the database can cause corruption.

 

[lawsonium]

Thanks for the advice but it's no problem, this is purely a front end access application which references a MySQL database on our central server.

The ODBC error (which isn't an ODBC error) if you see what I mean, still persists. Well, only if I leave the Trim function in :-/

Thanks,

Matt.

 

[lawsonium]

Anyone got any ideas on this?

I am imagening that it is something that either the Windows installation is missing or the Office installation being as some PC's don't have the error and others do!

The Trim function only removes white space from either end of the string so I don't think it's vital but I would like to know whats going on nicase this affects something more important.

Regarsd,

Matt.

 

[lawsonium]

Ok, amendment to the above.
I just realised I posted this in the wrong forum, this should be in the reports forum as the text box with the trim function is in the report and not the form and it was removing it from the report which stopped the error.

Can I move this post to the Reports forum or can a moderator do it?

Thanks,

Matt.

 

[lawsonium]

Anyone?

Matt.

 

[gemma-the-husky]

it might be a library reference.

in the user thats working ok, open a code module, then click in the toolbar

tools, references,

trim is probably in one of the libraies

either microsoft access
or VBA.

check the references for the dbs thats failing