Hello,
I am working in Access 2003 and need some help wrapping my brain around how to make a subform- a date-filtered view of a table- update the table directly from the form. Here is my set-up:
I have a table listing pay amounts and other salary information per pay date per employee. In this table, I have a field called PaidUnpaid. This field contains a P for Paid and N for Not Paid. The flags are assigned via a series of update queries as part of the preparation of the monthly salaries data for use in expense reports. However, the user still has to have the ability to go into the table and make some manual changes to the P/N flag. For that, I have a form in which the user picks a date range from two comboboxes. The user clicks buttons to view reports on people who worked overtime, holidays, etc and which of these entries were paid. If she wants to go in and manually change the pay status of some of these entries, I want her to be able to do it directly from the main form and have the table updated in real time. And I want her to be able to scroll through the table to go to the entry which she wants to change- I do not want her to have to specify criteria through comboboxes and then hit an update button (like, 'update table where name like combobox1.value, date like combobox2.value, etc)- there are simply too many fields to specify, and I think scrolling through the filtered table would be the most efficient way of doing it.
I was thinking of putting a subform on the main form, which would be a datasheet view of the table, filtered by the date range specified in the date comboboxes. The user would change what she needs to change right there and the table would be udpated. But I have no clue how to display a filtered view of a table on a form- everything I read talks about creating a subform via a query of the table, but then how do you make that update the table directly?
I am not looking for anyone to write code for me- I just need some general guidelines on how to implement the filtered datasheet view and direct update set-up. If anyone could point me to a good reading resource on this, I would be really grateful.
Thank you in advance for any help!
I am working in Access 2003 and need some help wrapping my brain around how to make a subform- a date-filtered view of a table- update the table directly from the form. Here is my set-up:
I have a table listing pay amounts and other salary information per pay date per employee. In this table, I have a field called PaidUnpaid. This field contains a P for Paid and N for Not Paid. The flags are assigned via a series of update queries as part of the preparation of the monthly salaries data for use in expense reports. However, the user still has to have the ability to go into the table and make some manual changes to the P/N flag. For that, I have a form in which the user picks a date range from two comboboxes. The user clicks buttons to view reports on people who worked overtime, holidays, etc and which of these entries were paid. If she wants to go in and manually change the pay status of some of these entries, I want her to be able to do it directly from the main form and have the table updated in real time. And I want her to be able to scroll through the table to go to the entry which she wants to change- I do not want her to have to specify criteria through comboboxes and then hit an update button (like, 'update table where name like combobox1.value, date like combobox2.value, etc)- there are simply too many fields to specify, and I think scrolling through the filtered table would be the most efficient way of doing it.
I was thinking of putting a subform on the main form, which would be a datasheet view of the table, filtered by the date range specified in the date comboboxes. The user would change what she needs to change right there and the table would be udpated. But I have no clue how to display a filtered view of a table on a form- everything I read talks about creating a subform via a query of the table, but then how do you make that update the table directly?
I am not looking for anyone to write code for me- I just need some general guidelines on how to implement the filtered datasheet view and direct update set-up. If anyone could point me to a good reading resource on this, I would be really grateful.
Thank you in advance for any help!
