Microsoft Access

Submission error with repeating table within a repeating section

rlewis01 — Fri, 03 Jan 2020 16:32:11 GMT

Hi wondering if anyone can help, i'm very new to InfoPath so don't fully understand everything.

I have designed a form for Audit purposes, I need to be able to have a common denominator of unit number and consultant linked to the audit data. The audit data needs to be able to add extra rows so I have created this using a repeating table within a repeating section.

I am able to submit the data with additional rows but as soon as I add another section it comes up with an error message and wont submit the data, really cant get my head around it.

(Unit number 1 / consultant 1 will submit but as soon as I add the second section unit number 2 / consultant 2 it errors)

Need some help setting up a form connected to Access database

jgligorevic — Thu, 05 Jul 2018 15:49:11 GMT

Hi community,

It is my first post. I have used InfoPath before, but only forms linked to SharePoint lists. Now I have an Access database that saves outsourcing activities of the company. I want to design forms that adds new records to the database (new outsourcing proposals).

Ideally, the next step would be to start an approval process through MS Visio and MS SharePoint Designer and have a senior lead approve. My biggest problem is that I have a database with complex relationships and I want to use list boxes for selecting some outsourcing functions and selecting entities to outsource to.

As such, I have in each table a primary key and sometimes several foreign keys, since I also have sub-delegation entities and sub-tasks (you see the complexity).

What would be the best way to set this up? A detailed explanation and walkthrough would be appreciated.

Thanks...

InfoPath form displayed on SharePoint, want responses added to a table in Access

Heathey94 — Mon, 20 Feb 2017 15:44:31 GMT

I've heard it's possible (and from the title of this group, it definitely seems to be the case) that you can use InfoPath to get data entered directly into a table in an access database, but everything I've found online appears to look at the reverse, are you able to provide any guidance? I am a complete InfoPath rookie (I'd never opened it before Friday), so you're going to have to be extremely basic with me here.

InfoPath form having issues connecting to Access database

Spotswood — Wed, 18 May 2016 20:04:40 GMT

