User Profile

Collapse

Profile Sidebar

Collapse
jvborg
jvborg
Last Activity: Mar 31 '09, 07:16 AM
Joined: Oct 13 '08
Location: Gibraltar
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jvborg
    replied to Running .bat from Access
    in Access
    I got it working!
    Thanks for all of your help, but it wasnt the code which was the problem lol!
    After all of that i used a simple VBA.Shell command to run the .bat file. The problem was that because the .bat was being run from a network folder, when the command prompt was appearing it was trying to run the file using a UNC path name. The command prompt does not accept the UNC path and the command prompt was reverting to my c: drive...
    See more | Go to post

      Leave a comment:

    • jvborg
      replied to Running .bat from Access
      in Access
      Hi ADezii,

      Thank you for the demo and the previous post, they were brilliant and i wish i could say that they worked, but again the command prompt is opening and closing straight away and without retrieving/writing anythin to the output.txt file. Im unsure of what else i can do. The .bat file is in a network mapped file, and is completely functional when clicked and when executed from Run on the windows Start menu. The .bat file works...
      See more | Go to post

        Leave a comment:

      • jvborg
        replied to Running .bat from Access
        in Access
        Could you please give me an example of how to do this, because i have never used this function before and am unsure on hw to use it. I have tried a few various methods but it keeps on returning the same errors. I used the following code but it comes up with "Compile error: Expected ="...
        See more | Go to post

          Leave a comment:

        • jvborg
          started a topic Running .bat from Access
          in Access

          Running .bat from Access

          I am trying to run a .bat file from access. On the click of a search button (btnSearch) I incorperate data entered into a text box (txtSearch) to print a script into a text file (script.txt). The .bat file which i am trying to execute uses this script, telnets to a remote computer and creates another text file with the output from its findings.
          Currently the script is being written to the file without any problems, but the command prompt for...
          See more | Go to post
          • jvborg
            started a topic Run Time Error 2110: cant move the SetFocus control
            in Access

            Run Time Error 2110: cant move the SetFocus control

            I am experiencing a problem when trying to move the setfocus to text field txtSearchDump, if i do not place the text into this field the query which i am initially trying to run does not execute. Any advice would be very helpful

            Thanks
            Joe

            Code:
            Select Case Me.optSearchCriteria.Value
        Case 1
            strSQL = strSelect & strFrom & strTitle
        Case 2
            strSQL
            ...
            See more | Go to post
            Last edited by Stewart Ross; Oct 13 '08, 11:21 AM. Reason: Please use the code tags provided
            No activity results to display
            Show More
            Working...