Solved
May 24, 2011
how to use LIMIT in query of MS ACCESS 2007
I have created some queries in MS Access 2007. they are giving error if I use LIMIT in query. Can anyone help me out…
thumb_up 15
trending_up 8
Access VBA
<p>Relational database design, SQL integration, and form logic.</p>
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
February 16, 2011
Creating a DSN-less connection for MS Access within Java
I'm building a desktop app that needs to communicate with a MS Access database. Now, unless I want to register the DSN for the…
thumb_up 5
trending_up 6
Solved
January 10, 2011
Retrieve column values of the selected row of a multicolumn Access listbox
How can I retrieve the value of specified column of the selected row in a multicolumn listbox? I populate the listbox by setting the…
thumb_up 12
trending_up 9
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
Solved
September 28, 2010
Determine whether a Access checkbox is checked or not
Such a simple question, but I cannot find the answer (Google, MS help, SO): How can I check by VBA whether an unbound checkbox…
thumb_up 15
trending_up 14
Solved
September 7, 2010
Is Access 2007 with a touch-screen POS interface the right choice to convert my INFORMIX-SQL app?
I have evaluated several development tools for converting my informix SQL-based app. They are: Genero/4Js, FileMaker, Oracle APEX, VFP, Clarion and Access 2007. I…
thumb_up 8
trending_up 3
Solved
July 19, 2010
How to add zeros in front of a text field in an access table
I have an access table with a text field. It has alpha numeric values. But i want all values to be minimum 3 digit.…
thumb_up 9
trending_up 2