267 questions with Microsoft 365 and Office | Access | For business | Other tags

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

How to register a key for Access ?

Hi, I am struggling to verify the key in order to be able to use Access i bought as LTSC and downloaded successfully. The error message coming up on screen saying the key is for volume- licensed version of Microsoft Access and the one I have is not the…

Microsoft 365 and Office | Access | For business | Other
asked 2026-01-19T13:36:51.4133333+00:00
Temenuzhka Dimitrova 20 Reputation points
answered 2026-03-07T14:18:30.0833333+00:00
Rajitram Ram 0 Reputation points
2 answers

MS Access - Compiled after 1st for does not load anything

I have an application that I have worked on for some time and I am at the stage of distribution and I have a strange issue... Compile - Success frmLogin - success frmMainMenu - Fails to load the mani menu for loads correctly when I run the code but…

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-20T21:47:09.59+00:00
Phillip J. Seaman 0 Reputation points
edited an answer 2026-02-23T09:55:56.3166667+00:00
Gabriel-N 15,130 Reputation points Microsoft External Staff Moderator
2 answers

When I try to open my access database, it gives me this error message:

Is there anything I can do to not mess it up and to be able to use it?

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-17T02:40:26.6566667+00:00
MB 0 Reputation points
commented 2026-02-18T08:05:00.99+00:00
Flora-T 11,700 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

“The database has been placed in a state by user ‘Admin’ on machine ‘LOCALHOST’ that prevents it from being opened or locked.”

Hi, I’m experiencing an issue with Microsoft Access and would appreciate some guidance. I’m using Microsoft Access 365 (Microsoft 365 Apps for enterprise) on Windows 11 Pro, working with an .accdb database stored on my local machine. The issue occurs…

Microsoft 365 and Office | Access | For business | Other
asked 2026-01-24T05:55:07.24+00:00
Wright Kenia 40 Reputation points
answered 2026-02-10T10:36:50.97+00:00
Carl Walker 0 Reputation points
2 answers

How to improve performance for access database

Access application loads very slowly while connecting to Access database on network drive

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-05T21:08:36.4+00:00
Ramnarine, Sonny (MTO) 1 Reputation point
commented 2026-02-09T07:40:48.4466667+00:00
Dora-T 11,460 Reputation points Microsoft External Staff Moderator
3 answers

Microsoft Access Database Engine supporting issue

Hi Folks, After the Microsoft 365 Apps Enterprise (EN) update on 16 December 2025, one of the applications on my machine—Monogram.CS—started experiencing issues due to a dependency on Microsoft 365 Apps Enterprise. Following the update, launching the app…

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-02T13:10:41.77+00:00
Kota, Putal Reddy 0 Reputation points
commented 2026-02-03T15:15:03.1966667+00:00
Gabriel-N 15,130 Reputation points Microsoft External Staff Moderator
3 answers

Microsoft Access database engine cannot find the input table or query '|'

I have a macro that is suddenly "broken". When I try to run it, I get a window that shows Error Number: 3018. And my only option is to "Stop All Macros". When I close that window, I get this message: The Microsoft Database…

Microsoft 365 and Office | Access | For business | Other
asked 2025-12-12T18:50:01.93+00:00
Eberhart, Elizabeth 0 Reputation points
commented 2025-12-30T19:25:12.5933333+00:00
Eberhart, Elizabeth 0 Reputation points
1 answer

Follow up inquiry from previous inquiry regarding Access and real estate short term rentals

This inquiry is an attempt to obtain the final result and procedures used in a previous question which originally posted on Microsoft Support Community.. migrated therefrom to here. Cliff on this site suggested to Phil Stephenson that he suggest a new…

Microsoft 365 and Office | Access | For business | Other
asked 2025-12-30T16:12:40.9966667+00:00
Bill Jones 0 Reputation points
edited a comment 2025-12-30T17:47:50.34+00:00
George Hepworth 22,660 Reputation points Volunteer Moderator
4 answers One of the answers was accepted by the question author.

Are there any plans on the Advance filter changing back to an actual filter instead of a query?

I had used the advanced filter on a regular basis on multiple tables at a time, why was it changed from a filter to a query. Are there any plans to change it back to an actual filter? This has been extremely frustrating. The query doesn't work well…

Microsoft 365 and Office | Access | For business | Other
asked 2025-11-11T16:37:14.0666667+00:00
Kim Stout 20 Reputation points
edited an answer 2025-11-12T21:53:11.5033333+00:00
George Hepworth 22,660 Reputation points Volunteer Moderator
3 answers One of the answers was accepted by the question author.

