In the Microsoft Access Asset Management Seminar, Part 1 you will learn how to build a database to manage your assets. You will learn how to create grouped assets (with unlimited grouping levels), track locations, owners, values, and keep a complete log of changes to the asset's history.

Did you ever complete Asset Management Part 2? I have ordered Part 1 and would like to see what you have developed in Part 2. I am interested in the Bar Codes (especially how to enter bar codes already used), I am also interested in the tracking changes (how to display name or serial number, not just the item numbers 9 to 4). I would also like to see how to list items in a particular location in a report style (I have 100's or even 1,000's of pieces I track and would like to list all of these items in 1 report for inventory purposes, plus add bar codes to this list).

Hi Alex, yes, exactly. It would be great to have a log where an asset is loaned out to an entity and you have a loan record where the from and to date are completed with the to field completed when they return the asset.

I'm in agreement with all the elements you say you're looking at introducing but as with some other comments, I'd like to track signing out equipment to individuals in a 'temporary loan' subform/table. Also, I'd like to be able to tackle the servicing of assets and keeping servicing records.

Thanks! Hope Part 2 is coming soon!

Reply from Alex Hedley:

Great ideas.Would you have a loan from and to date and set the to when they return?

Any ideas of timing for the second seminar? Seems like Rich is pretty busy lately and new courses are coming out pretty slowly....

Reply from Alex Hedley:

I think Rich wants to finish the Macros for Advanced and release a few Beginner 2016 courses for Excel/Word etc.He does enjoy Access Seminars the most so hopefully will throw one in between. It's a bit out of date but worth checking the Updated Production Schedule

Any progress with Asset Part2? I also have an asset DB that I want to use to sign out expensive equipment on a weekly basis to complete jobs and then sign back in after mission completion so I know what is and what is not available for my tech folks? Thanks, your classes are great and really could use this.

In part 2, I would like to see a query where you enter a bunch of parentIDs (such as a field of multiple barcode scans comma delimited) and it spits out a report of all the assets that are included in them. I can't quite figure out how to parse it into an OR statement that works.

Reply from Alex Hedley:

You could do this in VBA.You have the Field name, use SplitSplit ( expression [,delimiter] [,limit] [,compare] )Then you could build a dynamic IN ('x', 'y') statement looping your above arrayAdd this to your SQL statement and set that as the Record Source of your Form, that's covered in the SQL Seminars.

When do you expect to have Part 2 finished? I have an asset database I have been setting up where I am trying to track which asset is signed out to which employee. Each employee can and does have multiple assets assigned to them. As new employees are hired it would be nice to be able to add the new employee on the fly without to much trouble for the end user.

Reply from Alex Hedley:

I know he's working on the a couple of Expert lessons first to cover Macros etc.

Rich,Very anxious for the second installment. I want to use this method to keep track of both supplies and equipment on several ambulances and stock room, tie it to mandatory maintenance and check lists for all the medical equiipment we have, and automate the purchase order process in my inventory module. Can you give me any idea of timeing? Thanks.

Alex, I wouldn't hold your breath. I was also waiting. This is long overdue (as was Part 1) with no communication about the status. I wound up finishing it myself (by many internet searches) and I've now got a very good and feature rich asset management database. And I know quite a bit more about Access now. Sorry you have been waiting so long as well. I'd be happy to share any info I can if possible.

Reply from Alex Hedley:

Thanks Gene, any ideas or problems you came across and fixed would help others when making theirs.

Will your seminar cover the different depreciation methods. This would be helpful and I believe essential for proper asset management. It shows on the balance sheet as a contra asset account called Accumulated Depreciation.

The bar code idea is a good one to keep. If your using a sheet of labels like say, Avery 8160, it would be nice to know which position you might need to print 1 or more labels at. I hope that makes sense. I really would prefer to see a complete seminar on the bar code generation and printing myself.As for the 'Move a group'; this would be nice. We build kits and some of our kits have serialized items and sometimes we have to "Un-Build" the kit and move the items either back to stock or to another type of kit. This seminar is working very well with the 'Inventory' seminar I have been requesting for several years now. I am able to do my inventory with 'BOM's' now with this Asset seminar.All I'm missing now is the quantity used in the BOM based on it's unit of measure as to how much the kit(s) cost is.

Sometimes an asset may have more than one line item, either serialized or not. ie: 4 sticks of RAM in a PC; multiple video cards; etc. So; we might consider if the items are NOT serialized the show the line item once with a quantity of 4. If the item IS serialized, then show either 4 different line items with the serial number; OR have a link to open a form that will show the 4 serial numbered items related to that pc.

I have Assets which is software which cost a lot more than hardware. Would you just add it the Sub/Child parts?I would like to see also to track where my Office and windows product keys have gone. But I need them match on the order/code they came in onThank the seminar is great

Jim Upton

Reply from Alex Hedley:

I've not finished the course yet but I would think cost is irrelevant you would treat it as a Entity like everything else.

You could create a relationship between order and keys, just have it as another sub form

If you just want to
subscribe to get email updates when
the News
is updated, then
enter your name and email address and check the Notify Me box
below. If you would optionally like
to add your comments below to be posted, they are welcome.

Your Name:

Required

Your Email:

NOT Public

Subject:

Comments:

Sorry about this step. It's just to keep the spam bots away:

Verify:

What is 2+8:

Notify me when the News is updated.

Remember Me for my next comments

Please do not use this form for
Customer Service inquiries! If you have questions about your
account, shipping info, courses you've ordered, need passwords, etc.
please use the Customer Service Center instead.

I value your comments. They will be
displayed on this page (above). Your name will
be displayed, but your email address will not be. As
always, I promise to never give away your personal information to
anyone else, ever.

NOTE:
If you don't leave your name and email address, DON'T
expect a reply. I can't promise a personal reply to everyone who posts
here. I TRY my best, but I cannot guarantee it. If you don't
leave your real name and email address, I won't even bother. I usually
just hit DELETE. -Richard