fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
Home » Posts tagged "access vba functions"

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

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