Not so much of a question, but asking for help with a semi-extenstive project. Although If I had any, my question would now be now that I have some of it completed, what am I missing, errors, etc.. Hopefully someone out there can reveiw what I have and help out. Any help would be appreciated.



Hopefully there is someone out there that is familiar with Access, Excel and SQL enough (more than myself with only a basic understanding of each) to help me with at least some part of a project I have been slowly working on for the past 6 months. I used the Office 2010 version(s) as that is what I have access to universally.



The project files are on Dropbox and Github just in case there is a particular tool a person likes to use.


In short, the project is basically ERP and MRP data, with additional data such as HRM/HRIS, CRM, CMMS, Quality/Gage Tracking, etc. etc.



TBH, my goal is to end up on something like MySQL.

Hi,

I had a lot of years experience with Access from version 2 to 2010, but haven't used it for about 8 years now. I also developed a quite advanced Excel spreadsheet for costing a manufactured product, therefore have some knowledge regarding BOMs and ERP. I used to be a Systems Developer in a manufacturing company, so I'm sure I should be able to pass on some knowledge. I have experience with SQL Server both admin and development too.

One point to note though, this experience was over 10 years ago, so like an old unused car I'm a bit rusty!

Hope I can help in some form, so please point me in the direction of your code.

Best regards,
Malcolm.

Hi Malcom, this is the repository for my code and the project. Any help you can provide would be helpful. No matter how small. I'm only one person and certainly no expert. I'm only one person and me thinks that for the project to get done in reasonable time would take more than one person.



https://github.com/gbowne1/SPMS_ERPMRP


I have a copy on Dropbox if its easier grabbing from there.



I would very much suggest to please read the .md files


I do have a lot of the tables, queries, reports, etc started.



It also needs a nice looking and useful dashboard to be useful in a manufacturing environment. Everybody likes those button clicky thingies.


Sure I could use an off the shelf program but they basically are front ends to SQL which is fine, but what I have seen with a number of them


1) weren't written very well
2) extremely expensive
3) buggy
4) not terribly modifiyable
5) need extensive patching to get to work well
6) very little technical support without $$$$$$$
7) doesnt crash when loaded down with logins (etc)


and yes, a number of other things.



I have tested a large number of the software available for ERP/MRP. In fact that was my 'job' for a while. Not really found one that just works led me down this route.

Hi Gregory,

I'd already found your Github repositories, so I've been looking at the readme files. I've reinstalled an old copy of Access 2010, so I'll look at the databases soon.

I noticed that you're developing your website too, I might be able to assist there as I'm in the process of developing my coding skills in HTML, CSS and JavaScript, but like yourself I'm no expert. In Access development I used to be though.

I'll get back to you ASAP.

Regards,

Malcolm.

thanks Malcom. Any help would be appreciated, no matter how small.



I'm no expert and well, I know myself well enough that.. to raise my hand for help when I feel I'm beyond my scope of knowledge. Also the more eyes on it the merrirer.. sure would reduce errors.



Yeah, my website is crap. That's a whole seperate project. So, I decided that a group project as a site development team would be best as a website because I soon realized that not everyone knows CSS, HTML, Ajax, PHP, Javascript, etc. etc. etc.



Greg

I am going to be udating the website project soon. Probably by midnight tonight GMT/UTC -8 Pacific Time.


The proposal document has many missing areas of information to be conveyed. I originally did not realize a lot of stuff was missing.



The ABOUTTHIS.md file in the ERP/MRP repo has more information than the other readme files.


Greg

Hi Greg,

First, we need a better way to communicate, can I use your company email address info@ at least for first contact to exchange personal email addresses.

I have looked at the Access databases. SPMS_ERPMRP contains tables from BOM, but it also seems to contain many tables from different "example" databases?

The Parts table seems to be only storing weight as the main attribute, is this the only reason you need a BOM in order to calculate weights of assemblies?

I haven't looked in-depth at the VBA code in BOM, so can you explain what the BOM_Temp database is linked for?

Why does the program request which table to use for the BOM, what's the intended purpose? I would have just expected PARTS and BOM tables in a backend database linked to a frontend database with the business processing and forms.

What is the main goal of the Parts / BOM data functionality?

In SPMS_ERPMRP most of the forms do not seem to function, there is little to no data in the tables, as I said the database just seems to be a mix of many examples cobbled together.

Please let me know the priority functions that you want to be implemented, with as much detail in actual data fields required and any business rules you need.

Best regards,

Malcolm.

Malcolm,



I'm currently switching email providers especially because of the new site and domain. It's better off emailing me direct. Just add [email protected] to my username here.



A fellow I was working with a while back gave me a heap of stuff he already made for the project to get it started, so they may seem like examples. I figured it would be enough to get started. I added a little bit to it myself.



No, the weight addtibute is not the only attribute for BOM and Parts. The main goal for parts and BOM should not only be able to show inventory, parts usage, material data, part numbers, weight, size, units (ea, etc.) and a few more things. And you're completely right it would be parts and BOM in a back end.

I had originally considered using MySQL for this and or using Visual Studio 2019 and some SQL tools. But I'm still learning both. So sticking with what I knew seemed best. The only thing I have heard is that if more than 5 users are logged in, Access has problems.



There's no data in the tables, yet. There's a little bit of data in places but not a lot.

I don't know what the BOM_Template is linked to.



The program was not finished. So it just calls up the BOM. Like I said, what's there is a start. It really needs a clicky dash board with buttons that call up the different modules.



Thanks,

-Greg

Anyone can help me please let me know ASAP.