Problem I am a beginner in Access SQL. I am in need of writing a parameter query for Access SQL […]
Tag: ms-access
C# to Access SQL query based on UI controls
Problem I have a WPF application (using MVVM pattern) that allows users to perform a search for a record/records based […]
General function to test for empty/no-value controls
Problem I’m working on a very CRUD-heavy MS Access application, which has over 50 forms for entering and working with […]
Update 12 records in a database table in less than 13 queries
Problem I’ve got a database table in my application called “periods”. The structure of the table is: Year (Number) Month […]
Select Records Constituting Percentage of Total
Problem The Setup I have a table (call it myTable) in MS Access with two fields: Item (Text) and Quantity […]
Form controls – Single event handler for multiple controls, without sacrifices
Problem Bit of background info first – I’ve been struggling with a problem for a while now. How could you […]
Security issues in a SQL query and possible function?
Problem By adding more and more features to my websites, I am now up to 7 different hard coded queries. […]
Creating ShortCut (RightClick) Menus in Access
Problem I’m writing a tool to create shortcut menus for an application that I maintain built on the Access runtime. […]
DAO recordset effiency
Problem I have a form that consists of about 60 fields that all update when choosing a different customer from […]
Updating access records
Problem I spent an hour or so this morning compiling this, and since I have started reading Clean Code and […]