You are here:


Recent Answers

2016-10-17 Using MS Access - 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 Using MS Access - 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 Using MS Access - MS Access Linked Tables:

Hi Sam,    Thanks for the question.    I have only had to do this once or twice.  I had no luck with directly linking to the table that accesses the SQL via the OBDC, I had to create an Append query, to

2016-10-11 Using MS Access - 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-22 Using MS Access - Linking main form and subform:

Hi Oleg,    Have you set up Relationships?  Can be found under Database Tools.  If not:    Open the relationships window and drag in your tables. Set them up as I have in the attached pictures.    Note


Browse Alphabetically

©2016 All rights reserved.