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.

Filter by
Sorted by
Tagged with
1
vote
2answers
2k 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
897 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 ...
10
votes
1answer
29k 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
234 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
185 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
3k 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
59 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
801 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. ...

1
2