My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() Post#1 | |
Posts: 37 Joined: 27-November 17 ![]() | Hello does anyone know of a template in Access or Excel for production and inventory that I can start with and modify as needed? Thanks very much for any help or suggestions. |
![]() Post#2 | |
![]() UtterAccess Editor Posts: 18,253 Joined: 29-March 05 From: Wisconsin ![]() | Johnny, Please keep in mind that inventory control is one of the most complex things you can try to handle with Access - it's very much an expert-level thing to create. It would likely be more cost effective to seek out ready-to-use software rather than trying to roll your own. Having said that, you might want to read this article on Allen Browne's website that discusses how to handle stock takes and tracking inventory. Hope this helps, Dennis -------------------- (;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it. Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier. Guidelines for Posting Questions |
![]() Post#3 | |
Posts: 37 Joined: 27-November 17 ![]() | Thank you Dennis I am willing to give it a go. I have the time and want to learn. I will check out your suggestion thanks again. |
![]() Post#4 | |
![]() UA Admin Posts: 32,357 Joined: 20-June 02 From: Newcastle, WA ![]() | You can also get some ideas, I believe, from the classic Northwind database which has an inventory component, among others. My version has some modifications such as a revised naming convention. -------------------- My Name Is George and I believe in Karma How to Ask a Good Question Beginning SQL Server Visit My Blog on Facebook |
![]() Post#5 | |
Posts: 37 Joined: 27-November 17 ![]() | Would it be too much trouble to show what you mean with the modifications please? Thank you so much for helping me |
![]() Post#6 | |
![]() UA Admin Posts: 32,357 Joined: 20-June 02 From: Newcastle, WA ![]() | I explained them on the page where the download is available. -------------------- My Name Is George and I believe in Karma How to Ask a Good Question Beginning SQL Server Visit My Blog on Facebook |
![]() Post#7 | |
Posts: 37 Joined: 27-November 17 ![]() | Can you please provide the link? I haven't been able to find it yet. Thank you George PS Sorry I found the link thanks for the suggestions This post has been edited by johnnyenglish775: Dec 19 2017, 02:37 PM |
![]() Post#8 | |
![]() UA Admin Posts: 32,357 Joined: 20-June 02 From: Newcastle, WA ![]() | No problem. Good luck with the rest of your project. -------------------- My Name Is George and I believe in Karma How to Ask a Good Question Beginning SQL Server Visit My Blog on Facebook |
![]() Post#9 | |
![]() UtterAccess VIP Posts: 18,996 Joined: 29-September 03 From: Oklahoma City, Oklahoma ![]() | QUOTE Can you please provide the link? I haven't been able to find it yet. go to: http://www.gpcdata.com/Downloads.aspx Scroll down to "GPC's Customized Northwind Sample Database " and click on it underlined text. -------------------- Boyd Trimmell aka Hi Tech Coach ( HiTechCoach.com free Access stuff) Microsoft MVP 2010-2015 - Access Expert Inventory Control, Accounting, BPM, and CRM Software Developer "If technology doesn't work for people, then it doesn't work." |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 19th April 2018 - 10:24 PM |