Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Rental Inventory < Record Number | Cond Format Null >
 
Manage Rental Inventory
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   8 months ago

Manage Rental Inventory. Check In/Out Items, Books, Videos, Tools.


 S  M  L  XL  FS  Join Now

Learn how to check out rental inventory items, and automatically return any items to your rental inventory once the due date has passed. 

Graham from South Africa (a Gold Member) asks: I have a very simple inventory requirement. Items are checked out, and then once their due date arrives, I just want Access to automatically check them back into inventory. That's it. Can this be done in a daily event?

Members

We'll make an actual check in / check out system for each item. You can mark which customer checked out the item, the due date, see rental history, and more!

Silver Members and up get access to an Extended Cut of this video. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!

Links

Update Query: https://599cd.com/UpdateQuery
Criteria Query: https://599cd.com/Criteria
Access Developer 23: https://599cd.com/ACD23

Learn More

FREE Access Beginner Level 1
Access Level 2 for $1.00

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates

Resources

Mailing List - Get Emails When New Videos Released!
Consulting - Need Help with Your Database?

Questions?

Please feel free to post your questions or comments below or submit them via the TechHelp page.

 

Track Products Upload Images   Link 
James Hopkins 
44 days ago
Hey, I been working on a Service Based Database that Tracks Product (Chemicals & Fertilizers) Applications and Activities. I have created two Tables for the Chemicals and Fertilizer and their Activities and Applications. I am wondering if I should combined the Tables and Forms together to one. Also, wondering what's the best way to do the "Tracking, Appling, and Showing the Activities of the Products"?
Scott Axton
43 days ago
James the best answer is a definite maybe.  I don't quite understand the terminology you are using - "activities of the products".

I do understand a little bit (I think) if what you're trying to do. One of my former partners had a lawn care service.  The reason I recommended the Work Order Seminar.

With Access you can be as simple or as granular as you need to be.
Thing is I would combine all of your items in to one table that you are selling.
Whether you invoice for 1 Application or 3 hours of labor / application.  The next line item might be 4 lbs 10-10-10 poultry fert. The next might be mowing,  10K sq/ft  Understand?
The products and services can be broken out how ever you need but all the "items" you offer go in your products table whether it's widgets or services.

Then down the line you can go back through, using reports, to show the items you need to track.
You has x hours of labor, used y lbs. of pre-emergent, z gals of ground clear.  And so on.

Scott Axton
43 days ago
Check out the Chef's Kitchen Helper video.   It might help you to think outside the box a bit.
Apply the things you use and do to making a recipe.  

Also look at the {1515} if you haven't already.
Add a Reply
House Rental Upload Images   Link 
Saikou Balde 
6 months ago
Dear Richard,
I have several properties and I need something to help me follow all my tenants as well as knowing anytime what is rented and not rented and getting of each property
following my income and my expenses.
Richard Rost
6 months ago
Sounds like an excellent idea for a Seminar. I've been asked for something like this a couple of times before. I'll definitely add it to the list. Keep learning. You could build something like this easily yourself after, I'd say, Access Expert 2. Finish the Beginner series and after the first couple of Expert classes you'll know enough about relationships to start building something yourself. :)
Add a Reply

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

9/20/2021Letter Writer
9/19/2021Multi Field Combo
9/19/2021Project Management
9/17/2021Overlapping Windows
9/16/2021Inventory
9/10/2021Benefits of Access
9/10/2021Access on a Phone
9/5/2021Prevent Deletion
9/4/2021Booklet Template
9/4/2021Inspections Template
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: TechHelp Access rental management, check out, check in, point of rental, rental software, inventory management, track inventory of rented items, rental database template, rental tracker, rental equipment  PermaLink