Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
930 questions with Microsoft 365 and Office | Access | Development tags
3 answers
Microsoft Access form controls not updating after table changes
In Microsoft Access where updates I make to the underlying table aren’t being reflected in my bound form controls. I’ve already tried refreshing the form, rebuilding the record source, and even recreating the form from scratch, but some fields still show…
Microsoft 365 and Office | Access | Development
asked 2025-12-05T09:37:32.4933333+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, 93%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Conley Evan
20
Reputation points
answered 2025-12-05T18:15:00.1433333+00:00
DBG
11,531
Reputation points
Volunteer Moderator
4 answers
GetObject WMI Bug in Access 2510 (Build 19328.20244)
Attempting to call GetObject("winmgmts://./root/cimv2") from the Form_Activate event handler when opening a form using a Hyperlink SubAddress fails with an automation error "Unspecified error". Opening/activating the same form using…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 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, 19%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
1 answer
Search key was not found in any record Access 2016
weird Characters can not be deleted nor edited in access 2016
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-11-30T13:01:02.0133333+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(278.4, 21%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGU%3C/text%3E%3C/svg%3E)
German Umali
0
Reputation points
commented 2025-11-30T16:29:36.23+00:00
George Hepworth
22,215
Reputation points
Volunteer Moderator
2 answers
Update a year in a date field
hi i have a access db with a date field that hold data in the following format 02/10/2024 11:01:29 all i want to do is to be able on mass to update anything in the 24 year to 25, is there a way this could be done please? thanks in anticipation
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-11-30T07:23:52.4166667+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(115.19999999999999, 78%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mark Powell
0
Reputation points
edited an answer 2025-11-30T14:33:12.6733333+00:00
Ken Sheridan
3,546
Reputation points
2 answers
Access Report Prints Form Instead — Seeking Insights from the Community
Hi everyone, I'm hoping someone here can shed light on a frustrating issue we've been facing with Microsoft Access. We have a database where users click a button on a form (labeled “Delivery Sheet”) to open a report in Print Preview mode. The report…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-06-12T17:57:21.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(86.4, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Phillip Bridgeman
0
Reputation points
edited an answer 2025-11-25T17:17:22.8166667+00:00
Ken Sheridan
3,546
Reputation points
2 answers
Ms access reading data from c# code is giving unspecified error
Hi team, Facing issue while reading data from ms access in one of our widows service. after restarting the vm , the issue is getting resolved. Thank you
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-11-11T08:59:13.3966667+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(118.4, 25%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dasu, Siva (Dasu,Siva)
0
Reputation points
commented 2025-11-24T13:14:14.4033333+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(144, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jack-Bu
5,405
Reputation points Microsoft External Staff
Moderator
3 answers
Microsoft Access 2007 login button not working solution
How to create login form in Access 2007 step by step
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-11-19T14:24:29.4533333+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(128, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
Wisdom Chukwudalu
0
Reputation points
answered 2025-11-20T14:04:23.5733333+00:00
Ken Sheridan
3,546
Reputation points
1 answer
One of the answers was accepted by the question author.
How to sum column C and D if columns A = Starmer and B = Elected.
I have the following table. I need a way to a) aggregate elected position for each name b) aggregate non-elected position where it does not match the name c) a total of each one So for example Starmer wins. The Elected result should show 38. Non-Elected…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-11-11T20:43:23.74+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(48, 30%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HelloWorldMan
20
Reputation points
commented 2025-11-13T08:25:34.7166667+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
2 answers
How-to get RichText from LongText AppendOnly ColumnHistory()?
Is there a workaround to get the HTML-ish RFT from ColumnHistory() of a LongText field set with RichText format and AppendOnly versioning? I'm not trying to defend AppendOnly vs better solutions. Or storing HTML-ish RTF in Access. Just asking if anybody…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-07-25T22:26:34.42+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, 38%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Dick Watson
126
Reputation points
commented 2025-11-13T06:46:49.1833333+00:00
Dick Watson
126
Reputation points
4 answers
One of the answers was accepted by the question author.
Update Table Column with Sum of Two Numbers in Two Tables
I have ran into a brick wall trying to create an update query. I want to update the number stored in the column of a table with the sum of another number in the same table and another number in another table. Attached is the relationship between the…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-11-07T16:18:05.6666667+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, 57.99999999999999%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Keith A
40
Reputation points
edited a comment 2025-11-11T14:31:03.1233333+00:00
Ken Sheridan
3,546
Reputation points
3 answers
Error in InStrRev with respect to VarType
The MS ACCES has problems with this statement: HAVING ((( 1 * InStrRev ([Query21].[Naam tegenrekening], "Broek")) = 13 )) It reports "Type Mismatch", yet VARTYPE on this expression reports type = 3 (long…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-11-07T10:39:28.52+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(214.4, 8%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Pieter van Leeuwen
0
Reputation points
commented 2025-11-10T06:11:57.81+00:00
Jack-Bu
5,405
Reputation points Microsoft External Staff
Moderator
1 answer
My MS Access can connect to Azure Synapse SQL Serverless Pool, but failed to obtain data.
I connect from local MS Access File to Azure Synapse SQL Serverless Pool. I can connect to the db, and select the table and its column, but failed after select the column and got the error above. And another error message said the process is occupied by…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-10-31T04:54:56.94+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, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jason Wong
20
Reputation points
commented 2025-11-05T06:50:38.6833333+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,265
Reputation points Microsoft External Staff
Moderator
2 answers
Query to copy distinct records - no duplicates
I need to create a query to copy ONLY DISTINCT records to a new table where the old table has many duplicates? Should I set the query to copy only the First of each field? Also how do I insure that the new table accepts only distinct re records going…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-10-26T18:24:17.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(214.4, 84%, 30%)' 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)
Maxine Nietz
1
Reputation point
answered 2025-10-27T13:01:43.0933333+00:00
Ken Sheridan
3,546
Reputation points
1 answer
Microsoft Access Database Engine（ACE OLE DB 12.0）
How can I download Microsoft Access Database Engine（ACE OLE DB 12.0）? And how can I equip it with my visual Studio 2022?
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-07-04T01:27:22.48+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, 26%, 29%)' 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)
Mojito
5
Reputation points
commented 2025-10-26T04:01:26.11+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(236.8, 21%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
vini Rayal
0
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
930 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,984 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)
2 answers
Setting TabIndex Property in VBA No Longer Working After Recent MS Office Updates
September: After my PC installed recent MS Office updates (within the last two weeks), currently running Version 2508 Build 16.0.19127.20192 (32-bit), setting the TabIndex property is no longer behaving as expected. I have procedures, in MS Access forms,…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2025-10-03T17:54:13.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(102.4, 44%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEY%3C/text%3E%3C/svg%3E)
Eric Yevtushok
0
Reputation points
commented 2025-10-08T18:54:48.1033333+00:00
Eric Yevtushok
0
Reputation points
4 answers
How to I get my Office 2019 back. 365 has replaced it.
I own MS Office Pro 2019. 365 has now replaced it. I want 2019 back. How this happened: I volunteer with a non-profit that uses 365. In order to coordinate calendar, they gave me a 365 email account. When I activated the 365 email in 2019…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
11,288 questions
asked 2022-10-24T12:40:54.73+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, 36%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Coach Pop
6
Reputation points
edited a comment 2025-09-28T16:55:11.25+00:00
Stefan Blom
323.1K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
How to fix Automation error Object is not connected to server
I have an MS Access database with a table that has an OLE Object type field. The field stores a PowerPoint slide associated with the rest of the data in the record. I have a form with a bound object frame for the OLE Object field. There is a Button on…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
asked 2024-12-02T17:17:17.8866667+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(265.6, 71%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
William Sessums
20
Reputation points
accepted 2025-09-26T19:48:15.8733333+00:00
William Sessums
20
Reputation points
3 answers
One of the answers was accepted by the question author.
Access declare stmt issue moving from Windows 10 to 11
Hi, I have a basic Access database that is erroring on me now that it was updated to Windows 11. The error message is Compile Error The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 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(313.6, 45%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
7 answers
One of the answers was accepted by the question author.
TransferDatabase help
I have a MS Database that when I close the database, I want to export the main data table to a back-up database. Here is my VBA script - destfilename = "PGA Matrix 6-2022 - REP VERSION.mdb" destfileloc =…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
930 questions
Developer technologies | Visual Basic for Applications
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
1,554 questions
asked 2022-06-13T19:33:04.44+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(265.6, 80%, 35%)' 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
21
Reputation points
commented 2025-09-12T11:25:04.5566667+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(9.6, 3%, 10%)' 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)
Moore, Mike [EMR/MSOL/HSTN]
0
Reputation points