Initiate a ColdFusion page from an Microsoft Access Form

[ljevans]

I have a shipping application using an Access front end and a SQL 7.0 back end. I would like to use CFHTTP to track the package sent by UPS, FedEx and Airborne. I have successfully connected to each carrier's tracking page. Now I would like to initiate the tracking from the Access Shpping Memorandrum form where the tracking number is located. How can I initiate ColdFusion from an Access from?

 

[twcman]

If I am not missing something, you could use the cf page as your action= in the form tag. The only dumb questions are the ones that are never asked

 

[philhege]

ljevans,

Read up on VBA. You can construct a string with the URL and associated querystring variables, and submit it to IE to open in a separate process.

Or, you could add the browser object to your form, and submit the string to it. (We do this in Visual FoxPro, so the code's different.) Works great.

Good luck, and happy coding,
PH

 

[ljevans]

Access has a Browser object? What is it called and where do I find it?

 

[philhege]

Looks like. Read this post:

http://www.visualbasicforum.com/t34266.html

Have fun!