Hi all. Quick question. I just set up my first updatable form in an Access ADP! I created an updatable form for a warehouse that receives shipments. The underlying View I created which allows users to enter or change the date a shipment arrives[PlaceDate] is coded as follows:
SELECT PlaceDate, Car#, PO#, NoticeID, What, [Listed Gross Tons], [From], [Where To], Status, [Date Notice Received]
FROM dbo.RM_Notices
WHERE ([Complete?] <> 1)
ORDER BY Car#
I have a form which presents the fields from the view. The only field which users can edit is [PlaceDate]. It works great.
The thing is..I want to make it a little easier for the users. Multiple shipment receipts are often received at the same time. I would like to add a feature where I put a textbox at the top of the form in which users can enter a date, put an ‘X’ or some type of tick mark by the records they want to update and click a button to update the selected records. I am pretty sure setting this up is possible. Can someone point me in the right direction?
SELECT PlaceDate, Car#, PO#, NoticeID, What, [Listed Gross Tons], [From], [Where To], Status, [Date Notice Received]
FROM dbo.RM_Notices
WHERE ([Complete?] <> 1)
ORDER BY Car#
I have a form which presents the fields from the view. The only field which users can edit is [PlaceDate]. It works great.
The thing is..I want to make it a little easier for the users. Multiple shipment receipts are often received at the same time. I would like to add a feature where I put a textbox at the top of the form in which users can enter a date, put an ‘X’ or some type of tick mark by the records they want to update and click a button to update the selected records. I am pretty sure setting this up is possible. Can someone point me in the right direction?
