Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,571 questions
1 answer
Excel Connection Manager in SSIS Data Flow Task fails to connect to spreadsheet
Hi I am using Excel 2016 64-bit part of MS Office Pro Plus 2016 (from file/account/About Excel) Microsoft Access Database Engine 2016 Redistributable 64 Bit. From https://www.microsoft.com/en-us/download/confirmation.aspx?id=54920 Visual Studio…
Excel
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
317 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
181 questions
asked 2023-01-20T19:30:01.7733333+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, 40%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
James Ball
0
Reputation points
commented 2023-12-28T18:09:24.7933333+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, 10%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Puneet Sharma
0
Reputation points
1 answer
MS Access 2000 on Windows 10 suddenly crashing anytime I try to add a listbox or combo box on a new form.
Have been using MS Access 2000 on my Windows 10 computer without problems since windows 10 came out. Suddenly started having issue with existing database crashing and startup form failing to load (believed to have started after April 13, 2023 windows…
![](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, 92%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%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(76.8, 19%, 17%)' 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)
2 answers
One of the answers was accepted by the question author.
Error - Requested session access is denied
I'm having trouble logging into my virtual machine using an authorized local user account with all the necessary permissions. I keep receiving the error message "The requested session access is denied". However, I am able to log in successfully…
asked 2023-07-05T15:30:52.96+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(19.2, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Megha Goushal
25
Reputation points
commented 2023-12-27T13:14:13.54+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, 40%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Nikola M
0
Reputation points
4 answers
En access 2021 Ultima propiedad de las "propiedades de tabla". Se llama "activar orden".
En access 2021, me encuentro con la última propiedad de las "propiedades de tabla". Se llama "activar orden". Me viene con un 0 como valor predeterminado. ¿Qué utilidad tiene? ¿Qué valores puede tomar? Gracias.
asked 2023-12-16T01:46:08.92+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(144, 42%, 23%)' 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)
misionero
0
Reputation points
answered 2023-12-26T20:25:50.8933333+00:00
Ken Sheridan
2,751
Reputation points
1 answer
Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike Wolfe (MVP) will be leading a presentation called…
asked 2023-11-28T14:20:59.4733333+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
answered 2023-12-13T20:23:55.2966667+00:00
Colin Riddington
85
Reputation points
1 answer
How to ensure anyone can book via MS Bookings, not just those with a microsoft account
I'm trying to ensure all customers are able to book via our booking pages, regardless of whether they have a Microsoft account or not. The help pages says to select whether users will need to authenticate with their Microsoft 365 work or school account…
asked 2023-12-11T16:38:16.0033333+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, 64%, 31%)' 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)
Rosie Muggeridge
0
Reputation points
answered 2023-12-11T16:38:16.0066667+00:00
Q&A Assist
0 answers
I want to use Minecraft education edition as a school teacher. How can I use it?
https://www.eventservice.kr/2018/microsoft/ms_mec/education.html#edition I am a teacher working at a Korean school. I would like to get an Office 365 account for education because I heard that I can use Minecraft Education Edition if I get an Office 365…
![](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(80, 28.999999999999996%, 17%)' 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)
1 answer
Document Intelligence Studio (Former Form Recognizer) Project Access
How do I share my projects in Document Intelligence Studio to other team members?
![](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, 49%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%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(89.60000000000001, 78%, 18%)' 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)
0 answers
Can't transfer excel file to access.
I am attempting to transfer an Excel file to Access, but each time I try I receive an error message stating "Microsoft was unable to append all the data to the table." What could be causing this issue and how can I resolve it?
asked 2023-11-30T16:04:47.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(32, 0%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Nick
0
Reputation points
commented 2023-12-05T22:48:19.3066667+00:00
Colin Riddington
85
Reputation points
1 answer
how to update database using freeform list
I want to update a table based off of a list box. The list box needs to be freeform, copy/paste list. I have a table for servers. 1 column is for server names and another is for decommissioned (yes/no checkbox). I want to be able to provide a list of…
![](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
One of the answers was accepted by the question author.
Is it possible to connect a Google Forms to a linked Microsoft Access table using VBA code?
Is it possible to connect a Google Forms Survey (URL website) directly to a linked table in a Microsoft Access database and pull the respondents' responses directly into a linked MS table using VBA code? Currently, when respondents submit their responses…
![](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, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
0 answers
How to troubleshoot the cause of our Front end access database crashes that occur 2-3 times a day?
we have a front end database that we use in the front office. in the last year, we have gotten to the point that the database crashes several times a day. we solve it by getting all users off the database, deleting the lock file ( it is always there even…
![](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(48, 48%, 14%)' 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)
1 answer
access table transpose two fields
Hello, It's not easy for me to describe what I want. :-) I have a database table with two fields. In one field is an Active Directory Group, in the other field are the member of the group. In some groups there are 300 to 700 users separated by a…
asked 2023-11-30T13:13:03.53+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, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Andreas Sperling
40
Reputation points
answered 2023-11-30T16:03:41.4066667+00:00
Andreas Sperling
40
Reputation points
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
One of the answers was accepted by the question author.
How can I resolve the 'Cannot find user or service principal in graph database' error when assigning a role in Azure Digital Twins using a Microsoft account email?
I'm attempting to do the Digital Twins hands-on lab from GitHub (https://github.com/Azure-Samples/digital-twins-samples/tree/main/HandsOnLab), and I need to assign the Azure Digital Twins Data Owner permission using the following code: plaintextCopy…
asked 2023-11-24T08:16:51.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(57.599999999999994, 52%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
hwajeong lee
25
Reputation points
commented 2023-11-25T09:46:02.41+00:00
hwajeong lee
25
Reputation points
1 answer
Not possible to connect with RDP on Windows 11 Arm64 VM
I have crated my first Win 11 ARM64 virtual machine in Azure. After two days a RDP connection was not possible anymore. I have deleted and created a new one but the problem still exists. Port check show "accessible", and other Win x64 VMs are…
asked 2023-11-18T18:02:38.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(262.40000000000003, 34%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E7%3C/text%3E%3C/svg%3E)
79064419
0
Reputation points
commented 2023-11-20T21:08:05.5533333+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, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kobulloc-MSFT
24,656
Reputation points Microsoft Employee
1 answer
Booked my AZ102 exam using work Id. But, I don't see the transcript. I also got a different MCID. I want to merge two MCIDs
I booked my AI 102 exam using my work id But I don't see any transcript in my Microsoft learn profile. I merged my perosnal account with my worjk id but still I don't see the transcript. The MCID after merger and the one I received on email after…
asked 2023-11-20T10:35:41.5133333+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(208, 96%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sahni, Astha
0
Reputation points
answered 2023-11-20T19:46:03.9466667+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, 76%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Schneider, Tobias
1,125
Reputation points
1 answer
How to use Dlookup in MS Access?
Here is the formula: Me.txtpost = DLookup([Designation], [tblStaff], "EmployeeName=" & Me.txtname) Me.txtpost: the field where I want to retrieve the data. Designation: the data that I want to retrieve. tblStaff: the tablke where the…
asked 2023-11-19T07:40:47.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(156.8, 28.000000000000004%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Feras Hmedan
0
Reputation points
answered 2023-11-19T07:45:51.76+00:00
Vahid Ghafarpour
19,630
Reputation points
0 answers
Login Issue
Some of the users having trouble in login to specific organization tenants with same email ID. We have some users who have accounts with the same email ID but try to access the different organizations tenants. Eg: ABC@gmail.com (X Company) &…
asked 2023-11-18T17:10:47.4+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, 87%, 29%)' 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)
Chetan Saddar, Vodafone (External)
0
Reputation points
asked 2023-11-18T17:10:47.4+00:00
Chetan Saddar, Vodafone (External)
0
Reputation points
0 answers
ERROR EN SQL EN ACCESS
QUIERO HACER UNA CONSULTA EN ACCESS PARA GRABAR REGISTROS EN LA TABLA DESDE UN FORMULARIO Y ME DA EL SIGUIENTE ERROR: Error de sintaxis (Falta operador) en la expresión de consulta 'forms!Nombre del formulario!nombre del objeto. El objeto es un cuadro de…
asked 2023-11-15T21:12:39.5533333+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(297.6, 53%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sergio Scavino
0
Reputation points
asked 2023-11-15T21:12:39.5533333+00:00
Sergio Scavino
0
Reputation points