R
RCastellanoNH
What I am looking to do is enhance a single button to submit a form to a form
library, open an Access Dbase and close the existing InfoPath 2003 form.
BACKGROUND: I built a "worklist" in SPoint to collect change requests from
individuals.
I currently have a "submit" button that works 100% and sends the form via a
data connection to SharePoint and gives a happy "thank you message" but now I
need to launch an Access Database and close the IP03 form at the same time.
The link to the database is on a internal shared drive, (
\\Sfaxx28\16compd\SchedulingDB\Scheduling.mdb). There is no available
"action" on the button rules to open a hyperlink on the button except through
code. I was looking at the "OnClick" event handler for this button (which I
have labeled as "CTRL 36") but I cannot seem to get it to work. The VB code
I've used in Access to do the same function is not working here.
I know to both launch the hyperlink and submit with just one button click
you have to use code. I also know that this code can just call the same data
connection I have setup, I just cannot figure out how to do it as I am not a
developer. I figured out where to insert the code in InfoPath but not what
the code should be. I have not been able to find any related matter to the
subject and I'm hoping somone can help. I'm new to the blogosphere, and
InfoPath. I don't have access to any resources besides the Microsoft Office
InfoPath books.
Any assistance is greatly appreciated as I am quickly running out of
options, tools and time.
I look forward to anyones response.
Kind regards,
Rocco Castellano
Data Analyst II
library, open an Access Dbase and close the existing InfoPath 2003 form.
BACKGROUND: I built a "worklist" in SPoint to collect change requests from
individuals.
I currently have a "submit" button that works 100% and sends the form via a
data connection to SharePoint and gives a happy "thank you message" but now I
need to launch an Access Database and close the IP03 form at the same time.
The link to the database is on a internal shared drive, (
\\Sfaxx28\16compd\SchedulingDB\Scheduling.mdb). There is no available
"action" on the button rules to open a hyperlink on the button except through
code. I was looking at the "OnClick" event handler for this button (which I
have labeled as "CTRL 36") but I cannot seem to get it to work. The VB code
I've used in Access to do the same function is not working here.
I know to both launch the hyperlink and submit with just one button click
you have to use code. I also know that this code can just call the same data
connection I have setup, I just cannot figure out how to do it as I am not a
developer. I figured out where to insert the code in InfoPath but not what
the code should be. I have not been able to find any related matter to the
subject and I'm hoping somone can help. I'm new to the blogosphere, and
InfoPath. I don't have access to any resources besides the Microsoft Office
InfoPath books.
Any assistance is greatly appreciated as I am quickly running out of
options, tools and time.
I look forward to anyones response.
Kind regards,
Rocco Castellano
Data Analyst II