User Profile

Collapse

Profile Sidebar

Collapse
jackadams
jackadams
Last Activity: Dec 2 '13, 01:31 AM
Joined: Nov 24 '13
Location: Stow, OH, US
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • jackadams
    replied to PLEASE HELP!!! Error 53 / File Not Found
    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...
    See more | Go to post
    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.

    Leave a comment:


  • jackadams
    started a topic How Can I Encrypt Text

    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.
    See more | Go to post
    Last edited by NeoPa; Nov 25 '13, 11:28 PM. Reason: Split from original post in another thread.

  • jackadams
    replied to PLEASE HELP!!! Error 53 / File Not Found
    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
    ...
    See more | Go to post

    Leave a comment:


  • jackadams
    started a topic PLEASE HELP!!! Error 53 / File Not Found

    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
    ...
    See more | Go to post
No activity results to display
Show More
Working...