Aaron's Homepage Forum
Aaron's Homepage Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Miscellaneous
 Lounge
 inventory program
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ecm
Apprentice

Canada
89 Posts

Posted - Oct 27 2003 :  6:34:55 PM  Show Profile  Visit ecm's Homepage  Reply with Quote
Hi Im Looking for a program to keep inventory of my electronic parts or any ideas. looking for input here or what you do for your parts inventory.

to do or not to do

Nerf Smurf
Mad Scientist

USA
390 Posts

Posted - Oct 27 2003 :  10:55:17 PM  Show Profile  Visit Nerf Smurf's Homepage  Send Nerf Smurf a Yahoo! Message  Reply with Quote
Microsoft Excell is great for listing your components.

Go to Top of Page

Aaron Cake
Administrator

Canada
6718 Posts

Posted - Oct 28 2003 :  09:22:02 AM  Show Profile  Visit Aaron Cake's Homepage  Send Aaron Cake an ICQ Message  Send Aaron Cake a Yahoo! Message  Reply with Quote
Access has a built in inventory thingie. Seems to work well.

Go to Top of Page

ecm
Apprentice

Canada
89 Posts

Posted - Nov 07 2003 :  7:44:33 PM  Show Profile  Visit ecm's Homepage  Reply with Quote
I know that . the thing is if i need a 4017 how do i get excell to display stock without going thru the item list . is there a way of to get excell to find that item by just entering the part number. Aaron Im not familiar with Access wich program is that.

to do or not to do
Go to Top of Page

Aaron Cake
Administrator

Canada
6718 Posts

Posted - Nov 10 2003 :  09:31:06 AM  Show Profile  Visit Aaron Cake's Homepage  Send Aaron Cake an ICQ Message  Send Aaron Cake a Yahoo! Message  Reply with Quote
Google - > Microsoft Access

Part of office. It's the database program.

Go to Top of Page

n/a
DELETED (Inactive)

56 Posts

Posted - Dec 03 2003 :  10:43:36 PM  Show Profile  Reply with Quote
ECM. If you have your stock represented in lists, you can do an "Autofilter" of the columns that you have established. Just select the entire column by clicking on the column name/header "A, B, C etc." then go to the tools menu, select "filter" then select "autofilter". This will produce a drop down arrow, which will list all of the items in that column.

Another method is to do a simple "Find". press Ctrl + F. Then enter the item you are looking for. Excel will find the first item that matches your description. To find more, hit "find next" and excel will find the next in series. You can also use wildcard "*" for unknowns. For instance, if you're looking for a 555 timer, but you have all of the IC's listed by part number, you can use "* 555" etc. Play around with it.

I have created an Access database that I use to categorize my parts. If you're interested in the copy, send me an email and I'll shoot it over to you. Johnson7777 at hotmail dot com. Replace at with @, dot with .

Go to Top of Page

ecm
Apprentice

Canada
89 Posts

Posted - Dec 04 2003 :  5:42:34 PM  Show Profile  Visit ecm's Homepage  Reply with Quote
Thanx for the tip and as for Access I dont have that program ,I will look into it to see how much it cost .

to do or not to do
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Aaron's Homepage Forum © 1995-2020 AARONCAKE.NET Go To Top Of Page
This page was generated in 0.09 seconds. Snitz Forums 2000