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!
-
Subscript out of range problem
I consulted my brother-in-law who offerred this up and it did the trick. 'Check to see if line was split and last character duplicated If UBound(IPStringOut) < 7 Then If i < UBound(TempDetailsA) Then If StrComp(Right(TempDetailsA(i), 1)...- gotinput
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Subscript out of range problem
I understand that (or think i do), is there a way to have it pick up where it left off? Or check for the presence of an element 1 before trying to set the variable equal to it?- gotinput
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Subscript out of range problem
Given the following input: IP: 10.0.0.1 MAC: 00:11:22:33:44:55 computername.dns.root IP: 11.0.0.1 MAC: 00:11:22:33:44:56 computer2.dns.root the below script works great, however when the input is corrupted from another process and the data comes out: IP: 10.0.0.1 MAC: 00:11:22:33:44:55...- gotinput
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
