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
OB10/19/16101010You are right. I have changed the .....
Sam10/17/16101010Thanks, that helped a lot, the problem .....
OB10/17/16101010Thank you very much!
Oleg09/13/16101010Works great! Thank you so much!

Recent Answers from Scottgem

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

2016-09-13 Combo does not work in form property Data Entry = Yes:

OK, So you use a similar solution to the one I gave you for the date. The main point here is that you are creating redundant data but adding the same records for a customer all the time. This is poor design

2016-09-13 Combo does not work in form property Data Entry = Yes:

Do you have a Customer's table? Assuming that you do I would do this differently. I would enter data directly into the Transactions table. The only thing you need is a CustomerID foreign key in the Transactions


Ask A Question

Using MS Access

All Answers

Answers by Expert:

Ask Experts


©2016 All rights reserved.