Using MS Access/Expert Profile

Ask A Question


I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience in the area

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.


Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing


Brooklyn College BA

This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
MC12/22/16101010Scott, thanks for the info. I kind .....
John12/09/16101010Very helpful. Thanks Scott
OB10/31/16101010Thank you.
OB10/19/16101010You are right. I have changed the .....
Sam10/17/16101010Thanks, that helped a lot, the problem .....

Recent Answers from Scottgem

2017-01-03 Cascading combo box with UNMATCHED data:

Create an unmatched query using the wizard. Modify the SQL for that query so it is filtered for the current employee. In your combobox set the RowSource of the Locations Combo to something like:    SELECT

2016-12-05 database design:

Sorry, I missed this.     What it sounds like you want is a standard technique called Synchronized or Cascading comboboxes. This is a technique where you filter a combobox list based on a selection in

2016-10-17 MS Access Linked Tables:

There are a couple of ways to link to tables in an external SQL database. The most common way is to create a ODBC Data Set Name (DSN). This is done using the ODBC Administrator.     You need to be careful

2016-10-14 Combo box:

Correct, Access does not know whether a field should be using a list control or not. The only data type that automatically uses a specific control type is a Yes/No data type which uses a check box. You

2016-10-11 Dynamically updateing a combo box from a choice in another combo box using separate tables.:

Sorry for the delay. I missed seeing this question earlier,    I'm surprised you haven't found the information as this is a standard technique called cascading or synchronized comboboxes. If you search


Ask A Question

Using MS Access

All Answers

Answers by Expert:

Ask Experts


©2017 All rights reserved.