Search results

Hi, I want to create a simple employee leave tracker that will keep a balance of the amount of vacation days entitled for each person. There are 6 fields: 1. Leave Description 2. Reason - this is a selectable list with the values 'worked','leave','sickness'. 3. Date from 4. Date to 5. Days...

I would like to add that by creating a table from the EmployeeKnowledgeSharing table using the primary and two foreign keys, I can add more than one employee to more than one record. However, I would like ot see the detail of each record in a subform or in the detailed section of the form. When...

HI HiTechCoach Well, I've tried just about every combination I can think of following your advice but still cannot get the database to present the data in the way I like. This includes using subforms, linked forms, forms created with the wizard etc etc. The core problem is that when I have...

HI I managed to make it work but have encountered another problem. Some tables are already populated with data, running into hundreds of records. When I try to link the employee profile to the related record through a form (relationships are working fine), it will let me add new records but...

The qualificationsID is where I created the combo box, not under Emloyee ID.

Hi Boyd If I understood you corrctly, isn't that what I've done in the relationships? Please check the relationships.png. Or is it incorrect?

Hi I followed your recommendations and think this is working...to some extent but not sure it is working 100%. The problem I encounter now is the following. On the form, I can enter new employee profiles etc and it registers in the fields. However, when I close and re-open the contact...

Hi I have a problem with setting up relationships to enable me to view information in subforms. I followed the Help in MS Access, 'Create a form that contains a subform (a one-to-many form)' but I cannot get it to work, even though the what I am trying to do is exactly the same as in the...

Any resolution to this problem as I have the same one?

Hi I'm a beginner with access so please bear with me. I created a tab form and for each tab dragged the fields from the tables already created into each tabbed form, e.g. first tab is 'contact details' with various fields, second tab is 'inventory' with numerous fields etc. I created the...