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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: GISnunavut
- Order by date
-
Array from an Array
Thanks All; I used MajP's advice; Access query for the null strings and names without % and @, then slightly modified the subroutine to get the name with % and @. Then ran an append query on all.- GISnunavut
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
-
Array from an Array
Let me repost the code... Function LastName_Split() Dim dbs As Database Dim rst As DAO.Recordset Dim strRst As String Set dbs = CurrentDb strRst = "SELECT Collection_Step_Two.Borden_Number, Collection_Step_Two.Collection_Event...- GISnunavut
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Array from an Array
kjv1611: Thanks for this. However, for reasons down the road (processing-wise) I need all records in the new table... Let me explain it alittle better: Right now there are 12546 records; of those, the LAST_NAME column has 45 NULL records, 11732 records have "Smith" or "Jones" or "Arundale" or...- GISnunavut
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Array from an Array
All: My first time posting. I'm using DAO in MS Access 2003. Here's the story...I have a table called Collection_Step_Two with 8 columns and 12546 records. I'm attempting to create another table "Collection_Step_Three" from all data in "Collection_Step_Two". However, in the source table, the...- GISnunavut
- Thread
- Replies: 9
- Forum: Microsoft: Access Modules (VBA Coding)
