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

Sort by: Updated
Updated Created Answers
1 answer

I cannot send or receive emails in my hotmail account. I have been through all through all the troubleshooting steps but still need help

I can't send or receive emails in hotmail. I have been through all through all the troubleshooting steps but still need help. I am signed in but the problem continues

Microsoft 365 and Office | Access | For home | Other
asked 2025-12-13T13:30:31.3566667+00:00
andy white 0 Reputation points
answered 2025-12-13T13:30:41.9633333+00:00
Q&A Assist
2 answers

cant find geography in data types option . what can i do for that ?

cant find geography in data types option . what can i do for that ?

Microsoft 365 and Office | Access | For home | Other
asked 2025-12-12T14:14:12.06+00:00
Mh Ashik 0 Reputation points
answered 2025-12-12T14:37:23.9+00:00
Tom van Stiphout 40,086 Reputation points MVP Volunteer Moderator
1 answer

Is MS ACCESS available for us on MacBook Pro

I have Office 365 for my Mac Book Pro. I do not see MS Access. Is Access not included? How do I access if it is included.

Microsoft 365 and Office | Access | For home | Other
asked 2025-12-06T13:43:13.5566667+00:00
Joe Holler 5 Reputation points
answered 2025-12-06T13:43:29.0366667+00:00
Q&A Assist
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,490 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,696 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 7,385 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,520 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