-
Hi Hilary, I have followed what you said above. I have gone to the main table and selected modify.
I have deselected multi records on the main table, but, I still cannot get the database word/line in in the submit 'screen' dialog window.
Onlty Email Web service etc is appearing.
I have a single key for each table in the ...
-
I see. It looks like this is happening when you have a DB field with an ampersand in it. I'm working on an improved version of this code that won't have that problem and will put it up here in a day or so.
Jimmy
-
I have a repeating control and I would like the user to specify how many times the control should repeat. I just have a textbox and a button and I am trying to get the rule working for the button, but I can only set a field's value. Is there a way, using rules, that I could set the count(repeating_section) to what is typed in the ...
-
I was able to figure this out. I'll share just for any other person that finds themself in a similar situation.
I didn't realize the .xsn files were similar to .cab files. I was able to grab the .xsn file off of the production Sharepoint server, copied it locally, changed the extension from .xsn to .cab, opened it and low ...
-
Hello-
I am trying to use the results of a cross tab query from my Access 2003 database and display them in an Infopath 2003 form. The problem is when I go through the data connection wizard and I get to the part about selecting the table or query as my main source (or even as a secordary source) it does not recognize my cross tab ...
-
I have print view containing a repeating section that is pulling values from a database. I know it is simple to just query for all rows in the database when the form is opened, but what if I wanted a user to type a value in field1, tab out of that field, and have field2, field3, field4 populated in the form automatically from the same row in the ...
-
I'm trying to publish a Infopath 2003 SP3 form to a SharePoint 2007 (MOSS 2007 SP1) server.
If I publish it with a filename, like "test_form", when I create a new document and press submit, it generates the form named "test_form". If I substitute one of the required fields (field1) in the filename and ...
-
If I am creating a new data connection based on SQL, is it possible have form fields in the query?
Example: select "ein", "first_name", "last_name" where "ein" = @ein
where @ein is a form field
TIA
-
Here's the fix:
At the end of the Data Connection Wizard, check the "Allow overwrite if file exists" box, republish and resubmit form.
To prevent it from overwriting, a formula must be put in to change the file name.
-
I was wondering how I would access form controls in Visual Studio. I have a form that queries a SQL database and returns records. What if I wanted to take a database value for example and do string manipulations with it before displaying it in the text box? Why can't I call any of my controls on the form in Visual Studio?
Thanks.