tag:blogger.com,1999:blog-52735733386579359212011-11-27T15:27:13.880-08:00MS Access DeveloperCarlo Lingahttp://www.blogger.com/profile/02175752740466849637noreply@blogger.comBlogger41100tag:blogger.com,1999:blog-5273573338657935921.post-73086307198664506012009-09-23T00:14:00.001-07:002009-09-23T01:20:07.333-07:00Convert a number to wordsHere is a function that converts a given numeric value to words in dollars or other currency.  You can use this for your check writing application where you need to put the dollar amount in words in your checks.For example:? InWords(1234567890123.45)should return:One Trillion Two Hundred Thirty Four Billion Five Hundred Sixty Seven Million Eight Hundred Ninety Thousand One Hundred Twenty Three Carlo Lingahttp://www.blogger.com/profile/02175752740466849637noreply@blogger.com0tag:blogger.com,1999:blog-5273573338657935921.post-39231615863186656602009-09-04T09:04:00.001-07:002009-09-05T23:13:21.764-07:00Allow User to Add Values in Combo BoxIt is often good practice to provide users with a list of values that they can assign to a field when entering data into a Microsoft Access database form. With the use of pre-filled lists like a combo box, you can prevent the user from making incorrect data entry, and minimize the chance of spelling mistakes or incorrect choice of values.On some occasions, however, you may wish to allow the user Carlo Lingahttp://www.blogger.com/profile/02175752740466849637noreply@blogger.com0tag:blogger.com,1999:blog-5273573338657935921.post-66266975275961888812009-08-26T05:40:00.001-07:002009-08-31T07:40:25.438-07:00Opening a Dialog Form When Printing a ReportBefore printing a report, you normally would want to enter report parameters in a dialog box such as the following: The dialog form will popup when you open the Payroll Register report shown below: To do this, we just need to put a code in the Open event of the report to open the dialog form as follows: Private Sub Report_Open(Cancel As Integer)   DoCmd.OpenForm "frmReportCriteria", Carlo Lingahttp://www.blogger.com/profile/02175752740466849637noreply@blogger.com1tag:blogger.com,1999:blog-5273573338657935921.post-37005116933248019582009-08-12T04:48:00.000-07:002009-08-31T07:41:32.066-07:00Convert Numbers into String with Ordinal SuffixThe VBA code below allows you to represent a numeric value as its ordinal position in a set. The VBA function takes a numeric value and returns the number with the correct ordinal suffix as a string. For example: strOrdinal(1) returns “1st”, and strOrdinal(42) returns “42nd” The strOrdinal function uses the Mod operator to get the last two digits of the number. For all values between 11 and 19, Carlo Lingahttp://www.blogger.com/profile/02175752740466849637noreply@blogger.com0