Questions tagged [ms-access]
Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
68 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
5
votes
1
answer
148
views
Python SQL insert to MSAccess with VBScript
I have a business use case that required running SQL insert queries to a local MSAccess database with a Python script. The actual script does many other things and the SQL function is just one of them,...
2
votes
1
answer
174
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 ...
3
votes
2
answers
288
views
Sub that calls itself when its parent Workbook is closed
and no, I'm not talking about Workbook_BeforeClose. Note that the motivation of this question is Excel specific but the technique I'd like feedback on is not.
If ...
0
votes
2
answers
100
views
VBA code which exports data from Access to Excel and then loops through the Excel file
I have a couple of VBA loops that work in the blink of eye when I execute them through Excel, but doing this as part of an Access VBA application takes like 15 minutes. The loops run through each row ...
4
votes
2
answers
704
views
Recursive function designed to ensure that full folder path exists before copying a file to the location
My recursive function works, but I feel it could be improved... suggestions? The code ensures that a given folder path exists by checking its validity or creating them if they don't already exist, so ...
2
votes
0
answers
433
views
Command line framework for VBA compiler app, written in twinBASIC :o
Ok compiler is a bit of a stretch...
I'm working on a package manager for VBA code, written primarily in python. One fiddly step of the pipeline involves "compiling" packages; this is the ...
2
votes
1
answer
62
views
MS Access query complexity on finding duplicates
I have a list of names and ID's, with many multiplication (it's a payroll list). I'd like to see those ID's and names where the name changed somewhen.
Input:
id1 name
1 Josephine Baker
2 Norma ...
2
votes
1
answer
156
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 | ...
7
votes
1
answer
408
views
Add Default Rubberduck VBA Folder Annotation to VBProject.VBComponents
Currently Rubberduck VBA files all the VBProject VBComponents in that do not have a Folder Annotation in a Folder named after the VBProject. It can be time consuming to manually organize the ...
2
votes
2
answers
378
views
Auto formatting and auto validating TextBox VBA
So, I created a class to avoid all the work behind the validation of input in a textbox.
The idea is to pass an existing textbox and a type of the desired content and the class will take care of block ...
4
votes
0
answers
83
views
Edit Excel through MS Access
I have an Access macro that runs AfterUpdate of a form. It opens an Excel workbook and edits a few cells. I have It working the way I want, but the problem is that ...
4
votes
1
answer
148
views
Slow performing subquery
This query executes very slowly and I wonder if it can be improved?
We have an Access database split to front end / back end with around 50 users. BE is in a network folder and FE is on users' hard ...
1
vote
0
answers
787
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 ...
1
vote
1
answer
392
views
A function to validate that an unbound form in Access has all required fields filled out
My goal in this code review is to see if i can figure out how to optimize the Validate function takes up fewer lines of code. i know there must be a way to cut it down so that it doesnt span 300 lines ...
2
votes
3
answers
221
views
A function that replicates DLookup, and can use parameterized queries
This function was built to replace DLookup so that i could pass in parameterized queries for a speed increase. I also wanted a simple way to get more than one value if needed. For example, if i want 4 ...