SuperbHosting.net have generously
sponsored
dedicated servers to ensure
a reliable and scalable dedicated hosting
solution for BigResource.com.
|
|
Help With A Word Order Database
I am a modular housing sales consultant and I am trying to setup a work order database in access. This database would allow me to spec out a modular home for a prospective customer/client as they provide me with all of their home options (floors, exterior, doors & windows, interior, appliances, bathrooms, kitchen, etc.) and then print out an invoice with an estimated total.
I am currently using an excel spreadsheet and it is very cumbersome to use. I use it as an invoice and the invoice contains the following information on it.
Bill to:
Dealer Name
Dealer Rep
Phone, Fax, Cell
Ship to:
Customer Name
Customer Address
Phone, Fax, Cell
Home Options:
Floors:
Joist: (Structure Wood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist)
Carpet: (Cappuchinno, Biscuit, Pebble, Summer Straw, Praline, Herringbone, Cashew, Buckskin, Shale, Botanical, Cordovan, Stone, Cascade, Black Ice)
Vinyl Flooring: (Woodgrain #05296, Square Tile #57296, Mosaic #55296, Tan Stone #08296, Large Square Tile #07296)
Interior:
Interior Doors: (install, ship loose, 6 panel, flat)
Hardware: (Brass, Brushed Nickle, Round Knob, Level Handle)
Crown Molding: (4", 5")
Base Molding: (4", 5")
Appliances:
Color: (White, Black, Bisque, Stainless)
Dishwasher: (Standard, Power Scrub)
Microwave: (Over Range, Free Standing)
There are other options but this is just a brief listing of options as an example.
Each option would have a price attached, and selected price would be added to the invoice, and once work order is completed, the invoice would have options totalled. Ready for the customer and dealer to confirm and approve.
Can someone start me in the right direction on getting the tables setup for this - the one that I seem to be having the most difficulty with is how to setup the options for this invoice. I pretty well have a grasp on the others. I might also need help in relating the tables to one another.
I hope this all makes sense.
Any help would be greatly appreciated.
Donm
View Complete Forum Thread with Replies
Related Forum Messages:
Order Manager Database
Hi, I wonder if anyone could help. I'm in the planning stages of creating a order manager in access for multiple ecommerce sites. Database will store data on Customers, Inventory, Invoices, Returns, Shipments, Credits, Quotes etc for all sites, and also custom reports. And the idea is to have the database generate the ecommerce sites automatically as static html, which can be uploaded. As the orders come in they will be stored online, and then periodically downloaded into the database. The reason is we currently have 3 sites running and managing inventory and stock control is the hardest, as currently there are 3 databases controling stock! Also when a customer telephones its difficult to know which site they have ordered from which is unprofessional, and we have to log into every site just to find their order. Future ideas:- Meaning we are going to setup more sites which will obivously make the situation worse. We also want to branch out in into eBay using the eBay API to download transactions and sales, and will therefore need a place to store the data. Can anyone foresee any problems with such a system? Any ideas or examples? Thanks for your time.
View Replies !
Help With Clothing Order Management Database
Hi, I am trying to design and build an orders management database for a clothing wholesaler. Has anyone got any ideas on what entities i should have. I thought: Clients (Customer Details) Orders (Inc. order date, ship via etc) Order Details (sizes, quantity of orders per size) Product Details (Product Code, colour, size, stock numbers per size) Catergories (Shorts, Jackets, Jeans etc) Suppliers (Supplier Information) Delivery (Delivery Method etc) However, loads of problems when i come to planning the sizes part. I have different product catergories with different sizes And when i do the order details table, i need to enter order quantities for each different size for one clothing unit. Any ideas? I would also ideally want to link the order details and products tables by the product code number. I.e. When filling out an order In the order details table i want to type in the product code then have information from the product table automatcially fill in the gaps in the order details table, such as unit price, colour etc. Hope you understand and can help me!!! Thanks for your time J
View Replies !
Calculate Payroll In Order Database
I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and total for pay period. Each inspector is paid a different percentage, which is stored in tblInspectors. Payroll is paid every two weeks . . . I've been trying to figure out the best way to do this ... :confused: Any advise be greatly appreciated.:confused:
View Replies !
Order Entry Database Problem With Pop-Up Subform
I have taken the Order Entry database sample from Microsoft and have added a "Wizard" type interface. Question) I'm having trouble understanding how to get more than one Feature applied to a single new service. - For example, If I add a new SERVICE to an ORDER, and I need to add all available FEATURES to that SERVICE, how do I do that? *see my attached database & relationships. The form of FEATURES is also attached. I just want to be able to check off the ones that apply. (is this many to many? I tried a junction table but can't make it work) I would really appreciate some advice on my Forms, and definitely advice on my Table / Relationship structure. ps: My tblServices use to be called tblProducts. I then added the tblCategories, tblPaid, tblTeleServ, tblLongDistRate, tbl800Serv & tblFeatures. Thanks in advance for your help, jlig
View Replies !
Multiple Lines In Order Form From Single Database
I have 2 databases Product, with 3 entries ProdID, ProdName and UnitCost. 2nd database Order has Order ID, ProdName, UnitCost, Quantity, SaleDate and Total. I want to create a form to input data into the Order databse that allows me to enter several rows using the data from the product table by selecting ProdName(Product) from list and UnitCost(Product) being inserted into each row automatically as a new ProdName is selected. Can anyone hsuggest how best to do this.
View Replies !
MS Word File Path > Access Database, Possible?
Hi All, I have been trying to figure this out for ages but I cant seem to get the code right or find any info on it. In my database i have a mail merge on a button click which creates a new merged word document. I then need a way of when the user saves the document in word, bringing back the file path and putting it in a table called tblHistory with the correct customer ID in there too. Any help appreciated Thanks Alex
View Replies !
Microsoft Word Mail Merge - On Database Switchboard
I've got a mail merge letter in word using a booking system which I've built in Access, and I want to be able to access the mail merge letter (or the letter template) through that switchboard. Is this through running a certain macro, and if so, can anybody tell me what it is?
View Replies !
User Database From Command To Open Word Document
In access database, Is there anyone know how use macro to open a word document on a share drive..(example S:safetyRegulation.doc)?. Here is what I did and it doesn't work.. Runapp command line: C:Program FilesMicrosoftOfficeOfficeWINWORD.EXE //S:safetyRegulation.doc. Is there any easier way to do this? Please advice..thanks Rob..
View Replies !
Creating A Word Document Based On A Stored OLE (word) Object
Hi guys. I've got an application that contains some data, which should be transfered to both excel and word. What seemed pretty straighforward, makes my head hurt. I've got one form which captures all the data that I need. Based on this data, I want to create a word document, that the user then can edit and write whatever they want and save it. I don't need to store the word document. What I do want is to create this document based on a word template that I have stored in the database (I've so far used a ole object). So, my question is: How do I create a word document based on a word template (or word document) I have stored in the access database.
View Replies !
"Embed" Word Or Other Files Within A Database
Hi everyone I know it's possible to use Access to create a Word document and think it's possible to have a button (or combobox) open a Word document saved on the hard drive. If I'm correct with the second belief, the Word file(s) would need to be moved with the Access database if it's moved to another directory or PC. Is it possible to save the Word (or other) files within the database itself so simply moving the database to another directory or PC would take the "embedded" files with it? I realise that the database file size will increase, but suspect that this increase would be similar to the size of the individual Word files. Thanks for your time.
View Replies !
Order By
Good morning, I have a table ID (primary key) and ID -- FEASSDDE RDSAAASE NEESSDSD AEIERIEIEE and I want to do a select of these values, order by ID ASC, and see the position of each one in this order, something like this: POS ID -------------------- 1 AEIERIEIEE 2 FEASSDDE 3 NEESSDSD 4 RDSAAASE
View Replies !
Tab Order
I have a startup form with three buttons. All three buttons have Tab Stop set to No. However, when I open the form, there is a highlighted box around what would have been the first button set in the tab order had Tab Stop been set to Yes. Is there a way to not display the light green box around the text in the button? Thanks, SKK
View Replies !
Tab Order Help
My tab order is the way I want it and when the user enters after the last field on the form, they get a new record. Problem is, the cursor is putting them in the last field on the form instead of the first one. I don't get it. The first field is first on the tab order list. Help.
View Replies !
|
|
TRACKER
