396 questions with Microsoft 365 and Office | Access | Other | Windows tags

Sort by: Updated
Updated Created Answers
3 answers One of the answers was accepted by the question author.

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
asked 2025-08-06T07:53:47.1066667+00:00
Ernesto 20 Reputation points
answered 2025-08-07T20:05:45.4833333+00:00
Ernesto 20 Reputation points
5 answers One of the answers was accepted by the question author.

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
asked 2025-07-28T16:53:06.2833333+00:00
Sean M 20 Reputation points
edited an answer 2025-08-03T12:31:35.3466667+00:00
Ken Sheridan 3,026 Reputation points
1 answer

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
asked 2025-08-02T09:00:02.9333333+00:00
Alex McIntyre 0 Reputation points
answered 2025-08-02T12:14:47.99+00:00
George Hepworth 21,805 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

My microsoft authenticator app is not recognizing my microsoft account email so I can not add an account

I have downloaded the Microsoft Authenticator App but cannot add an account for 2 factor authentication. The Authenticator App does not recognize my Microsoft account email address. Can anyone offer any suggestions please.

Microsoft 365 and Office | Access | Other | Windows
asked 2025-07-29T00:10:25.2833333+00:00
Chris Sloan 20 Reputation points
edited the question 2025-08-01T02:26:21.8566667+00:00
Austin-H 3,555 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-07-21T15:14:50.1066667+00:00
Reddy, Dipuna 10 Reputation points
answered 2025-07-23T19:18:28.18+00:00
George Hepworth 21,805 Reputation points Volunteer Moderator
5 answers

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
asked 2025-05-28T03:48:11+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

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
asked 2025-06-19T09:01:05+00:00
Anonymous
5 answers

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
asked 2025-06-18T18:58:04+00:00
Anonymous
7 answers One of the answers was accepted by the question author.

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

Microsoft 365 and Office | Access | Other | Windows
asked 2025-06-18T06:54:07+00:00
Anonymous
15 answers

MS Access for Internet sharing among Users

There are many ways to share desktop Microsoft Access for multiple users' simultaneous access. I am not talking here about sharing MS Access in the same network. I need to share it among several users outside my network. What is the cost-effective…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-04-23T19:57:00+00:00
Anonymous
3 answers

How can I add space between words when typing in sql view of access?

I was using Access 2007 version 2016 file format. When I tried to type the SQL command in the sql view of query view, I cannot type any spaces. The words are packed together without spacing. How can I solve it? Just like the picture below www help!!!

Microsoft 365 and Office | Access | Other | Windows
asked 2025-05-03T16:04:09+00:00
Anonymous
2 answers

how do I enter an avery label number in access to print my labels

how do I enter an avery label number in access to print my labels

Microsoft 365 and Office | Access | Other | Windows
asked 2025-06-03T21:31:21+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

Is it possible to populate specific cells in a spreadsheet with specific data from Acces, but NOT as an organized table?

My company uses a spreadsheet as a sort of organization chart. Boxes with positions and then the next cell having the person's name who fills that position. But it is not in a simple column row list. Would it be possible to have values in my employee…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-05-17T10:11:28+00:00
Anonymous
9 answers

Office update Version 2505 (Build 18827.20164) has broken Access Database applications

Yesterday Office did an automatic update to Version 2505 (Build 18827.20164). Following the update all access data base files would no longer work as they used to with many of the buttons, and forms appearing blank. I was able to roll back to a previous…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-06-19T23:56:45+00:00
Anonymous
3 answers

Database design question

Howdy. I have an inventory database. I want to track where something is, and track the transactions when moving the item around. So currently I have a table for the items, of course, as well as one for the transactions, and types of transactions. If…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-05-29T12:13:35+00:00
Anonymous
1 answer

Type mismatch error

Hello, i have currently ran into a problem, and I am wondering if anyone could help. I have created a database, that has a macro, which runs several IFF functions and based on them runs Delete querys, and when i run the queries by themselvs individually…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-05-12T08:59:01+00:00
Anonymous
1 answer One of the answers was accepted by the question author.

MSAccess VBA - Help on query

Dear All, I have imported the below Excel sheet into an MSAccess table: As you can see the length of the two value should be 19 but, due to an accidental char (maybe carriage returns), I have 20 in the first row. This is an issue because when I import…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-07-08T13:16:33+00:00
Anonymous
7 answers

Why can't I use a variable to pass a date to this sub to set parameter values?

Hello. I'm using the sub from this thread https://answers.microsoft.com/en-us/msoffice/forum/all/can-you-use-a-public-function-sub-to-set-a/1043226e-ae37-450a-a045-3261256a9a29  to set a forms recordset. It works fine on the first form I set up. I…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-05-23T12:20:01+00:00
Anonymous
8 answers

Hi Develpers please guide me how to show custom notification correct urdu in vba editors

I will design a custom notification form, but my form does not show the correct Urdu. I will write a VBA message in Arial(Arabic) and show, do not correct, Urdu .Please help me

Microsoft 365 and Office | Access | Other | Windows
asked 2025-06-25T19:00:42+00:00
Anonymous
22 answers

I have Access from Microsoft 365 and havinga query problem

I have Access from Microsoft 365, I am creating a query, and when I try to save it the error: Characters found after end of SQL statement. I have tried to find the error and can't run a debug because it hasn't been saved. How can I debug to find the…

Microsoft 365 and Office | Access | Other | Windows
asked 2025-05-25T01:04:49+00:00
Anonymous