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.
1
vote
2answers
193 views
Excel VBA used to fetch Access data
I am using the following VBA to fetch data from an Access database. The query works but there is a lot of information in the database and the response time is very slow, about 30 seconds.
Is there ...
5
votes
1answer
48 views
VBA to MS-Access SQL query set(s) and outputs
I am hoping I can get some guidance on some better "best practice" suggestions on how to handle this kind of code set. I understand that parameterized queries are a thing, but I am not quite there yet,...
3
votes
0answers
23 views
Split cells vertically on comma MS Access 2010 VBA Module
This takes a field delimited by commas, and splits on the comma. The newly divided information is put in another field (created at the start of the program) called ...
1
vote
1answer
56 views
Update and sum query C# Access DB
I have a simple query using query builder of VS2012 C# which updates the database in my winforms application. The database has 216 entries so far and it's taking a lifetime to update the database. How ...
3
votes
4answers
90 views
A function that implements a query
I have some parameterized queries in Access 2010.
They are often used in VBA functions having the same parameters.
In such cases, I give the query and function the same name.
The following is such a ...
6
votes
1answer
481 views
Retrieving ListBox.column values and store into objects
I know there must be a better way to perform the above sub than using multiple If statements. I was thinking of storing the ...
4
votes
1answer
85 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 ...
3
votes
3answers
158 views
DAO recordset effiency
I have a form that consists of about 60 fields that all update when choosing a different customer from a drop down. I feel like my current way is not the best way as it takes about 30 seconds to ...
4
votes
1answer
176 views
Improving performance of VBA data validation script in Access with large data size
I work in IT compliance and one of my main duties is ensuring the integrity of employee network accounts. Partial VBA script as currently used is shown below:
...
4
votes
1answer
553 views
Speeding up Access query with a calculated field calling a VBA function
At work I have a Microsoft Access database of employees with fields such as employee's manager, employees email, and employee ID. My duties include updating this database and validating entries ...
7
votes
1answer
164 views
MS Access to PostgreSQL converter
I was hoping to get some feedback on the implementation of this class for programmatically converting an access file into a PostgreSQL schema (works by obtaining schema data from the cursor object).
<...
7
votes
1answer
909 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 ...
8
votes
1answer
883 views
Overriding all Access form control AfterUpdate methods
I have a set of custom event handlers for all my textboxes and combo boxes. The reason for this is my users want the bound form (to SQL Server) to immediately push changes to the recordset, rather ...
7
votes
3answers
1k views
Progress Bar Form
Forms in MS Access are really just special glorified classes, so you can create new instances of them from code like this.
...
12
votes
3answers
835 views
Security issues in a SQL query and possible function?
By adding more and more features to my websites, I am now up to 7 different hard coded queries.
I have read a lot about SQL injections and possible flaws and security issues, and wanted to make sure ...
12
votes
1answer
2k views
Creating ShortCut (RightClick) Menus in Access
I'm writing a tool to create shortcut menus for an application that I maintain built on the Access runtime. I compile this app into an *.accde file, so much to my chagrin, all right click menus are ...
4
votes
1answer
3k 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 ...
5
votes
2answers
3k 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 ...
1
vote
2answers
811 views
C# to Access SQL query based on UI controls
I have a WPF application (using MVVM pattern) that allows users to perform a search for a record/records based on their ...
8
votes
2answers
310 views
Generating a collection of controls
This question I asked previously mentions a function named BuildControlCollection, which I didn't go into the details of since it wasn't relevant. However, because ...
9
votes
1answer
10k views
Form controls - Single event handler for multiple controls, without sacrifices
Bit of background info first - I've been struggling with a problem for a while now. How could you have one single event handler to handle every control (or all of a particular type of control) on a ...
5
votes
1answer
130 views
Truncating long strings when saving inventory items to database
To test incoming data for string values that are too large for the "database" (MS Access), I could do this:
...
3
votes
3answers
166 views
Code conversion from Access to T-SQL
I have an Access database that I'm converting to SQL Server 2008. One of the queries in the database uses the LAST function. The table has a AutoNumber ID so true order is simple.
...
5
votes
2answers
2k views
Sending test emails to a list of email addresses
I've made the following program that takes a list of email addresses from a table in MS Access and sends each a test email.
...
4
votes
1answer
53 views
Time spent by product in process represented by clockin and clock out
This is the code I wrote to find out the time spent by product in process represented by clockin and clock out. Time stamps X and Y (for example, 7/23/2013 7:00 AM and 7/23/2013 8:00 AM) reflect the ...
4
votes
4answers
332 views
Adding entries to an MS Access file using OleDB
In the following piece of code I am adding entries to an MS Access file using OleDB. The purpose of this post is to point out my bad programming practices and if I have created any security flaws here....
5
votes
6answers
2k views
Using OLEDB to connect to a MS Access 2007 file
I am working on a program which use OLEDB to connect to a MS Access 2007 file. My program has a possibility to add and delete records from file by using SQL statements which select deleted item by ID.
...
