 |
 | 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 / August 2006Yet another infopath/access question
Hello, I have read some posts about this issue but it seems that everytime it doesn't fit my needs.... I have a simple form that uses a local access access (no SQL) db to gather an autonumber (no webservice). This, I have managed to do :). Now, when the user saves the form, I want to insert a row in the access DB so that when he opens the template again, it will have the next number. This is where things start to get complicated. I do not have the possiblity to submit to a access db in the GUI so I am pretty sure I need to do that programatically. Is there a soul that can point me to the right functions to use? or better some nice articles or even better for some code :9 Thanks Paulo If your form is not bound to the MS Access db, you'll have to use either a web service or ADO code to insert the record into the db. --- S.Y.M. Wong-A-Ton > Hello, > [quoted text clipped - 12 lines] > Thanks > Paulo Hello, "Not bound", how can I bound it? I kind of thought I needed ADO code... do you know where I can find examples? Thanks you Paulo > If your form is not bound to the MS Access db, you'll have to use either a > web service or ADO code to insert the record into the db. [quoted text clipped - 17 lines] > > Thanks > > Paulo When you create a new form and choose "New from data connection" and then select a db connection, your form will be bound to a db. I don't think you can bind a form to a database after it has already been created. No special ADO code is needed for InfoPath. You should be able search on Google to find ADO code that writes to a database. This article (http://support.microsoft.com/?kbid=185125) uses a stored procedure, but you can modify it to use SQL statements. Note: Since you'll be calling an ActiveX object when you use ADO, you might get security warnings in InfoPath whenever the code is invoked. You wouldn't have this issue if you used a web service to write to the db. --- S.Y.M. Wong-A-Ton > Hello, > [quoted text clipped - 25 lines] > > > Thanks > > > Paulo
|
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.