910 questions
910 questions with Microsoft 365 and Office | Access | Development tags
1 answer
Slow MS_Access print preview formatting after KB5060999 update
Greetings! This is happening for many users with the enterprise license - slowness when opening any report within the ACCDB files. The reports "Print preview" and "Print" functions fall into a slow process that does not consume CPU,…
Microsoft 365 and Office Access Development
asked 2025-06-24T08:09:46.1066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 4%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Silva Nicolas[Nikorasu_SHIRUBA]
0
Reputation points
edited a comment 2025-06-27T00:05:00.0833333+00:00
Silva Nicolas[Nikorasu_SHIRUBA]
0
Reputation points
2 answers
Access to Word Document
Office 365. I have an Access report with one image (logo) and 4 subreports as a Print Preview. I need to save it as a Word .docx. Would it be best to just use the export to word command on the Print Preview tab or should I try to set it up as a merge…
Microsoft 365 and Office Access Development
910 questions
Microsoft 365 and Office Word For business Windows
1,936 questions
asked 2024-10-31T13:47:49.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 84%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Maxine Nietz
1
Reputation point
answered 2025-06-26T19:52:02.2333333+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
1 answer
how do I add a trusted network location to MS access that uses an IP address?
We do a lot of company work remotely via a VPN. Unfortunately, the current setup doesn't allow us to connect directly to servers via their names, only IP addresses. I have to add one network location as a trusted location to an MS Access database. If I…
Microsoft 365 and Office Access Development
910 questions
asked 2025-06-25T15:18:14.1233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 34%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Antony Heij
0
Reputation points
commented 2025-06-26T03:02:04.3966667+00:00
Antony Heij
0
Reputation points
1 answer
How to work with Attachment data type in VBA
Is it possible to view the size of an attached file in a field of an Access table? For example, using <field>.FileName or <field>.FileType I can view the name or extension of the attached file. Is there a similar feature for file size?
Microsoft 365 and Office Access Development
910 questions
asked 2025-05-01T13:44:49.0766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 13%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sidnei Botelho
0
Reputation points
edited an answer 2025-06-26T01:08:37.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 27%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Daniel Pineault
476
Reputation points MVP
2 answers
How do I find my access database connection string?
I want to connect to my local access database in VBA. How do I find or make the details in this string that I need to do this connection?
Microsoft 365 and Office Access Development
910 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 53%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
2 answers
How do I fix my access form display
I can open a form in design mode and all the fields look great. When I switch to form mode I get a dark green overlaid and I do not see any of the fields
Microsoft 365 and Office Access Development
910 questions
asked 2025-05-10T02:23:07.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 14.000000000000002%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFP%3C/text%3E%3C/svg%3E)
Francis Phelan
0
Reputation points
answered 2025-06-25T16:45:17.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
ScottGem
0
Reputation points
Volunteer Moderator
1 answer
Access Report Prints Form Instead — Seeking Insights from the Community
Hi everyone, I'm hoping someone here can shed light on a frustrating issue we've been facing with Microsoft Access. We have a database where users click a button on a form (labeled “Delivery Sheet”) to open a report in Print Preview mode. The report…
Microsoft 365 and Office Access Development
910 questions
asked 2025-06-12T17:57:21.6633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Phillip Bridgeman
0
Reputation points
answered 2025-06-25T13:17:32.18+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
4 answers
Eorris when Using Chinese characters in sql queries in ACCESS Database.
Hi, from June, the access sql will pop up error as below, when referencing any Chinese character as the screen shot. The exact same codes worked well in May.
Microsoft 365 and Office Access Development
910 questions
asked 2025-06-16T01:40:35.5666667+00:00
Xiaoyu Wang
0
Reputation points
commented 2025-06-20T03:22:55.1266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dora-T
1,495
Reputation points Microsoft External Staff
Moderator
1 answer
Enabling user authentication to connect Access front end to Azure SQL Database
I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,326 questions
Microsoft 365 and Office Access Development
910 questions
asked 2024-07-12T16:24:59.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 31%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
George Dimitrov
0
Reputation points
commented 2025-06-17T16:29:52.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 27%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hamish HFL
5
Reputation points
2 answers
Access Report Prints Form Instead — Seeking Insights from the Community
Hi everyone, I'm hoping someone here can shed light on a frustrating issue we've been facing with Microsoft Access. We have a database where users click a button on a form (labelled “Delivery Sheet”) to open a report in Print Preview mode. The report…
Microsoft 365 and Office Access Development
910 questions
asked 2025-06-12T18:03:35.4266667+00:00
Phillip Bridgeman
0
Reputation points
answered 2025-06-12T20:07:14.5366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kallal
5,586
Reputation points
3 answers
Using Access, what is wrong with this query, UPDATE family SET F17 = CDate(bday);
UPDATE family SET F17 = CDate(bday) Where id = 1;
Microsoft 365 and Office Access Development
910 questions
asked 2025-05-27T16:08:17.6133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Thomas Pape
0
Reputation points
commented 2025-06-09T07:41:51.66+00:00
Luis Angel Ñañez Llanos
431
Reputation points
2 answers
Microsoft Access - My report is only showing up as a half page vertical
Every time I go to run my report, it shows up as a half page vertical. Can anyone provide me with step by step instructions on how to correct this? I cannot figure out how to get the report to show up and save as a full page.
Microsoft 365 and Office Access Development
910 questions
asked 2025-06-06T13:00:51.8333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 40%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JM2025
0
Reputation points
commented 2025-06-08T18:13:56.64+00:00
Karl Donaubauer
2,061
Reputation points MVP
2 answers
How to fix an expression newstu(x).Value = stu(x).Value
We use access for our student records, we have a student that wrote the wrong SSN in and we used to be able to transfer the student entire record by clicking on the tab Correct Student ID Numbers but it now throws an error code 64224: Invalid Argument…
Microsoft 365 and Office Access Development
910 questions
asked 2025-06-03T17:29:16.0066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 84%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Sarah Eskew
5
Reputation points
commented 2025-06-03T20:49:02.04+00:00
Sarah Eskew
5
Reputation points
1 answer
How to find my data base access password?
I need to know how to find my data base access password
Microsoft 365 and Office Access Development
910 questions
asked 2025-05-28T19:26:25.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 53%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Cheryl Shaver
0
Reputation points
answered 2025-05-29T12:15:19.0866667+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
CopyFromRecordset Automation Error
ExcelSheetPopulate.txtI had been running Office 2016 MSO (16.0.12624.20278) 32-bit for several years. I've been using the attached code in MS Access for the past 5 years without any issue. Suddenly, getting Error 430, 'Class does not support Automation…
Microsoft 365 and Office Development Other
4,375 questions
Microsoft 365 and Office Access Development
910 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 7.000000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
0 answers
MS Access Automation Error on updating to Version 2108
Some copies of MS Access at my organisation have updated to; Microsoft® Access® for Microsoft 365 MSO (16.0.14326.20384) 64-bit. Subsequently they are experiencing; Automation error -2146232576 (80131700) when setting references to some libraries e.g. …
Microsoft 365 and Office Access Development
910 questions
asked 2021-09-29T16:38:13.653+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 27%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Malcolm Weller
11
Reputation points
commented 2025-05-13T12:57:35.85+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
4 answers
ACEOLEDB.DLL from Microsoft 365 Apps crash with Exception code 0xc0000005
ACEOLEDB.DLL from Microsoft 365 Apps (at least versions 16.0.14228.20248, 16.0.14430.20006, 16.0.14701.20040 in "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\") appear to cause an application crash…
Microsoft 365 and Office Access Development
910 questions
Developer technologies C++
3,972 questions
asked 2021-12-29T20:18:30.603+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 15%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jmenninkainen
31
Reputation points
commented 2025-03-31T10:36:28.31+00:00
Jmenninkainen
31
Reputation points
2 answers
I CANNOT CREATE CALCULATED FIELD BECAUSE OF PROBLEM WITH MaxLocksPerFile
N° Fields I have a database in Access with about 130 fields. ACCESS and LOCATION The Access file is in a shared folder, just because it really is, but only I use it, no one else goes in. PROBLEM When I want to create a calculated field the following…
Microsoft 365 and Office Access Development
910 questions
asked 2025-02-18T00:22:04.7733333+00:00
Luis Angel Ñañez Llanos
431
Reputation points
answered 2025-02-19T09:55:06.2533333+00:00
Karl Donaubauer
2,061
Reputation points MVP
1 answer
Use VBA to delete all appointments in a day of Outlook
From MS Access 365 I need to use VBA to automatically delete all appointments for a specific day in the Calendar of Outlook. I can access the specific Calendar using the following command Set nsCalendar = nsMAPI.Folders("Specific Outlook…
Microsoft 365 and Office Access Development
910 questions
Microsoft 365 and Office Install, redeem, activate For business Windows
asked 2025-02-15T07:19:55.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 18%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
John Papaioannou
21
Reputation points
commented 2025-02-17T12:27:57.65+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
1 answer
How to fix Automation error Object is not connected to server
I have an MS Access database with a table that has an OLE Object type field. The field stores a PowerPoint slide associated with the rest of the data in the record. I have a form with a bound object frame for the OLE Object field. There is a Button on…
Microsoft 365 and Office Access Development
910 questions
asked 2024-12-02T17:17:17.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 71%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
William Sessums
0
Reputation points
answered 2025-02-03T18:50:56.7466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 3%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECO%3C/text%3E%3C/svg%3E)
Courtney Owen
0
Reputation points Microsoft Employee