Bill of Material Help

[TheLostDrafter]

Hello, I am fairly new to Access and I am trying to accomplish something I thought would be easy but there is so much info on here I'm not sure where to start.
I am creating some standard assemblies and each assembly will have a BOM (Created in AutoCAD). Currently I can pull a report listing all the items required per assembly but it lists them all in 1 row per assembly. I attached the output excel file (see tab "Summary"). If you look at the Sheet 1 tab, that is how the info should be.


The end game for this report is for someone to be able to select several assemblies, note the qty of each that they need and then create a report showing the total items they need to create all the assemblies. I am open to other options and suggestions. Also I don't mind research just need a little (or alot) of direction .
BOM-TEST2.zip

[Mickjav]

That looks like electral instalation Items
I know I keep posting links to my site but build them to help and they relate to each topic

My project works manager lite should give you some idears
https://databasedreams.createaforum.com/works-manager/




Hope it helps mick

[TheLostDrafter]

Thanks Mick for the quick reply! You are correct about electrical installation parts. From the photo that looks like something I might be able to use, I downloaded the manager lite and it seems to only work on 32-bit. We have 64-bit is there a workaround?

[Mickjav]

I will look at it but you can install the 32 bit of access for now.

I must have missed an API update somewhere as I only have a 32 bit version

[Mickjav]

As A Thought I might uninstall my 32 bit and update to 64 that was I will see whats working or not thanks for letting me know

[TheLostDrafter]

I will look at it but you can install the 32 bit of access for now.

Unfortunately installing software at my current employer is a long drawn out process. So that is not really an option for me.

[Mickjav]

Not a problem you could look at the data file that might give you some idears I'll let you know whenI've got it running on 64 bit version

[Mickjav]

Unfortunately installing software at my current employer is a long drawn out process. So that is not really an option for me.

Just found out why it wont run on 64 bit and will fix it within the next few days

https://www.accessforums.net/showthread.php?t=79215

[CarlettoFed]

Here BOM.zip you can see an example of how you could handle it.
Sorry for any translation errors from google as I am Italian and do not know English well.

[a.ashkani90@gmail.com]

Hi everybody
I need a sample access program for BOM.
The program is multi-level.
Show the main product along with the sub-assembly and the constituent parts of the sub-assembly.
Can someone help me and provide me with a sample program where the code can be edited?
Thanks to all

[Welshgasman]

Stop hijacking other people's threads.
By all means link to them, but post your own.