In Access 2007 I've used the Asset Management Database template and customized it for a customer.
It has five key tables: Assets, Contacts, Incoming, Outgoing, Transactions. I've made it as simple as I can for the majority of users. Their primary responsibility is when an asset is being delivered to a contact that it is assigned to that contact or when an asset is being returned it is checked in.
The way it works now is when assets are being assigned to a customer a form is opened by selecting a customer. Using a barcode scanner all assets are scanned and entered in the form which is connected to the Outgoing table. When done the employee selects the Process Outgoing button. This runs a macro that updates the status of the asset and its location in the assets table, it appends the transactions table, then deletes the records from the outgoing table.
When an asset is returned the incoming form is opened and the barcodes are scanned in. The process incoming button runs a macro that updates the asset status and location in the assets table, appends the transactions table, and then deletes the records from the incoming table.
The customer would like to have this web based so I'm considering migrating it to Access 2010 and setting it up as a web database on Sharepoint. I know that this is limited to select queries.
The question is how can I accomplish my update, append, and delete queries in a web database? Can it be done through macros? If so how?
The incoming and outgoing append queries appends the barcode, owner, and date fields of the transactions table.
The incoming and outgoing update queries update the assets table, based on the barcode, for the location, date, and owner fields.
It has five key tables: Assets, Contacts, Incoming, Outgoing, Transactions. I've made it as simple as I can for the majority of users. Their primary responsibility is when an asset is being delivered to a contact that it is assigned to that contact or when an asset is being returned it is checked in.
The way it works now is when assets are being assigned to a customer a form is opened by selecting a customer. Using a barcode scanner all assets are scanned and entered in the form which is connected to the Outgoing table. When done the employee selects the Process Outgoing button. This runs a macro that updates the status of the asset and its location in the assets table, it appends the transactions table, then deletes the records from the outgoing table.
When an asset is returned the incoming form is opened and the barcodes are scanned in. The process incoming button runs a macro that updates the asset status and location in the assets table, appends the transactions table, and then deletes the records from the incoming table.
The customer would like to have this web based so I'm considering migrating it to Access 2010 and setting it up as a web database on Sharepoint. I know that this is limited to select queries.
The question is how can I accomplish my update, append, and delete queries in a web database? Can it be done through macros? If so how?
The incoming and outgoing append queries appends the barcode, owner, and date fields of the transactions table.
The incoming and outgoing update queries update the assets table, based on the barcode, for the location, date, and owner fields.