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
|
|||
|
|||
Bill of materials
Hi. I need an Access (or maybe Excel) template to help me create bills of
materials. A worksheet with a list of items (record) with the fields "Part number", "description" and "cost". I then need to be able create a BOM by entering the "part number" and have the "description" and "cost" as well as "selling price" (cost + profit %) calculated. Thanks in advance. Chris. |
#2
|
|||
|
|||
Bill of materials
Hello Chris,
If you want, I can create a BOM database for you. I provide help with Access applications for a very reasonable fee. My fee to help you would be nominal. Contact me if you would like my help. Steve "Egan" wrote in message ... Hi. I need an Access (or maybe Excel) template to help me create bills of materials. A worksheet with a list of items (record) with the fields "Part number", "description" and "cost". I then need to be able create a BOM by entering the "part number" and have the "description" and "cost" as well as "selling price" (cost + profit %) calculated. Thanks in advance. Chris. |
#3
|
|||
|
|||
Bill of materials
Steve, where are you going to spam unsuspecting users once these newsgroups
are closed on 6/1/2010? I wouldn't recommend CDMA because quite a few people knowledgeable about you are "coming home" to CDMA and they'll be "on you" like the proverbial "duck on a June bug" -- not even a semi-moderator to advice them to "take it easy". -- Larry Linson, Microsoft Office Access MVP Co-author: "Microsoft Access Small Business Solutions", published by Wiley Access newsgroup support is alive and well in USENET comp.databases.ms-access "Steve" wrote in message ... Hello Chris, If you want, I can create a BOM database for you. I provide help with Access applications for a very reasonable fee. My fee to help you would be nominal. Contact me if you would like my help. Steve "Egan" wrote in message ... Hi. I need an Access (or maybe Excel) template to help me create bills of materials. A worksheet with a list of items (record) with the fields "Part number", "description" and "cost". I then need to be able create a BOM by entering the "part number" and have the "description" and "cost" as well as "selling price" (cost + profit %) calculated. Thanks in advance. Chris. |
#4
|
|||
|
|||
Bill of materials
That may not be too difficult a database application to create if your
requirements are as simple as they can be... but if you need to define and refer to assemblies within assemblies it is not so simple. I was acquainted with some mainframe software for Bill of Material Processing, and it could be quite complex. I recommend you do NOT make use of anyone who panders their for-fee services in a newsgroup (this one, for instance) which is intended for free support. In particular, Mr. Steve "my fees are very reasonable" Santus has, on rare occasions, posted actual answers to questions here (not "hire me" messages) and there have been so many errors in his answers that experienced users have commented here that no fee is sufficiently reasonable for solutions that do not work. -- Larry Linson, Microsoft Office Access MVP Co-author: "Microsoft Access Small Business Solutions", published by Wiley Access newsgroup support is alive and well in USENET comp.databases.ms-access "Egan" wrote in message ... Hi. I need an Access (or maybe Excel) template to help me create bills of materials. A worksheet with a list of items (record) with the fields "Part number", "description" and "cost". I then need to be able create a BOM by entering the "part number" and have the "description" and "cost" as well as "selling price" (cost + profit %) calculated. Thanks in advance. Chris. |
#5
|
|||
|
|||
Bill of materials - stevie is pimping again.
"Steve" wrote in message
... Hello Chris, If you want, I can create a BOM database for you. I provide help with Access applications for a very reasonable fee. My fee to help you would be nominal. Contact me if you would like my help. Steve Sleasy move stevie. Waiting until Saturday night before you attempt to pimp your questionable services. Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. 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. Please do not feed the trolls. John... Visio MVP |
#6
|
|||
|
|||
Bill of materials
Thanks for the warnings guys. My requirements really are that simple. If
no-one can suggest a template, how about some pointers? Access or Excell? I'm reasonably comfortable with basic formulas in Excell and I did some messing about with Access a few years ago. I'm familliar with one-to-many relationships and normalisation etc. I just don't have the time do devote to learning it all again from scratch. "Larry Linson" wrote: That may not be too difficult a database application to create if your requirements are as simple as they can be... but if you need to define and refer to assemblies within assemblies it is not so simple. I was acquainted with some mainframe software for Bill of Material Processing, and it could be quite complex. I recommend you do NOT make use of anyone who panders their for-fee services in a newsgroup (this one, for instance) which is intended for free support. In particular, Mr. Steve "my fees are very reasonable" Santus has, on rare occasions, posted actual answers to questions here (not "hire me" messages) and there have been so many errors in his answers that experienced users have commented here that no fee is sufficiently reasonable for solutions that do not work. -- Larry Linson, Microsoft Office Access MVP Co-author: "Microsoft Access Small Business Solutions", published by Wiley Access newsgroup support is alive and well in USENET comp.databases.ms-access "Egan" wrote in message ... Hi. I need an Access (or maybe Excel) template to help me create bills of materials. A worksheet with a list of items (record) with the fields "Part number", "description" and "cost". I then need to be able create a BOM by entering the "part number" and have the "description" and "cost" as well as "selling price" (cost + profit %) calculated. Thanks in advance. Chris. . |
#7
|
|||
|
|||
Bill of materials
Take a look at the demo at:
http://community.netscape.com/n/pfx/...apps&tid=23133 It's the file attached to the second post in the thread and you'll need to convert it up to Access 2007 if that's what you are using. It is a true BoM solution in that it handles assemblies and sub-assemblies of an arbitrary number of levels. It's not intended to be a fully working template, however, only a demonstration of how the recursive querying necessary to produce a bill of materials can be simulated in Access. I suspect that it might not be what you are looking for, however, as what you've described sounds a lot simpler than a true BoM, and could be much more simply achieved with tables Parts, Worksheets and WorksheetDetails, the last modelling a many-to-many relationship between the first two. Post back for further assistance if necessary when you've taken a look at the demo. Ken Sheridan Stafford, England Egan wrote: Thanks for the warnings guys. My requirements really are that simple. If no-one can suggest a template, how about some pointers? Access or Excell? I'm reasonably comfortable with basic formulas in Excell and I did some messing about with Access a few years ago. I'm familliar with one-to-many relationships and normalisation etc. I just don't have the time do devote to learning it all again from scratch. That may not be too difficult a database application to create if your requirements are as simple as they can be... but if you need to define and [quoted text clipped - 20 lines] . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 |
#8
|
|||
|
|||
Bill of materials
These are "exploding BOM samples"
http://www.mvps.org/access/modules/mdl0027.htm http://www.mvps.org/access/queries/qry0023.htm But it's not completely clear what you requi From your description, you just want to be able to look up a single part in a part number table, and add % to the cost? That's not a template: it's a query using the filter button on the Access menu. (david) "Egan" wrote in message ... Hi. I need an Access (or maybe Excel) template to help me create bills of materials. A worksheet with a list of items (record) with the fields "Part number", "description" and "cost". I then need to be able create a BOM by entering the "part number" and have the "description" and "cost" as well as "selling price" (cost + profit %) calculated. Thanks in advance. Chris. |
#9
|
|||
|
|||
Bill of materials
Thank you for the link Ken.
You're right, what I need is very simple with no requirement for the sub-assemblies as in your example. "KenSheridan via AccessMonster.com" wrote: Take a look at the demo at: http://community.netscape.com/n/pfx/...apps&tid=23133 It's the file attached to the second post in the thread and you'll need to convert it up to Access 2007 if that's what you are using. It is a true BoM solution in that it handles assemblies and sub-assemblies of an arbitrary number of levels. It's not intended to be a fully working template, however, only a demonstration of how the recursive querying necessary to produce a bill of materials can be simulated in Access. I suspect that it might not be what you are looking for, however, as what you've described sounds a lot simpler than a true BoM, and could be much more simply achieved with tables Parts, Worksheets and WorksheetDetails, the last modelling a many-to-many relationship between the first two. Post back for further assistance if necessary when you've taken a look at the demo. Ken Sheridan Stafford, England Egan wrote: Thanks for the warnings guys. My requirements really are that simple. If no-one can suggest a template, how about some pointers? Access or Excell? I'm reasonably comfortable with basic formulas in Excell and I did some messing about with Access a few years ago. I'm familliar with one-to-many relationships and normalisation etc. I just don't have the time do devote to learning it all again from scratch. That may not be too difficult a database application to create if your requirements are as simple as they can be... but if you need to define and [quoted text clipped - 20 lines] . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 . |
#10
|
|||
|
|||
Bill of materials
I've now made my three tables;
Part, with fields; / Part Number / Description / Cost Kit, with field / Kit/ and to link them; PartKit with fields /Kit / Part Number/ and i've got the one-many relationships between the tables. I can make the form to input the new parts, but I'm stuck with how to make a form to create a new kit "KenSheridan via AccessMonster.com" wrote: Take a look at the demo at: http://community.netscape.com/n/pfx/...apps&tid=23133 It's the file attached to the second post in the thread and you'll need to convert it up to Access 2007 if that's what you are using. It is a true BoM solution in that it handles assemblies and sub-assemblies of an arbitrary number of levels. It's not intended to be a fully working template, however, only a demonstration of how the recursive querying necessary to produce a bill of materials can be simulated in Access. I suspect that it might not be what you are looking for, however, as what you've described sounds a lot simpler than a true BoM, and could be much more simply achieved with tables Parts, Worksheets and WorksheetDetails, the last modelling a many-to-many relationship between the first two. Post back for further assistance if necessary when you've taken a look at the demo. Ken Sheridan Stafford, England Egan wrote: Thanks for the warnings guys. My requirements really are that simple. If no-one can suggest a template, how about some pointers? Access or Excell? I'm reasonably comfortable with basic formulas in Excell and I did some messing about with Access a few years ago. I'm familliar with one-to-many relationships and normalisation etc. I just don't have the time do devote to learning it all again from scratch. That may not be too difficult a database application to create if your requirements are as simple as they can be... but if you need to define and [quoted text clipped - 20 lines] . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 . |
|
Thread Tools | |
Display Modes | |
|
|