57,892 questions
0
votes
4
answers
127
views
Query to select a value of a column of a table identified by a value of another table
I'm wondering if it is possible to use an Access SQL query that selects a value of a column of a table identified by a value of another table.
For example I have tables A, B, C and D:
A:
ID_A
tbl
...
- 27
1
vote
1
answer
58
views
Access DB query can't rename column to "Supplier", column shows up blank
I'm having an issue with the following query:
SELECT
[ON1].EarliestDate,
[ON1].Route,
"***" AS Carrier,
[ON1].Supl, <--- This is the problem column
[ON1].Seq,
...
- 23
Advice
0
votes
4
replies
71
views
Basic timesheet program: add a timestamp and the time completed in a sheet with ID and automatically linked name and date/time
I am creating a basic timesheet for my job using Microsoft Access. We have ID cards that have our specific ID number. I am trying to figure out a way to swipe the card (we already have a card reader).
...
2
votes
2
answers
70
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
2
answers
95
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
75
views
MS Access VBA, Call Function, but goto a specific line of function
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
2
votes
3
answers
115
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 ...
- 31
3
votes
2
answers
189
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
138
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
68
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
65
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
4
votes
2
answers
152
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,446
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
95
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
74
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 ...
