If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I am using Window 7 and Access 2007
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. |
#2
|
|||
|
|||
I am using Window 7 and Access 2007
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. |
#3
|
|||
|
|||
I am using Window 7 and Access 2007
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" wrote in message ... 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. |
#4
|
|||
|
|||
I am using Window 7 and Access 2007
Thanks
Can you send me a copy of the code. I am using Access 2007 in window 7 Thanks again Al "Jerry Whittle" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|