Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 9 of 11 (108 items) « First ... < Previous 7 8 9 10 11 Next > Re: What is the Visual Basic code for setting a field value from a secondary data source? Hi Potemkine, Nice to hear from you again. Ok, noted about the rules vs code part. I'm still using your code to refresh this new form though :) I was thinking of using code because my form has multiple sections and nested sections and thus using rules can sometimes take quite a lot of mouse clicks. Was just trying to find out if it ... Posted to Code (Forum) by ZhenYuan on 09-06-2010 Re: What is the Visual Basic code for setting a field value from a secondary data source? Hi Jimmy, I decided to just use rules :) but for knowledge sake, I'll still like to know how I can go about this in code? Is it more efficient to use rules instead of code? Thanks! Posted to Code (Forum) by ZhenYuan on 09-06-2010 Re: What is the Visual Basic code for setting a field value from a secondary data source? Hi Jimmy, Thanks for your help again. When you say variabled, do you mean:Dim oItem As XPathNavigator Dim oSecData As String oItem = Me.CreateNavigator().SelectSingleNode("/my:myFields/my:Date_Letter", Me.NamespaceManager)oSecData = ... Posted to Code (Forum) by ZhenYuan on 09-06-2010 Re: What is the Visual Basic code for setting a field value from a secondary data source? To add on, what I'm trying to do is something like: Me.CreateNavigator().SelectSingleNode("/my:myFields/my:Date_Letter", Me.NamespaceManager).SetValue("abcd") Except that SetValue is not applicable for xpath input. It only takes string values. I hope to be able to replace "abcd" with a xpath to my secondary ... Posted to Code (Forum) by ZhenYuan on 09-06-2010 What is the Visual Basic code for setting a field value from a secondary data source? Hi, I understand that rules can be set to populate fields using data retrieved from a secondary data source. I'm just wondering if this can be done via Visual Basic code? Reason is because I kind of have alot of fields and using code might be faster to populate my form? The replaceself function can be used to replace nodes but is there code ... Posted to Code (Forum) by ZhenYuan on 09-06-2010 Re: Can I load database table values into my form dynamically? Hi Hilary, Thanks for your suggestions! Previously I was having trouble because I was trying to tie my secondary data source data to a repeating table which I've added separately. The end result was that this table did not populate according to my DB table. In fact nothing came out and only the first row was populated. Your comment on ... Posted to Controls (Forum) by ZhenYuan on 09-03-2010 Can I load database table values into my form dynamically? Hi, Just wondering, if I have a Billing table in my database that has columns, ClientID, BillAmount, BillDate, can I populate these fields into my form dynamically? Dynamically in the sense, for example I want to retrieve Billing details from Client 12345 and there are only 3 bills to date, then I will have a 3x3 table. If I query on client 23456 ... Posted to Controls (Forum) by ZhenYuan on 09-03-2010 Re: How to integrate InfoPath forms with MS Outlook? Hi Patrick, Sounds like a good idea. But when you talk about Public Folders, are you talking about a shared folder in the destination mailbox? ie, an email folder I share to all users from my own Outlook Inbox? However, this would require me to grant users Reviewer rights to my Inbox as well, which is not exactly good. An ... Posted to Qdabra Database Accelerator (Forum) by ZhenYuan on 08-29-2010 How to integrate InfoPath forms with MS Outlook? Hi, Was wondering if there is a way to integrate my designed form in Outlook? Right now, if we want users to use the form, we have to email the URL to them. Our objective is to have this link in everyone's Outlook such that when they eventually need to use it, everyone can go to some folder, example: "InfoPath forms" folder and ... Posted to Qdabra Database Accelerator (Forum) by ZhenYuan on 08-26-2010 Re: Switching between form views Hi, Yup, thats a good way to go about it. Thanks! Posted to Newbie Questions (Forum) by ZhenYuan on 08-23-2010 Page 9 of 11 (108 items) « First ... < Previous 7 8 9 10 11 Next > Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.