57,834 questions
Score of 2
3 answers
149 views
Retrieve data, but only from those that are present at both of two specifed locations in a separate connection table
I want to build a query that retrieves things from locations, but only the things that are present at both of two locations specified by the user.
This is the Things table:
thingId
name
1
thing one
2
...
- reputation score 123
Score of -8
0 answers
135 views
Inherited a large MS Access database, need to reorder, reorganize, and improve [closed]
I inherited an old Access database (several accdb files, actually) at an educational institution where I started working.
There are more than 4000 records of students starting from those admitted in ...
- reputation score 1
Score of 2
0 answers
231 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 902
Score of 0
0 answers
84 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 902
Score of -2
2 answers
91 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 329
Score of 0
1 answer
153 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 902
Score of 0
2 answers
120 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
140 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
146 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 123
Score of 3
0 answers
164 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
124 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
220 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
88 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
125 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
263 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
