Pass argument from command button on Access form to python script

Question

Using Access 2010 and python 2.7.8

Have a command button on Access 2010 form. I am trying to pull the value from the Field1 text box and pass it to a python script. I am struggling with passing the variable. Commented out stuff is other things I tried.

Value in Field1 Text box is:

C:\\tests\\Project

VBA behind command button:

Private Sub Command0_Click()
    arg1 = """" & Field1 & """"
    'arg1 = Field1
  Debug.Print arg1
    'Call Shell("C:\\Python27\\ArcGIS10.3\\python.exe " & "C:\\tests\\Test.py " & "C:\\tests\\Project", vbNormalFocus)
    Call Shell("C:\Python27\ArcGIS10.3\python.exe " & "C:\tests\Test.py " & arg1, vbNormalFocus)
End Sub

Python code is:

import os.path

#fp = "C:\\tests\\Projects"
fp = argv[1]
os.makedirs(fp)

Superfy · Accepted Answer · 2015-06-15 00:55:39Z

1

Try the following in Python

# should be sys.argv[1]
sys.argv[1]

You may want to utilise os.path.join to be certain where your makedirs are going

import os
import sys

sys.argv[1]
fp = r'c:\test'
os.makedirs(os.path.join(fp,sys.argv[1]))

THE VBA in Excel - works for me...

Private Sub test()
    arg1 = Range("A1").Value
    Debug.Print arg1
    Call Shell("""C:\Python27\python.exe"" " & """c:\test\test.py"" " & """arg1""", vbNormalFocus)
End Sub

edited Jun 15, 2015 at 0:55

answered Jun 12, 2015 at 23:56

Superfy

3512 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user12059 Over a year ago

No this did not work. The command button is executing the python script but the argument is still not getting passed and or recognized.

user12059 Over a year ago

The command fp = r'c:\test' did not seem to do anything since the argv[1] passes the entire pathname. I changed it to fp = r'c:\monkey' and the program still ran and no directory named monkey was created. What is intent of this command? Otherwise your suggestions did work. I am not sure why it didn't this past weekend. Maybe I missed something in my code.

Superfy Over a year ago

r'c:\test' the r indicates that it is a raw literal string, '\' and such is treated as backslash. Otherwise \t \n \r maybe read as tab, new line or return carriage... But if you are passing the string it doesn't matter really...

user12059 · Accepted Answer · 2015-06-15 17:17:36Z

0

Thanks go to Superfly. Need to import sys into python script and make fp=sys.argv[1].

Access VBA

Private Sub Command0_Click()
    argv1 = Field1.Value
    Debug.Print argv1
    Call Shell("C:\Python27\ArcGIS10.3\python.exe " & "C:\tests\Test.py " & argv1, vbNormalFocus)
End Sub

Python

import os.path
import sys

fp = sys.argv[1]
os.makedirs(fp)

answered Jun 15, 2015 at 17:17

user12059

7472 gold badges14 silver badges27 bronze badges

Collectives™ on Stack Overflow

Pass argument from command button on Access form to python script

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related