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

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

"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…
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

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

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

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?
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

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 …
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.
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

Access 16 - Report Displaying Selections Without Data

18
Hi Experts,

Please see the file for the details described below.
 
I am creating a report to contain …
Troubleshooting Solution

How to parse Name field into separate fields

28
MS Access query to Parse string that may contain any or all of the following: title, first name, …
Troubleshooting Solution

how to convert an msaccess db backend to mssql

15
I developed a database in MS Access 365 and am now being told that since MS has deprecated Access as …
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 …
Post

Updated roadmap from Microsoft on Microsoft Access:  …

1
Updated roadmap from Microsoft on Microsoft Access:

Troubleshooting Solution

ODBC Error

64
Hello,
As our internal web service, we are running Apache 1.3.26 (Win32) with PHP 4.3.5.
Windows 7…

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more