Click here to Skip to main content

Submit your article

Microsoft Access

MS-Access

Great Reads

Exploring Computational Number Theory (Part 1)

by William Hey

Classical number theories

Dynamically Add Access Database Columns at Runtime using VB.NET

by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Semi-Prime Ordered Sequences (Part 2)

by William Hey

Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.

Selecting and Importing Excel File and Sheet for import into Access

by Clifford Nelson

This is a tip that has the code for selecting an Excel file and sheet for import into Microsoft Access. This includes the code required to browse for a file, and populate a ListBox with the sheets of the Excel Workbook, and the code to import an Excel spreadsheet.

Latest Articles

Azure Active Directory Authentication with OpenID Connect and Authorization with App Roles

by DotNetLead.com

Azure AD for authentication and authorization of users for your website

Indian Number Formatting of Currency in Microsoft Access and Excel

by Gustav Brock

Format amounts in VBA using the Indian number format for currency and amounts

SQL Full Outer Join

by essentialSQL

How to reconstruct full outer join in SQL using other join clauses

Migrating Legacy Microsoft Access Database to Excel (or any other database) - Complete Application and Code

by rohitsies

Helps migrate your Microsoft Access database to Excel

All Articles

Microsoft Access

Exploring Computational Number Theory (Part 1)

31 May 2016 by William Hey

Classical number theories

Dynamically Add Access Database Columns at Runtime using VB.NET

21 Apr 2013 by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Semi-Prime Ordered Sequences (Part 2)

31 May 2016 by William Hey

Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.

Manage business logic in Access forms

8 Mar 2012 by Torsten Tiedt

Avoid event spaghetti code when business logic becomes complex.

Generate Access Reports from Tables

24 Jun 2014 by Bhis

Back in 2008, I was doing some freelance work and had a chance to work on this MS Access Report project. The client dealt with employee benefits, claims, and payment reimbursements.

The Six Hat Send Mail Class (Easily Send Email Using VBA)

2 Jul 2016 by Six Hat Solutions

Easily Send Emails From Your Microsoft Applications Using VBA and the SendGrid API

Indian Number Formatting of Currency in Microsoft Access and Excel

1 Feb 2021 by Gustav Brock

Format amounts in VBA using the Indian number format for currency and amounts

Ole and Accessing Files Embedded in Access - Part #2

18 Aug 2009 by mrjvdveen

Ole and accessing file embedded in Access

OLAP for LightSwitch

2 Sep 2011 by ComponentOne

A video that demonstrates OLAP for LightSwitch

Advanced Classes in C

29 Jun 2013 by Ghosuwa Wogomon

An example of a clean way to implement classes in C

regular-expression

Human Emotion Detection from Image

20 Sep 2010 by shakil0304003

It can detect human emotion from image

General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection

15 Mar 2012 by ProEnggSoft

General purpose class to fill some or all of the DataTables of strongly typed DataSet from DataBase and to save some or all of the DataTables to DataBase by creating TableAdapters using reflection.

Add some AI to your combo box lookups

15 Dec 2010 by hector [.j.] rivas

Helping the combo box autocomplete function with a frequency count.

artificial-intelligence

Microsoft Access Application Development Guidelines

15 Jan 2013 by Marco Sorich

Some guidelines for developing better MS Access solutions.

Automating deployment for MS Access Application

30 Jun 2016 by Mani Murthy

Using .Net application to automate the MS-Access Application

How to Import MDF File to Microsoft Access

24 Apr 2013 by Gouri Sancroj

An article that lists the steps to import MDF files to Microsoft Access