RE: [AccessDevelopers] Graphical Inventory

[John Ruff]

I would consider using their existing inventory database for something like this.   Find out what type of database the inventory is stored in. SQL Server, MySQL, Access, etc. Does the existing inventory database store lot #, # of buckets and/or weight of each pallet? Is there a barcode system to identify each pallet lot? If they have a barcode system identifying the each lot, do they scan info into the inventory database?   I would use the existing database to store the data. I would create a table in it to store the required info. If they have a barcode system, I would use the barcode to scan the appropriate info into the newly created table. They may need to enter certain data manually (the 1st time only) into the computer, such as # of buckets, weight of the pallet, etc. But this should only be a one-time entry. If there is no barcode system they could manually enter the lot # and enter the new location. These could be drop-down boxes and after they make the moves, you process the appropriate movement data such as Orig Loc to New Loc Date/time of move, etc.   I guess a graphical form depicting the locations as you are describing them could be developed and drag-and-drop procedures could be developed, but for cost effectiveness I believe something along the lines of what I suggest above might be more realistic.   You might want to check out Peter DeBaet's website at http://www.peterssoftware.com/. He has a program called Drag-N-Dropper that will fit right up your alley. (Why re-invent the wheel?)   Good luck,   John V. Ruff – The Eternal Optimist J  From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly Sent: Thursday, September 15, 2005 1:45 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Graphical Inventory I have a project that I think goes beyond what Access is capable of, but am not sure where to find suitable software either.  Perhaps someone has some ideas.   My client has a food processing plant with a huge freezer.  In the freezer, there are "lanes" for pallets to be stacked in.  The pallets are placed in stacks of 3-5 "layers" up to maybe 15 "slots" (or stacks) from the wall.   Product is moving in and out of the freezer constantly, and the forklift drivers many times have trouble finding where pallets are located.   What the client wants is simply a database solution that contains a map of the freezer with all its lanes, slots, and layers (it is fine for the layers to be shown from left to right across any lane-slot location, so we're not talking about 3-D).  Whenever a lot (10 pallets) is moved into the freezer, the forklift drivers should be able to quickly mark on the computer where they placed each pallet.  For each pallet, they need to mark the wieght of the pallet, the lot #, and the # of buckets on the pallet.   When pallets are rearranged, the client wants the drivers to be able to simply click and drag pallets from one location to another.   There is no permanent information they want to record (they already have an inventory database) -- they just want a way to easily keep track of what is where in their freezer.   I can envision designing an Access database that might be suitable, but I'm not sure how "pretty" I could make it.  Is there even a way to click and drag items around on a form?   So here are my two questions:   1.  Does anyone know of a software product out there that would be ideal for this project?   2.  Is Access capable of more than I am giving it credit for?   TIA, Toby Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.