Hi,
I’m pretty much a beginner in Access and am running into a few problems with my database.
I have a form (frmAssets) that gets it information from a table (tblAssets). The form displays some info in relation to asset tracking, (who, what, where and when type of info) – I trying to adjust a MS template. I have some trouble with recording the dates the assets are out of the office. I created a junction table (tblLendingRecord) in which I want to record the history of the assets in terms of who had them and for how long (and a few other bits of info).
I created a button in frmAssets “Change Owner”. I want its function to be to populate tblAsset with the form’s information and at the same time populate tblLendingRecord. Ie, tblAsset will only have the current info and tblLendingRecord will have the history of the asset as well.
I have attached the sample which will explain it probably better.
Can anyone assist?
I’m pretty much a beginner in Access and am running into a few problems with my database.
I have a form (frmAssets) that gets it information from a table (tblAssets). The form displays some info in relation to asset tracking, (who, what, where and when type of info) – I trying to adjust a MS template. I have some trouble with recording the dates the assets are out of the office. I created a junction table (tblLendingRecord) in which I want to record the history of the assets in terms of who had them and for how long (and a few other bits of info).
I created a button in frmAssets “Change Owner”. I want its function to be to populate tblAsset with the form’s information and at the same time populate tblLendingRecord. Ie, tblAsset will only have the current info and tblLendingRecord will have the history of the asset as well.
I have attached the sample which will explain it probably better.
Can anyone assist?
