Bill of materials
in [Getting Started]
|
From: Egan on 22 May 2010 19:18 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.
From: Steve on 22 May 2010 19:41 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 santus(a)penn.com "Egan" <Egan(a)discussions.microsoft.com> wrote in message news:EDD705DF-32D0-4E0B-B9F7-644F7198D873(a)microsoft.com... > 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.
From: Larry Linson on 22 May 2010 20:05 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" <notmyemail(a)address.com> wrote in message news:uxSFJhg%23KHA.1892(a)TK2MSFTNGP05.phx.gbl... > 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 > santus(a)penn.com > > > "Egan" <Egan(a)discussions.microsoft.com> wrote in message > news:EDD705DF-32D0-4E0B-B9F7-644F7198D873(a)microsoft.com... >> 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. > >
From: Larry Linson on 22 May 2010 20:13 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" <Egan(a)discussions.microsoft.com> wrote in message news:EDD705DF-32D0-4E0B-B9F7-644F7198D873(a)microsoft.com... > 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.
From: Egan on 23 May 2010 04:56 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" <Egan(a)discussions.microsoft.com> wrote in message > news:EDD705DF-32D0-4E0B-B9F7-644F7198D873(a)microsoft.com... > > 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. > > > . >
|
Next
|
Last
Pages: 1 2 3 Prev: update a table based on a sum query Next: Bill of materials - stevie is pimping again. |