-
I do not know of a way to hide columns, rows yes, columns no. But to simulate you could hide the conrtols in the column but that would be work.
So are you disabling the controls or hiding them?
What are the values before?
What are the values after?
Are they the same? Do you have default values for the fields? You are using ...
-
Hey Erik.
Looking at this closer it appears you are trying to set a main data connection to a database. If that is so then I am not sure your xpath is correct it would typically be /dfs:myFields/dfs:queryFields/dfs:Dimensie
Maybe the namespace thing you have works, I have not tried that before.
If you are not planning on using a variable ...
-
Here is what I have used successfully before.
This allows for the parmeters to be passed on the command line. A couple things to watch out for is that you may have to specify your path to infopath or run this in the same folder. Also If you do not have the exact amount of variables it wont work. So if you only need one ...
-
Hey there.
On the first "database" type form you created I would drag all the query controls onto the form and then drag your datafields on as a repeating table and do some experimentation in preview mode.
Once the fields are on your form you can right click and convert them to dropdowns and give them some values to choose from. ...
-
I would put all the controls in a section if you can, then you can just hide the section and do not have to set conditional formating on every field.
You would need to have a rule on your drop down with an action for each field to set it to blank or 0 or the defualt value or whatever. Setting the field's value should be independent ...
-
Welcome Tommy.
I have not been successful using Access for file attachments. I know SQL can store the Base64 file attachment that InfoPath produces but I do not believe Access can.
Best practice would not be to use Access for a company wide solution anyway. SQL Express is free and is better designed for multi-user use.
If you want to ...
-
You can use Excel as an ODBC datasource and get access to informaiton that way as a data source.
You could import your data into SQL Express, have your spreadsheet access and update the data from there and then contect to the table from InfoPath.
If you have SharePoint you can convert into a dynamic list with the SP import wizard and then use ...
-
Hi Stefan, Welcome!
This is definitely feasible in InfoPath. You can create a Database form from your SQL Express Table and then display this list on your form.
Since you want an XML product you will want to just save the final InfoPath form probably. So you could create a group in your form schema to contain the selected row ...
-
I would check your permissoins on the SQL box first off. Ideally you can grant your self heightened permissions and get it working and then begin removing premissions back to normal and find what you need.
Then I would also check that the server name is in your trusted sites or intranet zone in Internet Explorer. Data Connections look ...
-
I assume you setup the original form as a database form when you created it. You should be able to go into Data Connections and modify the main data connection and point it at the sql server tables instead of the mdb file.
Highlight the data connection, select modify. Select Change Database and if this is the first time using ...