C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,385 questions
3 answers
Query is too complex.
Hello To delete many selected records at once: In a loop I populate question marks: QuestionMarks = QuestionMarks + "?, " Then: "DELETE FROM table WHERE theID = ? AND fld IN (" + QuestionMarks + ")" And: For Each MyRow As…
C#
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,605 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.
833 questions
asked 2024-05-24T08:22:33.26+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(12.8, 77%, 11%)' 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)
StewartBW
505
Reputation points
answered 2024-05-24T21:13:32.9666667+00:00
Karen Payne MVP
35,201
Reputation points
3 answers
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
3 answers
What works in my PC does not work in a Remote PC
I have written a database for someone else and installed it in their PC. It works just fine. Now they want an update - to be able to view PDFs from Access. This works just fine from my PC with the command: Application.FollowHyperlink…
asked 2024-05-22T20:12:17.5866667+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
edited a comment 2024-05-24T11:00:29.5066667+00:00
Ken Sheridan
2,671
Reputation points
0 answers
What works in my PC does not work in a Remote PC
I have written a database for someone else and installed it in their PC. It works just fine. Now they want an update - to be able to view PDFs from Access. This works just fine from my PC with the command: Application.FollowHyperlink…
asked 2024-05-22T20:10:28.5566667+00:00
Maxine Nietz
1
Reputation point
commented 2024-05-23T10:56:23.0966667+00:00
Viorel
113K
Reputation points
4 answers
ComboBox BeforeUpdate handler - Cancel/Undo unexpected behavior
Consider the following scenario: An unbound combobox with rowSource set to a query. The selected value is used in later processing. In a given situation, the BeforeUpdate handler displays a MsgBox confirming that the user wants to change the…
asked 2021-10-02T21:20:08.573+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(16, 8%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
James Garrison
11
Reputation points
commented 2024-05-22T20:33:42.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(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' %3ERB%3C/text%3E%3C/svg%3E)
Richard Berman
0
Reputation points
1 answer
Need help on reactivaing my microsoft 365 developer Sandbox
Hi All, Last year in November i signed up for 365 developer community and i was given the E5 Instance Sandbox for development due to some issues i have left the program after developing the powerapp and integrated it with teams. After completion of my…
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,583 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.
833 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,920 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.
66 questions
asked 2024-05-16T18:05:15.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(115.19999999999999, 42%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vemula Suryateja
0
Reputation points
commented 2024-05-22T04:43:23.9433333+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(176, 78%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Prasad-MSFT
5,706
Reputation points Microsoft Vendor
0 answers
Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)
Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…
asked 2024-05-16T05:19:08.68+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, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
T West
136
Reputation points
edited the question 2024-05-16T09:33:54.2633333+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
13,996
Reputation points Microsoft Employee
1 answer
Grand total of current stock report
I want to get grand total of current stock in the blank square at the bottom, but cannot figure out how.
asked 2024-05-14T20:18:43.5733333+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, 7.000000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mick Kobayashi
0
Reputation points
edited an answer 2024-05-15T13:23:01.65+00:00
Ken Sheridan
2,671
Reputation points
0 answers
How to contact a forum moderator?
Hi. How do I contact a forum moderator here? I want to know why one of my threads has been deleted. https://learn.microsoft.com/en-us/answers/questions/1660015/access-europe-user-group-meeting-using-vba-to-crea As an MVP, I would never knowingly write…
asked 2024-05-08T12:37:37.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(108.80000000000001, 90%, 20%)' 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
141
Reputation points MVP
commented 2024-05-14T15:30:23.4566667+00:00
Colin Riddington
141
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Access VBA References caused compile error
An Access database in Microsoft Office 365, which is up to date, uses references to several other programs, selected in the Tools | References menu in the VBE. It has compiled successfully for several months as it is developed. It then suddenly failed…
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.
833 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,028 questions
asked 2024-05-08T17:38:21.3566667+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, 63%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Andrew Collins
61
Reputation points
edited the question 2024-05-14T01:53:37.35+00:00
Emi Zhang-MSFT
22,551
Reputation points Microsoft Vendor
1 answer
Missing Certificate - AZ900
Hi, I have recently passed the Microsoft Certified: Azure Fundamentals AZ-900 course and received the email with the certification ID, but whenever sign into my Microsoft Learn profile there is no certificates/awards recorded against my account. Kind…
![](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, 89%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
1 answer
When I select the Lookup Wizard option in Access, I encounter Path Not Found
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,848 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,359 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
314 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.
833 questions
asked 2024-04-23T18:08:38.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(89.60000000000001, 38%, 18%)' 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
Reputation points
answered 2024-05-10T11:37:25.01+00:00
Ken Sheridan
2,671
Reputation points
0 answers
SSIS - Transfer data from Multiple tables using a single DFT
Hi... I followed all the procedures in this post and created a SSIS Package. (https://social.technet.microsoft.com/wiki/contents/articles/33564.ssis-transfer-data-from-multiple-tables-using-a-single-dft.aspx When i tried to execute this package all the…
asked 2023-01-18T09:41:46.0633333+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(204.8, 49%, 29%)' 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)
Soumya Bhat
5
Reputation points
commented 2024-05-09T08:07:21.87+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, 55.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
yousra mohamed mahmoud
0
Reputation points
1 answer
I'm looking for accessing MS Project outside platform using RESTful APIs
I'm in the process of building a service that consumes or updates MS Project details via Restful API calls. After exploring the Graph API, I found that MS Project resources are not currently supported. While there are SDKs available for .NET, I'm…
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.
833 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,920 questions
asked 2024-05-05T14:19:04.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(153.6, 48%, 24%)' 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)
Shrenik Mensinkai
0
Reputation points
edited an answer 2024-05-07T14:54:15.6933333+00:00
Prasad-MSFT
5,706
Reputation points Microsoft Vendor
0 answers
Access Europe User Group Meeting - Using VBA to create a class based on a table - Wed 1 May
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some…
asked 2024-04-24T20:46:35.66+00:00
Colin Riddington
141
Reputation points MVP
commented 2024-05-05T11:18:29.0166667+00:00
Colin Riddington
141
Reputation points MVP
0 answers
unable to register as a developer
when trying to register i keep getting an error that says If you require further information please reach out to Microsoft support with reference number: 715-123225 and transaction ID: ac291227-fbb6-4402-b981-391c18ff79a2. Correlation ID:…
asked 2024-05-04T19:41:29.7866667+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(3.2, 96%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
John Stallings
0
Reputation points
asked 2024-05-04T19:41:29.7866667+00:00
John Stallings
0
Reputation points
1 answer
Finding as how to allow one device id access and restrict other or all in Azure P1
Hi, Testing to create a policy rule in P1 license where we allow few devices id and restrict some or all. Kindly suggest. We tried but could not, devise registered using multifactor only. Thanks
asked 2024-04-28T06:51:03.23+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, 50%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mark Devon
5
Reputation points
edited the question 2024-04-29T11:45:18.98+00:00
MayankBargali-MSFT
69,581
Reputation points
1 answer
One of the answers was accepted by the question author.
Execution Context for MS Access front end to SQL Server backend
Hello, we have a business application that is based on MS Access front end and SQL Server backend. Tables are linked via DNS-less connection. The application is using SQL Server Authentication using an ODBC connection, driver is SQL Server (connection…
![](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(19.2, 96%, 11%)' 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)
1 answer
I cannot see any tables when Connecting the Azure via MS Access Linked Table Manager, what am I missing?
I have installed AdventureWorksLT as well as my own tables in a new Azure database that I am trying to connect to via "Linked Table Manager" in MS Access but all I see are the sys tables. If I use DoCmd.TransferDatabase acLink it works fine…
asked 2024-04-22T17:41:46.8033333+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, 50%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EFS
0
Reputation points
answered 2024-04-23T05:30:18.2566667+00:00
ShaktiSingh-MSFT
13,996
Reputation points Microsoft Employee
3 answers
Working with Access database via OleDbReader
Hey all I have no problem when all my access mdb are string! I'm using Access database engine 2010 to connect to mdb. The problem occurs when I have Boolean / Integer / Date fields: New OleDbCommand("INSERT INTO tableblah (strfield, intfield,…
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,385 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,605 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.
833 questions
asked 2024-04-01T16:00:49.7066667+00:00
StewartBW
505
Reputation points
commented 2024-04-19T09:41:12.49+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, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
36,471
Reputation points Microsoft Vendor