linking access to a web form/protx

[DeanRowe]

Hi,

Any help on this matter would be greatly appreciated as it is a problem that we have been living with for a long time.

Heres the problem....

I have an Access database that stores our customers details, aswell as the details of the products that they are ordering from us.

We process all of our payments over the telephone, and use a Payment Service Provider called Protx to process their card details. The process is quite straight forward, we simply log on to a secure website, then copy and paste their name, address, post code, and credit card details into the web form. Our database and the webform have exactly the same fields.

However it is quite a time consuming process, having to keep switching between our browser and database windows for 5 different fields, and when it's done 50 times a day it adds up to alot of time spent.

Does anyone know if there is a way of cutting down this process, for example being able to copy and paste all of the fields in one go from our database form, into the webform? Or possibly know of a programme that can allow me to do this?

I have spoken with friends who have told me that it may be possible to use our access database as an internet browser, would enabling this allow the problem to be fixed somehow?

Any help on this matter would be greatly appreciated.

Kind Regards

Dean Rowe

 

[ByteMyzer]

Using Access to instantiate an Internet Browser for copying and pasting information into a secure web form is a rather long way around. You might ask Protx's Tech Support group if they offer an XML API interface. By this means you would be able to create an XML object with the necessary input data and transmit it to the secure connection in Visual Basic within Access.

 

[DeanRowe]

Thank you for your response ByteMyzer, I've emailed Protx's customer support department asking if they do offer an XML API interface. It's something that I don't have a clue about in complete honesty, but if it's possible then I will certainly be learning it!

Thanks for your help

Dean