Ian Mac
08-10-2004, 11:37 AM
Hello All,
My problem is not to far removed from the other question about this.
I have a Main Employee form:
The user selects a Team, then Person from Comboboxes on the form.
I then have several subforms on a Tab Control.
The pages are historical data about the person, headings are
Hours
Contract End
Contract Type
Team
Grade. etc.
Each 1 is linked to a qry.
My Main Employee table has the following fields:
SysID, GivenName, Surname, EmpID, StartDate, LeavingDate, DOB
All the other 'Main' tables use the SysID for the linked key.
Have a StartDate and EndDate, then the data fields required. And also carry their own uniqueID
I have then set up a simple qry which pulls together a FullName.
The linked qry for each sub form is using all of the fields from the relivent tables + FullName (this is the criteria for the Requery)
When the Person is selected I Requery all the Subforms to display the information.
BTW I am using Continuous Forms. I have removed sysID and FullName from the forms.
----------------------------------------
The problems (or questions)
Like the other question I would like the sysID of the underlying Table to populate automatically from the Name on the sheet. (This stored in a Textbox currently but I will move it to a variable once everything runs correctly)
I can add a record no problem, with all of the details. But, currently there is no way to add the sysID to the table as I have hidden the field option form the Sub Form. Going back to the underlying table has 0000 as the ID, as I would expect as I have not entered this data.
How can acheive this?
-----------------------------------
Second question:
This is a doozy!
How would can I automatically populate the EndDate of the last record for that person (Based on Max StartDate) to be 1 day before the new change?
I would like this to be reflected on the Sub Form straight away for the user to see. I am assuming some Form refreshing will will achieve this but it is beyond my knowledge.
Sorry if that's all a bit long winded.
Thanks for any help.
Ian Mac
My problem is not to far removed from the other question about this.
I have a Main Employee form:
The user selects a Team, then Person from Comboboxes on the form.
I then have several subforms on a Tab Control.
The pages are historical data about the person, headings are
Hours
Contract End
Contract Type
Team
Grade. etc.
Each 1 is linked to a qry.
My Main Employee table has the following fields:
SysID, GivenName, Surname, EmpID, StartDate, LeavingDate, DOB
All the other 'Main' tables use the SysID for the linked key.
Have a StartDate and EndDate, then the data fields required. And also carry their own uniqueID
I have then set up a simple qry which pulls together a FullName.
The linked qry for each sub form is using all of the fields from the relivent tables + FullName (this is the criteria for the Requery)
When the Person is selected I Requery all the Subforms to display the information.
BTW I am using Continuous Forms. I have removed sysID and FullName from the forms.
----------------------------------------
The problems (or questions)
Like the other question I would like the sysID of the underlying Table to populate automatically from the Name on the sheet. (This stored in a Textbox currently but I will move it to a variable once everything runs correctly)
I can add a record no problem, with all of the details. But, currently there is no way to add the sysID to the table as I have hidden the field option form the Sub Form. Going back to the underlying table has 0000 as the ID, as I would expect as I have not entered this data.
How can acheive this?
-----------------------------------
Second question:
This is a doozy!
How would can I automatically populate the EndDate of the last record for that person (Based on Max StartDate) to be 1 day before the new change?
I would like this to be reflected on the Sub Form straight away for the user to see. I am assuming some Form refreshing will will achieve this but it is beyond my knowledge.
Sorry if that's all a bit long winded.
Thanks for any help.
Ian Mac