Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

Importing and Exporting Data

That is the scenario that you are supposedly facing. You can tackle the last problem first. First of all, your entire solution can be handled with one form. To query another database, consider the IN clause that you can either run from a RunSQL action or directly as a row source. Here is a typical SQL statement:

SELECT * from Customers; 

To make the query run from another database, you simply add the IN clause with the database and path in quotes:

SELECT * from Customers IN "C:\AccessByExample\Northwind.mdb" 

The following is another syntax that produces the same results:

SELECT * from [C:\AccessByExample\Northwind.mdb].Customers 

Applying this to the subject at hand, the following SQL string is the row source ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book