Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to make an order entry program for customers...
I would appreciate if someone could point me in the right direction... What I
would like to be able to do is have a work sheet with columns for Part# Width, Height, Depth, Specs., etc... When some one uses the drop down lists on this work sheet it should bring the information that I just out lined with it and show up in the appropriate columns and rows. Is this the right program or would something like access be more along the lines of what I need? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to make an order entry program for customers...
You can probably do it in either Access or Excel. If you have an extremely
large database and are not running xl2007, Access might be better for inerfacing your order and inventory system. But basically, either would work. I would consider using listboxes or comboboxes for calling up the variations of parts and specifications so that choices can be made by the user and then transferred to a single entry on the worksheet. You could possible use textboxes but I find the listboxes easier to work with for multiple choices. Everyone has their own preferences, depending on approach. "John" wrote: I would appreciate if someone could point me in the right direction... What I would like to be able to do is have a work sheet with columns for Part# Width, Height, Depth, Specs., etc... When some one uses the drop down lists on this work sheet it should bring the information that I just out lined with it and show up in the appropriate columns and rows. Is this the right program or would something like access be more along the lines of what I need? Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to make an order entry program for customers...
Good samples he
http://www.vertex42.com/ Purchase Order: http://www.vertex42.com/ExcelTemplat...ase-order.html Or, just Google for it. Regards, Ryan--- -- RyGuy "JLGWhiz" wrote: You can probably do it in either Access or Excel. If you have an extremely large database and are not running xl2007, Access might be better for inerfacing your order and inventory system. But basically, either would work. I would consider using listboxes or comboboxes for calling up the variations of parts and specifications so that choices can be made by the user and then transferred to a single entry on the worksheet. You could possible use textboxes but I find the listboxes easier to work with for multiple choices. Everyone has their own preferences, depending on approach. "John" wrote: I would appreciate if someone could point me in the right direction... What I would like to be able to do is have a work sheet with columns for Part# Width, Height, Depth, Specs., etc... When some one uses the drop down lists on this work sheet it should bring the information that I just out lined with it and show up in the appropriate columns and rows. Is this the right program or would something like access be more along the lines of what I need? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order Entry | Excel Discussion (Misc queries) | |||
How to program data entry to avoid zeros or last 5 digit. | Excel Discussion (Misc queries) | |||
CollegestudentHelp me create an automated data entry program in Ex | Excel Discussion (Misc queries) | |||
CollegestudentHelp me create an automated data entry program in Ex | Excel Discussion (Misc queries) | |||
HOW DO I PROGRAM THE TAB KEY TO MOVE IN SPECFIC ORDER? | Excel Programming |