If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help setup db to track unique to customer orders history
We are a mfg company. We want to create a db that would make it easier to set
up an order history for each customer. Each of these customers has a variety of different items that are unique to them. We wish to setup new items within the customer form so we can enter and track the items and their history on the fly Help |
#3
|
|||
|
|||
help setup db to track unique to customer orders history
"Steve" schreef in bericht m... If you want help creating this database, I can help you. I provide help with Access, Excel and Word applications for a nominal fee. Contact me if you would like my help. Steve Here are a couple of customer comments after I helped them ......... blah blah... Go away Steve!!! get lost !!!! No-one wants you here... No-one needs you here... Also your fake credentials won't work... To the OP: http://home.tiscali.nl/arracom/whoissteve.html Arno R |
#4
|
|||
|
|||
help setup db to track unique to customer orders history - if stevie was any good, why does he need to grovel for work?
"Steve" wrote in message
m... If you want help creating this database, I can help you. I provide help with Access, Excel and Word applications for a nominal fee. Contact me if you would like my help. Steve These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. A few gems gleaned from the Word New User newsgroup over the Christmas holidays to show Stevie's "expertise" in Word. Dec 17, 2008 7:47 pm Word 2007 .......... In older versions of Word you could highlght some text then go to Format - Change Case and change the case of the hoghloghted text. Is this still available in Word 2007? Where? Thanks! Steve Dec 22, 2008 8:22 pm I am designing a series of paystubs for a client. I start in landscape and draw a table then add columns and rows to setup labels and their corresponding value. This all works fine. After a landscape version is completed, I next need to design a portrait version. Rather than strating from scratch, I'd like to be able to cut and paste from the landscape version and design the portrait version. Steve Dec 24, 2008, 1:12 PM How do you protect the document for filling in forms? Steve One of my favourites: Dec 30, 2008 8:07 PM - a reply to stevie (The original poster asked how to sort a list and stevie offered to create the OP an Access database) Steve wrote: Yes, you are right but a database is the correct tool to use not a spreadsheet. Not at all. If it's just a simple list then a spreadsheet is perfectly adequate... John... Visio MVP |
#5
|
|||
|
|||
help setup db to track unique to customer orders history
Getting_By wrote:
We are a mfg company. We want to create a db that would make it easier to set up an order history for each customer. Each of these customers has a variety of different items that are unique to them. We wish to setup new items within the customer form so we can enter and track the items and their history on the fly Help How is this different from a standard Customers -- (1,M)--- Orders---(1,M)---Order Details ---(M,1)---Products database? If you don't purge the orders or order details, then you have their order history already. Proper indexing should make the database work fine. If you wanted to populate a list of "Frequently Ordered Items", you could write a query to do that... -- Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
help setup db to track unique to customer orders history
I'm not sure I understand....
You offer to help people who come to these FREE newsgroups for a fee and then... ....post questions in this FREE newsgroups on how to create their database for them? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Steve" wrote in message m... If you want help creating this database, I can help you. I provide help with Access, Excel and Word applications for a nominal fee. Contact me if you would like my help. Steve Here are a couple of customer comments after I helped them ......... Thanks for your work; it is just what I was looking for! You're good. This is only the second time I've contracted out Access development, you were the first, you did a fine job the first time but this time I thought I'd see what the open monetary marketplace could provide. Let's just say you are the only one who has been able to get me the result I was looking for and I didn't have to spend any time explaining the details to you. Scott Rich I imported all of your additions this afternoon. It works great. Thank you so much. Please send me an invoice and I will send check. Thanks again..I enjoyed spending the time on the phone. Hope I can call you again the next time I need help Rhonda Marko "Getting_By" wrote in message news We are a mfg company. We want to create a db that would make it easier to set up an order history for each customer. Each of these customers has a variety of different items that are unique to them. We wish to setup new items within the customer form so we can enter and track the items and their history on the fly Help |
#7
|
|||
|
|||
help setup db to track unique to customer orders history
Getting_By,
Take a look at the Northwind database... This should be a great start for what you want. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Getting_By" wrote in message news We are a mfg company. We want to create a db that would make it easier to set up an order history for each customer. Each of these customers has a variety of different items that are unique to them. We wish to setup new items within the customer form so we can enter and track the items and their history on the fly Help |
#8
|
|||
|
|||
help setup db to track unique to customer orders history
Hi Getting_By,
Adding to Pieters - and yours Inline: "PieterLinden via AccessMonster.com" wrote: Getting_By wrote: We are a mfg company. We want to create a db that would make it easier to set up an order history for each customer. Each of these customers has a variety of different items that are unique to them. We wish to setup new items within the customer form New items would be easier to set up on it own form - assigning it then to a specific customer then could be done either on the Product form or Customer form with a subform. so we can enter and track the items and their history on the fly Help How is this different from a standard Customers -- (1,M)--- Orders---(1,M)---Order Details ---(M,1)---Products Assuming this standard start for the layout you will need to add the table that states what products are related to a specific customer. tblCustomerProducts CustomerID ProductID CustomerNumber ' I put this in to show how I used this format - Customers needed different numbers (used on the Invoices) for the same products that we produced. You can either have a 1 customer to 1 product ID or as we needed many customer could have the same product. Any product not in the list is assumed to be available to all. database? If you don't purge the orders or order details, then you have their order history already. Yes, but you don't have the products that they didn't order that are specific to them. and you can't limit the order detail subform to those products that they are alowed to order that are specific to them. Proper indexing should make the database work fine. If you wanted to populate a list of "Frequently Ordered Items", you could write a query to do that... -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|