Can't change tab order in field property sheet of Access form

Just lost the functionality of setting the tab order for a field by entering a number in the field's properties. For example, if the tab order is set to 2 for a particular field, and I change it to 4 (where greater than 4 fields exist in the form), the…

Microsoft 365 and Office | Access | For business | Other
asked 2025-10-01T02:15:00.99+00:00
TroyD 65 Reputation points
edited a comment 2025-10-10T07:42:45.0033333+00:00
Anonymous
1 answer One of the answers was accepted by the question author.

How to get Not Like statement to work in Access

I'm trying to isolate typing mistakes in one column of data vs. another using the "not like" statement in an Access query but it doesn't seem to be working. For example, I have two columns of numbers and a third "total" column. If the…

Microsoft 365 and Office | Access | For business | Other
asked 2025-10-01T18:40:34.8833333+00:00
Starr N 20 Reputation points
edited a comment 2025-10-04T15:08:03.58+00:00
Ken Sheridan 3,571 Reputation points
0 answers

DLookup To Calculate Fields On A Report

I have a simple database called the Incident Management System. I have a lookup field called "Status," which has the values "Completed," "Delayed," and "Ongoing." I want to use a DLookup function to calculate…

Microsoft 365 and Office | Access | For business | Other
asked 2025-06-22T19:03:33+00:00
Anonymous
edited the question 2025-07-22T12:28:58.4166667+00:00
George Hepworth 22,660 Reputation points Volunteer Moderator
5 answers

Access VBA code to close form and not save changes made

Hello, I have created a form in Access that has a command button for the user to select when they want to exit the form without committing the changes made. The code attached to the button's click event is: Private Sub btnExitDontSave_Click()…

Microsoft 365 and Office | Access | For business | Other
asked 2025-04-30T09:14:27+00:00
Anonymous
4 answers

How do I fix the SendObject failure with MS Access and the new version of Outlook

For years I have used the SendObject to send a Report from MS Access as a PDF attachment using Outlook. Now is seems none of my previous code to automate emails from within MS Access works anymore. I have searched for a solution but have not been…

Microsoft 365 and Office | Access | For business | Other
asked 2025-04-07T08:44:54+00:00
Anonymous
6 answers

Issue with MS Access 365 not releasing Forms from Forms collection

I'm running MS Access Version 2502 (Build 18526.20168 Click-to-Run), Current Channel and I've noticed that in certain scenario Forms are not being removed from Forms collection. If I create a new database with a single form called 'Form1' and add 2…

Microsoft 365 and Office | Access | For business | Other
asked 2025-04-02T12:15:56+00:00
Anonymous
12 answers One of the answers was accepted by the question author.

In Access, VB, I am needing help with a IF/THEN scenario involving dates.

I have a form that I use for task scheduling and keeping track of dates when I performed that task. It is a simple form where I have a "STATUS" field combo box with "Not Started" and "Completed" for source options. Also,…

Microsoft 365 and Office | Access | For business | Other
asked 2025-05-27T15:00:28+00:00
Anonymous
2 answers

Migrating from Microsoft Access to Shopify

I'm working on migrating a SQL database from Microsoft Access to Shopify and wonder if anyone has any experience doing this? The site I'm working on has legacy issues, including old customer CMS databases that are on Microsoft Access that I need to get…

Microsoft 365 and Office | Access | For business | Other
asked 2025-05-18T06:53:46+00:00
Anonymous
12 answers

DLookUp With Dates On A Report

In my same Executive Summary Report, I want to use the DLookup function to call for the following information onto the report: ~ Date and the format is a Medium Date ~ CompanyName ~ Address 1 ~ Address 2 ~ URL ~ Email ~ Tel Thank you

Microsoft 365 and Office | Access | For business | Other
asked 2025-06-23T12:49:44+00:00
Anonymous
15 answers

Workdays excluding week ends and public holidays.

Good day, I have set up a date table and a holiday table, The purpose of this is to produce a report to show many working days are available each month. I have a function. which runs in three phases. Phase 1, to see how many working days are available…

Microsoft 365 and Office | Access | For business | Other
asked 2025-05-02T14:05:53+00:00
Anonymous
5 answers One of the answers was accepted by the question author.

How to restore rpt file to normal in Access

For the past week, Access has been previewing and even downloading rpt files as distorted and misaligned files. No one else in my department has this issue and I've been searching and not finding a solution. I am also unsure if a fix is possible since I…

Microsoft 365 and Office | Access | For business | Other
asked 2025-04-28T18:26:28+00:00
Anonymous