I am coming on here because I was assigned a project to help collect work data (#'s of each task completed) and I have set up the database and form in the shared network drive. The form submits perfectly for me, but when anyone else (even those with NO restrictions in network drive) tries to submit the form, it tells them the database cannot be found. I have gone on their computer and looked to make sure that the path is correct as well as to make sure the bindings were still working on the form. I have even gone and added the network drive to the intranet section under IE security.

My questions is what do I check next?

Issue with the connection from MS Access 2013

Vertex SharePoint — Tue, 22 Sep 2015 09:37:16 GMT

Hello, I have limited knowledge in MS Access. My requirement is to link the SharePoint 2013 site in MS Access 2013. Am able to link SP 2013 site in MS Access 2010 but now in Access 2013. Am getting the below popup when I try to link from Access 2013 "Microsoft Access could not connect to the site you specified. Verify the address of the site or contact your site administrator" Are there any special settings to be made to access the SP 2013 site in MS Access 2013? Kindly help, thanks in advance.

Submitting Infopath Form to Access DB with autoincrement primary key

Marleah — Wed, 12 Aug 2015 18:31:03 GMT

Hi, I have an infopath form that needs to submit information to an Access DB, I am having a problem as I need a unique id associated with the form to update ID fields that are primary keys in several tables, the fields were once auto increment primary key fields. How can I keep the autoincrement primary key feature of the Access tables, and have the infopath form update the field properly. My first attempt was to create a regular integer field for the primary key and attempt to get the max id field from the Access Table and increment by 1 when I submit the form. But I have not been successful trying to do this. Is there a way to keep the auto-increment primary key field and have it increment when the infopath form is submitted to the database. In some of the material I have encountered there is reference to doing just this type of thing. Specifically: Developing Solutions with Microsoft® InfoPath Chapter 6, Database Integration. But on the Microsoft Office Dev site, it states that Infopath does not support the auto-increment datatype in Access. Please help. Thanks, Marleah Isom

InfoPath 2013 vs InfoPath 2010 (Data source compability issue)

kromeda — Sat, 08 Aug 2015 10:01:03 GMT

Hello, at first I would like to apologies for my English, I’m working on it. I’v got a problem, when I created an InfoPath 2013 Filler Form and added secondary data source with an MS Access table. I left "automatically retrieve data when the form opens" selected. Everything is going to be fine until someone with an InfoPath 2010 installed trying to open it. I set option in properties of the form, so it’s comparable with InfoPath 2010 (also i tried "Empty Form 2010 (InfoPath FIller)" from scratch, and got the same result). Anyway, when person with InfoPath 2010 try to open it will get connection error (cannot query table (secondary data source) or smth) during Form load, and it will open without data stored in tables. I tried to find out what’s the problem. And here’s what I found: by default, when you add MS Access database table as secondary data source Form defines to it OLE DB provider, and there are some particular properties for connection string to every MS Access connection. For example Provider=Microsoft.ACE.OLEDB.12.0; Password=””; User ID=Admin; Data Source=D:\Shared\BD\reading.accdb; Mode=Share Deny None; Extended Properties=””; Jet OLEDB:System database=””; Jet OLEDB:Registry Path=””; Jet OLEDB:Database Password=””; Jet OLEDB:Engine Type=6; Jet OLEDB:Database Locking Mode=1; Jet OLEDB:Global Partial Bulk Ops=2; Jet OLEDB:Global Bulk Transactions=1; Jet OLEDB:New Database Password=””; Jet OLEDB:Create System Database=False; Jet OLEDB:Encrypt Database=False; Jet OLEDB:Don't Copy Locale on Compact=False; Jet OLEDB:Compact Without Replica Repair=False; Jet OLEDB:SFP=False; Jet OLEDB:Support Complex Data=False; Jet OLEDB:Bypass UserInfo Validation=False; Jet OLEDB:Limited DB Caching=False; Jet OLEDB:Bypass ChoiceField Validation=False This information is available from the manifest.xsf file. Connection string was built within InfoPath 2013 Form. The same connection string properties are present for InfoPath 2010, except two last properties. These are the core difference between IP 2013 and IP 2010 connection string when you add secondary data source with MS Access DB table. In IP 2010 these properties are simply not provided. There are no even space for them if you try to “create” connection in a data connection wizardry (InfoPath 2010) and press “Choose data base” -> “Create” -> “Additional” -> “Microsoft Office 12.0 Access Database Engine OLE DB provider” -> tab “All”. For me solution was to use ODBC data provider instead of OLE DB, but I don’t really think Microsoft could allow such issue with compatibility of InfoPath 2010 and InfoPath 2013

run query error in Infopath from Access data source

Rosie — Thu, 16 Jul 2015 08:45:06 GMT

I did a infopath form connecting to submit both information to Access and Sharepoint(for workflow approve). Everything is great, almost completed, but when I am trying to use "Run Query", a field in the repeating section does not return correct value, only 0. This field has a formula which help the user to calculate the value from input data in the same repeating table when the user fill-in the infopath. It works correct when user fill-in the data, but if the user try to run query, and get existing data from Access datasource, this formula just return 0. Anyone can help me on it?

Public InfoPath form connecting to Access db in a restricted location

CasperMelb — Tue, 02 Jun 2015 01:52:01 GMT

Hi, I have used the forums on this site many times to get help but this is the first time I am posting, so, Hi everyone. Hopefully someone has an answer to my question. I have an InfoPath 2010 form which is available to everyone to use, hosted on SharePoint that needs to connect to an Access 2010 database which is stored in a restricted drive location. The form needs to be accessible to all staff but due to the sensitivity of the data being submitted, the database must remain restricted. Also, the form needs to be able to query the database for the secondary data connections. Please note that using SharePoint lists in not an option available to the team that will be maintaining the data submitted. Does anyone know of a way to enable the form to be able to connect to the database to query & submit without assigning access to the restricted folder to all staff. I have been told it may be possible to "assign" a system account to the form which will have access to the restricted folder but I also need to ensure the form can populate the users data into the form ,such as USER() & email address. I would classify myself as a beginner to intermediate InfoPath user. Thank you in advance for any help you can provide. Andrew

InfoPath hyperlink to Access Database

JazzTheMan — Tue, 21 Apr 2015 21:40:51 GMT

I have multiple InfoPath forms connected to an Access database to receive/submit data. Within one of these InfoPath forms, I want to create a button (I would prefer a button) or a hyperlink that opens a specific report within the Access database. I have successfully created a hyperlink which opens the Access database, but I can't figure out how to make it open a specific report. I can create elements within the Access database to get the user to the reports, but I would much rather the report just open when the user clicks the button/hyperlink. My main goal is for the user to have access to the necessary report, but not have access to the database itself. I'm open to other solutions to achieve the goal. This is strictly Infopath and Access; no sharepoint available to us. Thank you!

How to create an InfoPath Form for data entry to an Access 2010 Database for use on Sharepoint 2010

S-Coupland — Mon, 17 Nov 2014 09:53:42 GMT

Hi There, this is my fiirst post to this site and i hope that you can assist me please

My boss recently attended an Access course, from this they discovered that you can make User Forms in Access to get information from databases. This concept impressed him so much that he now wants to apply this to all our data entry and search processes.

I have been asked to create a data submission form using infopath 2010. that seems to be rather straight forward, my problem is i need the data submission form to send and save the entered data to an Access 2010 database, the form is going to be available on Sharepoint 2010.

I have tried searching and reading all last week and i am more confused, there is a template available in InfoPath 2010 for Databases but i cant for the life of me work out what the Qyuery Fields and Data Fields are and how to use them.

Is there a toutorial that walks through step by spet the process of creating a data submission form and how to link this form to Access 2010 to store and save the entered data.

Many Thanks

Simon

Pull Data from Access

Perceptus — Mon, 19 Nov 2012 18:55:33 GMT

I want to pull all the data from a query and have it displayed on an Infopath form. I dont need to modify the data in any means(nor would it be possible given the amount of joins xD). I have created a form using MS Access Connection and can see Q and D field data in the Data Source window. Where do I go from here?

Image Control in a Repeat Section and MS Access Table

lace114 — Sun, 12 Oct 2014 21:32:59 GMT

Hello All,

I am a newbie with InfoPath forms and MS Access. I have a InfoPath form that is pulls data from a MS Access table and collect user response in the field.

The data enters into a repeat section fine but I am having issues getting the images control in the repeat section to work properly. The user is required to add images to each repeat section. The pulled data/pre-populated info are set to read only on the form.

My first issues is that InfoPath doesn't allow/disable MS Access image/memo fields and displays the field as simple text. The submit button is also disable because of the size restriction.

My attempts to create a fields outside the data source cause the image control to repeat/duplicate itself within each repeat section or I get this error info " Control can not repeat here".

My user are required to capture unique image to each item in the repeat table. I don't necessary need the images to be save into Access but would like them to be displayed on the form.

Is there a workaround that modifies InfoPath restrictions to Access Image/memo type field?

Is there a workaround that allows me to set/bound the image control properly?

Thanks for you help in advance.

access & Options button

ranoha — Sun, 13 Jul 2014 09:20:23 GMT

Hello,

How can I send data to access and update the information in that form I use the controls on the Options button?

Thanks

Timeout error during form load

Kalinsias — Fri, 03 Apr 2009 23:18:09 GMT

I have read through the forums and saw several threads that talked about this topic. In reading them, I came quickly to the conclusion that I haven't learned as much as I thought. I have picked up on form designing and even database connections, but I've hit a problem that probably requires inserting some code, and I'm a serious fish out of water in that department.

I have a form that several users in my department will be using to record audit findings. To make it easier on them, I created an Access database for populating several of the drop-down lists in the form. The InfoPath form and the Access database are in the same folder on a shared drive. For people on the network, it works fine. However, I have one user that is remote and connecting to the network via VPN. When she attempts to open the form, she gets the error regarding timeout.

I guess what I need is to know how to increase that timeout, written for an InfoPath user that is still in diapers. Ha!

Any help will be much appreciated. This isn't my background, but I am a quick study....promise!

Infopath VBA UPDATE not working properly

jaspence — Fri, 24 Jan 2014 14:55:06 GMT

I have two main tables that I am entering data into and need to be able to update a record set if one exists for a part number/supplier combination. I have the code working to correctly populate the tested_parts table when a record does not already exist, but can not get the tested_parts table to update when a record does exist. I have a rule, within my Infopath form, which does the query of the tested_parts table based on entered data (supplier_tp and part_num_tp combination) and identifies the record set with the primary key index_tp. If a record set exists I need to update the tested_parts table with lab_num_tp, alloy_spec, last_tested fields associated with the index_tp identified. I have run the debugger and the correct values are being obtained based on the entered data and rules query so I am assuming there is something wrong with my update code and am to much of a noob to catch it.

If part_num_tp.Length > 0 Then

'If activated

If index_tp.Length > 0 Then

'If previous record exists

Dim cmd_tp As OleDbCommand = conn.CreateCommand()

cmd_tp.CommandType = System.Data.CommandType.Text

sb =

New System.Text.StringBuilder()

sb.Append(

"UPDATE tested_parts ")

sb.Append(

"SET [lab_num_tp] = lab_num_tp, [alloy_spec] = alloy_spec, [last_tested] = last_tested ")

sb.Append(

"WHERE [index_tp] = ")

sb.Append(index_tp)

cmd_tp.CommandText = sb.ToString()

cmd_tp.Parameters.AddWithValue(

"lab_num_tp", lab_num_tp)

cmd_tp.Parameters.AddWithValue(

"alloy_spec", alloy_spec)

cmd_tp.Parameters.AddWithValue(

"last_tested", last_tested)

cmd_tp.Parameters.AddWithValue(

"index_tp", index_tp)

Else

Dim cmd_tp As OleDbCommand = conn.CreateCommand()

cmd_tp.CommandType = System.Data.CommandType.Text

sb =

New System.Text.StringBuilder()

sb.Append(

"INSERT INTO tested_parts ")

sb.Append(

"([lab_num_tp], [part_num_tp], [part_name_tp], [supplier_tp], [prod_code_tp], [alloy_spec], [last_tested], [DFAR]) ")

sb.Append(

"VALUES ")

sb.Append(

"(@lab_num_tp, @part_num_tp, @part_name_tp, @supplier_tp, @prod_code_tp, @alloy_spec, @last_tested, @DFAR)")

cmd_tp.CommandText = sb.ToString()

cmd_tp.Parameters.AddWithValue(

"lab_num_tp", lab_num_tp)

cmd_tp.Parameters.AddWithValue(

"part_num_tp", part_num_tp)

cmd_tp.Parameters.AddWithValue(

"part_name_tp", part_name_tp)

cmd_tp.Parameters.AddWithValue(

"supplier_tp", supplier_tp)

cmd_tp.Parameters.AddWithValue(

"prod_code_tp", prod_code_tp)

cmd_tp.Parameters.AddWithValue(

"alloy_spec", alloy_spec)

cmd_tp.Parameters.AddWithValue(

"last_tested", last_tested)

cmd_tp.Parameters.AddWithValue(

"DFAR", DFAR)

Try

conn.Open()

cmd_tp.ExecuteNonQuery()

Catch ex As Exception

MessageBox.Show(ex.Message,

"An error occurred", MessageBoxButtons.OK, MessageBoxIcon.Error)

Finally

conn.Close()

End Try

End If

Infopath and Access connections

tharki_singh — Sun, 05 Jan 2014 17:24:27 GMT

Access 2013 doesn't support creating new Data Collection forms. However, it does process data collection forms that were created in earlier versions of Access. The data collection feature enabled customers to create data collection forms and send those forms as an email message. When customers returned those email messages, the data was processed and stored in an Access database. Can someone help me with a work around plz?

Submit with attachments

cartotech81 — Fri, 03 Jan 2014 18:25:18 GMT

I guess I have multiple issues here. To begin I only have access to sharepoint 2010 and access 2007. I need to allow the use of attachments ony my form, but when trying to submit to access it will not let me because of a longbinary issue. I have read some posts about how to do this but they are no where near being in lamens terms. I would also be willing to save form data to sharepoint, but I am not sure how to save attachments to sharepoint either.

Thanks,

Jason

Auto Populate multiple rows using two different access queries.

zakickes — Tue, 23 Jul 2013 14:10:46 GMT

Hi everyone, So I have been reading this forum and google searching regarding infopath and access integration, however I have hit a wall in my studies. Just a fyi, I am quite the newbie when it comes to these programs, but I would greatly appreciate any information that may help me reach my goal. Basically, I am making an info path form that team leaders can fill out in order to sign up their employees for remote and secondary site testing. My goal is to create a form where they can input their corporation ID, and it will auto populate their name and business unit for them by referencing an access query named something like "OPTBusinessUnit." I found out how to do this yesterday from the forum post - http://www.infopathdev.com/forums/t/8421.aspx - by following Hilary Stoupa's excellent explanation. The problem, however, is that the team leaders will also need to enter their employees corporation ID, and the employees information will auto populate by referencing a seperate query from the same databse named "StaffContactInfo." I Don't know what I am doing wrong, but infopath seems to only allow me to auto populate either the team leader information OR the employee information. As far as I can tell, this is because I can only use one query as the "Main" data connection, and for the auto populate to work correctly I must use the main connection in conjunction with a secondary connection. Is this correct? Or am I going in the wrong direction? Again, any help is greatly appreciated and I thank you for your time, Zachary Ickes

Infopath form connects to Access Database with Office 2010 but not office 2007

douala — Wed, 03 Jul 2013 16:58:53 GMT

This has been a thorn on my side for a week!!!!

I have designed an Infopath form that retrieves data from an Access Database via a button.

The Access database is located in a shared drive where all users have access.

I have even changed the Access database from .accdb to .mdb

The form retrieves data perfectly for users who have Office 2010. Infopath gives an errors "Infopath cannot run specified query" with users who have Office 2007 as soon as the button is clicked.

I have been seraching and searching online and no solution.

My security is set to "Full Trust". My form is an "Infopath Filler 2007", I do not know what to do next?

Thanks

Submitting Infopath form to access database

theresac — Mon, 15 Jul 2013 17:59:23 GMT

Hello,

I created an Infopath form that is connected to an Access database. My boss is convinced that I can have the Infopath form feed to an Access database each time submit is used. We have access 2007 and i'm not sure it can be done.

I really need help with this issue!!

How to make a "main" entry field copy for each row of a repeating table?

akamphaus — Mon, 13 May 2013 19:10:09 GMT

Hello I am using a repeating table to collect data which is submitted to an Access database. One of the pieces of data I am collecting is a username, first name, last name, and date. What I would like to happen is for a user to enter each of these items once and for them to be included with each row of the repeating table when submitted to Access. Currently I have these 4 fields outside of the repeating table in a non-repeating section. I find when a user submits the form, these are only included for the first row. My plan was to have a field for the username et al. in the non repeating section, then have another username field in the repeating table and make that hidden but I can't figure out how to make sure these are always the same. I am quite new to InfoPath and not sure what is the best way to accomplish this but I am hoping someone can give me some suggestions (even knowing if this can't be done would be helpful.) Thanks in advance! Anna

