All Questions
26 questions
3
votes
1
answer
553
views
VBA introspection library for SQLite
SQLiteDB VBA Library is a set of VBA helper functions for the SQLite engine. The primary motivation behind this project is to provide convenient access to extended introspection features. Because of ...
- 415
2
votes
1
answer
147
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 | ...
- 161
3
votes
2
answers
151
views
How to get the median value faster
Using Excel, I have one sheet ("db") with data extracted from MES.
I have to analyze this data and I need: Articolo, Fase, Tipo Confezione, TURNO, Macchina, avg and median.
I searched ...
- 297
7
votes
1
answer
342
views
VBA-Sync code feedback
I was hoping to get some input on a class module I'm designing to abstract away the boilerplate of utilizing asynchronous queries in VBA. cQueryable supports both synchronous and asynchronous queries. ...
- 171
3
votes
1
answer
144
views
SQL to Excel then to CSV file for Data Upload
Before we get started I need to let you know a critical piece of information: Due to permissions within an offsite database I am NOT allowed to create tables even temporary ones within the database ...
- 595
3
votes
1
answer
292
views
VBA and SQL to return SQL results to Excel
Now that I finally have time to look back at this code I wrote over a year ago. I need help with streamlining the code I have written. I had to write a significant amount of ...
- 595
0
votes
1
answer
5k
views
VBA Excel Looping through recordset and storing the data to use later
I have a loop to add Recordset items to a Dictionary so I can do comparisons and retrieve specific data later in the code (not ...
- 11
6
votes
1
answer
409
views
ADODB Wrapper Class (Revisited)
I recently posted this question on my implementation of an ADODB Wrapper Class. I realized in my own review that I was missing some very important things, so much so, that I decided it would be worth ...
- 678
2
votes
1
answer
578
views
ADODB Wrapper Class
I use ADO (specifically for accessing SQL) daily at work. So, I finally decided that I was going to create a class that makes it simple for myself and other programmers on the job to use. Just the ...
- 678
1
vote
0
answers
767
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
3
votes
1
answer
148
views
Running SQL Queries On A Worksheet (With Set Of Random Numbers Between 1-20 Filling Column A) Handled As An ADO
INTRO
I am using an Excel worksheet as my "database." No headers so [F1] is assigned to column one by default. I filled the entire column, all 1,048,576 ...
- 525
0
votes
1
answer
1k
views
Excel VBA Filtering: AODB vs Autofilter vs SQLite
I have an Excel sheet with data in about 100,000 rows, 16 columns. I have to extract data (one value from the 1 row I find) from this table a few thousand times. I have been using Autofilter to ...
- 1
1
vote
2
answers
99
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
5
votes
2
answers
1k
views
Code which pulls from SQL and dumps in Excel
I have a working code that pulls data from SQL and dumps in a column. Unfortunately it is extremely slow as it takes around half a second to pull each data point and it needs to be much faster. Are ...
- 53
0
votes
1
answer
106
views
Get data from Access SQL database with ADODB and weather data using web service and Excel VBA
This is a follow-up from this post.
It all works, but I think the code could be made to work faster and to be more stable. I have made improvements and updated the code in this new question.
...
- 153