Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
20,824 questions with Microsoft 365 and Office | Access | For home | Windows tags
1 answer
One of the answers was accepted by the question author.
change access default language from Chinese to English
I work in China, use a Huawei computer and have a Microsoft 365 subscription. I have English Chinese and Danish installed as languages with English as default. When using Access, however, the program automatically change to Chinese every time I enter a…
Microsoft 365 and Office | Access | For home | Windows
asked 2025-10-23T02:28:00.1566667+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(0, 16%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Siri China
20
Reputation points
commented 2025-10-25T01:46:40.93+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, 11%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Teddie-D
6,630
Reputation points Microsoft External Staff
Moderator
3 answers
I purchased Microsoft 365 Personal and do not seem to have access to Microsoft Access
I purchased Microsoft 365 personal because my son needed to use Microsoft Access for one of his classes, but after the Microsoft 365 apps were installed, Microsoft Access was not among them. How do I get Microsoft Access?
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 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(51.2, 25%, 14%)' 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)
3 answers
MS Access object location error
I keep getting this error when trying to sort one of my tables on a number column. It goes ahead with the sort after I click OK. It's not helpful that its just a quote mark. I compacted and repaired because I don't know what else to do, but it still…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 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(60.8, 81%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%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(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)
3 answers
Error in Access VBA on Combo Box
On a form I have a combo box, Combo61, with the following code for AfterUpdate: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[SONo] = '" & Me![Combo11] & "'" If rs.NoMatch Then MsgBox "That SONo does not…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-10-09T18:25:39.23+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
commented 2025-10-14T19:19:48.5666667+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(291.2, 38%, 38%)' 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)
Marcin Policht
63,720
Reputation points MVP
Volunteer Moderator
3 answers
Adding calculated total against an ID
Hi all. First of all... I have no Access training, or database training, and am doing this by watching youtube and reading lots of questions/answers online. I'm playing a game, where your characters can win points in contests. As it's getting quite…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-09-20T10:20:40.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(291.2, 15%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Silke Juppenlatz
1
Reputation point
commented 2025-10-12T08:36:44.5966667+00:00
Silke Juppenlatz
1
Reputation point
2 answers
Access password
My Access is now requiring a password. I did not set a password.
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-10-08T00:24:47.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(246.4, 66%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Michelle Johnson
0
Reputation points
commented 2025-10-09T08:57:21.1066667+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
6,450
Reputation points Microsoft External Staff
Moderator
5 answers
Why is the paste function no longer working in Access, in design view of a Form? But, copy works.
While in the design view of a Form, I am unable to paste. I am able to copy. But, the "paste" is greyed out when I right click to paste. The Ctrl C works, I can see it select items. But, the Ctrl V does not do anything.
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 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(284.8, 44%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
1 answer
Does Microsoft 365 Personal have Access
Does Microsoft 365 Personal have Microsoft Access?
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-09-09T03:31:21.82+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(224.00000000000003, 81%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPW%3C/text%3E%3C/svg%3E)
Paul White
0
Reputation points
commented 2025-09-24T08:12:48.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(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
5,780
Reputation points Microsoft External Staff
Moderator
4 answers
My order entry software requires MS Access 2010 and recently having problem opening the software since it appears to be trying upgrade to a newer version of MS Access. Can I prevent it from trying to upgrade of make changes?
My front order entry software requires the use of an older version of Microsoft Access 2010 and has been working fine however recently it is not opening properly and it appears to be trying to upgrade to a newer version to Access. Are there any fixes…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-09-22T02:55:03.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(153.6, 75%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBO%3C/text%3E%3C/svg%3E)
Bert O
0
Reputation points
edited a comment 2025-09-23T09:07:05.6433333+00:00
Karl Donaubauer
2,336
Reputation points MVP
5 answers
Exporting Access Query Data to Specific Cells in Excel: Guidance Needed
For a non-technical use, could someone please offer a detailed description, or refer me to one, that shows how to export data from an Access query or report to specific cells in Excel. Again, I am not proficient in Access. Thank you
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-09-13T16:58:15.9266667+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(272, 42%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
William Bielfeldt
45
Reputation points
answered 2025-09-14T14:34:29.4433333+00:00
William Bielfeldt
45
Reputation points
2 answers
Getting an unexpected error in the code of a function
I have a function to perform a MailMerge as follows: Function PrepForWord() Dim objWord As Word.Application Dim objDoc As Word.Document Dim objMailMerge As Word.MailMerge DoCmd.SetWarnings False DoCmd.OpenQuery "CertInfo2" DoCmd.OpenQuery…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-09-06T19:17:29.2733333+00:00
Maxine Nietz
1
Reputation point
commented 2025-09-07T17:18:59.8+00:00
Maxine Nietz
1
Reputation point
1 answer
I am getting a data type mismatch error when compiling my VBA code
When I try to compile my VBA Code for a sub-procedure, I get a Data Type Mismatch error when I get to the line: lRecCounter = rsRecordset.RecordCount I originally had lRecordCount identified as Inter. When that did not work, I did some research and read…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-27T13:19:33.76+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(60.8, 7.000000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Michael Burden
40
Reputation points
commented 2025-09-01T02:47:11.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(140.8, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Flora-T
5,160
Reputation points Microsoft External Staff
Moderator
3 answers
Access wont save the modification in the queries
I do have a wine list from which I generate a Query to edit a wine Menu, when I put some requirement in the Query it wont save them for further use. Also I generate a report from the wizard, to print the Wine Menu, but despite the fact that the report…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 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(131.20000000000002, 36%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Why isn't Clear Grid command in the Sort & Filter section’s Advanced menu in Access
Hello, Why isn't Clear Grid command in the Sort & Filter section’s Advanced menu in Access, which should be there as the book says？
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-17T10:09:46.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(22.400000000000002, 63%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZZ%3C/text%3E%3C/svg%3E)
Zhenyu Zeng
96
Reputation points
commented 2025-08-17T10:59:07.4033333+00:00
Zhenyu Zeng
96
Reputation points
3 answers
One of the answers was accepted by the question author.
How do I get Monaco SQL Editor to load in my ACCESS program so I can uncheck the box
All of a sudden each time I try to "Run" a basic query I get an error message "Executing selected SQL text is only supported in the Monaco SQL Editor." Google says to go to "File/Options/Current Database" and uncheck the…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-17T20:37:35.57+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(182.40000000000003, 13%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Sue Williams
20
Reputation points
commented 2025-08-21T18:48:46.74+00:00
Sue Williams
20
Reputation points
8 answers
One of the answers was accepted by the question author.
Why will my Access databases not open?
I use Microsoft 365. I haven't used Access for a while, and I have a few databases that I now want to use. I launch Access and locate a database in my file system. I click on the filename, and the Access application opens immediately. However, the…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-20T16:29:39.3566667+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, 63%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lucas Hutton
60
Reputation points
accepted 2025-08-31T19:37:06.9766667+00:00
Lucas Hutton
60
Reputation points
2 answers
One of the answers was accepted by the question author.
which reference do I need to create objects"
I am having trouble creating object types in ACCESS VBA. I am using the statement: Function BuildSQLInsertNewMold(objCurrMold As clsMold) As String This produces the error User-type Not Defined when I try and compile the Function. Is there a Reference I…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-20T20:28:03.92+00:00
Michael Burden
40
Reputation points
accepted 2025-08-27T11:37:41.47+00:00
Michael Burden
40
Reputation points
9 answers
One of the answers was accepted by the question author.
Troubleshooting Document Search Form Data Retrieval Issues
There is a query-based search form that sources data from a query linked to the primary table. Although the search form operates correctly, some items from the documents table are not appearing in the form when it is opened, and there does not seem to be…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-22T18:53:59.1566667+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, 77%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWL%3C/text%3E%3C/svg%3E)
Walter Laidlaw
20
Reputation points
commented 2025-08-24T18:40:21.4566667+00:00
Walter Laidlaw
20
Reputation points
2 answers
One of the answers was accepted by the question author.
MS Office 365 Access
Afternoon This is just a general question. about Access. If Office 365 is installed on a Apple product. Can Access be executed from the basic Office installed on any Apple product? Assume that the current version of the Apple OS is installed. The…
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-24T19:01:35.06+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, 23%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Bob Barnes
20
Reputation points
accepted 2025-08-24T19:19:57.2633333+00:00
Bob Barnes
20
Reputation points
5 answers
Trying to export an Access report to MS Word
I am trying to write a macro or vba code that I can use to export an open Access report directly to Word. If there is no such thing, I could export it to PDF. Here is the macro I have written which is NOT working. Can you help?? Thanks in advance, Max
Microsoft 365 and Office | Access | For home | Windows
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
20,824 questions
asked 2025-08-26T18:47:18.8466667+00:00
Maxine Nietz
1
Reputation point
answered 2025-08-27T20:43:41.3966667+00:00
Ken Sheridan
3,291
Reputation points