57,836 questions
Score of 0
0 answers
148 views
The Dir() function vs. referencing another VBA project
Prerequisite: You are familiar with
The VBA Dir() function
Linking to a second VbaProject in a different MS Office file (Tools->References)
Now consider:
In the main Project:
Sub foo()
Debug....
- reputation score 892
Score of 0
1 answer
68 views
EdgeBrowserControl firing events too often?
I am using the EdgeBrowserControl with MS Access.
As far as I experienced, I consider there are some problems with the events firing. Can somebody confirm or deny?
The _NavigateError event
... almost ...
- reputation score 892
Score of -2
2 answers
86 views
Record Locking Error after continuous form me.Refresh [closed]
I have a continuous subform which displays a list of questions which the user needs to answer. Access front end, SQL Server back end. Depending on the answer to a question, some subsequent questions ...
- reputation score 327
Score of 0
1 answer
136 views
MS Access re-uses already established ODBC connections, disregarding differing connection parameters
MS Access seems to re-use already established ODBC connections, disregarding differing connection parameters, when using multiple Linked Tables.
I suspect this happens with EVERY kind of database ...
- reputation score 892
Score of 0
2 answers
114 views
A query with a field that counts the number of fields > 0
I created a query with fields containing values (quantities of items in different warehouses) from the table named TABELLA.
The query checks the "Check_ID" field of the "TABELLA" ...
- reputation score 423
Score of 1
2 answers
138 views
Create a query with columns containing sums of values from a table
I have a table with 3 columns:
Part Number
Location (where the part number is stored - 4 cities "London, Paris, Rome, New York")
Quantity (how many products are stored in that location)
I ...
- reputation score 423
Score of 0
1 answer
144 views
SUM(amount) not working when also calling base column amount in SELECT clause
I want to create a query that shows the amount of an item kept at a specific location, but also the total combined amount of every location that has that item.
For example; if location 1 has 400 of a ...
- reputation score 91
Score of 3
0 answers
161 views
Bulk insert into Access DB from a large CSV file takes a lot longer using OLEDB than the old ADO. Any way to speed it up?
I have a legacy app that was written in VBA running within Access. A mathematical model produces CSV files with millions of rows. The VBA code then bulk inserts these into an Access table (with no ...
- reputation score 43
Score of 1
3 answers
122 views
Can I override Microsoft Access display default of four digits instead of two digits for calculated dates less than 50?
For reporting purposes, I need to give the date of an individual's death and how old they were on that date. To make my life easier, I have set up a calculation in Microsoft Access 2019 to display a ...
- reputation score 11
Score of 0
2 answers
218 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 ...
- reputation score 45
Score of 0
1 answer
84 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 ...
- reputation score 501
Score of 0
0 answers
118 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) (...
- reputation score 391
Score of 1
2 answers
259 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 ...
- reputation score 105
Score of 0
5 answers
180 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
...
- reputation score 27
Score of 0
1 answer
84 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,
...
- reputation score 21
