NeoPa,
Not sure what you mean when you stated "It seems that it would only work otherwise if the Current Drive & Directory point to the folder the file is stored in."
I use a browse4director y function to browse to the folder that the text files are located. I hope this is not an issue down the road!
Sorry about choosing as best answer... yes I am a newbie to forums, so my apologies. Even if it...
User Profile
Collapse
-
Last edited by NeoPa; Nov 25 '13, 11:35 PM. Reason: Please refrain from adding extra questions into an existing thread. Links are allowed but all questions should have their own threads. -
How Can I Encrypt Text
This thread was split from another (PLEASE HELP!!! Error 53 / File Not Found).
Do you have any sample code that will encrypt a 10-digit number using base 32? That is my next project! Any help would be GREATLY appreciated. Thanks in advance. -
Well, after hours of tooling around, I solved the issue. I had to change the following code in order for it to function properly... I will see if it works tomorrow!
Code:[B][I]FROM[/I][/B] SourceFile = Dir(strPath & "\SG*.txt") [B][I]TO[/I][/B] SourceFile = Dir(strPath & "\" & "*.txt") [B][I][U]AND[/U][/I][/B] [B][I]FROM[/I][/B] Open SourceFile For Input As #1
Leave a comment:
-
PLEASE HELP!!! Error 53 / File Not Found
Hello everyone. I had this code working last night, but then I closed the database and now it will not open the appropriate file "SourceFile ", which is a simple comma delimited text file that the user selects, for processing...
Here is the code that was working...
The line where it states the error is in BOLD font below...
Code:Private Sub SCANFILE_DECODER() DoCmd.setWarnings False
No activity results to display
Show More
Leave a comment: