Access
A family of Microsoft relational database management systems designed for ease of use.
329 questions
0 answers
Device management could not be enabled
Your account was not set up because device management could not be enabled. This device might not be able to access some resources such as wifi vpn or email
asked 2024-07-01T05:29:52.7133333+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(291.2, 62%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mahalakshmi S
0
Reputation points
asked 2024-07-01T05:29:52.7133333+00:00
Mahalakshmi S
0
Reputation points
6 answers
One of the answers was accepted by the question author.
Invalid procedure call or argument error
When pressing a command button the code below is executed, and it results in an error as seen in the picture. In addition, I seem to be the only user with this issue. My coworkers don't mention having this issue. I never had this issue until about a…
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
329 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.
847 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,057 questions
asked 2024-06-04T21:28:57.5766667+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 the question 2024-07-01T02:56:55.8133333+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,145
Reputation points Microsoft Vendor
0 answers
I lost my access to Minecraft
I bought Minecraft years ago from a gift card. I migrated my Mojang account to my Microsoft account and I could play with no problems for the time being. I played the last time like 2-3 days ago, and now I wanted to play Minecraft again. I can't.…
asked 2024-06-30T10:46:23.02+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, 23%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Magdalena Rudnik
0
Reputation points
asked 2024-06-30T10:46:23.02+00:00
Magdalena Rudnik
0
Reputation points
0 answers
Error when changing DataSet from Access to SQL
I have a VB program that I wrote many years ago that used an Access database. The program has a DataSet that I originally created from the Access database. Recently, I tried changing the connection string it uses to point to a MS SQL Server Express…
asked 2024-06-29T17:52:56.2233333+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, 10%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gregory Greenman
0
Reputation points
asked 2024-06-29T17:52:56.2233333+00:00
Gregory Greenman
0
Reputation points
0 answers
Access Europe User Group Meeting - Wed 3 July
The next Access Europe User Group meeting will be on Wednesday 3 July 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). We are pleased to welcome two presenters from Germany: Olaf Nöhring and André Minhorst. Olaf will…
asked 2024-06-28T18:28:52.7133333+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
edited the question 2024-06-28T19:09:19.6733333+00:00
Colin Riddington
141
Reputation points MVP
0 answers
How to set up client permissions on secure shared database
Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…
![](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(131.20000000000002, 54%, 22%)' 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)
5 answers
One of the answers was accepted by the question author.
External users without Microsoft account cannot access Sharepoint site
Hello, I have created a Sharepoint site within my organization, and within it I have created a series of folders and files to share with external people (I have enabled external sharing to users who do not belong to the organization, etc.). The problem…
asked 2024-06-18T10:55:17.8066667+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, 27%, 20%)' 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)
SAT TECH
20
Reputation points
answered 2024-06-20T13:53:33.4866667+00:00
Mustafha Shariff
0
Reputation points
1 answer
How to stop sql_generate_invisible_primary_key generation when migrating Access database to Azure MySQL
After import of Access table to Azure MySQL instance database, an invisible primary key is automatically generated. 'SHOW VARIABLES LIKE "sql_generate_invisible_primary_key";' shows 'ON'. Trying to 'SET GLOBAL sql_generate_invisible_primary_key…
asked 2024-06-10T21:07:18.86+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(172.8, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
GScavello
0
Reputation points
commented 2024-06-18T23:48:41.63+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
0 answers
Object variable or With Block variable not set
I have this code that is executed upon pushing a button. After going through most of the code i get an error saying 'Object variable or With Block variable not set'. Private Sub CancelJob_Click() On Error GoTo Err_Close_Jobs Dim BOM As String Dim i…
asked 2024-06-18T16:01:14.43+00:00
Lopez, Ahiezer
236
Reputation points
commented 2024-06-18T16:44:58.51+00:00
Lopez, Ahiezer
236
Reputation points
0 answers
Bug in Access Database Compare Tool
Hello As seen in the screenshot: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the…
0 answers
Jet compact utility
Hello Any idea why this download is not signed with a code signing certificate by Microsoft? https://video2.skills-academy.com/en-us/office/troubleshoot/access/jet-compact-utility-download And, there's a password protected mdb database that I need to compact,…
3 answers
One of the answers was accepted by the question author.
Limit the rows in Access table
Hello Is it possible to limit the number of rows in each Access mdb database table? Will need to apply the limitation via VB.NET OLEDB and using Access database engine. Thanks.
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
329 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,641 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.
847 questions
asked 2024-06-13T15:00:50.7033333+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
745
Reputation points
answered 2024-06-15T14:13:18.4+00:00
Ken Sheridan
2,756
Reputation points
2 answers
Error 2105 After Trying to Add New Record
Hello, all. I was wondering if I could get any help on this topic. I am quite new in this world of dealing with MS Access, database management, and VBA coding. However, I was able to create a front and back-end database so my colleagues could create…
asked 2024-06-08T20:18:46.0733333+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, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Larissa Marques Freguete
0
Reputation points
commented 2024-06-10T19:20:37.68+00:00
Larissa Marques Freguete
0
Reputation points
2 answers
Access Europe meeting on Wed 5 June - Extended File Properties / Manage Import/Export Data Tasks
The next Access Europe meeting will be on Wednesday 5 June 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by about 19:30 (7.30PM). The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST . Please note that the UK…
asked 2024-05-29T20:09:23.51+00:00
Colin Riddington
141
Reputation points MVP
answered 2024-06-07T17:18:58.41+00:00
Colin Riddington
141
Reputation points MVP
2 answers
Microsoft Access Error After April 2024 Microsoft Update: Too many client tasks
I am getting the error "Too many client tasks" when querying an Access database using ODBC after an April 2024 Microsoft update was applied, which was the update for Office 2016 KB5002340. When I uninstalled that update, it's working well…
![](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, 33%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
access copy and paste issue
We have a strange intermittent issue in an Access 2016 database application (classic architecture with individual front end per user with links to a central backend database), that prevents users copying text from emails, word docs, xlsx spreadsheets etc…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,428 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
329 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,673 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.
847 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(217.60000000000002, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
1 answer
How do I use an Access query to update a field in a SharePoint calendar?
I have a SharePoint 2016 calendar with 3 multi-value lookup fields (Org L1, Org L2 and Org L3) which need to be set based on a value in a multi-value choice field (Project). I'm trying to use Microsoft Access 2021 to do what I thought would be easy…
asked 2024-05-28T20:49:42.4033333+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(179.20000000000002, 37%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kandace Rowe
0
Reputation points
commented 2024-05-29T15:19:12.5366667+00:00
Kandace Rowe
0
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…
![](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)
0 answers
How can I create a label in Microsoft Access that ignores empty fields and moves the remaining fields up?
I have a form that is a label and I need to have this as a sort of "general purpose" label so there may be a field missing from time to time (Company Name) that when the label prints, it ignores that field and moves the rest of the fields up so…
asked 2024-05-23T04:03:46.13+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, 92%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jeff Toombs
0
Reputation points
asked 2024-05-23T04:03:46.13+00:00
Jeff Toombs
0
Reputation points
1 answer
How to Nest Select Case statements in SQL
I seem to have problems when I try to Nest "Select Case(s)" in Access/SQL... Can it be done; is there a specific syntax to do it? This is what I am trying to accomplish...Select Case Me.[RecordSource] Case 0 Case 1 Case 2 Select Case…
asked 2024-05-22T21:19:49.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(51.2, 42%, 14%)' 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)
Garnet Brockman
0
Reputation points
answered 2024-05-22T22:04:21.7166667+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,701
Reputation points MVP