57,864 questions
-1
votes
0
answers
91
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
80
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
240
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
168
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
76
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
81
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
126
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
84
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
119
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
253
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
158
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
76
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
76
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
169
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,464
