Using MS Access/Expert Profile


Ask A Question

Expertise

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.

Organizations

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

Education/Credentials

Brooklyn College BA


This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
OB10/31/16101010Thank you.
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/27/16101010 

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

Volunteer


©2016 About.com. All rights reserved.