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
Edward van Biljon (MVP)
M365 Apps & Services MVP | Windows Insider MVP | MCT | Author | eJPTv2 | eCPPTv2 | CRTP | CRTE | CRTO | Security+ | CEH | Pentest+

Experienced Messaging Specialist with a demonstrated history of working in the information technology and services industry.

Troubleshooting Solution

Excel 365 allows overlapping areas in a scattered Selection. Why?

byRobert Berke
1

At one time Excel 2016  prevented overlapping cells in a scattered selection.

Excel 365 no longer

…
Troubleshooting Solution

Only group records if gap is less than half hour.

bybfuchs
20

Hi Experts,


I have the following query that groups all schedules of patients per patient, per

…
Troubleshooting Solution

Resolve Type mismatch in expression

bybfuchs
6

Hi Experts,

When trying to join a field that is defined as date with a field that is defined as text,

…
Troubleshooting Solution

Query showing all records not included in another query.

bybfuchs
3

Hi Experts,

I have the following query named QSEISMatching  that displays records by joining two

…
Troubleshooting Solution

MS Access with Teams?

bySteveL13
2

I've been advised not to use MS Access with Sharepoint.  But what about with Teams?

Troubleshooting Solution

Ms Access Count Question

byDeeDee Baldwin
2

How could I count the Columns in a string in MS Access query?  I am not counting the value within

…
Troubleshooting Solution

Creating query to display all records in QueryA that are not in QueryB

bybfuchs
13

Hi Experts,


I am having trouble creating a query that gives me all records from one query that are

…
Troubleshooting Solution

Issue with Access form

byFred Webb
9

I have a custom-made progress bar using a form (Progressbar) and a text box with some code on a

…
Troubleshooting Solution

ms access question

byDeeDee Baldwin
2

I need to create a calculated field in MS Access query  that determines  if Field A is <= 125% of

…
Troubleshooting Solution

Access takes forever to open

bySteveL13
15

I use MS Access quite a bit.  But lately when I try to open a database, it seems to take forever for

…
Troubleshooting Solution

Error with linked Excel file on date field.

bybfuchs
13

Hi Experts,

Why do I get in one pc an error when linking to an excel file and field defined as

…
Troubleshooting Solution

Syntax Error

bySteveL13
3

I'm getting a syntax error when I try to open a form using...  (note that IDPropertyName is a text

…
Troubleshooting Solution

How to cope with "empty" sub-reports in Access Reports?

bycolinasad
7

I am using an Access 2007 "ADE Project" as a front-end to a SQL Server database.

I have an Access

…
Troubleshooting Solution

SharePoint 2019  - Replacing Lists with Imports

byJake S
2

I have a form in SharePoint 2019 (local server)  that does a lookup from a list called "Assignment"

…
Troubleshooting Solution

Query to round to the nearest 15 minutes.

bybfuchs
10

Hi Experts,


I have the following query returning all records where scheduling of both tables/queries

…
Troubleshooting Solution

Option group search not working

byFred Webb
4

I have an option group search on my Form Exact Match Begins With and Contains 

The only thing firing

…
Troubleshooting Solution

Make an access form label control visible based on the value in a text control

byFred Webb
8

I have a form with a label control (lblNotfnd) that I only want visible when the value in a boolean

…
Troubleshooting Solution

Displaying First and Last name only stored in one field.

bybfuchs
5

Hi Experts,

How do I display a field containing full name without showing the middle name if exists?


Troubleshooting Solution

Error when selecting a record on a sub form

bySteveL13
5

I'm getting an error when entering a new record in a continuous form sub form.  The error happens

…
Troubleshooting Solution

Join two schedule tables storing info in different format.

bybfuchs
12

Hi Experts,


I have two tables storing schedule info of patients, one has it in one record per day, as

…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more