fbpx
Logo
Home » Posts tagged "ms access functions"

Tag Archives: ms access 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: , , , , ,

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: , , , ,

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: , , , , ,