I am using Window 7 and Access 2007
in [Getting Started]
|
From: Als Hotmail on 19 May 2010 15:43 The trim function gives me a compiler error SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " " & [Members]![MiddleName] & " " & [Members]![Suffix] & " " & [Members]![Title]) The function works using windowXP & vista Any suggestions would be helpful.
From: Jerry Whittle on 19 May 2010 16:26 In the VB window, type the following in the Immediate pane: Debug.Print Trim(" 1 " ) If you get an error, then it's probably a References issue. Go up to Tools, References and see if anything is amiss there. If it does work, there may be something wrong with your SortName. Simplify by removing some of the fields in it and see what works and doesn't work. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Als Hotmail" wrote: > The trim function gives me a compiler error > > SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " " & > [Members]![MiddleName] & " " & [Members]![Suffix] & " " & [Members]![Title]) > > The function works using windowXP & vista > > Any suggestions would be helpful. >
From: Als Hotmail on 19 May 2010 17:59 Debug.Print Trim(" 1 " ) works in the VB window. When I put in a query grid sortname: trim(" 1 ") I get the error message compile error in query. Any other suggestions? Thanks Al "Jerry Whittle" <JerryWhittle(a)discussions.microsoft.com> wrote in message news:4DE009EA-30D1-4FF5-AA0C-702733F35972(a)microsoft.com... > In the VB window, type the following in the Immediate pane: > > Debug.Print Trim(" 1 " ) > > If you get an error, then it's probably a References issue. Go up to > Tools, > References and see if anything is amiss there. > > If it does work, there may be something wrong with your SortName. Simplify > by removing some of the fields in it and see what works and doesn't work. > -- > Jerry Whittle, Microsoft Access MVP > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > "Als Hotmail" wrote: > >> The trim function gives me a compiler error >> >> SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " " >> & >> [Members]![MiddleName] & " " & [Members]![Suffix] & " " & >> [Members]![Title]) >> >> The function works using windowXP & vista >> >> Any suggestions would be helpful. >>
From: Als Hotmail on 19 May 2010 18:01 Thanks Can you send me a copy of the code. I am using Access 2007 in window 7 Thanks again Al "Jerry Whittle" <JerryWhittle(a)discussions.microsoft.com> wrote in message news:4DE009EA-30D1-4FF5-AA0C-702733F35972(a)microsoft.com... > In the VB window, type the following in the Immediate pane: > > Debug.Print Trim(" 1 " ) > > If you get an error, then it's probably a References issue. Go up to > Tools, > References and see if anything is amiss there. > > If it does work, there may be something wrong with your SortName. Simplify > by removing some of the fields in it and see what works and doesn't work. > -- > Jerry Whittle, Microsoft Access MVP > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > "Als Hotmail" wrote: > >> The trim function gives me a compiler error >> >> SortName: Trim([Members]![LastName] & ", " & [Members]![FirstName] & " " >> & >> [Members]![MiddleName] & " " & [Members]![Suffix] & " " & >> [Members]![Title]) >> >> The function works using windowXP & vista >> >> Any suggestions would be helpful. >>
|
Pages: 1 Prev: How do I append non-matching records Next: Queries to reduce a set of data pairs |