Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

It’s very strange how Microsoft Access database systems and processes constantly repeat themselves and once again I’m working on some VBA code to communicate with Microsoft Outlook (Email and contact management system). Here you can see a quick video of such a simple but effective utility I offer (for only the cost of a couple of pints of beer!) – check it out… Microsoft Access Database Tutorial VBA Code Task Tool To Outlook The Task Tool utility was built to demonstrate […]

Tags: access vba to outlook, how to automate ms access, microsoft access database, microsoft access database tutoiral, ms access database, vba code

Concatenating Multiple Rows Into Single Line In MS Access

By benadt2017
Jun-12-2014
Functions, Modules, Queries, VBA
Comments Off on Concatenating Multiple Rows Into Single Line In MS Access

Now I’m not going to take credit for this next piece of Microsoft Access database VBA code as it was originally created by a well-known Allen Browne – many thanks! Instead, I’m going to borrow his code for you (my regular readers) just in case you haven’t seen this before and add an element of quickly adding criteria to a query as a workaround to avoid expanding the VBA code itself. There are potential problems and errors this code will […]

Tags: access vba custom function, concatenate VBA code, how to concatenate into a single line, microsoft access database, MS Access, using ms access queries

Access VBA Events: What Are Events And How Do We Use MS Access VBA Events

By benadt2017
Sep-30-2013
Modules, MS Access, VBA
Comments Off on Access VBA Events: What Are Events And How Do We Use MS Access VBA Events

Microsoft Access VBA events have been around forever! Well, not forever but since VBA has been (circa 20+ years) and it’s still widely unexplored beyond the basic event triggers one gets to see and know about namely the clicking of a Command Button on a form or when the form itself opens. Many users and developers have used events in many ways which is not just exclusive to MS Access (Excel is also a very popular application) and to get […]

Tags: access vba, how to create access vba code, microsoft access vba events, ms access vba events, where are access events

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports

Working and automating an Access report VBA will require some knowledge of the module window (VBE), the defined sections and an insight to pre-defined events for each element of a report design interface. However, let’s take a step back and identify some of the report properties that can be used in a module that do not appear in a standard design view layout for a report. The three I want to highlight here and you may want to note are: […]

Tags: access report vba, access vba code, designing microsoft access reports, ms access reports, using vba in access, vba

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

By benadt2017
Jun-11-2013
Functions, Modules, MS Access, VBA
Comments Off on MS Access Functions: How To Build A Soundex Or Sounds Like Custom Access VBA Function

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 vba functions, creating functions in access, custom built microsoft access functions, how to build a vba function, MS Access, ms access functions

MS Access Databases Properties: How To Set It Using Access VBA And The DAO Object

As with most Microsoft Office applications, MS Access databases also have a properties feature that captures the basic file attributes like author, date and subject to name a few. There is also a custom tab to edit and add your own properties and is stored with the database file itself. To know more about changing the built-in properties window, see view and change MS Office 2010 file properties. For the earlier versions (pre 2007), this feature can be found via the […]

Tags: access vba, ms access database properties, ms access databases, ms access module, vba programming code

Mail us

ben@accessdatabasetutorial.com

Mail us

ben@accessdatabasetutorial.com

Category Archives: Modules

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

Concatenating Multiple Rows Into Single Line In MS Access

Access VBA Events: What Are Events And How Do We Use MS Access VBA Events

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports

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

MS Access Databases Properties: How To Set It Using Access VBA And The DAO Object

Recent Posts

Recent Comments

More Social Media

Archives

Categories

Quick Link

Follow me on Twitter

Recent Comment