Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
1,986 questions with Microsoft 365 and Office | Access | For business | Windows tags
2 answers
One of the answers was accepted by the question author.
how to download Access app without affecting the existing office apps
i need to download Access app without affecting the existing office apps .. i tried xml file through office customization tool but id uninstalled the office apps .. i am open to any solution
Microsoft 365 and Office | Access | For business | Windows
asked 2025-12-11T08:49:51.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 48%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
abdo elbarbary
20
Reputation points
accepted 2025-12-12T08:38:36.2033333+00:00
abdo elbarbary
20
Reputation points
2 answers
Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. how can i fix this errror
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-12-11T15:46:47.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 68%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
michael moore moore
0
Reputation points
answered 2025-12-11T18:09:35.7133333+00:00
DBG
11,531
Reputation points
Volunteer Moderator
6 answers
MS Access- How to create a list from a Combo Box
On my form, I want a combo box that displays a list from my table that based on a select from the table, returns a list of matching records.
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-12-05T18:24:30.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Patrick Snyder
0
Reputation points
commented 2025-12-10T17:55:22.4466667+00:00
DBG
11,531
Reputation points
Volunteer Moderator
2 answers
I am getting message when trying to load a new table: "search key not found in any records"
I am trying to load a table. I am getting the message: Search key not found in any records what do I do?
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-12-01T17:54:35.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 28.000000000000004%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
RICHARD DINICOLA
0
Reputation points
answered 2025-12-01T18:40:43.14+00:00
George Hepworth
22,220
Reputation points
Volunteer Moderator
4 answers
Icons are greyed out on my Microsoft Access app
In my Access application, form Icons are not available on the home page. Need to know how to fix it, More specifically I need to sum in a form using a formula in the foot page using the following code =sum([Amount]) but I am getting an error message. The…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 5%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
3 answers
Unwarranted requests to reinstall Access
I am frequently prompted to reinstall Access on my computer. It is Office Professional Plus 13. I also have Office 365 installed on my computer. Help!!!
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-11-24T16:08:54.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMZ%3C/text%3E%3C/svg%3E)
Mt Zion MBC Family Ministry
0
Reputation points
commented 2025-11-28T05:06:03.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 70%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Tammy-Ng
5,510
Reputation points Microsoft External Staff
Moderator
3 answers
MS Access Database Instantly Crashes on Version 2512 Build 19509.20000
I have an Access file that worked on Version 2512 (Build 19504.20000), but instantly crashes on Version 2512 (Build 19509.20000). It appears to be a small update 19504 to 19509. From what I can tell, the database locks, then crashes. I can create new…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-11-12T19:07:23.1366667+00:00
Daniel Needemyer
40
Reputation points
edited an answer 2025-11-20T06:13:55.7033333+00:00
Tammy-Ng
5,510
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
How to highlight a txtbox background according to another table?
I have a list of holidays in a table. I would like to use this list to highlight a holiday date on a calendar in Access. Is there a language I can use?
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-11-17T17:14:14.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Robbie Doo
20
Reputation points
accepted 2025-11-19T17:23:29.1133333+00:00
Robbie Doo
20
Reputation points
2 answers
Using ODBC Scalar Functions via the Microsoft.ACE.OLEDB.12.0 provider raises error -2147217900: Malformed GUID in query expression
I'm connecting to an Excel spreadsheet via Ms Access using ADODB and the Microsoft.ACE.OLEDB.12.0 provider. This all works fine using standard Ms Access SQL functions, but as soon as I try to use an ODBC Scalar Function it raises an error -2147217900:…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-11-17T06:35:39.6233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 62%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Brett Miles
21
Reputation points
commented 2025-11-18T08:31:15.9433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
Gabriel-N
9,955
Reputation points Microsoft External Staff
Moderator
2 answers
How to export a Big Access DataBase on a CSV file
Hello, I search a way to export my Access database to a CSV file to change the database. I just want a solution or know if that's possible export it because when I try to export it (I click on saved export) Then I can pick different options between…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-11-07T08:21:19.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
BRENDLEN, Valentin
0
Reputation points
answered 2025-11-13T14:51:40.74+00:00
George Hepworth
22,220
Reputation points
Volunteer Moderator
4 answers
One of the answers was accepted by the question author.
Advanced Filter/Sort and Toggle Filter Not working
Within the past couple of weeks, users of multiple Access databases have experienced instances of the Advanced Filter/Sort and Toggle Filter not working (greyed out). The forms have an underlying query and when you go into Advanced Filter/Sort, Access…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-11-10T16:43:14.6266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 78%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TroyD
65
Reputation points
answered 2025-11-12T21:53:29.9866667+00:00
George Hepworth
22,220
Reputation points
Volunteer Moderator
2 answers
Why is my “Microsoft Outlook Object Library” reference missing after I updated to the “New Outlook” in Microsoft 365?
Although I’m a novice, I manage an access database that generates multiple emails via VBA. We recently updated to the “New Outlook” and following the update, the emails will no longer generate, due to a missing “Microsoft Outlook Object Library”. (When I…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 86%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
4 answers
Microsoft 365 Access VBA Error
I created an Access database that loads tables from csv files, runs two queries and creates a csv report file through the use of modules. macros and import and export file specification. In its current format it works correctly. A change to the csv…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-11-03T17:29:43.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jolitz, Thomas
0
Reputation points
answered 2025-11-07T19:08:04.5266667+00:00
Jolitz, Thomas
0
Reputation points
3 answers
Access 2024 just installed, template for "Home Inventory" will not load
Access template error for Home Inventory.pdf hp laptop.pdf error screen and computer spec in attached pdf.
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-10-22T20:12:02.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 68%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Richard Meszaros
0
Reputation points
edited a comment 2025-10-23T11:19:03.6066667+00:00
George Hepworth
22,220
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Microsoft Access error - Data type mismatch in criteria expression
Receive error in Microsoft Access when running a query - data type mismatch in criteria expression. How can I resolve this error?
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-10-21T19:10:28.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 24%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Milnor, Deanna L
20
Reputation points
accepted 2025-10-22T11:57:51.6766667+00:00
Milnor, Deanna L
20
Reputation points
2 answers
Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)
Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
931 questions
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
1 answer
Bug in Access Database Compare Tool
Hello As seen in the screenshot: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2024-06-17T15:11:21.3+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 77%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
StewartBW
1,905
Reputation points
commented 2025-10-15T13:53:57.7533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 26%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Michael Coffey
0
Reputation points
3 answers
MS Access Salesforce Connector - Is it really being retired?
Guys (and maybe Karl Donaubauer) , My company uses the MS Access Salesforce Connector a lot for mission critical work. Currently it is working great. But today I saw this website: …
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-09-12T03:55:37.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 15%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Paul Sisler
0
Reputation points
commented 2025-10-15T13:09:31.9633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 79%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NaomiG
0
Reputation points
5 answers
One of the answers was accepted by the question author.
MS Access "Undefined function in Expression"
I wrote the below function and am trying to use it in a query but I keep getting an "Undefined function in Expression" error: Option Compare Database Option Explicit Public Function DZRxCheckEligible(Location As String, SurgeryDate As…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-10-08T16:06:41.7966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 37%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZD%3C/text%3E%3C/svg%3E)
Zhang, De-An
40
Reputation points
commented 2025-10-14T02:28:00.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dora-T
8,520
Reputation points Microsoft External Staff
Moderator
1 answer
Microsoft blocked macros
how I will enable all macros in microsoft access, excel and word files
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
1,986 questions
asked 2025-09-12T06:16:44.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 94%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marie Marteja
0
Reputation points
commented 2025-09-24T08:13:41.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 18%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Austin-H
6,990
Reputation points Microsoft External Staff
Moderator