=Trim problem

[mlstewart]

I've created a database where I use the Trim feature quite a bit (especially in mailing address). Everything was working perfectly. I packaged the database with a run-time version of Access using the packaging wizard in the XP developer's edition. Now, it is like Access doesn't recognize Trim. I've got some text boxes on a form that use it and all that is displayed is "#Name?" and I also have some reports (record source is a query) where I use Trim and when I try to open one of the reports, it prompts me to enter a paramater value for Trim. These problems started when I packaged it with the run-time version. Can someone please helps me with this!! I don't know what to do. Everything worked perfectly before it was packaged.

Thanks,
ML

 

[LittleSmudge]

I'm not an expert on 'packaging for run-time' but when I've come across those sorts of problems before ( VBA not recognising simple functions like Left, Trim, etc ) then it has been because a DLL library was missing from the list.

If Access can't find a DLL it seems to forget lots of other things besides ( The libraries that are lower than the missing one in the priority list. )


Are you sure that you linked in all of the necessary libraries when you made the package for run-time ?









G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[mlstewart]

No, I am not sure. That was my first time ever using it. Do you have any suggestions or advice?

Thanks,
ML

 

[LittleSmudge]

Go back to the working database and open the code window.

Then from the tools menu select references

make a note of all those items ticked.



Then, when you put the Runtime package together you need to make sure that all of the necessary library files are included in your package.





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[mlstewart]

Ok, I will try that. I will let you know it turns out.

Thanks,
ML