Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 11th, 2020, 10:52 PM
Authorized User
Points: 64, Level: 1
Points: 64, Level: 1 Points: 64, Level: 1 Points: 64, Level: 1
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Nov 2008
Location: Seattle, Washington, USA.
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gbowne1
Default Help with Access/Excel/SQL project wanted

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.
Reply With Quote
  #2 (permalink)  
Old June 12th, 2020, 12:52 PM
Authorized User
Points: 380, Level: 6
Points: 380, Level: 6 Points: 380, Level: 6 Points: 380, Level: 6
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Oct 2010
Posts: 64
Thanks: 0
Thanked 16 Times in 16 Posts
Default I'll try to help!

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.
Reply With Quote
The Following User Says Thank You to malcolmdixon For This Useful Post:
gbowne1 (June 12th, 2020)
  #3 (permalink)  
Old June 12th, 2020, 02:39 PM
Authorized User
Points: 64, Level: 1
Points: 64, Level: 1 Points: 64, Level: 1 Points: 64, Level: 1
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Nov 2008
Location: Seattle, Washington, USA.
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gbowne1
Default

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.
Reply With Quote
  #4 (permalink)  
Old June 12th, 2020, 03:51 PM
Authorized User
Points: 380, Level: 6
Points: 380, Level: 6 Points: 380, Level: 6 Points: 380, Level: 6
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Oct 2010
Posts: 64
Thanks: 0
Thanked 16 Times in 16 Posts
Default Github Repository

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.
Reply With Quote
The Following User Says Thank You to malcolmdixon For This Useful Post:
gbowne1 (June 12th, 2020)
  #5 (permalink)  
Old June 12th, 2020, 04:47 PM
Authorized User
Points: 64, Level: 1
Points: 64, Level: 1 Points: 64, Level: 1 Points: 64, Level: 1
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Nov 2008
Location: Seattle, Washington, USA.
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gbowne1
Default

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
Reply With Quote
  #6 (permalink)  
Old June 12th, 2020, 05:19 PM
Authorized User
Points: 64, Level: 1
Points: 64, Level: 1 Points: 64, Level: 1 Points: 64, Level: 1
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Nov 2008
Location: Seattle, Washington, USA.
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gbowne1
Default

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
Reply With Quote
  #7 (permalink)  
Old June 13th, 2020, 07:16 PM
Authorized User
Points: 380, Level: 6
Points: 380, Level: 6 Points: 380, Level: 6 Points: 380, Level: 6
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Oct 2010
Posts: 64
Thanks: 0
Thanked 16 Times in 16 Posts
Default Databases

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.
Reply With Quote
The Following User Says Thank You to malcolmdixon For This Useful Post:
gbowne1 (June 14th, 2020)
  #8 (permalink)  
Old June 14th, 2020, 05:34 AM
Authorized User
Points: 64, Level: 1
Points: 64, Level: 1 Points: 64, Level: 1 Points: 64, Level: 1
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Nov 2008
Location: Seattle, Washington, USA.
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gbowne1
Default

Malcolm,



I'm currently switching email providers especially because of the new site and domain. It's better off emailing me direct. Just add 44@gmail.com 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
Reply With Quote
  #9 (permalink)  
Old June 15th, 2020, 08:49 PM
Authorized User
Points: 64, Level: 1
Points: 64, Level: 1 Points: 64, Level: 1 Points: 64, Level: 1
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Nov 2008
Location: Seattle, Washington, USA.
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gbowne1
Default

Anyone can help me please let me know ASAP.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing MS Project via MS Access using Project object crowegreg BOOK: Access 2010 VBA Programmer's Reference 0 November 29th, 2017 04:38 PM
access and vba tutorials wanted andrew43215 VB How-To 0 March 28th, 2006 08:42 AM
Remote access to an Access Project Database bright_mulenga Access 0 February 9th, 2006 10:51 AM
Need a bit of help with an Excel project wwfc_barmy_army Excel VBA 1 November 1st, 2004 04:17 AM
From 1 project to get access to another project hplim18 Pro VB.NET 2002/2003 0 March 30th, 2004 10:33 PM



All times are GMT -4. The time now is 01:31 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.