You are here:
| Expert | Average Ratings | Expertise |
|---|---|---|
SayedazizIndia
Available
|
database designing,event driven programming,capturing/updating data programmitically using ms access 2000 and ms access 2002 | |
Bob HeiflerU.S.
Available
|
ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING
QUESTIONS Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here. |
|
Richard RostU.S.
Available
|
![]() |
|
ScottgemAvailable
|
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design. | |
Manish BatolaIndia
On Vacation
returns 11/30/2009 |
ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions and many more being added every year. |
If I follow you, you have two tables in one to many relationship. What's not clear is which is the one and which is the many. But these tables should NOT have the same primary key. They should both have
I would not use a combo in this case. I would use either an Option Group or a Check box. But the process is the same no matter what control you use. In the After Uodate event of the Status control
Depends on the structure of your database. The proper structure would be using three tables like this: tblPayroll PayrollID (Primary Key Autonumber) EmployeeID (Foreign Key PayDate PayPeriodStart
Users should NEVER interact directly with tables. All interaction with the data should be done through forms. You have very limited control when data is entered into tables. There are no events to trigger
Well first you really shouldn't be entering data directly into tables. You should be using forms. But frankly, I'm not clear what's happening here. Ma7 VBAybe a screen shot might help. Another possibility
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.