Hello Toby, Yup, Access is capable of doing this as long as the graphics are kept simple.
I'd use a bitmap to represent the room and Boxes to represent the pallets. A restriction you have is that you can only have somewhere between 600 and 700 controls on a form (I forget the number). All of the controls must be present on the form cos if you create them on the fly the screen will flicker while changing from design to normal views. The boxes can be dragged around with a little bit of clever programming and their positions need to be recorded so they can be put in the right place on form open. You will need a decent amount of RAM, trying to do this on a shoe string will slow the whole thing down. If you want a simple demo, let me know (it's too much work if it's not going to b used) Aint much Access can't do. Regards Robin. --- In AccessDevelopers@yahoogroups.com, "Toby Bierly" <[EMAIL PROTECTED]> wrote: > 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
