=trim ... "ted" <n6trf[ at ]arrl.net> 11/13/2008 8:00:22 PM Suddenly one of our pc fails because it cant find the trim function. Went to the references for vb & they all were the same. They tried to reload office xp but that didn't help. Got any ideas? TIA -- _______________________________ In Christ's matchless name ted n6trf

Re: =trim ... "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 11/14/2008 12:46:36 PM When you say that the references were the same, are you sure that there wasn't a "MISSING:" in front of one (or more)? One thing to try is add another reference at random, back out of the dialog then go back in and delete the reference you just added. Another is to unselect as many of the selected references as you can (Access won't let you unselect them all), back out of the dialog then go back in an reselect all of the references you unselected. (Remember to write down the references you unselected, because they'll be in a different order when you back in!) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "ted" <n6trf[ at ]arrl.net> wrote in message news:%234YD3pcRJHA.4504[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > Suddenly one of our pc fails because it cant find the trim function. Went > to the references for vb & they all were the same. They tried to reload > office xp but that didn't help. Got any ideas? TIA > > -- > _______________________________ > In Christ's matchless name > ted n6trf >

Re: =trim ... "n6trf" <n6trf[ at ]arrl.net> 11/20/2008 6:07:17 PM Ok thanks for the comeback. We had a duplicate copy of our front end & when we executed that one the 'trim' went away. Evidently something corrupted in the front end. "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> wrote in message news:%23yaDKclRJHA.4084[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > When you say that the references were the same, are you sure that there > wasn't a "MISSING:" in front of one (or more)? > > One thing to try is add another reference at random, back out of the > dialog then go back in and delete the reference you just added. > > Another is to unselect as many of the selected references as you can > (Access won't let you unselect them all), back out of the dialog then go > back in an reselect all of the references you unselected. (Remember to > write down the references you unselected, because they'll be in a > different order when you back in!) > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "ted" <n6trf[ at ]arrl.net> wrote in message > news:%234YD3pcRJHA.4504[ at ]TK2MSFTNGP02.phx.gbl... >> Suddenly one of our pc fails because it cant find the trim function. Went >> to the references for vb & they all were the same. They tried to reload >> office xp but that didn't help. Got any ideas? TIA >> >> -- >> _______________________________ >> In Christ's matchless name >> ted n6trf >> > >