Access to create BOM program

[Eric]

hello;

i'm trying to create a simple BOM program using Access.

-i have a table created that have my assembly top-level
number, plus all their components and quantities.

-i created a list box to pick the assemblies from which
moves them from the pick list box to a second list box.

-i created a query which sees what is in the second list
box.

-i created a report that displays the query.

here's the results: i can select any number of
assemblies for a report, and the report shows the
assembly number, as well as it's subcomponents and how
many of each are needed.

here's what i need: to be able to specify *how many* of
each assembly i want, then have a report generated that
shows that i need X quantity of this assembly, and shows
that i will need X numbers of its subcomponents.

it seems that all i need is to be able to input a desired
quantity into a text box for each assembly i have on a
report, then have some code that multiplies the needed
subcomponent quantity (which is in a table) by that
number, then that's what the report displays.

just not sure how to (1) associate a quantity input text
box for each assembly every time and (2) how to multiply
that quantity into the subcomponents to display it on a
report.

any ideas?

-eric

 

[Arvin Meyer]

We have a sample BOM on the Access Web. Have a look at:

http://www.mvps.org/access/modules/mdl0027.htm

While the database is in Access 97, it should convert OK to later versions.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Mike Painter]

We have a sample BOM on the Access Web. Have a look at:

http://www.mvps.org/access/modules/mdl0027.htm

I have a fond memory of some code I wrote for A BOM program.
It was the first and about only time I've used a recursive subroutine for
other than factorials,
it was about 20 lines long, produced and printed a fully exploded list to
any depth and it ran the first time with no error.

 

[Guest]

-----Original Message-----
I have a fond memory of some code I wrote for A BOM program.
It was the first and about only time I've used a recursive subroutine for
other than factorials,
it was about 20 lines long, produced and printed a fully exploded list to
any depth and it ran the first time with no error.

that sounds great; could you dig it up and post it?

i actually found that sample BOM that was mentioned, but
it does not do any of the things i need it to.

-eric

 

[Tony Toews]

that sounds great; could you dig it up and post it?

Agreed. I'm sure Arvin would be happy to put it on the Access Web.
(Assuming this was written in Access of course.)

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Mike Painter]

that sounds great; could you dig it up and post it?

i actually found that sample BOM that was mentioned, but
it does not do any of the things i need it to.

Probably not. It was done in the 80's in Advanced Revelation which used Pick
Basic and multi-valued fields (a bad thing only in a relational environment.

I suspect it could be done with a self referencing table, would take more
code but not be difficult.
Pick Basic has probably the strongest string handling available outside
languages specifically designed for strings.

There was about ten minutes of staring into space between this line and the
one above it.
I'll play with it.
Send me an email if interested.

 

[Eric]

-----Original Message-----


Agreed. I'm sure Arvin would be happy to put it on the Access Web.
(Assuming this was written in Access of course.)

um...i'm sorry; what is the link to the Access Web site
your're speaking of..?

-eric

 

[Douglas J. Steele]

um...i'm sorry; what is the link to the Access Web site
your're speaking of..?

http://www.mvps.org/access/