Overview Microsoft Query does provide the "CONTAINS" criteria to check whether a field contains a value, the SQL ‘WHERE’ clause for this is "WHERE criteria_field LIKE ‘%value_to_check%’". The problem is how to use parameter with "CONTAINS" criteria? Steps With the ‘&’ operator we can easily concatenate the parameter in the "LIKE ‘%%’" [...]
Archive for the "MS Office" category
Overview Let’s consider this scenario: I have a Access DB and want to retrieve the data in Excel. In Excel 2007, the easiest way to do it (as far as I know) is to use built-in Access connect ("Data" tab => "Get External Data" group => "From Access"). However, in this way I [...]
Overview In making dynamic Excel spreadsheet, sometimes we may have a function with result "#REF" or "#DIV/0". Some of these error messages are avoidable, but some of them aren’t. In this case we have to conceal (hide) the error message. In Excel 2003 or before, we were using the "IF" function to check whether [...]
Overview In my previous blog showing How to convert Access 2007 App into Runtime Mode, I discuss how to convert Application to Runtime Mode. However, you need to specify a Start-Up Form so that the Runtime Application have something to show when started. Reference Change Access 2007 database options for your application [...]
Overview Access Forms let you create a user-friendly interface to end-user, it can also restrict what your users can view/modify. However user can still modify your table directly if your application is not run in Runtime Mode. Below shows the steps to convert your Access 2007 application to runtime before you put it to [...]
Overview 在上一篇文 Publish Browser Enabled InfoPath Form to MOSS 2007 中分享了製作 MOSS browser enabled InfoPath Form 的方法. 今次就再為InfoPath Form 加上 Web Services 既 Data Connection. Reference InfoPath and Web Service data connection Data Connections in Browser Forms Data Connection Libraries [...]
今日開始玩InfoPath, 想publish一張 InfoPath 既 form 入 SharePoint Server 做 WebPart, 但係0向 publish 既時候就見到呢個warning… "This form template is browser-compatible, but it cannot be browser-enabled on the selected site" 結果搞左一大輪先搞得掂… 方法請參考下面既link Reference: A checklist for enabling browser forms with Forms Services and SharePoint 2007 [...]
Subscribe to this blog