RE: [AccessDevelopers] Graphical Inventory

[Craig Gross]

Why do this in Access at all? Since they do not require storage of data then any other program will do. They simply want a graphical point and click interface so as to maintain visual representation of the freezer.   Not knowing all the potential software all ready available, I would suggest the most obvious, and that is PowerPoint. You could build front end graphics easily, and then either with some animation effects, and or some VBA code create point and click procedures. Though I would still check to see if anything else is out there that may make your task easier.   -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly Sent: Thursday, September 15, 2005 4: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 This email and any attachments contain information from Baker & Taylor which may be confidential, privileged and/or protected by other legal rules. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or use of the contents of this email is prohibited. If you have received the email in error, please notify us by reply email immediately and then delete the email and your reply from your email system. NOTE: Baker & Taylor accepts no liability for the contents of this email. This email shall not operate to bind Baker & Taylor to any contract, order or other obligation. 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.