Top "Ms-access-2007" questions

Microsoft Access 2007 - a rapid database application development tool

VBA: Why must I set focus to control every time?

I am creating a personal Library Inventory system using an Access 2007 database. In code, whenever I reference the .Text property …

ms-access properties ms-access-2007 vba
Is it possible to use subquery in join condition in Access?

In postgresql I can use subquery in join condition SELECT * FROM table1 LEFT JOIN table2 ON table1.id1 = (SELECT id2 …

sql ms-access join ms-access-2007 left-join
Can Microsoft Access autocomplete fields?

I'm using Microsoft Access 2007. When I start typing a new record,is there a way to get access to suggest …

ms-access combobox textbox ms-access-2007
Is it possible to change the font in the SQL edit window in Access 2007?

It would be nice if there was a right-mouse-click menu on the edit panel to change the font size, but …

ms-access ms-access-2007
linked table read only

I have an access 2003 (mdb) database on housing projects I update for our local planning office on a quarterly basis. …

ms-access permissions ms-access-2007 linked-tables
ADODB.Fields error '800a0cc1' Item cannot be found in the collection

I need to create a select box with query data from my Database by using the query technique that I've …

sql asp-classic ms-access-2007
default value for switch in access 2007

I am using switch statement in access 2007, i want to know how I can specify default value select switch ( MyCol = 1, …

sql ms-access ms-access-2007
How do I correctly use two Not Exists statements in a where clause using Access SQL VBA?

I have 3 Tables: NotHeard,analyzed,analyzed2. In each of these tables I have two columns named UnitID and Address. What …

sql vba ms-access-2007 not-exists
PDO: How to access Microsoft Access file on Linux?

I have managed to read data of Microsoft Access file (.accdb) on Windows using PDO but I'm having problem getting …

php linux pdo odbc ms-access-2007
How to make a passthrough / passthru query editable?

In the Microsoft Access 2007 with an SQL Server Backend, we usually take a linked table from the SQL Server as …

sql-server ms-access ms-access-2007 passthru pass-through