Word
A family of Microsoft word processing software products for creating web, email, and print documents.
737 questions
3 answers
When launched from Access via VBA, Word open a .tmp file outside the trusted folder (maybe OLE problem)
Hi, I have an Access form with an OLE BoundObjectFrame holding Word documents. I repurpose the context menu so I can lauch the Word document by my VBA code. When a file is opened everything is fine. But when I try to open a second one without closing the…
Word
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,687 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
907 questions
asked 2023-11-25T22:38:03.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(240, 8%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lauro Colasanti
101
Reputation points
commented 2023-11-28T08:59:18.6666667+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(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
7,315
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Table in local emulator with CapsLock in table name is can't access by postman
I create 2 table with name are (Test, test) , I can access table test by using SAS key but Test I get no permission. you can check following picture
asked 2023-11-20T06:29:13.9033333+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(224.00000000000003, 43%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Felix Truong
40
Reputation points
accepted 2023-11-27T14:32:42.85+00:00
Felix Truong
40
Reputation points
1 answer
How to increase the Custom Rest API Processing Speed?
Hi, Can anyone help me understanding on why API speed is not what it used to be? I have designed a custom API for one of my client(lets say abc), in this I created a Staging table to store data received from API and on Insert event in table using…
asked 2023-10-13T04:34:37.0433333+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(166.4, 19%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Varun Garg
0
Reputation points
edited the question 2023-11-24T05:06:49.59+00:00
ShaikMaheer-MSFT
38,321
Reputation points Microsoft Employee
1 answer
Method to query access database from excel Visual Basic for Applications VBA
Thanks for any help. I have been using the below method to query my Access database from Excel VBA for over a decade. Today it started throwing an unspecified error. I tried all the usual suspects (reboot, reinstall, switch PC, access files from local…
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,687 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2022-02-02T20:42:47.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(25.6, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Brad_BK
1
Reputation point
edited the question 2023-11-23T14:31:34.21+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(153.6, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jiachen Li-MSFT
28,151
Reputation points Microsoft Vendor
1 answer
Access query returns no results
I have a simple situation that isn't acting simply. I have 1 table, tblApplications. 1 query, qryApplications. 2 form, fmApplicationSearch and fmApplication. The fmApplicationSearch form has 3 fields (and a button to open fmApplication), …
![](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(163.2, 2%, 25%)' 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)
1 answer
Check instances of opening an add-in (accde)
Hi, In VBA, is it possible when opening an add-in (accde) to check if this add-in is already opened by another database? I would like to perform an action in my add-in only each time it is opened for the first time.
asked 2023-11-10T16:03:57.73+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(272, 1%, 36%)' 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)
jacky Perpète
41
Reputation points
answered 2023-11-18T05:36:29.7933333+00:00
jacky Perpète
41
Reputation points
0 answers
Access VBA SMTP now requires Authentication
I had some SMTP emails that were working just fine. But now my organization requires that we use authentication to send out to outside domain emails. My working code is as seen below: Sub SendEmail(sTo As String, sSubject As String, Optional sBody As…
asked 2023-11-17T18:56:24.3366667+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(188.79999999999998, 8%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Criseno, Ryan
0
Reputation points
asked 2023-11-17T18:56:24.3366667+00:00
Criseno, Ryan
0
Reputation points
0 answers
how come i do not find releases pipeline tab and not find use the editor to create a pipeline with YAML on my machine?
i am using dev.azure to do ci/cd, but how come i do not find releases pipeline tab and not find use the editor to create a pipeline with YAML?
![](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, 77%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
What best way to file your program in windows 11
How to import containers from ssh dev container
asked 2023-10-19T00:19:31.3033333+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(105.60000000000001, 78%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
abiola mohammed
0
Reputation points
answered 2023-11-10T08:00:13.38+00:00
Wesley Li-MSFT
4,391
Reputation points Microsoft Vendor
0 answers
Calculate by month days served based on start date and end date into a report
I am creating an MS Access project that will determine the amount of time served by month and need it to return the results into a temporary table that will be used to populate a report. The criteria will be supplied in the initial form/report that will…
asked 2023-11-07T15:11:47.6266667+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(249.60000000000002, 70%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Texas-Carey
0
Reputation points
edited the question 2023-11-08T01:23:47.3+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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
27,641
Reputation points Microsoft Vendor
0 answers
LINKEDIN ERROR: STATUS 403 Api Organization version: 202310
I am working to get data from public pages with Api "Organization" with the last version (202310), but I always get status 403, "Not enough permissions to access" eventhough I got the specific scope for this request. If I switch to…
asked 2023-10-31T15:03:04.9633333+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(54.400000000000006, 53%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Juan Carranza
0
Reputation points
edited the question 2023-11-03T20:17:53.27+00:00
Juan Carranza
0
Reputation points
2 answers
Access shortcut
I used to be able to copy a field entry from the previous record in a table by Ctl '. It now no longer works. Is there now another way? Copying and pasting takes too many key strokes.
asked 2023-10-16T11:21:18.06+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(73.60000000000001, 99%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Alan Green
0
Reputation points
commented 2023-10-31T23:07:38.8933333+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, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Colin Riddington
85
Reputation points
2 answers
Access Europe meeting on Wed 4 Oct - The future of Access
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK…
asked 2023-09-26T13:03:20.97+00:00
Colin Riddington
85
Reputation points
answered 2023-10-10T20:22:03.4433333+00:00
Colin Riddington
85
Reputation points
1 answer
One of the answers was accepted by the question author.
How to control the attachment mini toolbar in access
Hello, I just started to work with the attachment field in access, and noticed that the attachment mini toolbar is in auto hide mode, can I switch that to be allways visible, and reposition its place and control its size? Regards,
asked 2023-09-26T06:29:59.4966667+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, 67%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abdulrahman Althunayan
40
Reputation points
accepted 2023-10-04T04:59:18.59+00:00
Abdulrahman Althunayan
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Query on License
Hi All I am using Microsoft 365 E5 license, Is Microsoft Access part of this license. when i search in Volume licensing portal with the word access i dont find any product with this name. please guide me
asked 2023-10-03T13:45:04.6833333+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(137.6, 72%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rising Flight
4,196
Reputation points
accepted 2023-10-03T17:25:54.7433333+00:00
Rising Flight
4,196
Reputation points
1 answer
MSAccess Does Not Close Under Windows 11
I'm using the Access 2010 runtime for some applications I support. These applications run fine under Windows 10 but when I run them under Windows 11 the MSAccess executable still runs in the background when I quit the application using DoCmd.Quit. I've…
asked 2022-05-10T22:13:04.713+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(60.8, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Bill Bordiuk
1
Reputation point
commented 2023-09-25T10:17:48.0733333+00:00
Johan Welman
0
Reputation points
1 answer
Old Access 2002 runtime application will not run when virtualized.
I have a client that uses an old Access 2002 runtime application. It uses a split Access database system on a Windows 2003 server. The developer has long since gone out of business and they cannot get it recompiled. We tried to update to newer version of…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,437 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-09-20T14:06:45.3433333+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(230.39999999999998, 77%, 32%)' 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)
Day Goree
0
Reputation points
commented 2023-09-21T17:22:21.69+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,226
Reputation points
1 answer
aceoledb.dll crash
My application opens 2 connections to 'accdb' files. Whenever I close the second connection I have an access violation in the aceoledb.dll (16.0.5320.1000). I don't see what could be wrong in my code. I use ATL and this should already ensure that I…
asked 2023-09-17T14:56:54.9333333+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, 33%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rudolf Meier
291
Reputation points
answered 2023-09-18T05:25:28.1966667+00:00
Tanay Prasad
2,115
Reputation points
1 answer
Problem exporting forms with DoCmd.TransferDatabase from an accde file.
Access 2021 Hello, In a database, from a button on a form, I create another database and export a table and a form to this new database. This functionality is in VBA code. In the accdb file everything works perfectly. I then create an accde file from the…
asked 2023-09-15T08:02:45.37+00:00
jacky Perpète
41
Reputation points
answered 2023-09-16T04:50:06.7133333+00:00
jacky Perpète
41
Reputation points
3 answers
How can I add x amount of working days to a date?
Suppose I wanted to add 85 working days, meaning only the weekdays, to a field with an existing date, how could I do this? Same scenario, but also take into account holidays so don't count the holidays as a working day. How could I do this?
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
334 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,687 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-09-12T18:15:40.18+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(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
edited an answer 2023-09-13T16:49:41.06+00:00
Ken Sheridan
2,756
Reputation points