Help with actions

[xdeimusx]

I have lending library template and I am trying to create a new action.I am unfamiliar how to create action and am in need of a little assistance.
To give an example in this template when you check out a asset it assigns it to a contact. When you check the asset back in it puts it back in your inventory, however, it really never leaves your inventory. Now I am trying to create another button along side of that one if one of my employees installs the asset i want it to put the asset in a different place and take it out of inventory. I assume it goes like this. I have to create a table of the assets information i want transferred and a place to transfer to . create a table for the button to be linked to. create a form for the user to put what job the part was installed on. Click the button wham bam takes the asset out of inventory put it in another table that can be reported later. If this involves writing script for a filter of some sort i would need alot of help on that.

[June7]

Don't recommend this. Instead of yo-yoing records, just toggle a Yes/No field to indicate status. Not understanding why you need this. Doesn't the db already do something to indicate asset availability status?

[xdeimusx]

Kinda. It will tell you the status, who and if it is checked out but never takes it out of the inventory. once the asset has been installed it needs to be transferred to a different table and be completely gone from inventory.

[June7]

Still don't understand. The item is checked out but eventually returns, doesn't it? Even though it is checked out you still must account for the item, right? That means it is still part of your inventory. If all no, then maybe you should look at the Inventory template database.

[xdeimusx]

Say I own a vacuum business and i have 2 employees. Both are taking 1 vacuum out to go door to door ( check out 1 vacuum to each employee.). First employee comes back and did not sell the vacuum ( I check the vacuum back in to my inventory.). Second employee sells the vacuum and dosnt have anything to return. This is where i want to be able to transfer the inventory that was checked out to him to a new place. We will call that the sold table. How do i create a button to remove the vacuum from my inventory to a "sold Table" so at the end of the month i Know what i sold and what i still have. The Inventory DB Wont let me check inventory out to employees.

[June7]

Code to copy/delete records would involve SQL action statements, like:

DoCmd.SetWarnings = False
DoCmd.RunSQL "INSERT INTO tablename ..."
DoCmd.RunSQL "DELETE FROM tablename WHERE ID = " & some input value
DoCmd.SetWarnings = True

The INSERT action could be combined with a SELECT query. Check this tutorial http://www.sqlteam.com/article/using...insert-records.

Alternatively, adapt db to handle this without moving records around. Either Inventory to allow checkout or Library to show status as 'sold' then a child table that would record the ID of sold item, price, date, salesperson, customer.

[xdeimusx]

Not going to lie but I have no idea where to input those values. Do I just ad them to the filter that is associated with that check in/check out process?

[June7]

By 'no idea where to input those values' do you mean the code I show? The code would have to go in an event, such as a button click. I use only VBA, not macros. I just remembered that the template is probably heavy on macro coding. I don't know if the check in/out process would be the best place for this.

Instead of executing an SQL in VBA you could build an Access query object and save it. Then the VBA (I don't know what the macro equivalent would be) code would run the saved query object with: DoCmd.OpenQuery "query name"

You would need to create the 'sold' table that would be the destination for the INSERT action.