A small (open source) Inventory Control application using Ms Access.

[Avelino Sampaio]

Hi

I'm finally releasing the inventory control project, so you can start your inventory control.

When unzipping, just run the SysInventory_v_1.accdb file to load the application. Create a shortcut of this file on your desktop, for easy access.

Remembering that you first have to inform MS Access, that your folder is a "trusted location". This task is very simple, just follow the video offered.

[Zero999]

Zero999

Thanks for the tip.

Image 1 and Image 2: My components are stored in drawers, pots, cases, boxes, ....

Image 3: I have many used parts. Sorting, storing and registering is a very boring task. How to have control of it all, without the help of an application?

Tell me how you handle this issue. What program do you use? What method do you use? How has this bothered you?

I haven't had this problem. At home, I organise my components in a some boxes and manually keep an eye on stock levels. At work, we have a system which works in a similar manner and we have a proper store.

[ak]

Just read about your program for keeping track of your parts. Some months ago we wrote a similar one at work. If anybody is interested:

https://github.com/ArnePhotonics/EpartStocker

[Avelino Sampaio]

Hi

I am available to answer any questions. I also accept suggestions for possible improvements. If you wish, you can communicate in private.

[Avelino Sampaio]

Hi

It has been very useful to save images with small example circuits. See the examples of Tl431 and TP4056.

[Avelino Sampaio]

Hi!

Now I will carry out the inventory issue and have the final report of the project cost.

[Avelino Sampaio]

Hi

Zero999

Eu não tive esse problema. Em casa, organizo meus componentes em algumas caixas e fico de olho nos níveis de estoque manualmente. No trabalho, temos um sistema que funciona de forma semelhante e temos um armazém adequado.

Anyone else would like to express themselves, how do you handle your stock? Are you using an Excel spreadsheet?

[JARS]

“Avelino, I put one more continuous form in the application, where in each line of the registered item the component's photo appears, and when clicking on this image it appears in a larger size.

A good feature would be to register a device with your brand and model and a way to find the electrical schematic of that device if you have already downloaded this schematic.”

[Avelino Sampaio]

Hi

Image 1: Surpassing 1300 registered items.
Image 2: Starting to acquire SMD items.
Image 3: Latest purchases at LCSC.

[wizard69]

Renate

I chose Ms Access because it is part of the MS Office package. I think most people here subscribe to the MS Office package. Another problem that weighed heavily on my decision was that the user didn't need to install anything. I think this brings more security, for the user who wants to try the offered application.

Actually no, we don't all use MS Office.    I'm late to this thread but I think it is worth pointing out that MS Access isn't a universal solution.    I do like the idea of an open source inventory application though.   The thought of instant access to transistor parameters is a good idea too but that isn't core inventory control.

[coromonadalix]

Open Office
Libre Office
FreeOffice

[Avelino Sampaio]

Ok, ok, ok, it's already clear to me that using MS Access makes it impossible for many to use the application. However, I have neither the intention nor the knowledge of migrating the application to another platform. Anyone who has the experience and wants to migrate the application to a more universal platform, can offer this alternative here.

Wizard69, the application offered was designed to meet the demand of a DIY, without any ambition beyond that.

[Avelino Sampaio]

Hi

Passing by to celebrate 100 downloads of the app. A victory, considering the degree of rejection for having used the MS ACEESS platform.

[PKTKS]

Reason being is not REJECTION  by itself..

The MS thing is:
unportable
A resource hog pig
100% incompatible w others
Paid and overpriced licenses
Highly likely to be non functional next upg

..  so just consider porting the db to sqlite and at least 30 interfaces better are available

Paul

[PKTKS]

Let me enhance the suggestion by placing my own shelf very small inventory controller applet done by simple using SQLITE in which is possible to interface with dozen apps..

From VB.. anyone can just jump to DELPHI or better ...
the modern replacement LAZARUS. http://lazarus-ide.org/

