Hi
for example, I have in Access a record with field names 'ID' 'Section' and 'frequency'
The ID is 001
The Section is Human Resources
The frequency is quarterly
How do I?
i) As the section is Human Resources - when I click a button it opens the excel document called 'Human_action_points.xls'
ii) create a new worksheet called Human_001 (i.e. the section + ID)
iii) copy the recordset values to the newly created worksheet
iv) as the frequency is quarterly - select the already created worksheet 'quarterly' - and copy the table that is there and paste it onto out newly created worksheet
iv) not allow the user to skip through other worksheets
v) after saving, anytime the user opens access and they click the 'button' on record 001 it opens the exact worksheet Human_001
I know its alot, but any help much appreciated
Thanks
for example, I have in Access a record with field names 'ID' 'Section' and 'frequency'
The ID is 001
The Section is Human Resources
The frequency is quarterly
How do I?
i) As the section is Human Resources - when I click a button it opens the excel document called 'Human_action_points.xls'
ii) create a new worksheet called Human_001 (i.e. the section + ID)
iii) copy the recordset values to the newly created worksheet
iv) as the frequency is quarterly - select the already created worksheet 'quarterly' - and copy the table that is there and paste it onto out newly created worksheet
iv) not allow the user to skip through other worksheets
v) after saving, anytime the user opens access and they click the 'button' on record 001 it opens the exact worksheet Human_001
I know its alot, but any help much appreciated
Thanks