All Questions
7
questions
2
votes
1
answer
139
views
One way Synchronize 2 Access Tables with VBA ADODB
I am synchronizing two MS-Access databases.
One of them on a network drive, the other one on the local machine.
(For testing purposes both in the same directory)
The Databases both contain a table ...
1
vote
0
answers
142
views
ContactEditor - Excel VBA db app: Storage Library
ContactEditor uses Excel VBA as a prototyping platform for a personal information manager combining the "Model, View, Presenter" (MVP) pattern and a persistent storage manager.
Fig. 1. Data ...
4
votes
1
answer
450
views
Creating a values only copy of an excel workbook without opening it
I have created a working VBA script that allows the user to select a workbook and make a values only copy of it without opening it. This is useful for getting data from a workbook that is very slow to ...
-1
votes
1
answer
26
views
SQL Group qry by codeProduct and Last(description) [closed]
For the ADMIN: I wrote this tread on S.O. questions/61183026, but I think that is more correct to post this tread here, if you think no, please scuse me and delete this message.
Hi, I've one xls ...
2
votes
1
answer
552
views
Executing arbitrary SQL statements using VBA in Excel
I built a workbook to help me extract data from a MSSQL database into Excel. I realize that this is fairly easy to do with Microsoft SQL Server Management Studio, but I can't easily get that installed ...
2
votes
0
answers
99
views
Programmably Typing the Tables, Views, and Columns Properties of a Database
Programmably Typing a Database gives you the advantages of Intellisense and Compiler Type Checking.
Notice that single public DatabaseAlias variable of public Type DatabaseAlias is used. The ...
4
votes
1
answer
4k
views
SQL + VBA Populating Data in Cell Range
I currently have a code that is connecting to SQL database in VBA. The data is populating correctly. However, I was wondering if there is a way to condense the code below.
I have 4 different columns ...