troubleshooting Question

Tracking Depreciation with Access

Avatar of BBlu
BBluFlag for United States of America asked on
Microsoft Access
10 Comments2 Solutions757 ViewsLast Modified:
I recently asked for help in finding a database template for tracking the depreciation of assets
(https://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_25519267.html#a28579100)

This one from Microsoft:
http://office.microsoft.com/en-us/templates/TC010184591033.aspx?CategoryID=CT101426031033&av=ZAC000)

seems to be pretty good, but it appears that I'd have to enter each month's depreciation amount for any new asset I add.   The depreciation table has 3 fields (besides the unique ID): Asset ID, Depreciation Date, and Depreciation Amt.  Unless I'm reading it wrong, if I were to add a new asset that had a 1-year depreciation life and was worth $1200, I'd have to create 12 entries depreciating $100.  Is there some VBA script that I can write that will add the records automatically?  Something like a for loop that adds (12*depreciation years) records?

ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros