Newbie Questions

Re: Accessing an Access DB

Taffman — Thu, 04 May 2006 09:51:47 GMT

Hears a real dumb question, but I'll ask it anyway. I totally understand how to create a secondary XML data source and it works well for me locally.

When I get round to publishing by form on sharepoint, are the secondary datasources added to my form embedded in the form and therefore will move with the form when I publish, or co I have to copy these datasources seperatly to the sharepoint (or other)location.

Second dumb question, if the secondary data source is an Access Database, is this type of datasource also embedded in the form as per XML or should this be moved seperatly?

Re: Accessing an Access DB

Jerry — Mon, 01 May 2006 19:04:22 GMT

Matt.... when I enter the following code, per your example, I get an error message which says... "Object required". There must be something wrong with the code? Line 24... where it starts out as "oQueryID.text = eventObj.Source.selectSingleNode...

// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of arguments.
//=======
function btnViewDetail::OnClick(eventObj){var oQueryId = XDocument.DOM.selectSingleNode
("/dfs:myFields/dfs:queryFields/q:Customers/@CustomerID" );
oQueryId.text = eventObj.Source.selectSingleNode("@CustomerID").text;
XDocument.Query();
XDocument.View.SwitchView("Detail");}

Re: Accessing an Access DB

Jerry — Thu, 27 Apr 2006 21:39:24 GMT

Matt... in your tutorial... in the section where you said to "Add code behind the View Detail button", I apparently are not performing Step 3 correctly. That's where I am to replace the contents of the
OnClick event handler with your code. Currently the template reads as
"function btnViewDetail::OnClick(eventObj)
{
// Write your code here
}

What do I need to remove? Do I insert your code you suggested into the area where it says "// Write your code here"?

Re: Accessing an Access DB

Jerry — Thu, 27 Apr 2006 18:11:56 GMT

Thanks SO MUCH guys.... I'll check it out. :-)

Re: Accessing an Access DB

Matt Faus — Thu, 27 Apr 2006 17:32:35 GMT

Hi Jerry,

Check out this tutorialhttp://infopathdev.com/howto/tutorials/default.aspx?i=0bb37b4de44348408680a53a449f2353 , especially the instructions under "Add a supplementary data connection to the same database"

Re: Accessing an Access DB

Ted Fitch — Thu, 27 Apr 2006 17:29:16 GMT

Hi Jerry,

You can use a secondary data source (your Access DB located on a different shared server) to do this.

Here is a really good how-to that Matt Faus wrote that I think should point you in the right direction:

http://infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85

Good luck!

Ted

Accessing an Access DB

Jerry — Thu, 27 Apr 2006 14:44:54 GMT

Please forgive me if the answer to my question has already been answered, but I could not find the answer, so here goes:

I created a nice Purchase Order form using InfoPath, and placed it on our Sharepoint site. I now need to access an Access DB, located on another shared server. The data in the Access DB is for budgeting purposes, the Purchase Orders are cut against say 100 Budget items, containing some data I want to be able download into some fields in my form. When I connect to the Access DB, I would want all of the 100 Budget items to be listed, then be able to select the one I want by clicking on the item and have the data in that item populate 5 Read Only fields in my form. For example, the Access DB would look something like this:
Budget PO#, Activity #, Category, Budget Amt, Avail Bal
14700069999, 001, EQOFF, 1500.00, 750.00
14700063621, 001, EQOFF, 3000.00 3000.00
14700067895, 001, EQOFF, 2000.00 0.00

Can someone point me in the right direction to figure out how to do this? I don't care about updating the DB, just to see all the items in it, select the applicable Budget PO#, and download the data in that PO into my InfoPath form.