Access
A family of Microsoft relational database management systems designed for ease of use.
325 questions
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)
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
![](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
commented 2024-06-18T16:44:58.51+00:00
Lopez, Ahiezer
236
Reputation points
2 answers
One of the answers was accepted by the question author.
How to create with Visual studio a deployment for an Access project
Good morning, I have an Access 365 project and I would like to create an installation project of it using visual studio 2022. I would like some information on how to do it. It's possible? Thank you Marco Dell'Oca
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,791 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.
846 questions
asked 2024-06-15T14:50:59.2366667+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, 84%, 10%)' 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)
Marco Dell'Oca
141
Reputation points
commented 2024-06-17T05:56:51.4466667+00:00
Ali Muhammad Rajwani
0
Reputation points
0 answers
Jet compact utility
Hello Any idea why this download is not signed with a code signing certificate by Microsoft? https://learn.microsoft.com/en-us/office/troubleshoot/access/jet-compact-utility-download And, there's a password protected mdb database that I need to compact,…
2 answers
LOST Office 365 Developer license
I LOST Office 365 Developer license! My office 365 developer license expired in May, I reapplied for a office 365 developer license last week, but I haven't gotten a office 365 developer license yet, I don't see any information on the "My…
![](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, 8%, 30%)' 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)
![](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(169.60000000000002, 67%, 26%)' 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)
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.
325 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,637 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.
846 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
705
Reputation points
answered 2024-06-15T14:13:18.4+00:00
Ken Sheridan
2,751
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…
asked 2024-06-04T21:28:57.5766667+00:00
Lopez, Ahiezer
236
Reputation points
accepted 2024-06-12T18:28:09.0066667+00:00
Lopez, Ahiezer
236
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
![](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
answered 2024-06-07T17:18:58.41+00:00
Colin Riddington
141
Reputation points MVP
asked 2024-06-06T14:43:46.38+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(67.2, 7.000000000000001%, 16%)' 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)
Jean C. Melendez
0
Reputation points
answered 2024-06-07T01:55:34.5366667+00:00
LiHongMSFT-4306
25,006
Reputation points
0 answers
Open form of still open database from another access
Good morning, I have a Ms Access form from which I would like to open another form which is located in another database already open. I can do this if the second database is closed, but not when it is already open. How to do? Thanks to everyone who…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,413 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.
846 questions
asked 2024-06-05T10:52:18.6033333+00:00
Marco Dell'Oca
141
Reputation points
asked 2024-06-05T10:52:18.6033333+00:00
Marco Dell'Oca
141
Reputation points
2 answers
One of the answers was accepted by the question author.
How to insert a new reference in an excel projet
Good morning, I have a Ms Access project that creates a new Ms Excel project and inserts data into a sheet. I need to insert a new reference in the created Excel project. I want to insert a reference to Ms Access to be able to invoke a Ms Access form.…
asked 2024-06-02T15:13:41.3166667+00:00
Marco Dell'Oca
141
Reputation points
accepted 2024-06-03T16:25:22.3066667+00:00
Marco Dell'Oca
141
Reputation points
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,413 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
325 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,658 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.
846 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)
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#
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,528 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,637 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.
846 questions
asked 2024-05-24T08:22:33.26+00:00
StewartBW
705
Reputation points
commented 2024-05-31T05:48:41.7633333+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
27,836
Reputation points Microsoft Vendor
0 answers
ActiveX control not working
I have a form “InvoicesForm” with a subform “AttachedPDFForm” that displays PDF names. The subform displays the names of PDFs in a text control named PDFName and has a button to View PDF with the following code: Dim filepath As String filepath =…
asked 2024-05-29T16:27:39.9666667+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
commented 2024-05-29T18:35:55.2266667+00:00
Olaf Helper
42,576
Reputation points
1 answer
In Access, an ActiveX control is not working
I have a form “InvoicesForm” with a subform “AttachedPDFForm” that displays PDF names. The subform displays the names of PDFs in a text control named PDFName and has a button to View PDF with the following code: Dim filepath As String filepath =…
asked 2024-05-29T16:34:35.52+00:00
Maxine Nietz
1
Reputation point
answered 2024-05-29T18:33:42.1433333+00:00
Olaf Helper
42,576
Reputation points
1 answer
One of the answers was accepted by the question author.
Integer equivalent in Access
Hello I work with Access mdb with OleDbRader (Access Database Engine) in vb.net and need to set the data type to Integer (NOT Long Integer) so: Dim cmd As New OleDbCommand("ALTER TABLE Blah ALTER Column colm ???",…
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,528 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,637 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.
846 questions
3 answers
One of the answers was accepted by the question author.
Form Filter returning no records causes Error 2185: Can't reference a property for a control unless the control has the focus
I have a continuous form with a simple query as the data source. In the form header I have an unbound control into which the user types a partial search string. In the onChange for that control I update the form filter dynamically. This all…
asked 2021-11-02T00:26:50.213+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, 52%, 27%)' 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
236
Reputation points
edited an answer 2024-05-26T12:19:27.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(204.8, 28.000000000000004%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Non Linear
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)
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
Maxine Nietz
1
Reputation point
edited a comment 2024-05-24T11:00:29.5066667+00:00
Ken Sheridan
2,751
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
1.1L
Reputation points