Collecting Data using Infopath Forms Access 2007 Feature - Why this poor Style Generation?

edzurita — Tue, 05 Mar 2013 14:39:12 GMT

Hello All,

I'm trying to modify the resulting forms generated in Infopath 2007 when I use the Collecting Data from Access 2007. The generated email contains a form linked to the database, but its style is too poor, and I think is difficult to modify.

Somebody knows hot to accomplish this? I wouls like to modify this ugly generated form in order to transform in a beautiful form fit for a princess.

Thanks in advance.

Ed.

Retrieving data from multiple fields with same value

mxdems28 — Wed, 14 Nov 2012 20:30:59 GMT

I have built a form based on the database template and hope want to pull records based on two mutually exclusive fields. Basically I have a table that has a username and a contactname field which contain an employee identifier. In theory if the username field has a value then the contactname should be blank and vice-versa. In certain records both the username and contactname have the same value and others have different values other than null. I want to be able to query both the username and contactname fields simultaneously so that if either field contains the value I have queried the record will be returned. Is there a way to do this with filters or rules? In development I am using an Access 2010 database but hope to migrate the data to SQL2008.

If I split the database into two tables and define a relationship between the username field and the contact name will this accomplish my goal?

Can you use 'preceding-sibling' with an Access database connection?

BurgessJunction — Wed, 21 Nov 2012 02:32:22 GMT

I used a Data Connection to connect to a single table in an Access database, but I can't seem to get the 'preceding-sibling' functionality to work.Would like to be able to use information from the last record in a database to autopopulate a new record with the same information. The new record will have some information overwritten and when user submits the new record it will be added to the database. This will allow a track record of changesThe error I get is: "preceding-sibling::Report_Request/Version" does not point to a valid location path of a field or group.

Hierarchy - MyFields > dataFields > d:Report_Request > Version

Thanks!