916 questions
916 questions with Microsoft 365 and Office | Access | Development tags
3 answers
In MSAccess 2003, how to fix the "Not responding" file open, import or link window.
On a new computer with a clean Windows 11 installation. When using MSAccess 2003 (can't confirm for Excel or Word) and trying to open anything related to the file explorer (File - Open, Save as, New, import and link), the small file explorer window hangs…
Microsoft 365 and Office | Access | Development
asked 2025-08-01T02:08:57.5233333+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(6.4, 90%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF5%3C/text%3E%3C/svg%3E)
FD-5007
0
Reputation points
answered 2025-08-01T12:18:01.2466667+00:00
George Hepworth
21,805
Reputation points
Volunteer Moderator
2 answers
How-to get RichText from LongText AppendOnly ColumnHistory()?
Is there a workaround to get the HTML-ish RFT from ColumnHistory() of a LongText field set with RichText format and AppendOnly versioning? I'm not trying to defend AppendOnly vs better solutions. Or storing HTML-ish RTF in Access. Just asking if anybody…
Microsoft 365 and Office | Access | Development
916 questions
asked 2025-07-25T22:26:34.42+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, 38%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Dick Watson
106
Reputation points
answered 2025-07-28T15:08:40.82+00:00
DBG
11,381
Reputation points
Volunteer Moderator
3 answers
how to use relative paths for access linked tables
How can I set a relative path to an external linked table
Microsoft 365 and Office | Access | Development
916 questions
asked 2025-07-15T00:08:47.1966667+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, 96%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Dominic Raftery
0
Reputation points
commented 2025-07-18T06:25:54.89+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, 61%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
TiNo-T
4,215
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
Update tables linked in Access using VB.NET
I have an Access DB that has linked tables to other access DBs and links to Excel spreadsheets. I would like to scan the links, using vb.net, and validate that they are pointing to the current location of the files. If not I want to change the link…
Microsoft 365 and Office | Access | Development
916 questions
Developer technologies | VB
2,897 questions
asked 2021-10-16T22:11:13.52+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, 38%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Don Glover
516
Reputation points
commented 2025-07-16T14:38:29.5066667+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(64, 3%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ryan Kristoffer M. Liray
5
Reputation points
2 answers
Set country code for Microsoft 365 personal account
How to correct country code for Microsoft 365 personal account. MSAccess cannot be downloaded, because country code is incorrect
Microsoft 365 and Office | Access | Development
916 questions
asked 2025-07-14T12:13:26.3733333+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(275.2, 93%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Arthur Read
0
Reputation points
answered 2025-07-14T12:29:03.9+00:00
George Hepworth
21,805
Reputation points
Volunteer Moderator
1 answer
Access Error Handling Question
I'm using the following error handling on my forms: Private Sub Form_AfterInsert() On Error GoTo ErrHandler Me.Requery On Error GoTo 0 Exit Sub ErrHandler: MsgBox "Error " & Err.Number & " (" & Err.Description &…
Microsoft 365 and Office | Access | Development
916 questions
asked 2025-07-12T19:26:20.1166667+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, 65%, 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)
James
0
Reputation points
answered 2025-07-12T21:25:44.2633333+00:00
Ken Sheridan
3,026
Reputation points
1 answer
Microsoft Access Database Engine（ACE OLE DB 12.0）
How can I download Microsoft Access Database Engine（ACE OLE DB 12.0）? And how can I equip it with my visual Studio 2022?
Microsoft 365 and Office | Access | Development
916 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(198.4, 26%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
![](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(54.400000000000006, 70%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
3 answers
Code Label Won't Indent in Access
When I try indenting a Label in Access by pressing the Tab key the code jumps back to the beginning of the line. This occurs on 'ErrorHandler:' If I remove the colon the label indents fine. Any ideas? James
Microsoft 365 and Office | Access | Development
916 questions
asked 2025-07-08T12:07:39.77+00:00
James
0
Reputation points
edited a comment 2025-07-08T19:27:54.81+00:00
George Hepworth
21,805
Reputation points
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
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
916 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
20
Reputation points
commented 2025-07-06T02:26:08.0533333+00:00
Sidnei Botelho
20
Reputation points
1 answer
We have a 32bit VB program using Microsoft.Jet.OLEDB.4.0. How to upgrate Microsoft.Jet.OLEDB.4.0 to 64 bit?
We have a 32bit VB program using Microsoft.Jet.OLEDB.4.0. How to upgrate Microsoft.Jet.OLEDB.4.0 to 64 bit?
Microsoft 365 and Office | Access | Development
916 questions
asked 2025-07-04T13:57:09.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(44.800000000000004, 36%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Stey, Christof
0
Reputation points
answered 2025-07-05T17:02:32.69+00:00
Karl Donaubauer
2,076
Reputation points MVP
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
916 questions
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
commented 2025-07-01T13:08:53.16+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(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Duane Hookom
26,280
Reputation points
Volunteer Moderator
4 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
916 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
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
916 questions
Microsoft 365 and Office | Word | For business | Windows
8,318 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
21,805
Reputation points
Volunteer Moderator
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
916 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
68,755
Reputation points
Volunteer Moderator
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
916 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
916 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,076
Reputation points MVP
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
916 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
21,805
Reputation points
Volunteer Moderator
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
916 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
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
916 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
3,225
Reputation points Microsoft External Staff
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
916 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