963 questions with Microsoft 365 and Office | Access | Development tags

Sort by: Updated
Updated Created Answers
1 answer

Access 365: Control stacking order changes when using Tab key in form Design View (2309 and later)

Issue In Microsoft Access for Microsoft 365, in form Design View, when overlapping controls are selected, the stacking order (front/back display order) changes unexpectedly when using the Tab key to move the selection. Example Initial state (design…

Microsoft 365 and Office | Access | Development
asked 2026-06-11T09:37:07.5033333+00:00
tsuji 0 Reputation points
commented 2026-06-16T09:12:06.7833333+00:00
Michelle-N 17,775 Reputation points Microsoft External Staff Moderator
2 answers

How to view .SNP file

I have a number of files in .SNP format, which originally could be opened with the Microsoft Snapshot Viewer which was part of Microsoft Access. I cannot find a safe version of that program to download. How can I view these .SNP files now or convert them…

Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | Development
asked 2024-11-02T12:44:18.7533333+00:00
Philip Cox 5 Reputation points
answered 2026-06-14T06:37:17.1233333+00:00
Gustav 757 Reputation points MVP
4 answers

VBA fails after recent Windows update...

I have this old MS-Access program (from 2002) where i use a matrix routine from Excel. It has worked until recently - but now fails on my Windows11-PC. I have an older bakup-PC with Windows10. They share the same OneDrive, and the program works on the…

Microsoft 365 and Office | Access | Development
asked 2026-06-10T15:55:38.2833333+00:00
Jake104E 40 Reputation points
commented 2026-06-11T22:14:37.9366667+00:00
Hin-V 15,490 Reputation points Microsoft External Staff Moderator
5 answers One of the answers was accepted by the question author.

Microsoft Access Conditional Formatting Color Palette Choices Reduced

Microsoft Access Conditional Formatting Color Palette Choices Reduced. I used to be able to choose from about 40ish colors, then the next menu to about 100 color, then to the custom palette. The 40ish color palette is now replaced with a simple 10…

Microsoft 365 and Office | Access | Development
asked 2026-04-25T00:43:26.2733333+00:00
Angela Marie 45 Reputation points
commented 2026-06-03T16:46:12.75+00:00
Angela Marie 45 Reputation points
3 answers

Append to Clipboard using MS Access VBA

I have a delimited string, ConstStr = "1356, 1360, 1366, 1368", and would like to add each value in the string to the clipboard so that, when executing a "Paste", all the values would fill individual cells,…

Microsoft 365 and Office | Access | Development
asked 2026-05-19T13:01:34.2066667+00:00
Doug 25 Reputation points
edited a comment 2026-05-21T14:10:07.3066667+00:00
Vergil-V 14,780 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Microsoft Forms 2.0 Object Library

The "Microsoft Forms 2.0 Object Library" is not found in my MS Access Reference drop down list. Where is it found?

Microsoft 365 and Office | Access | Development
asked 2026-05-19T13:53:53.5933333+00:00
Doug 25 Reputation points
accepted 2026-05-21T14:07:36.35+00:00
Doug 25 Reputation points
2 answers

What reference libraries contain the DataObject object?

What reference libraries contain the DataObject object?

Microsoft 365 and Office | Access | Development
asked 2026-05-19T13:30:36.5933333+00:00
Doug 25 Reputation points
commented 2026-05-20T13:45:05.9166667+00:00
Michelle-N 17,775 Reputation points Microsoft External Staff Moderator
3 answers

Reference for DataObject

Dim MyData As DataObject produces this error: Is there a Reference to a dll required?

Microsoft 365 and Office | Access | Development
asked 2026-05-19T13:27:53.73+00:00
Doug 25 Reputation points
commented 2026-05-20T12:55:34.89+00:00
Gabriel-N 19,035 Reputation points Microsoft External Staff Moderator
2 answers

DataObject object reference for MS Access

What reference library should I use to define DataObject in VBA code for MS Access project?

Microsoft 365 and Office | Access | Development
asked 2026-05-19T13:47:55.22+00:00
Doug 25 Reputation points
commented 2026-05-20T07:18:07.4566667+00:00
Jayden-P 23,245 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Access VBA, Screen.ActiveReport.Name not working code stopt no report is present

On Error Resume Next reportName = Screen.ActiveReport.Name If Err.Number <> 0 Then MsgBox "Is momenteel niet actief.", vbExclamation Err.Clear Exit Sub End If On Error GoTo 0

Microsoft 365 and Office | Access | Development
asked 2026-04-21T09:41:12.9166667+00:00
C.J. P 40 Reputation points
commented 2026-04-23T08:30:50.35+00:00
Gabriel-N 19,035 Reputation points Microsoft External Staff Moderator
2 answers

MS Access ohe add in

seit gestern kann ich keine Email aus Outlook in MS Access 365 importieren, es sind keine Add ins vorhanden, ich kann auch keine nach installieren

Microsoft 365 and Office | Access | Development
asked 2026-03-31T20:35:20.3133333+00:00
Ibrahim Etier 0 Reputation points
commented 2026-04-23T08:09:10.3066667+00:00
Ibrahim Etier 0 Reputation points
3 answers

Microsoft Access: Database is in an inconsistent state on Network Shares

We have a split .accdb database stored on a shared network drive. Since the latest Office update, users are constantly getting the error 'Microsoft Access has detected that this database is in an inconsistent state.' Running 'Compact and Repair' dozens…

Microsoft 365 and Office | Access | Development
asked 2026-04-17T01:17:48.3166667+00:00
Nichols Dylan 40 Reputation points
commented 2026-04-20T00:29:55.3266667+00:00
Dora-T 14,370 Reputation points Microsoft External Staff Moderator
3 answers

OleDbConnection using Microsoft.ACE.OLEDB.16.0 causes an access violation in mso98win32client.dll on app closing

I recently updated one of our VB.NET 4.8 applications from 32 bit to 64 bit. The application uses an OleDbConnection using Microsoft.ACE.OLEDB.16.0 to connect to an access database. We noticed that when the application closes, it hangs for around 15 - 20…

Microsoft 365 and Office | Access | Development
asked 2026-04-02T11:00:59.9533333+00:00
Jonathan Riley 10 Reputation points
commented 2026-04-10T07:12:13.9+00:00
Steven-N 25,305 Reputation points Microsoft External Staff Moderator
2 answers

Look/Style

How do I change the look/style of the overall database?

Microsoft 365 and Office | Access | Development
asked 2026-03-30T15:00:44.8533333+00:00
Kimberlene Perry 0 Reputation points
commented 2026-03-30T16:57:25.7+00:00
George Hepworth 22,855 Reputation points Volunteer Moderator
2 answers

I want to purchase time with an Access/Word merge specialist

I have a Access database that has a button that opens a DocumentMenu that is on a networked drive. That Menu hyperlinks to documents that, when clicked, are supposed to (and did, in Office2007) open forms that are connected to tables in my Access…

Microsoft 365 and Office | Access | Development
asked 2026-03-26T13:03:14.3066667+00:00
Durst Law 0 Reputation points
commented 2026-03-27T08:25:32.94+00:00
Gabriel-N 19,035 Reputation points Microsoft External Staff Moderator
2 answers

MS Access macro grouping

I have created a group block of actions within a Macro but cannot find how to remove the grouping specification.

Microsoft 365 and Office | Access | Development
asked 2026-03-12T02:28:19.1066667+00:00
Mark Woodhead 0 Reputation points
commented 2026-03-16T03:03:23.5+00:00
Anonymous
4 answers One of the answers was accepted by the question author.

Table entering a record with no data from form button click

I have a relational database table (itemTable) connected to a Main Form. Connected to the main form is a sub Form (itemImages)Connected to ItemImageTable . After Adding the item data, i go to enter the item images on the sub form but, after adding the…

Microsoft 365 and Office | Access | Development
asked 2026-03-11T21:34:33.66+00:00
Mark Truett 20 Reputation points
commented 2026-03-12T20:08:31.38+00:00
DBG 11,711 Reputation points Volunteer Moderator
3 answers One of the answers was accepted by the question author.

I want to ask is there a known registry override to increase the handle limit

My Access application is frequently crashing with Error 3048 ("Cannot open any more databases") despite properly closing all recordsets and setting objects to Nothing in my VBA cleanup routines. Since the latest Office update (Build 2602), the…

Microsoft 365 and Office | Access | Development
asked 2026-03-09T13:50:10.7833333+00:00
Hon Ying 40 Reputation points
accepted 2026-03-10T14:13:03.89+00:00
Hon Ying 40 Reputation points
1 answer

Necesitamos SQLServer2005_BC_x64.msi para Access

Necesitamos SQLServer2005_BC_x64.msi, donde lo podemos decargar?. Aqui ya no esta https://archive.org/download/sql-server-2005-backward-compatibility-components/SQLServer2005_BC_x64.msi Es para usar un Access Gracias

Microsoft 365 and Office | Access | Development
asked 2026-03-06T14:50:39.4166667+00:00
FranciscoJose.Aguilar 0 Reputation points
answered 2026-03-06T15:19:22.3966667+00:00
George Hepworth 22,855 Reputation points Volunteer Moderator
4 answers One of the answers was accepted by the question author.

ActiveX Register

Just upgraded to latest Access. How do I "Register" an ActiveX Control from a previous version?

Microsoft 365 and Office | Access | Development
asked 2026-03-02T06:07:02.13+00:00
RobJCut 105 Reputation points
commented 2026-03-05T07:41:28.99+00:00
Gabriel-N 19,035 Reputation points Microsoft External Staff Moderator