mapping with auto route

[rberbe2002]

hi i have a form with the following two text boxes:

postcode_start
postcode_end

and a button with

get route

wat i want to do is from the access form, when the two postcodes have been entered automatically use autoroute and calculate the route.

thanks for the help in advance

 

[Dennisk]

you will have to use a shell command to execute and if autoroute can be run from the command line and accept postcodes then it can be done.
Look up the help on Shell and ShellExecute

 

[rberbe2002]

Public Function AutoRoute()

Shell "C:\Program Files\Microsoft AutoRoute\AutoRout.exe", vbNormalFocus

SendKeys "^R", True

End Function

whats wrong with the above? it opens autoroute but ctrl+r does not work?

 

[Dennisk]

I don't know what control R does in autoroute. does autoroute except command line parameters and if so will it accept post codes?

 

[rberbe2002]

it starts the

route planner