Top "Ms-access-2007" questions

Microsoft Access 2007 - a rapid database application development tool

How to show recordset data in Ms access subform

How can i show the result of one SQL query in an Access Sub form control? I tried the below …

ms-access-2007 recordset subform
How to get the affected rows in VBA ADO Execute?

The following code errors on the MsgBox cn.RecordsAffected line with: Arguments are of the wrong type, are out of …

ms-access vba ms-access-2007 ado
How do I make an editable UNION query?

In the course of a complex database structure, I need to provide the user with a means of editing data …

sql ms-access ms-access-2007 ms-office
In Memory, Stand-Alone, Disconnected ADO Recordset

I'm running this code on my datasheet subform when my form loads and I'm not getting any error messages or …

ms-access ms-access-2007 vba
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path

I have created DSN for Mapped drive like this:- Y:\\192.168.2.5\data\db.accdb Now i am accessing this database …

java ms-access-2007 jdbc-odbc
Microsoft Access 2007 -- View Query Used In Report?

I need help navigating Microsoft Access Reports. I am in the Report Designer, and I need to know the which …

ms-access reporting ms-access-2007
Syntax error in string in query expression 'ID = 4

I am using Visual Basic 2010 express to control a Ms.Access 2007 database. I am struggling in adding a record to …

database ms-access-2007 vbe
MS Access Form Bound to ADO Disconnected Recordset

I seem to be clueless on this subject. I can attach an ADO recordset to a form, but I am …

vba ms-access-2007 ado recordset
Strip out non-numeric characters in SELECT

In an MS Access 2007 project report, I have the following (redacted) query: SELECT SomeCol FROM SomeTable The problem is, that …

sql regex ms-access ms-access-2007
Placeholder text in an unfilled (empty) text box on an Access form

How can I add "placeholder" text to a Text Box in an Access form? Before the user has typed anything …

ms-access ms-access-2007 ms-access-2010