57,903 questions
1
vote
1
answer
40
views
Access query for finding whether participants in a program returned in the next season
I'm not really sure how to start formulating the query that I want to run.
I have participants (tblParticipants) who attend programs (tblPrograms) that take place in a year and season (e.g., Spring ...
0
votes
1
answer
46
views
Impossible to connect to a Microsoft Access database in LibreOffice 25.2 with UCanAccess and jdbcDriverOOo 1.6.2
I need to edit the content of a MDB file under Debian Linux 12 with LibreOffice 25.2.
I tried to use the solution mentioned in the documentation (relying on UCanAccess) without success: I added the ...
- 4,284
1
vote
1
answer
55
views
MS Access VBA, Call Function, but goto a specific line of funtion
I'm using the code below to convert a pdf to excel.
When the code gets to 'laptop version, it will open a form which I will execute things(haven't put that in the code yet).
On that form I'd like to ...
- 23
1
vote
3
answers
111
views
Equipment inventory tracking - filter out duplicates resulting from equipment marked 'vacant', or best way to mark equipment vacant
I have an Access database that is tracking trucks. I have one table for trucks and all their details, and another table tracking the drivers and their details. The third table is tracking positions ...
- 11
3
votes
2
answers
167
views
Migration from Windows 10 to 11 and VBA can no longer execute batch files or tasks
I have VBA running on MS 365 on a Windows 10 VDI. My VBA code includes executing a batch file which in turn runs some python code. This has all worked fine
I now have a Windows 11 physical PC, but ...
- 105
0
votes
1
answer
134
views
Update MS Access db with SQL that includes select statement
I'm using NodeJS and node-adodb to try to run an update on a MS Access database that includes selects. I tried this:
update [Objects]
set
[Object] = 1,
[CardID] = (select id from Oracle where ...
- 3,298
Best practices
0
votes
7
replies
64
views
Simultaneous access to a table in a shared folder
In the company I work for we have an Excel file that we need to fill out daily, stored in a network folder on the server.
Unfortunately, it can only be used by one user at a time.
I tried creating a ...
- 395
Advice
0
votes
5
replies
60
views
Modifying an Access VBA project with VBA
In principle I should be able to write some VBA code, and run it over a VBA project to amend the project.
Scenario: A collection of databases is being moved from one server to another.
There are a lot ...
- 61
-2
votes
0
answers
97
views
When doing a query over 2 tables there is Data Missing
I am trying to use MS Access to compare 2 tables which have 1 common field so that I can output combined information.
The main goal of the query Is to use table A to fill in missing information from ...
- 567
4
votes
2
answers
143
views
VBA Err not reset after Exit Sub, despite documentation
VBA in Microsoft Access 365. According to Microsoft's documentation for Err.Clear,
Use Clear to explicitly clear the Err object after an error has been handled, for example, when you use deferred ...
- 1,436
1
vote
1
answer
133
views
Can't insert into Access database
I have an Access database (.mdb) that was created and sent to me by someone else. I have tried running it in both nodejs with node-adodb and with python and pyodbc, and I get an error. Here is my ...
- 3,298
-4
votes
2
answers
91
views
How to set sub-forms Record Source base on a combo box on the main form [closed]
I am working with two forms: a main form named frm_Inspections and a sub-form named sub_Questions.
I have a combo box on frm_Inspections that allows me to select the type of inspection I am conducting....
- 3
0
votes
2
answers
72
views
How to populate an unbound report field with specific text
I have a query that will hold different criteria for QA/QC purposes. Simplest explanation is it will show when certain fields are NULL and populate the corresponding QA report. In that report, I'd ...
1
vote
0
answers
163
views
InvokePattern.Invoke does not activate Access/VBA button when window is on secondary monitor
Background: I have a C# automation client (.NET Framework 4.8) using System.Windows.Automation to invoke a button in a Microsoft Access (VBA) application. The target control is non-standard / ...
- 11
-1
votes
1
answer
96
views
Error with primary key when inserting into Access with node-adodb [closed]
I have nodejs 25.0.0 and node-adodb. I am trying to insert into a MS Access database in a table that has a primary key (ID) that is set to auto-increment and has "required" set to true. I ...
- 3,298
