WILL SOMEONE PLEASE HELP?

[crashoverride]

I've posted before and got no response, I was hoping to give this one more
try. Here is my problem:

I am using Infopath to create forms that send and receive data from a
Microsoft Access database. When I designed the Access database a while back,
I created a form in the database that has code which performs somewhat
complicated calculations upon the press of a button in the form (using DAO).

I am now creating a form in Infopath that I wish to carry out the same
calculations. Instead of re-writing code in XML (which I know nothing about),
I am trying to figure out the necessary steps/code that I can use to trigger
the click event of the button in my Access form upon the click of a button in
my Infopath form.

Any help would be much appreciated. Thanks!

 

[Josh Bertsch [MSFT]]

I am not familiar with Access at all, but for button in InfoPath to interact
or run code in Access, you will have to write code on the buttons onClick()
event and probably call into the Access OM. So either way you will probably
have to write a good chunk of code.

--josh bertsch

 

[Tom Curtin]

I just wanted to point out that the code in access is probably vba, which
means most of it could be pretty readily moved to be vbscript in InfoPath.
Remember InfoPath supports jscript, vb script and VB.NET (Visual Studio) so
you really aren't talking about "redoing code in XML"