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

Expert Spotlight
Daniel Pineault
President / Owner CARDA Consultants Inc.

Making your data sing and fixer of broken things.

Troubleshooting Solution

Dlookup problem

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

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

byPatrick Matthews
27
by Patrick G. Matthews


A common request in the various …
Video
Executing a SQL Server Stored Procedure from Within Access 5m

Executing a SQL Server Stored Procedure from Within Access

byTechMommy
6
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft …
Post

Recently, users of O365 Microsoft Access have been getting …

byJim Dettman (EE MVE)
2
Recently, users of O365 Microsoft Access have been getting #Deleted on all records when using …
Troubleshooting Solution

VBA or Macro to send the cursor in the "search..." of the Access Navigation panel

byGontran Harvey
23

I would need a macro or vba code the set the focus to  the search field in the top of the naviagtion

…
Troubleshooting Solution

MS Access 2003 Error in loading DLL when performing .Net Interop

byKyle Abrahams
27

Hi All,


We are running into error 48 (error in loading DLL) when performing an interop operation from

…
Post

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

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

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

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

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

byDustin Stanley
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

bynfstrong
133
I need to perform some calculations based on our clients fiscal year ends.  Not all of our clients …
Article

Utilise Microsoft's Next Generation Cryptography (CNG) API in VBA

byGustav Brock
2
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: Compatible with other environments.
Troubleshooting Solution

How to create a dynamic query builder

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

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

byTerri Anderson
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, …

byLucas Bishop
1
Gmail just launched a physical Security Key access option, dubbed as Advanced Protection, for their …
Troubleshooting Solution

Add New Record Based on Form Field Data

byJack Lugo
17

I have 'User Permissions' set up on my DB that allow certain 'User Groups' different enabled

…
Article

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

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

As stated in the first article,  …
Article

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

byGustav Brock
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: Hashing.
Article

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

byGustav Brock
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: Encryption.
Article

Storing encrypted data in Microsoft Access

byGustav Brock
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: Storing hashed or encrypted data.
Article

Storing passwords in VBA using the Microsoft NG Cryptography (CNG) API

byGustav Brock
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: Handling passwords.

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more