You are here:

Using MS Access/Experts

ExpertAverage RatingsExpertise

Sayedaziz

India
Available
database designing,event driven programming,capturing/updating data programmitically using ms access 2000 and ms access 2002

Bob Heifler

U.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 Rost

U.S.
Available
I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.

Scottgem

Available
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Manish Batola

India
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.

Recent Answers

2009-11-20 MS Access AutoNumber feature:

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

2009-11-20 How to connect a text field to combo box:

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

2009-11-20 To calculate gross,Net salary for an employee in Access:

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

2009-11-19 ACCESS - modify date:

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

2009-11-19 Search mode??:

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

All Answers

Answers by Expert:


Ask Experts

Volunteer


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