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
|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 .....|
|OB||10/17/16||10||10||10||Thank you very much!|
|Oleg||09/13/16||10||10||10||Works great! Thank you so much!|
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
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
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
Answers by Expert: