Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1594
  • Last Modified:

how can I generate an indented bom with microsoft access

how can I generate an indented bom with microsoft access
0
vernalway
Asked:
vernalway
  • 3
  • 2
2 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Couple different methods:

1. SQL Approach
2. VBA based approach.

  I would start by taking a look at this:

Expanding a Hierarchical Data Structure
http://www.experts-exchange.com/Database/MS_Access/A_19-BOM-parts-list-expansion.html

 which will give you a good start.   let me know if you have any questions on the article.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
And keep in mind that this is only one way to structure this, although most solutions fall along these lines; a part master, then a BOM table with each level of the BOM entered individually.

 For example, I have a VBA sample that doesn't use recursion.   Others do BOM editing using a tree view control so you can see the entire structure, etc.

Jim.
0
 
vernalwayAuthor Commented:
Thanks a lot Jim!  That gets me going nicely with the example of a recursive routine.  I'll be implementing today.
0
 
vernalwayAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for vernalway's comment #a40335182

for the following reason:

Problem solved.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Welcome to EE.  Glad to hear that helped you along.

Given that, assuming you made a mistake in choosing your own comment as the solution for the question (everyone does this at first because it's so easy just to pick the last comment), so I'm going to object to the close.

That will allow things to be closed properly.

Jim.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now