Mail us

Category Archives: Functions

MS Access Functions: How To Build A Soundex Or Sounds Like Custom Access VBA Function

MS Access

Working with MS Access functions (of the built-in variety), you may have noticed a vast list of functions across different categories. By combining (or nesting) functions, you can certainly produce complex output values which will serve you well with your queries, forms and reports. However, there is one lacking feature (or function) in Microsoft Access that could hinder searching for values and that is a function that can find similar or ‘sounding like’ a string match of characters. This function […]

Tags: , , , , ,

How To Convert Numbers To Words: Access VBA Function

Access VBA

Once again, I’ve been asked by a client to create procedure to turn a monetary number (numerical value) into its text equivalent and so I wanted to share with you how to convert numbers to words using Visual Basic code that can also be applied not just to your Access database but with any application that entertains VBA code! How To Convert Numbers To Words: The Steps This article is intended for users who know and have some VBA code […]

Tags: , , , , ,

How To Concatenate Access Fields In Queries ?

Microsoft Access 2003

To join or not to join, that’s concatenation for you! How do you join or concatenate Access fields together for your queries or other objects (including forms and reports) is a matter of mastering the rules and knowing the operators. There are plenty of simple demonstrations and video tutorials around on the web showing you how to combine and joins fields from tables in a calculation using the concatenate principle. Most Access developers and users will use the & (ampersand) […]

Tags: , , , , ,

Access DLookup Function: Why You May Need To Apply This Function

Using the Access DLookup function may be called upon where users need to output a value from other data sources (i.e. tables or queries) where there is no direct relationship. Hang on a moment! I though Microsoft Access was a relational database system (RDBMS) so why calculate to connect to a value? Yes it is an RDBMS but depending on how the database was designed and built or if you had inherited an Access database this could well mean having […]

Tags: , , , ,

Access Requery Or Not To Requery – That Is The Question


The following four methods can be found in Microsoft Access and have different uses: Access Requery Access Refresh Access Repaint Access Recalc They can be split into two parts where the first two points handles records (the data) and the latter two the objects and their components (no data). Therefore you can start by answering the first simple question to help navigate to which part is best to use: “Do I want to update data or components in my Microsoft […]

Tags: , , , ,

Microsoft Access String Function: Borrowing String Functions from Excel

Microsoft Access Database

I published an article last week on how you can use an Access string function that doesn’t really exist in Microsoft Access. In fact, you can build any function you like but using Microsoft Excel which has the function I wanted to utilise saved my having to create a function from scratch.Check it out below how you can do this… Custom Microsoft Access Functions: How To Borrow Functions From The Microsoft Excel Library The definition of any function no matter […]

Tags: , , , , ,