167 questions with Microsoft 365 and Office | Access | For home | Other tags

Sort by: Updated
Updated Created Answers
2 answers

how to add a calculated field to a form in access

after entering data in one field do calculations to fill in other fields in the same form

Microsoft 365 and Office | Access | For home | Other
asked 2025-10-30T19:05:51.43+00:00
Thomas Sadler 0 Reputation points
commented 2025-11-24T07:46:39.8566667+00:00
Jack-Bu 5,405 Reputation points Microsoft External Staff Moderator
5 answers One of the answers was accepted by the question author.

Unable to filter reports in Microsoft Access database

There appears to be a bug in Access Database that has appeared within the last month possibly caused by a Windows 11 or Office 365 update?  Reports (not associated with a Query) worked fine the last time I tried to run a report that required using a…

Microsoft 365 and Office | Access | For home | Other
asked 2025-11-01T22:22:09.17+00:00
Allan Plucinik 40 Reputation points
commented 2025-11-18T13:23:03.11+00:00
Karl Donaubauer 2,691 Reputation points MVP
2 answers

How do I correct a File Sharing Lock?

I have apparently exceeded my file sharing lock count on Access. How do I clear it?

Microsoft 365 and Office | Access | For home | Other
asked 2025-10-26T04:09:29.8666667+00:00
Tom McCorkill 0 Reputation points
commented 2025-10-29T06:25:09.34+00:00
Flora-T 6,820 Reputation points Microsoft External Staff Moderator
2 answers

Access download

I have the correct subscription for Mac to have Access but I cannot find it to down load. Where do I find it?

Microsoft 365 and Office | Access | For home | Other
asked 2025-10-05T17:39:49.0066667+00:00
Isaac Moffett 5 Reputation points
commented 2025-10-17T15:17:29.37+00:00
Austin-H 6,990 Reputation points Microsoft External Staff Moderator
1 answer

Sending an email within MS Access app

Hi, does anyone have any sample code to send an email from an icloud.com email address from within a MS Access published database? I am using Access 2024. Thank you.

Microsoft 365 and Office | Access | For home | Other
asked 2025-09-14T13:50:56.13+00:00
Norman Smith 0 Reputation points
commented 2025-09-19T04:00:57.6+00:00
Dora-T 8,185 Reputation points Microsoft External Staff Moderator
2 answers

Access VBA - confused by Byref Argument Type Mismatch

I am attempting to call a function that also passes by data in ByRef variable. Everything is a type string and the calling sub has the receiving variable set as type string. Yet I am getting the Byref mismatch message. The ByVal is the string variable…

Microsoft 365 and Office | Access | For home | Other
asked 2025-04-13T23:17:47+00:00
Anonymous
0 answers

Microsoft database

Query wizard shows that there is another user has a source table, "type mismatch in Expression"

Microsoft 365 and Office | Access | For home | Other
asked 2025-06-23T12:56:30+00:00
Anonymous
11 answers

Microsoft 365 - Access - "Import" no longer working after installing latest update.

I have an "Import" (.csv file to an existing table) that has been working for years. This month, after installing latest Office update, the import no longer works, "Err: Invalid argument". I checked the file to be imported and it is…

Microsoft 365 and Office | Access | For home | Other
asked 2025-04-01T17:07:48+00:00
Anonymous
16 answers One of the answers was accepted by the question author.

Access Database Question

Hello, I need some help with a database that is many years old. I have two duration fields, named Dur1 and Dur2 which display the time of some recordings that I have. The problem is they are formatted as numerical and the entries are in seconds, so that…

Microsoft 365 and Office | Access | For home | Other
asked 2025-05-27T23:36:46+00:00
Anonymous
15 answers

How to change width on the left side list showing Tables and other parts.

My MS Access has made my left column containing names on tables etc so narrow I cannot read the names of them. How to change this?

Microsoft 365 and Office | Access | For home | Other
asked 2025-05-17T13:35:35+00:00
Anonymous
8 answers

Close one form if record is found

If a record is found, i want to close the search form. It isn't working currently. This is the code I'm using Private Sub cmdChecknr_Click() DoCmd.OpenForm "CDfrmchecksort", , , "CheckNr =" & CheckNr & "" …

Microsoft 365 and Office | Access | For home | Other
asked 2025-04-09T16:20:11+00:00
Anonymous
13 answers One of the answers was accepted by the question author.

Error code 2482 on Access macro

I am experiencing error 2482 when trying to run an Access macro that contains a step with an expression. Macro runs fine until that step. Database is in a trusted location, but CurrentProject.IsTrusted=False. Running Windows 11 on PC.

Microsoft 365 and Office | Access | For home | Other
asked 2025-05-16T17:34:50+00:00
Anonymous
1 answer

Why does my MS Access 2021 say Unlicensed Product for the product ID purchased on 6/3/25?

Why does my MS Access 2021 say Unlicensed Product for the product ID purchased on 6/3/25?

Microsoft 365 and Office | Access | For home | Other
asked 2025-06-09T18:56:22+00:00
Anonymous
6 answers

How do I add conditional questions to a Microsoft Access Form?

I have no experience with database design or coding at all and I'm trying to teach myself Access in order to keep track of all my art. I want to design the form so that, if the yes/no box for "fanart" is checked, a new field appears, prompting…

Microsoft 365 and Office | Access | For home | Other
asked 2025-04-09T11:55:12+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

Attn: Ken Sheridan - I am trying to create a BOM in Access

Hi Ken, I am trying to create a BOM in Access and saw your helpful replies to similar questions, there you posted a link to BOM.zip with an example of recursive querying workaround, unfortunately that link no longer works, would it be possible to repost…

Microsoft 365 and Office | Access | For home | Other
asked 2025-05-13T00:06:20+00:00
Anonymous
7 answers One of the answers was accepted by the question author.

Problem with query transferts

Since the last Office update, when I try to transfer a query from one Access database to another, I get this error message. It only happens with queries. Does anyone have the same problem and possibly a solution ? I've never had any problems before…

Microsoft 365 and Office | Access | For home | Other
asked 2025-03-13T17:07:50+00:00
Anonymous
2 answers

Access 365 error " number of bytes of a unicode string is not even"

I have an access database from office 365. I am getting serious problems with accessing data. I have a split database. When I try to open one of the tables in the back end it gives this error " number of bytes of a Unicode string is not even".…

Microsoft 365 and Office | Access | For home | Other
asked 2025-01-24T16:56:56+00:00
Anonymous
7 answers

Microsoft Access

Is Access available for 365 Apple subscribers or only PC based subscribers?

Microsoft 365 and Office | Access | For home | Other
asked 2025-02-28T02:26:59+00:00
Anonymous
11 answers One of the answers was accepted by the question author.

Bug in Microsoft Access handling of variables since dec 5, 2024 update - version 18227.20152

UPDATE: This bug was fixed before the end of 2024. There were 8 updates on my computer, so I am unsure of which update actually fixed the issue. Thanks Microsoft! Since the release of Office (Update) on Dec 5, 2024 (18227.20152) my Access databases have…

Microsoft 365 and Office | Access | For home | Other
asked 2024-12-10T15:26:57+00:00
Anonymous
16 answers

MouseWheel event no longer working

In MS 365 Version 2412 (Build 18324.20092 Click-to-Run), in Access Forms, the MouseWheel event has changed. In the event handler: Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long), the 'Count' value is now always zero. Until this…

Microsoft 365 and Office | Access | For home | Other
asked 2024-12-26T06:53:22+00:00
Anonymous