Access
A family of Microsoft relational database management systems designed for ease of use.
398 questions
3 answers
One of the answers was accepted by the question author.
How do list results of a column in a table in one field separated by commas in MS Access
I would like to know how to get a column into a query field. Similar to how in Access if you use the multi-value field in MS Access. However, i do not wish to use the mutli-value. For example, if I had a table column1 with A C D F G (one…
Access
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.
880 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,172 questions
asked 2024-10-16T18:48:02.2+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, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
imodett
61
Reputation points
edited the question 2024-11-01T07:32:19.25+00:00
Emi Zhang-MSFT
25,541
Reputation points Microsoft Vendor
2 answers
Two finger scrolling not working in Access
Two-finger scrolling on a touchpad is not working on an Access form. It works OK in Excel, so it's not the computer or the mouse/touchpad drivers. It's also fine on the Navigation Pane in Access. If I open a table, it does scroll but is jerky and…
asked 2023-03-29T10:34:43.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(182.40000000000003, 57.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
john fallows
10
Reputation points
commented 2024-10-31T22:15:28.35+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(310.4, 8%, 40%)' 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)
SonofTheAlmighty
0
Reputation points
0 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…
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
asked 2024-10-31T13:47:49.46+00:00
Maxine Nietz
1
Reputation point
2 answers
For MS Access Error Message: ODBC call failed. String or binary would be truncated #8152
Dear all, I have a MS Access DB Form (mask) and a "comments" field in the mask connects to a SQL Server db table field of 2500 length. I extended the length to 3000 char as per request and refreshed the connection, but the user still cannot…
asked 2024-10-11T11:50:23.4233333+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(185.6, 72%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I
0
Reputation points
answered 2024-10-11T18:54:03.47+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, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout
1,696
Reputation points MVP
3 answers
How do I fix the OLE Object in Access Error 3118?
Cannot join on Memo or OLE Object <name>. (Error 3118)
asked 2024-10-03T17:53:14.9933333+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(32, 21%, 13%)' 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)
April Kurtz
0
Reputation points
edited an answer 2024-10-05T15:32:38.2266667+00:00
Ken Sheridan
2,841
Reputation points
1 answer
One of the answers was accepted by the question author.
Sandbox environment to try MS-4010 Labs
Is Microsoft is providing any sandbox environment to try MS-4010 Labs?
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,268 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.
880 questions
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365: Microsoft 365 Copilot refers collectively to Copilot experiences within Microsoft 365 applications.Development: The process of researching, productizing, and refining new or existing technologies.
152 questions
Microsoft Copilot
Microsoft Copilot
Microsoft terminology for a universal copilot interface.
342 questions
asked 2024-09-25T21:31:44.1766667+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(243.2, 33%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Gurjot Brar
20
Reputation points
commented 2024-10-03T06:03:47.05+00:00
Gurjot Brar
20
Reputation points
4 answers
One of the answers was accepted by the question author.
How do I close orphan database connections?
The last step in my Access application (before DoCmd.Quit) is to close the connection to the backend database on the network drive, as follows: This has always worked until one of the workstations was upgraded to Windows 11. Now when that workstation…
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
398 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.
880 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,172 questions
asked 2024-09-08T16:49:41.33+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(288, 39%, 37%)' 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)
DarrellDoesData
20
Reputation points
edited the question 2024-10-01T07:20:27.4666667+00:00
Emi Zhang-MSFT
25,541
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?
Hello, within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...? Was given an Access DB and need to migrate and need to know if they are all simple straight forward stand alone Tables or if…
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
398 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.
880 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,172 questions
asked 2024-09-11T18:02:58.09+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(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,881
Reputation points
commented 2024-10-01T07:04:13.33+00:00
Emi Zhang-MSFT
25,541
Reputation points Microsoft Vendor
0 answers
MS ACCESS 2021
/ functions in MS Access Filed properties in tables and most useful / important features
asked 2024-09-26T04:13:47.1466667+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(313.6, 11%, 40%)' 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)
Saleem2148
0
Reputation points
commented 2024-09-26T04:15:23.8166667+00:00
Saleem2148
0
Reputation points
1 answer
Can anyone tell me what happened with sending emails from accessweth outlook (new)
I had a button on a form that I click and the invoice would show and clicked send and it would send it as a email through outlook as pdf. work this way for 15 years has not worked since tuesday.
asked 2024-09-22T04:39:32.3533333+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, 17%, 33%)' 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)
Bazza1
0
Reputation points
edited an answer 2024-09-24T10:45:30.4333333+00:00
Karl Donaubauer
1,891
Reputation points MVP
0 answers
Not able to access the account/subscription I was added to
I recently joined an organization. The account owner added me to the microsoft azure as an external user. I am able to login. Then they added the 'Global administrator' role against my user. They also added me under their microsoft azure subscription.…
asked 2024-09-13T15:31:06.4633333+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(140.8, 47%, 23%)' 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)
Avin
0
Reputation points
commented 2024-09-13T17:19:57.7566667+00:00
Tom van Stiphout
1,696
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
I clicked on Access policies on my ley vault, but i was shown this "Access policies not available". How do i make it available?
Access policies not available. The access configuration for this key vault is set to role-based access control. To add or manage your access policies, go to the Access control (IAM) page. How can I resolve this
asked 2024-09-09T11:45:38.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(281.6, 72%, 37%)' 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)
Charles Onyebuchi
20
Reputation points
accepted 2024-09-11T10:05:16.8833333+00:00
Charles Onyebuchi
20
Reputation points
1 answer
no unique index found for the referenced field of the primary table
This error pops up during creation of relationships "no unique index found for the referenced field of the primary table"
asked 2024-09-10T17:49:46.9566667+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(99.2, 81%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOD%3C/text%3E%3C/svg%3E)
O'Donnell, Sharman@DIR
0
Reputation points
answered 2024-09-10T17:55:22.0533333+00:00
Olaf Helper
44,931
Reputation points
2 answers
Access database locked
Access database locked as it is apparently opened by Admin on a single user computer. the message box says try again when the database is available. i have waited 24 hours to no avail
asked 2024-09-10T04:05:59.31+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, 43%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RajuH
0
Reputation points
edited an answer 2024-09-10T15:42:45.1733333+00:00
Karl Donaubauer
1,891
Reputation points MVP
3 answers
MS Access version 2407 unable to connect to Salesforce via Linked Table Manager
Has anyone else experienced a problem connecting to Salesforce after updating to version 2407 (Build 17830.20138) Current Channel? Issue started happening last week (7/29/2024) to user where they get error ODBC--connection to '{{Salesforce}}' failed when…
asked 2024-08-08T23:51:24.59+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(32, 92%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Brent Smiley
0
Reputation points
answered 2024-09-10T15:38:52.9133333+00:00
Karl Donaubauer
1,891
Reputation points MVP
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…
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
edited a comment 2024-09-05T19:09:49.3166667+00:00
Oury Ba-MSFT
19,426
Reputation points Microsoft Employee
3 answers
Calculating time differences for a swimmer in Access 2019
I'm having trouble calculating time differences for a swimmer in Microsoft Access 2019. How can I do this properly?
asked 2024-08-15T17:15:11.9566667+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(92.8, 93%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
Charles Johnson
0
Reputation points
edited an answer 2024-08-31T12:06:44.9066667+00:00
Ken Sheridan
2,841
Reputation points
1 answer
Can't active develop tab to powerpoint
I'm trying to Enable the Developer Tab in PowerPoint but I can't find it under the main tabs in the preferences cus I need to USE VBA code to make a presentation. I'm Using a Mac device
asked 2024-08-29T11:13:52.08+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, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
ahmed lotfy
0
Reputation points
commented 2024-08-30T02:05:43.95+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
10,560
Reputation points Microsoft Vendor
0 answers
Microsoft Access/SQL Server Hosted on Azure - How to Distribute to End Users
I am wanting to use Microsoft Access to create various dashboards/forms for inventory management, PO requests, and maintenance. I feel confident in my abilities on the Microsoft Access development end. I guess what I’m looking for is advice on how to…
asked 2024-08-28T16:10:50.44+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, 28.999999999999996%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kyle Chesshir
0
Reputation points
edited the question 2024-08-29T06:11:51.9566667+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
15,336
Reputation points
1 answer
i dont understand why i'm getting errors on code below in Access
ID = Nz(DLookup("UserID", UserT", "UserN=""" & UserN & """"), 0)
asked 2024-08-25T13:42:51.4833333+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(217.60000000000002, 14.000000000000002%, 31%)' 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)
Anybody Here
0
Reputation points
answered 2024-08-25T15:00:35.1633333+00:00
Ken Sheridan
2,841
Reputation points