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
  • 226K Content
  • 16K Contributors

Expert Spotlight

Independent consultant specializing in the writing of custom packages for businesses.

Troubleshooting Solution

Dlookup problem

154
Based on the following print screen provided i am trying to do a Dlookup on that query (the tables …
Article

HMAC in VBA using the Microsoft NG Cryptography (CNG) API

This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: HMAC.
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

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

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 …
Troubleshooting Solution

redesign of Access Tables

byverpit
146
I have two Access tables that badly need a redesign.  I have posted the entire project and …
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 …
Troubleshooting Solution

MS Access Product Variables Variations Multiple Product Conditions Table and Relationship Setup For Customer Orders and Inventory

133
Ok I am very lost on this part. I have Products and each product has 4 Product Conditions. These …
Troubleshooting Solution

fiscal year end calculations

132
I need to perform some calculations based on our clients fiscal year ends.  Not all of our clients …
Troubleshooting Solution

How to create a dynamic query builder

131
I am trying to determine the best way to go about creating the code necessary to allow a user form …
Troubleshooting Solution

Access Experts: General discussion thread for Access Zone (31-Dec-2012)

118
This thread is intended for general discussion among Experts participating in the Access zones.  
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,  
Troubleshooting Solution

Quasi-Dashboard for Homemade Help Desk Program in Excel/Access

119
This question stems from a previous project that I have collaborated with one of my great friends …
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 …
Troubleshooting Solution

Access Experts: General discussion thread for Access Zone (13-Jun-2012)

104
This thread is intended for general discussion among Experts participating in the Access zones.  
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 …
Troubleshooting Solution

Get total of hours between date fields and midnight.

bybfuchs
14

Hi Experts,

I am trying to get the count of hours between a given date/time field and 12 midnight.

The

Troubleshooting Solution

Query to find phone number which won't be an exact text match

byBobby
109
I have an external vb script which is triggered by our phone system and then passes a variable …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more