20,814 questions
20,814 questions with Microsoft 365 and Office | Access | For home | Windows tags
1 answer
How can I get MS Visual C++ reinstalled on my just bought computer?
Bought a new PC. Had issues with Adobe and MS Visual C++. Adobe tried to repair. They tried removing and reinstalling MS Visual C++. It would never completely boot up. Adobe removed MS Visual C++ and asking me to get Microsoft to reinstall the program.
Microsoft 365 and Office | Access | For home | Windows
asked 2025-08-29T02:45:29.8233333+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(185.6, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Douglas Burgess
0
Reputation points
edited an answer 2025-08-29T03:06:21.6266667+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
3,750
Reputation points Microsoft External Staff
Moderator
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
20,814 questions
asked 2025-08-26T18:47:18.8466667+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-08-27T20:43:41.3966667+00:00
Ken Sheridan
3,106
Reputation points
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
20,814 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
answered 2025-08-27T14:34:26.9666667+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
3,200
Reputation points Microsoft External Staff
Moderator
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
20,814 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
7 answers
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
20,814 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
40
Reputation points
commented 2025-08-27T06:57:21.8933333+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(54.400000000000006, 70%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Tammy-Ng
2,535
Reputation points Microsoft External Staff
Moderator
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
20,814 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
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
20,814 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
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
20,814 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
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
20,814 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
61
Reputation points
commented 2025-08-17T10:59:07.4033333+00:00
Zhenyu Zeng
61
Reputation points
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
20,814 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)
![](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)
3 answers
Error Opening Access Templates in Office 2024
After purchasing and installing Office 2024 Desktop version, all applications function correctly except for Access. When attempting to open a template, the following error message appears: Template "xxxxx.accdt" could not be instantiated The…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-08-08T15:18:37.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(153.6, 98%, 24%)' 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 Barone
0
Reputation points
commented 2025-08-09T12:36:07.22+00:00
George Hepworth
21,900
Reputation points
Volunteer Moderator
4 answers
MS Access is failing to import macros from an old database to a new database showing a blank list
MS Access is failing to import macros from an old database to a new database showing a blank list My MS Access Database had crashed a few days back, I tried Compact and Repair, but it failed to correct it, it shows an error saying, Search Key Is Not…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-08-01T08:22:35.13+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(310.4, 98%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKE%3C/text%3E%3C/svg%3E)
Kanchan Electronics
5
Reputation points
commented 2025-08-07T06:35:12.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(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
4,105
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How to move Microsoft Access Full Version to new Win11 PC
I am an Office 365 subscriber. After upgrading my old Windows 10 desktop PC (with Office 365) to a new Windows 11 PC, my Access transferred as a runtime version rather than the full version I had on the old desktop computer. I now need to get the full…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-07-30T18:48:22.7766667+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, 78%, 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)
Mac McIntire
20
Reputation points
accepted 2025-07-31T14:54:46.6766667+00:00
Mac McIntire
20
Reputation points
1 answer
How can I add the download version of Access to my Office device with a digital attachment?
When attempting to add the download version of Access 2024 to a device with the digital attachment version of Office 2024, authentication fails. Please note that Access is the download version of Office, not the licensed version. In the past, Office 2021…
Microsoft 365 and Office | Access | For home | Windows
20,814 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(259.20000000000005, 64%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Query returns wrong sum
In my query I have a column that returns 192 rows. The field is formatted at currency. A couple of issues. When I run the query it returns 192 records. If I change the total from Group By to count I get a count of 251 If I change the total from…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-07-29T04:40:35.24+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, 56.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Patrick Simonds
21
Reputation points
accepted 2025-07-30T03:05:33.3433333+00:00
Patrick Simonds
21
Reputation points
1 answer
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 (labelled “Delivery Sheet”) to open a report in Print Preview mode. The report…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-06-12T18:01:25+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
asked 2025-07-21T21:12:00.6766667+00:00
Anonymous
13 answers
Northwind 2.0, Startup Error
I download the new Northwind database. I get a VBA error in the startup code: Sub or function not defined line 40, OneTimeProcessing is yellow. What's wrong and how to fix it? I hope Microsoft doesn't expect me to search through 20 modules to find a…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-04-03T01:15:38+00:00
Anonymous
asked 2025-07-21T21:12:00.6766667+00:00
Anonymous
3 answers
Selecting a quantity of random records. Number of records selected on a form txt box.
I have a table of 1200 records in MS Access. I want the user to enter a number (on a form) which will select that number of random records (also based on other criteria). I can hard code the number e.g. 15 and the query is ok. SELECT TOP 15 * FROM…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-06-30T15:06:19+00:00
Anonymous
asked 2025-07-21T21:12:00.6766667+00:00
Anonymous
1 answer
Add/Edit command button not working.
Good morning to all, I have an Access 365 database. with the help of Mr. Sheridan my database has greatly improved. My problem is as follows: I added a new control as a combo box and an Add/Edit btn that should allow the user to add or edit items in…
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-04-14T11:46:02+00:00
Anonymous
asked 2025-07-21T21:12:00.6766667+00:00
Anonymous
2 answers
Why is the interface like this?
Why is the I interface like this?
Microsoft 365 and Office | Access | For home | Windows
20,814 questions
asked 2025-05-07T08:34:22+00:00
Anonymous
asked 2025-07-21T21:12:00.6766667+00:00
Anonymous