 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / January 2008Connecting Infopath form to Database
I have a database and have followed all the steps to create an infopath form to connect to this database. In the button properties, I have selected Submit but in the Submitting Forms dialog box, it has many things listed but not database. Now what?? I am a little new to IP, but if I can help I will. When you say 'Submitting Forms dialog box' do you mean Submit Options dialog box? What version are you using? 2003 or 2007? When you go to Tools > Submit Options is this the same window mentioned above? Did you try this? On the Tools menu, click Data Connections. In the Data Connections dialog box, click the main data connection, and then click Modify. In the Data Connection Wizard, click Next. On the next page of the wizard, select the Enable submit for this connection check box, and then click Finish. This is all I can think of right now. I am using the 2003 version. If you double click (button) you get the Button Properties. For my action I click "submit" and get the Submitting Forms dialog box, the same as that which is on the Tools menu. From the same dialog box I also select to "enable submit commands". At this point I am suppose to select from the "Submit to drop down, "Database" as stated in the Microsoft on line instructions. Problem is I do not have that as an option and cannot figure out why. > I am a little new to IP, but if I can help I will. > [quoted text clipped - 13 lines] > > This is all I can think of right now. Go to Tools and Data Connections and select the Main data connection. At the bottom it will list deatils, make sure it says receive and Submit. If it does not like your database structure, no primary key etc. It will not allow submit. This could be the issue.  SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > I have a database and have followed all the steps to create an infopath form > to connect to this database. In the button properties, I have selected > Submit but in the Submitting Forms dialog box, it has many things listed but > not database. Now what?? I do have a primary key on my database and when I check the details, it does say retrieve data from database but not submit so I must have done something wrong. I seem to recall at one point I got some type of message saying the Submit button could not be enabled. I am going to start my form all over and see if I can make it work. > Go to Tools and Data Connections and select the Main data connection. At the > bottom it will list deatils, make sure it says receive and Submit. [quoted text clipped - 6 lines] > > Submit but in the Submitting Forms dialog box, it has many things listed but > > not database. Now what?? A database type form only allows one set of tables. If you need to update multiple tables then you have to use web services. You may want to look at the Database Accelerator package. It is an installable set of web services that allow you to query and submit multiple tables without code. You can find out more at http://www.qdabra.com SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > I do have a primary key on my database and when I check the details, it does > say retrieve data from database but not submit so I must have done something [quoted text clipped - 12 lines] > > > Submit but in the Submitting Forms dialog box, it has many things listed but > > > not database. Now what?? Thanks verymuch to you and everyone who responded. I was able to get it set up exactly as I want, and of course it was my table construction as well as the need for primary keys. I do have another question that is un-related so I will post that separatley if I cannot find a similiar post. Thanks again. > A database type form only allows one set of tables. > [quoted text clipped - 22 lines] > > > > Submit but in the Submitting Forms dialog box, it has many things listed but > > > > not database. Now what?? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.