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

Sort by: Updated
Updated Created Answers
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 13,220 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 16,540 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 17,700 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 22,305 Reputation points Microsoft External Staff Moderator
4 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 25 Reputation points
recommended 2026-04-30T13:47:10.2533333+00:00
George Hepworth 22,855 Reputation points Volunteer 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 17,700 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 13,650 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 17,700 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 17,700 Reputation points Microsoft External Staff Moderator
3 answers

Why did DoCmd.TransferSpreadsheet acImport stop working intermittently?

After MS Office updates in October, DoCmd.TransferSpreadsheet acImport sort of stopped working for one of my 7 files. If I import that file first it works fine, but then I have to close the database and then reopen it to get the other 6 files to import.…

Microsoft 365 and Office | Access | Development
asked 2026-02-10T21:32:58.0466667+00:00
Kristy Board 0 Reputation points
recommended 2026-03-02T09:43:32.3633333+00:00
Anonymous
3 answers

How can I remove the extra files?

I am trying to create a form out of a query and a search form which gathers the inputs from the user. The three inputs are Start Date, SO #, and Job. In this example I only inserted 11/06/2025 for Start Date. It resulted in 7 records which is correct,…

Microsoft 365 and Office | Access | Development
asked 2026-02-23T16:12:36.9033333+00:00
Lopez, Ahiezer 236 Reputation points
edited an answer 2026-02-24T22:50:43.7266667+00:00
George Hepworth 22,855 Reputation points Volunteer Moderator
1 answer

MS Excel Power Pivot connection issue with MS Access Odbc

Hi There, I'm encountering problem Excel pivot refresh data failed when I was trying to pull data fm MS access. below if the errors appearing. can you pls help. desperately need help to problem fix. "[Microsoft][odbc Microsoft access…

Microsoft 365 and Office | Access | Development
asked 2026-02-02T14:28:51.0833333+00:00
Ai Tee Ling (SG) 5 Reputation points
answered 2026-02-02T16:26:16.34+00:00
Karl Donaubauer 3,191 Reputation points