ms-access

55 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.

Solved June 29, 2011

GUI interface for sqlite data entry in Python

I am making a simple sqlite database for storing some non-sensitive client information. I am very familiar with python+sqlite and would prefer to stick…

thumb_up 9 trending_up 16
Solved April 11, 2011

MS Access trigger?

I have two tables named [Insert_Record] and [Delete_Record] in MS Access. Both tables have the same fields but one table has records whereas another…

thumb_up 7 trending_up 8
Solved December 10, 2010

Check if a database cell is empty first

I am accessing an MS Access 2007 database through C#, and I keep getting an exception whenever I try to read an empty cell.…

thumb_up 8 trending_up 6
Solved November 16, 2010

NOT IN condition in SQL

Can anyone tell me the exact syntax for NOT IN condition in SQL on two columns. This is my query written in VBA. strNewSql…

thumb_up 13 trending_up 6
Solved November 15, 2010

Select query with date condition

I would like to retrieve the records in certain dates after d/mm/yyyy, or after d/mm/yyyy and before d/mm/yyyy, how can I do it ?…

thumb_up 17 trending_up 6