In reference to the Lending Library Template

**orange** · 08-18-2015, 10:34 AM

Ufriendly,

Yes it would be a query. I don't use macros, so can offer little on that.
In many inventory databases, there is a transaction file to record things like StockAdded to Inventory, Stock/Items sold to Customers along with TransactionDate, Quantity, AgreedToPrice...

Here is a thread dealing with Inventory. There is a sample database included in post #12, but the dialog/exchange in the thread may help. It shows you some interaction (confusion/clarification/options...)

Let us know how you progress.

Also: How exactly did you record your video? --well done.

**Ufriendly** · 08-18-2015, 11:12 AM

I looked at link. It helped a lot. Still the calculation you gave me above, should I setup a query and run it on whatever Item I want to know the balance available on? Also your answer seems to not fit a lending library template but a stock control sneered. If that is true, should I not use the lending, and use another type template??

**Ufriendly** · 08-18-2015, 11:14 AM

I used camtasia to record video. adobe now has a product that does similar if you happen to have adobe CC subscription. Haven't tried it yet. No time to learn plus Camtasia is the leader in this area at least for now.

**June7** · 08-18-2015, 11:24 AM

If you switch to an inventory control template, might still have to modify for your check in/out functionality. I see two aspects of your inventory management:

1. stock is received and sometimes disposed of (due to damage, theft, loss, sale, donate)

2. stock is checked out for temporary use and returned for reissue

Might be able to treat them all as transactions in one table. The added complexity may be you want to be able to track the 'checked out' items to who currently has possession and generate report based on just the check in/out transactions.

**Ufriendly** · 08-18-2015, 11:27 AM

Great thanks!! I'll look. Think you sent before I sent last msg. Disregard.

**Ufriendly** · 08-18-2015, 11:30 AM

True and that tracking is built into lending. Thats why I want to use it. Seems a lot more work recreating that in stock then fig out on hand balance in lending. I'll try to get lending to work with the info here and get back to the group. Hell it may be easier to just go to location and count bal on hand. Lol.

**orange** · 08-18-2015, 11:34 AM

Ufriendly,

My comments were for Inventory in general. I was not addressing any template per se.
I think June is more familiar with the templates and I know she knows Inventory. I was making general statement and did not mean to redirect your basic approach.

Thanks for the info on your video. I don't have Camtasia, although I recognize it. I would prefer a free product or reduced options product. It's more for tinkering than anything productive.

**Ufriendly** · 08-18-2015, 02:03 PM

Looks like you can use Adobe activate free for 30 days if that helps. http://thankyou.adobe.com/en/na/prod...150818200139:s

**Ufriendly** · 08-30-2015, 09:50 AM

I put a form that has a comment field in it, on a navigation form. Now when I add a comment it doesn't add it to the comment history. Should that functionality move with the form to the nav form??

**June7** · 08-30-2015, 10:20 AM

Don't know. Never relied on comment history and don't use navigation form - don't like it.

The field worked before? Try opening the form independently and test that field again. If that works then I guess you have an answer to your question.

**Ufriendly** · 08-30-2015, 11:37 AM

It is working. But you have to click next to go to the next item record and then click back to the one you were on to see the change. Maybe adding an add comment button on that form would work? Any ideas on how I would do that. I've attached form with the comment form second. Is that an sub-form? What would you do instead of a Nav form?