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

Expert Spotlight

Christopher Hankwembo is a Zambian Chartered Accountant and also developer of CA Premier Accounting Package

Troubleshooting Solution

Need to stop Access front end bloating while running.

46
I have an MS Access o365 front end .accdb file in a split database application.

When running the …
Article

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

27
by Patrick G. Matthews


A common request in the various …
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…
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

Updated roadmap from Microsoft on Microsoft Access:  …

1
Updated roadmap from Microsoft on Microsoft Access:

Article

Truly Random Numbers in VBA

6
Pseudo random numbers are right at hand in VBA. Obtaining truly random numbers, however, requires an external source. One is the Swiss Quantis QRNG Chip. The output from one of these has been made public by ETH Zürich, and here we present a complete solution for retrieval of random numbers in VBA.
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 …
Troubleshooting Solution

No Click event for ComboBoxes when you first click them -- help!

24
In my never-ending quest to make things easy for my users, and for me as a coder trying to make …
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

Need to create multiple dependent drop-down lists in Excel based on selections and another sheet.

36
I have an Excel document where I need to create multiple dependent drop-down lists in Excel specific…
Troubleshooting Solution

Sharing Microsoft Access database online

9
Hi
I have a Microsoft Access split database solution that I would like to share online. I don't want …
Troubleshooting Solution

VBA for using the Windows File Dialog

22
Folks,
I know that there has to be a procedure where when one  clicks on a command button for the …
Troubleshooting Solution

Function to sort record of many note fields.

bybfuchs
28
Hi Experts,
I'm looking for a solution to a poor designed db, (not taking any credit for it, and …
Troubleshooting Solution

Access 13. Can I access the property sheet in form view

15
Access 13. Can I access the property sheet in form view? If so how?
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

Looking for free relational database software recommendations

41
I'm going to teach a couple of friends (intro) SQL.  One of them has MS Access, as do I.  The other …
Troubleshooting Solution

looping thru all table fields and constructing a SQL where string

bybfuchs
22
Hi Experts,

I am looking to dynamically construct a SQL string based on two tables as follows.

Having …
Troubleshooting Solution

Freaky -- Can someone explain this bizarre VBA ListBox behavior?

16
OK, I've got a form with a listbox and a textbox. I want the textbox to get updated with the …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more