Modify 'Assigned To' field

[twoj]

Hi,

I have several items that are assigned to specific entries; ie Assigned To: House1 , Assigned To: House2

and I would like to change the entry from House1 to HouseX, is there an easy way to do this?

I believe the database is an Access db, I'm fine if i can do this in Access? not sure if the tables are open for modification?

I prefer to do this in the gui but i don't want to go through hundreds of items to do the long method of changing each item.

thanks

 

[twoj]

Used Microsoft Access to open the Assets.mdb database; go to the Assets table, go to the PresentLocation column (next to 'Amount Paid' column), Sort the PresentLocation, A-Z, scroll down to the entries of the ones you want to modify.

Modify one entry and copy it to the others, save the database.

As always, make a backup of the database before any modifications.

Hope this helps anyone else in the same boat.

 

[admin]

we will have to add this to the Properties window for changing values in multiple assets.  It should not be too hard we will try to get it done in the next few weeks for an update.