But not even all those funky things are needed... a simple PASCAL of dozen lines can do the trick..
If needed FPC can handle curses or newt interfaces..

Just about plain simple things...

Code: [Select]

Program MaSemicon;
Uses sqlite3, sqlite3db, strings, classes;
var
i, j     : Integer;
SQL,nmat : String;
mysql3   : TSQLite;
reslt    : TStringList;
begin
mysql3 := TSQLite.Create('tabcomp.db');
mysql3.BusyTimeout := 1000;

SQL := 'SELECT DISTINCT * FROM tabcomp WHERE comp_CLASS LIKE "Regulator" ORDER BY comp_LABEL,comp_QTD;';
mysql3.Query(sql, nil);

str(mysql3.List_Field.count, nmat);
Writeln('Total_Matches: ' + nmat);
for i:=0 to mysql3.List_Field.count-1 do
begin
reslt := TStringList( mysql3.List_Field.items[i] );
for j:=1 to reslt.count-2 do
write(reslt.Strings[j],' ');
writeln('');
end;
mysql3.Free;
end.

My own query results attached for such amazing simple trick...
Paul

[coromonadalix]

thks for this  inventory program 

is it possible to add    say:     an % of stock left warning and or give some warning the stock / inventory will de depleted  ??  EX: if you added in stock 100 diodes (1n4007) and you consumed almost all of them ??

[Avelino Sampaio]

PKTKS,

I've been working with MSAccess (VBA) for over 20 years and I don't want to extend the debate of the platform used. Some people happily pay $15.00 for an LM399 while I'm super happy to pay $30.00 for an annual MS Office license. It all comes down to what each individual considers as VALUE. To you it's GARBAGE to me it's GOLD.

[Avelino Sampaio]

Coromonadalix,

The warning is visual only (red text). See "reply #23" if it serves the purpose.

[PKTKS]

PKTKS,

I've been working with MSAcess (VBA) for over 20 years and I don't want to extend the debate of the platform used. Some people happily pay $15.00 for an LM399 while I'm super happy to pay $30.00 for an annual MS Office license. It all comes down to what each individual considers as VALUE. To you it's GARBAGE to me it's GOLD.

Don't get me wrong..  I have very extensively used that on early 90s..
Until complete ditching all MS over 2000s.

As said.. the overall result is restricted by not being portable
and locked out for other interfaces... like simple console querys...

It would be a simple jump DELPHI... but MS imploded Borland..
LAZARUS replaced VB with 200% improvements...

It should be a more or less simple jump from VB to LAZARUS..
while the whole DB ported to SQLITE is actually 300% faster and about 1000% lighter in system resources...  because SQLITE does not use a daemon ...

nor any sort of REGISTRY LOCKED access..

Just a tip to improve the user base..
not depreciate your valuable effort..

Take advantage of the work and use it on a better jump...
The time consumed should worth it

Paul 

PS> just adding that LAZARUS (and ObjectOriented Pascal) already have integrated by default at least all these DBs  ready to interface..

https://wiki.freepascal.org/Components_and_Code_examples#Databases

SQLITE or Postgres will outperform ACCESS by orders of magnitude in time.. resources and capabilities  not to mention prtability
 

[coromonadalix]

Coromonadalix,

The warning is visual only (red text). See "reply #23" if it serves the purpose.

Thks   Missed that detail   

[Avelino Sampaio]

Hello,

I'm back with an update.

4- I already have more than 1450 items registered.
1- This month I completed my goal in investing in opamps. Close to $250.
2- I registered some of the main features of each opamp. When viewing the print, it helps me compare them and choose.
3- Now to get rid of some scrap, extracting some of its components. Very boring task to register all this in the program but it has been very rewarding to find the components quickly.

Remembering that application is available for download on replay#25

[Avelino Sampaio]

Many components of these scrap boards I end up throwing in the trash, due to lack of skills in extraction techniques. I believe that will change for me after I found this channel below.

https://www.youtube.com/@mrsolderfix3996/videos