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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parsing and Storing values in a specific field
Sorry, made some errors while translating my code in the early post. Here we go... Public Sub Oplos(Mystring As String) Dim pos(4) As Integer Dim MyValues(4) As String Dim i, j, counter, startpos As Byte counter = 0 For i = 2 To Len(Mystring) Step 1 If Mid$(Mystring, i, 1) = ","...- Passenger
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
how do I parse a string in acess by "," and put it in different fields
Hi, Maybe this code can help you with the parsing problem. Public Sub Oplos(Mystring As String) Dim pos(7) As Integer Dim MyValues(7) As String Dim i, j, counter, startpos As Byte counter = 0 For i = 2 To Len(Mystring) Step 1 If Mid$(Mystring, i, 1) = "," Then counter =...- Passenger
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Parsing and Storing values in a specific field
Hi, I've noticed that the use of the "#" isn't consistent - you can write some parsing code if you make sure that each line is starting with an "#" and is closed with a "#"; also be sure that between each value the delimiter-sign is used. Once you have done this...- Passenger
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
-
Map drive disconnect
A red cross shows on the mapping to the server(W2K). I know this happens after 15 or so minutes by default but there is a command that can set the default to never "disconnect" Thanx- Passenger
- Thread
- Replies: 2
- Forum: Microsoft: Windows servers
