All Questions
7 questions
2
votes
1
answer
149
views
How to speed up a treeview population in Access?
I have the following function that causes a significant visual jittering and lag in my access database - This is a treeview selection based on data in a table (tblDATA) with the fields:
Object | ...
- 171
1
vote
0
answers
770
views
Running an UPDATE SQL QUERY within VBA using DAO
I have a macro in Excel that updates a recordset using WHERE a primary key in MS Access matches a primary key in a UserForm label value. The macro is called from a ...
- 41
1
vote
2
answers
105
views
Select Records Constituting Percentage of Total
The Setup
I have a table (call it myTable) in MS Access with two fields: Item (Text) and ...
- 113
4
votes
1
answer
363
views
Parameterized Query in Access SQL
I am a beginner in Access SQL. I am in need of writing a parameter query for Access SQL and found a few tutorials and links for that but that wouldn't satisfy my requirement.
DB: Access DB
This ...
7
votes
1
answer
3k
views
Run arbitrary INSERT INTO SQL Query using parameters
While DoCmd.RunSQL is all well and good for simple code, the number of times I've run into problems with unescaped apostrophes and the like was starting to nark a ...
- 171
5
votes
1
answer
5k
views
MS Access VBA code to compare records in a table and combine data - revised
I've previously posted a version of this code here:
MS Access VBA code to compare records in a table and combine data where necessary
To repeat what I'm looking for from my previous post:
Note I ...
- 203
5
votes
2
answers
5k
views
MS Access VBA code to compare records in a table and combine data where necessary
I need to process some data which is the output from a CAD system, namely a Bill of Materials.
I've constructed database and written some VBA code to achieve this. An explanation of what this code ...
- 203