-
Hi Bryan,
You can do it by changing the SQL command in the data connection wizard - click on the 'Edit SQL...' button in the data connection wizard, and enter the following command
Select TOP 1 * from <TableName> order by 'Field1' desc.
-
Look at this kb article- http://support.microsoft.com/kb/939269.
Hope it solves your issue!
-
qRules is intended for anyone who would like to leverage the power of Microsoft Office InfoPath without writing code. The library provides a set of advanced commands that can be used declaratively via rules.
InfoPath allows us to set the value of a target field by using rules. We can even filter which field we want to set the value of. However, ...
-
Glad it worked! :)
-
qRules allows you to dynamically control Save and
Submit in your InfoPath forms. Using the command ChangeSubmitUrl you can
modify the Submit location of your SharePoint submit data connection.
In the tutorial below, the submit location will change according to a
selection made in a dropdown.
Using SetSave you can enable or disable ...
-
-
I modified your xsn - all I did was added some space b/w rows and it looks fine in outook.
Attached the modified xsn.
Let me know how it goes for you.
Thanks!
-
Hi Jeff,
I am an InfoPath newbie and it would be nice to share and learn from others. Let me see how much I can help you.
I am using Infopath 2007 and Outlook 2007.
I tried the same thing as you mentioned above and my cell alignment looks fine in the outlook. Attached the form for your reference. Just download it and save it locally and try ...
-
I am an InfoPath newbie and it would be nice to share and learn from others. So, let me give this one a shot. I am using IP 2007. Here are the detailed steps.
I added 3 text boxes.
In the first text box (field1) - change the datatype = "Whole Number (interger)" and format = ...