Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Change last,first name to first last name
I have 2 (hopefully) simple things i am trying to accomplish. 1. I have a field which is formatted: "LAST_NAME, FIRST_NAME". I would like to make the field be formatted: "FIRST_NAME LAST_NAME" (no comma just a space seperating them). 2. I have several fields containing dollar values (8.22...- MM889
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
searching for files with part of file name
PHV - Have a working solution now, thanks for helping me get started with a little code :)- MM889
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
searching for files with part of file name
Thanks for the quick replies! mintjulep - Can you point me towards some info on arrays? I haven't used them yet in any of the programming i have done.- MM889
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
searching for files with part of file name
Background: I have a folder full of pdf's that all have a "code" and a year in the name of the file that distinguishes what the file is. For example: File_1_HJ8DF_2010.pdf File_2_HLKSSSF_2011.pdf File_3_HJ99ISDF_2010.pdf I am trying to figure out a way using vba in access 2010 to search for...- MM889
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
