It is important to have the right "Reference" set and in the right order. I am never quite sure of which reference file needs to be involved but look under Tools -> References and see if "Microsoft Access 9.0 Object Library" is checked as a library reference and that it is as high as possible in your list of references.
In any case your problem is due to not having the right reference selected or it not being listed high enough in the list of references. Common enough issue. --- In [email protected], M Brovage <[EMAIL PROTECTED]> wrote: > > Whenever I use the trim, mid, etc, in a query I get an undefined function. At work these worked for this database and now at home I get the undefined message. > > I created a new query using trim, mid and I get the same message. > > What is happening? > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > [Non-text portions of this message have been removed] > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
