Explore Access on Experts Exchange

Expert Solutions for Your Tech Problems

AccessMicrosoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications,...

Read more
  • 224K Content
  • 16K Contributors

Expert Spotlight
Keep everyone healthy; Wear a mask - Social distance - Don't touch your face - Wash your hands for 20 seconds

Almost 50 years of programming experience. Click '+ More' in my "Full Biography" to see links to some articles I've written.

Troubleshooting Solution

I'm running an Access 2016 Front End and a SQL Server 2014 back end. I'm unable to Update Access Date fields in my project.

110
I can't seem to get Access and SQL to communicate when it comes to Dates. The project I'm working on …
Article

Creating a customized Access ribbon and Network Database

I wrote this article because I was unable to find an article on this here on EE. Read on for step-by-step instructions on how to create a custom command ribbon in your office applications that not only make them look more professional but also protects against the ID10T error.
Video
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Article

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access

27
by Patrick G. Matthews


A common request in the various …
Post

I recently passed my Microsoft 70-346 Exam.  As part of my …

4
I recently passed my Microsoft 70-346 Exam.  As part of my revision I used Flash Cards that I …
Post

Hello everyone out there in Experts Exchange World!  My name…

8
Hello everyone out there in Experts Exchange World!  My name is Terri and I am new to this site.  …
Post

Gmail just launched a physical Security Key access option, …

1
Gmail just launched a physical Security Key access option, dubbed as Advanced Protection, for their …
Article

Callback functions in Microsoft Access VBA. Part 1

1
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
Article

Callback functions in Microsoft Access VBA. Part 2

Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to reconfigure a callback function.
Article

Callback functions in Microsoft Access VBA. Part 3

Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to share one callback function between multiple controls.
Article

Understanding and using CommandBars, Part II (Creating your own)

38
Applies to: 2000, 2003, 2007, 2010, 2013 (desktop)

As stated in the first article,  
Article

Revitalise colours in the VB editor

The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.
Post

Lost code of form  Issue If you on a form decide to …



Lost code of form
Issue
If you on a form decide to move some controls into a…
Article

Indian number formatting of Currency in Microsoft Access and Excel

The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dynamic formatting to accomplish this.
Troubleshooting Solution

Ad sequence number to new record in MS Access

66
I have several forms but these are all linked to the same table and create or elaborate records on …
Post

WebRTC Came to stay!  It took a while but it seems that …

1
WebRTC Came to stay!

It took a while but it seems that now there is no turning back.

Levou um …
Article

Search As you Type for Microsoft Access Combobox

This is a rather simple but effective way of searching while typing on a Microsoft Access Combobox.
Troubleshooting Solution

Issue to DLookup in VBA

32
Hi,
How to resolve issue with DLookup to line below? I want to validate if table "Week8-13" is …
Troubleshooting Solution

Revising a Regex Function: MS Access

94
Hello Experts,
I need help revising a regex function that was created for me earlier this year by …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more