Browse by Tags

Submit 2007

Hi there, I have a form based on an Access 2007 database. The form is a Purchase Order form. When "submitting" the form I would like to save a record in the database PLUS send an email to a person who can either Approve or Reject the purchase order before it is sent to the Supplier. On the...

Posted to Newbie Questions (Forum) by Gary Burke on 10-13-2008
Auto populate - only adds data from first row in database

Hiya, I'm currently working on a form where I have customer details (from Access DB set up as secondary data source) set to auto populate related fields. I've done this using rules set to a list box. My problem is that when I preview or test the form, the auto populate will only enter the data...

Posted to Newbie Questions (Forum) by Rebecca on 07-12-2008
Not Able to Pull Data From a SQL Database

I have created a InfoPath form that queries a datasource for a a user and then auto populates other fields on the form. I orginally designed this using an MS Access database and everything worked perfectly. I changed the datasources to point to a SQL database (The SQL view's structure is identical...

Posted to Database Integration (Forum) by David P on 05-29-2008
Converting an Access Databse to a SQL Database

NEVER MIND..FIGURED IT OUT! I am converting an an Access database that I am using as a prototype to a SQL Database. But I have a problem with the row size...it exceeds the maximum bytes allowed per role(8060). My row size is (11733). I use the table as an Main datasource wjich allows to me to read and...

Posted to Database Integration (Forum) by m181354 on 12-19-2007
Re: InfoPath cannot submit the form. Row cannot be located for updating

I added a condition on the submit to check for the key and it works now

Posted to Database Integration (Forum) by m181354 on 09-28-2007
InfoPath cannot submit the form. Row cannot be located for updating

I am submitting a form to an Access database which uses an AUTONUMBER field for a key. I can save the form initially but when i re-open the form and make a change and then select submit again I get the following error. Do you know what I do to fix this? infoPath cannot submit the form. An error occurred...

Posted to Database Integration (Forum) by m181354 on 09-27-2007
Formatting Expression Box Formula's

Hi, I have a database with one table, it has three coloumns, (1) a simple number format 0001, 0002, 0003 & so on....[text format in access] (2) Name [text format in access] (3) date [date format in access] So I have connected this database as my main connection and this all works. I have an expression...

Posted to Database Integration (Forum) by Monte Cristo on 09-07-2007

Page 1 of 1 (7 items)

InfoPath Dev

Browse by Tags

Submit 2007

Auto populate - only adds data from first row in database

Not Able to Pull Data From a SQL Database

Converting an Access Databse to a SQL Database

Re: InfoPath cannot submit the form. Row cannot be located for updating

InfoPath cannot submit the form. Row cannot be located for updating

Formatting Expression Box Formula's