Ok I want to run a SQL query while using the event procedure VB in MS Access.What I'm doing is trying to select a room of a building.So the form goes : Building (and they pick say Smith Hall) then ...

I was trying to write a conditional query in MS Access today, without success. Here's the problem.I have a field (myField) that is a lookup to a table (myTable) in the query. myField stores the ...

How to: MS SQL to MS Access. Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats.

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.

How to Make Tiered Drop-Down Lists in Access. A drop-down list in Access 2013 offers a list of values to aid in data entry in tables or forms. Although you can allow users to manually enter values ...

Programs written in Visual Basic 6.0 can access Microsoft Access 2003 databases. Knowledge of programming elements, such as functions and loops, and knowledge of databases and SQL is required to write ...

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.