57,862 questions
0
votes
2
answers
199
views
Previously working database access code in Visual Basic 26 program suddenly throws exception
I have a fairly complex VB program that accesses various components of my home control and monitoring system and displays data from them on a form on my desktop. On startup, it downloads recent data ...
- 45
-2
votes
0
answers
97
views
Changing control source of drop down set another drop down null? [closed]
I am programmatically changing the control source for a text box based on a selection from a drop down. That drop down determines the "library" that data is being pulled from where the "...
0
votes
1
answer
74
views
MS-ACCESS: In SUBform list records grouped by MAINform-ID
I have a MAINform with ID and a SUBform linked using this ID. In the SUB actually I have a textfield [Funktion] with f.e.
A: Gymnastics
B: Running
C: Climbing
Now I'd like to to change this into a ...
- 501
-1
votes
0
answers
95
views
MS Access AutoExec RunCode Throws Error 2001
I have an autoexec function that runs the below, however other users get a stop macro error message everytime they open the access db. below is what is contain in the module, anytime someone opens the ...
- 13
0
votes
0
answers
90
views
ODBC Microsoft Access Driver Not a valid password. (-1905)
I'm trying to open a Jet Access database file with pyodbc but I'm getting this error :
ProgrammingError('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Not a valid password. (-1905) (...
- 381
1
vote
2
answers
245
views
The right square bracket within a charlist in the LIKE statement in Microsoft Access
The right square bracket can't be enclosed within the square brackets and thus can't be used also within a charlist, for example:
Like "*[#?]]*"
Is any other way to to insert the right ...
- 105
0
votes
5
answers
174
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
0
votes
1
answer
77
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,
...
- 21
Advice
0
votes
4
replies
88
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
73
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
135
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,294
1
vote
1
answer
87
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
123
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
269
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
160
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