You are here:

Databases

Recent Answers

2016-09-13 Using MS Access - Pass value from main form to subform:

Hi Oleg,    Many thanks for the question.    To do what you ask you will need to write a bit of code.  I am not sure of your level of expertise in VBA so I will step you through it.      You also have

2016-09-13 Using MS Access - Form property DataEntery=Yes prevents fields be filled out automatically:

Hi Oleg,  When you set a property such as dataEntry = Yes, it will open the form with blank fields for data entry. Under this circumstance if you want some fields to be filled out automatically then you

2016-09-13 Using MS Access - 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 Using MS Access - 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

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

OK, I'm a bit confused here. You should have a table of customers. You should NOT always be entering a new customer. It sounds to me like your main form should be an Orders table with CustomerID a foreign

Categories

Browse Alphabetically

©2016 About.com. All rights reserved.