InfoPath Dev

 Hi You could try this code with an OnSaveRequest - Tools, Form Options, Open and Save, Save using custom code - it works for me and you may be able to adapt it for your button.  Sub XDocument_OnSaveRequest(eventObj) Dim PositionName Dim InnovationUnit Dim SaveFile PositionName = ...

Brenda When you create your Infopath form from the Access DB you can choose which fields/tables are used in the form. Gary

Hi Using IP2003 I have added a button with a rule set to 'submit to data connection'. For the same button I have added the following code (VBScript). Sub Submit_OnClick(eventObj) Dim myEnvelope set myEnvelope = Application.ActiveWindow.MailEnvelope ' Specify addresses, subject, and introduction. myEnvelope.To = "email ...

Hi Try creating the hyperlink in MS Word (I'm using Office 2003). The tooltip for the hyperlink will show the path as file:///S:\filelocation etc. I have used this successfully to create hyperlinks to files in IP2003 Gary

If you check the display properties of the textbox you will find that you can set paragraph breaks (multiline), wrap text and 'expand to fit text' plus many other useful features.  Gary

I have also came across this problem. The Introduction property of the emailadapter can not be used with Infopath 2003. Don't know about IP2007.  Gary

Doh! Fixed this one myself. Previous code was trying to pick the field rather than the row. This works: Dim oComment Dim oLastRow Set oLastRow = XDocument.DOM.selectSingleNode("//my:myFields/my:Approval/my:Response[last()]") Set oComment = oLastRow.selectSingleNode("my:Comment") Gary

Jimmy I have tried the last() method (as mentioned earlier in this thread) to pick up the last row in my repeating table but it doesn't seem to work. It is picking up the first row of the table every time. Dim oComment 'creates value for Comment Set oComment = ...

Hi I use the following VB code to check to see if the Access DB is in use with a Form Load event. It checks for the existence of the lock file (.ldb) then displays a custom message if the DB is in use. I don't know SQL but I'm sure it should have something similar. Sub XDocument_OnLoad(eventObj) Dim db As String = ...

Hi Has anyone got any ideas on this one. I have a number of forms that users access through a web page on our intranet. Instead of the Open/Save/Cancel buttons on the form download dialog I would prefer to have only Open and Cancel showing. This would prevent the more absent-minded users saving a copy of the form template (.xsn). The only other ...