Knowledge.ToString()

  • How To: CVS to Mercurial Conversion Using ConvertExtension

    For my personal projects, I “was” using CVSNT for version control. I had an old laptop which was crashed few days ago. Fortunately, I had a backup of all the projects CVS files. I got new laptop and I had to install CVSNT but I got another shock. Now for CVSNT, I have to pay…

    |

  • MS Access: HTML Editor Control to Use in Forms

    If you want to get HTML editor within MS Access form, there are couple of solutions available. The free solution I know is to get Not So Elegant HTML Editor. The problem with this editor is that After looking at this editor, you will never say “so cool” It is good for basic editing but…

    |

  • MS Access VBA: Get/set Javascript Variable in Microsoft Web Browser ActiveX Control

    In your MS Access application, if you are using Microsoft Web browser, we may have to interact with the JavaScript variable inside the loaded page. There is no obvious method exists in the Web browser control but using the following trick you can get/set the JavaScript variable in the webpage. Quick Tip Add JavaScript function…

    |

  • SharePoint: Remove URL from Lookup Columns Using JavaScript

    If you want to remove URL from the Lookup columns in SharePoint, just copy and paste the following code into the page.

    |

  • InfoPath: Hide Command Text for Conditionally Inserting Row in Repeating Table

    Problem 1 Allow the users to insert a row in repeating table based on condition evaluation. Solution Select the repeating table, right click on it to open up context menu. Click on “Repeating Table Properties…” > “Display Tab” > “Conditional Formatting…” button. It will open up “Conditional Formatting” dialog. Click on “Add…” to open up…

    |

  • InfoPath: Conditionally Hide Hyperlink Control

    You may have been to a situation where you have to conditionally hide the hyperlink control but unlike many other InfoPath controls, hyperlink controls does not support conditions. But there is a way to hide this control. 🙂 Here is my main data source. IsVisible is a boolean field and Hyperlink is a string storing…

    |

  • InfoPath: A Proper Way to Blank Out Whole Number, Date Using JScript

    Problem When you blank out data in InfoPath using JScript, you would probably use the following method. Above code works well when “my:node” is of data type String. If the data type is Number or Date, above code will work but on the user interface you will see an error “Only integers allowed.” and “Only…

    |

  • InfoPath Error: Reference to Undeclared Namespace Prefix “dfs”

    Error If you are trying to get/set values using XPath on Secondary Data Source, you might get the error “Reference to undeclared namespace prefix: dfs”. Cause When you are trying to use XPath expression on Secondary Data Source, you must have to declare the namespace that is going to be used in the code. By…

    |

  • InfoPath Hyperlink Control: Show Hyperlink Based on Filtered Data

    In InfoPath, Hyperlink control does not support filtering data when you select a field for repeating group. But you can definitely avert this limitation using a trick. For example, I have secondary data source “Data” as xml file with the following content Now I want to get a hyperlink out of “Value” attribute of “Setting”…

    |

  • Extended Function getTagFromIdentifierAndTitle to get Fill-In enabled Dropdown

    SharePoint javascript function getTagFromIdentifierAndTitle is extended to detect “Fill-in” dropdown which otherwise fail to get the dropdown element from document.

    |