407 questions with Microsoft 365 and Office | Access | Other | Windows tags
Export MSAccess table to CSV
Dear all, from an MSAccess Database table I need to extract the content to a csv file. As this csv file needs to be imported in a SQLite table and especially for the Date field the format must be YYYY-MM-DD HH:MM:SS (like 2025-11-27 00:00:00 NOT…
Microsoft 365 and Office | Access | Other | Windows
Invalid Argument Error
I am receiving an invalid argument error when running a query in MS Access. I wasnt having this issue when I was using Windows 10 operating system. When I transitioned to Windows 11, I started receiving the invalid argument error. Do you know what is the…
Microsoft 365 and Office | Access | Other | Windows
Why Access and Publisher did not get the new 365 icons?
The Microsoft 365 apps are getting new logos (and I have received all of them) Access and Publisher were not getting these new icons as they were not shown https://microsoft.design/articles/fluid-forms-vibrant-colors/ here. Why so?
Microsoft 365 and Office | Access | Other | Windows
When will the issue with dao360.dll that is crashing my VB6 app connected to Access databases be fixed?
When will the issue with dao360.dll that is crashing my VB6 app connected to Access databases be fixed?
Microsoft 365 and Office | Access | Other | Windows
MSAccess - Select max value of each group
Dear All, by the below query I get the following MSAccess data: SELECT [TEMP_TABLE].Serialnumber_Or_SNID, [TEMP_TABLE].Warranty_Code, Max([TEMP_TABLE].EXTENSION_SORT_ORDER) AS MaxOfEXTENSION_SORT_ORDER FROM TEMP_TABLE GROUP BY …
Microsoft 365 and Office | Access | Other | Windows
How can I print labels from selected records in Access?
How can I print labels from selected records in Access
Microsoft 365 and Office | Access | Other | Windows
Database Compare is asking for Microsoft.ReportViewer.ProcessingObjectModel.dll ver 12.0.0.0
Database Compare is asking for Microsoft.ReportViewer.ProcessingObjectModel.dll ver 12.0.0.0 which is not available to download in the web. screenshot attached. How to fix?
Microsoft 365 and Office | Access | Other | Windows
Access - VB - DAO library looking in wrong folder
The VBE under Tools / References says that DAO 3.6 is available at C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll However, there is no DAO folder in that location (and no dao360.dll). It is in the C:\Program Files (x86)\Common…
Microsoft 365 and Office | Access | Other | Windows
How to fix Microsoft Access
I’m currently experiencing issues with our Microsoft Access application. I’ve already reached out to one of our IT personnel, and while they’ve been trying to troubleshoot, the problem remains unresolved. I was advised by one of our IT professionals to…
Microsoft 365 and Office | Access | Other | Windows
How to get linked jpg images to appear on an Access form. It seems to be a common issue.
I've done everything they tell you to do in various videos on youtube but I still cant get images to appear on the forms unless they're static which won't work in the setup I am working on.. I've had a VB script sent to me but not being familiar with VB,…
Microsoft 365 and Office | Access | Other | Windows
Microsoft Access 2021 - Main Switchboard
I have an flat based Access Data Base developed many years ago and imported into Access 2021. It has a number of queries and reports linked to a Main Switchboard. I want to edit that Switchboard so that I can add new reports and delete others. I…
Microsoft 365 and Office | Access | Other | Windows
Using value from forms in a query
I have several different data tables that use Project Number. I'm gathering data from the different tables and putting into one local table. I set up a form and used a text box for entering project numbers.....I have 2 different ones so I can enter…
Microsoft 365 and Office | Access | Other | Windows
Issues with Access's Analyzer Tools
Hello. I'm experiencing issues with Access's performance analysis tools. Once opened, when I move the mouse over dialog boxes, they give me errors and inform me about the events that caused them. For example, "The 'FldListMouseMove' expression you…
Microsoft 365 and Office | Access | Other | Windows
I am new to access. I am setting up a new database and associated queries. I would like suggestions on the correct way to set up my tables.
I 've used Excel for many years and am relatively proficient with it. However, I am working on a project that requires far more than Excel offers. I believe access is the best prograqm for this. I am completely new to Acess so I am on a big learning…
Microsoft 365 and Office | Access | Other | Windows
Access VBA Error 3211 "The database engine could not lock table"
Access 2021 has just started giving '3211' errors on all of my databases when accessing a particular table. I'm a user, not a tech, so I'm lost. It must be a generic permission setting in Access as it's affected all similar databases on the same…
Microsoft 365 and Office | Access | Other | Windows
Inquiry About Support Lifecycle and Alternatives for Microsoft Access Database Engine 2016 Redistributable
Hello, I would like to know when the Microsoft Access Database Engine 2016 Redistributable will no longer be supported by Microsoft. Does it follow the same support lifecycle as Access 2016, which is scheduled to end in October 2025? Additionally, could…
Microsoft 365 and Office | Access | Other | Windows
Access Form Loads Slowly Top-to-Bottom After Windows 11 24H2 (Build 26100.4061) Update
After updating to Windows 11 version 24H2 (build 26100.4061), I've encountered a major performance issue with Microsoft Access. Specifically: Access forms that previously loaded instantly now render slowly from top to bottom, visibly displaying…
Microsoft 365 and Office | Access | Other | Windows
Which way is better to track something's current status
This goes for multiple things, but I'll use my current example. I have a table for employees. I have a table for jobs in my company. I have a table that tracks when an employee is put into that job, and when they end that job (either having been…
Microsoft 365 and Office | Access | Other | Windows
Query to show whether certain types of things are assigned to a person
Howdy. I have tblItems - ItemID pk, ItemTypeID fk (what kind of item it is), EmployeeID fk (If it's assigned to an employee, will have their EmployeeID, null if not assigned) What I was trying to do is get a query to have one column the EmployeeID, then…
Microsoft 365 and Office | Access | Other | Windows
I have downloaded Microsoft 365 family but can't see that access has downloaded
Hi there I have downloaded Microsoft 365 family from my subscription to my MacBook, however, can't see that access has downloaded. How do I download Access? Many thanks Melissa