I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
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
|MC||12/22/16||10||10||10||Scott, thanks for the info. I kind .....|
|John||12/09/16||10||10||10||Very helpful. Thanks Scott|
|OB||10/19/16||10||10||10||You are right. I have changed the .....|
|Sam||10/17/16||10||10||10||Thanks, that helped a lot, the problem .....|
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
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
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
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
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
Answers by Expert: