Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
969 questions with Microsoft 365 and Office | Access | Development tags
1 answer
A bug that prevents Access Runtime 365 from being used on Windows 10.
Thank you for your continued support. Although the issue has now been resolved, starting on August 22, we encountered a problem where Access assets opened in Access Runtime 365 could not be opened. The affected device was running Windows 10. Since a…
Microsoft 365 and Office | Access | Development
asked 2026-08-25T02:05:13.2033333+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(70.4, 96%, 16%)' 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)
test_account
0
Reputation points
commented 2026-08-28T07:25:19.53+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, 75%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
BabybooHN
2,615
Reputation points
Independent Advisor
4 answers
Microsoft Access Report – 3rd Page Prints at 1/4 Size Only When Printing Full Report
I'm having an unusual Microsoft Access printing issue at one of three locations. I have a report called rpt_Contract that includes two subreports, rpt_Legal1 and rpt_Legal2. The report prints as three pages. At one location only, when all three pages are…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-08-17T19:48:30.6733333+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(32, 96%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jazzy23
10
Reputation points
commented 2026-08-21T18:13:01.7133333+00:00
Karl Donaubauer
3,461
Reputation points MVP
2 answers
Can't Paste Multiple Objects in MS Access
Simple as that. Select multiple objects on an MS Access form, and either copy or cut them. They are not pastable. Not on the same form, and not on any form. This has been broken for AT LEAST a year now, as I found a report from 2025 citing the same…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-08-17T18:14:04.8666667+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' %3EDM%3C/text%3E%3C/svg%3E)
David Mancini
1
Reputation point
commented 2026-08-18T09:50:49.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(243.2, 5%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
Dale Fye
5
Reputation points
2 answers
How to allow access with vba forms and modules run on another laptop?
I built an Access database which is basically a frontend that uses forms with vba code and passthrough queries to connect to a SQL Server database. It works fine on the machine I built it on, but when I try to run it on my new laptop it hides a bunch of…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-08-10T19:52:36.5433333+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, 41%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dan Griswold
0
Reputation points
commented 2026-08-12T09:26:29.7033333+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(121.6, 2%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JeseminQH
270
Reputation points
Independent Advisor
30 answers
Search for subform record based on text box
I am trying to bring up a form record based on text entered in a text box. The form "Furnace + Header Data Form" is a parent form, with 2 subforms called "Header Data Form" and "Surrogate Data Form". This question is in…
Developer technologies | Visual Basic for Applications
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
1,653 questions
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2022-12-12T18:31:50.943+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(121.6, 6%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
carmens
6
Reputation points
answered 2026-07-24T19:39:24.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(32, 57.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
unshackled
0
Reputation points
1 answer
How can I prevent the code I write in Access SQL from being automatically reformatted into multiple lines?
Even if I write my SQL code on a single line in Access, it gets automatically reformatted into multiple lines when I run the query. How can I prevent this?
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-07-08T09:52:06.6633333+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(198.4, 28.000000000000004%, 29%)' 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)
Mine Dayan
0
Reputation points
commented 2026-07-09T13:46:37.5133333+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, 9%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Michelle-N
20,725
Reputation points Microsoft External Staff
Moderator
1 answer
In Access how to set criteria for show field content or not
In access: How to display a field's contents or the word "unavailable" based on another field with a yes/no structure. This is for a query that is being used for generating a report.
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-06-27T18:01:59.6733333+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(160, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Anita Diamond
0
Reputation points
answered 2026-06-27T18:09:11.3033333+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, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Duane Hookom
26,935
Reputation points
Volunteer Moderator
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-06-11T09:37:07.5033333+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(25.6, 97%, 12%)' 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)
tsuji
0
Reputation points
commented 2026-06-16T09:12:06.7833333+00:00
Michelle-N
20,725
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 | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,030 questions
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2024-11-02T12:44:18.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(92.8, 52%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Philip Cox
5
Reputation points
answered 2026-06-14T06:37:17.1233333+00:00
Gustav
767
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 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(163.2, 79%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
![](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, 69%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-04-25T00:43:26.2733333+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(3.2, 41%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 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, 3%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
2 answers
What reference libraries contain the DataObject object?
What reference libraries contain the DataObject object?
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-05-19T13:30:36.5933333+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, 32%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Doug
25
Reputation points
commented 2026-05-20T13:45:05.9166667+00:00
Michelle-N
20,725
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 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(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)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 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(179.20000000000002, 19%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 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(230.39999999999998, 90%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-03-31T20:35:20.3133333+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(169.60000000000002, 74%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIE%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-04-17T01:17:48.3166667+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(259.20000000000005, 27%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nichols Dylan
40
Reputation points
commented 2026-04-20T00:29:55.3266667+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
15,980
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
969 questions
asked 2026-04-02T11:00:59.9533333+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(304, 33%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jonathan Riley
10
Reputation points
commented 2026-04-10T07:12:13.9+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(32, 54%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Steven-N
25,315
Reputation points Microsoft External Staff
Moderator