Search results

Yep - and that is exactly how I am envisioning utilizing it. The idea is still in its infancy but that clarifies what I was thinking. I'm thinking more about how to collect the data rather than how to store it - which isn't exactly correct either - but I'm wondering if I can't revisit the...

Thanks Larry! I would love to review what you've done. What you describe is definitely in the my ballpark.

It wouldn't be a replacement. I'm just exploring options for designing a front end for an EAV backend - I'm ADHD and find that I function best by ....oh...I don't know - exploring. :-)

Hi All, I'm designing a DB for the quality assurance department of a steel manufacturing plant. The primary data collection is from inspections of materials and products as they are delivered, rolled, welded, painted, fabricated, etc. The challenge is that all of the various TYPES of...

isladogs - I'm going to respond to you about the converter in a different post titled JSON converter for Access because it might be easier for someone else considering the same type of approach and might be easier for them to find.

So ....when I do go over his head, I'm going to need to be able to respond to this email I received from him as to what he has done incorrectly. Thoughts? Suggestions? THX as always!

I should also mention that I already know just how much he hates Access (for no good reason). I asked him to install MySQL on my computer. He instantly said no. I told him that I was researching a means to not use Access at all (knowing his Achilles Heel). He even more instantly - within seconds...

Hi Doc, see my reply to George :)

Thank you very much for that. FWIW, I have actually enjoyed learning Access through this trial by fire. There is a lot that he doesn't know. Almost all of his obstinance stems from a political broohaha with the person who attempted to develop the original DB for quality and did a miserable job...

We We have a setup similar to that right now using RDP and time sharing. We have three plants: Rankin, Greensburg, and Bartow. Greensburg and Bartow time share a database on a dedicated server via RDP. Due to their operations being extremely streamlined as far as product inspections are...

Hi Doc, Right on. You're one of the rare few who has ever heard of NPRDC. lol. "Maim" instead of.....that's hysterical!

Thanks isladogs! Sounds promising - informative for sure. I'll take a look.

Hey plog - one last thing - and I'm not at all trying to be argumentative or even defensive. It's just that I realized this is a prime opportunity to toot my own horn about something I have never had the opportunity to do before. In 1998, I worked for NPRDC, a civilian contractor for the US Navy...

And I have a background in database management from college and working for a private contractor for the Navy out of college. (yes a long time ago but nonethless). That's why I sometimes sound like I know more than I do but I'm also aware that I'm over a decade since I had my hands and feet in...

I should also add that we do have an MRP designed/built by an outside source but after a few years of using it, upper management realized that they got what they paid for by not taking part in the very beginning and spending the time with the designers to make sure that business rules were taken...

So......yeah........some guidance to assist/direct me in what I know will be a year or two project to add a by-line or two to my resume would really be appreciated. :-)

Hi plog, You would be correct for any modern company. I do not work for a modern company. When I started here four years ago there was nothing recorded digitally. It was still ALL paper in 2018. We have one IT guy and he is....recalcitrant. Please see my reply to DBGuy for moore. :-) Thank...

There's more to the story - of course - which also speaks to what plog said above also. I work for a company that is only very recently aware that it should move out of the 1980's. We have one IT guy and he is obsessed with network security to the point where our internet browsers are almost...

Hi All, I don't know how many times (over the past couple of years) I have written the next sentence (lol): I work for a steel manufacturing company in QC. I developed an inspection database in Access 2016 to collect our daily inspections and provide reporting on activities. The inspections...

Hi all, I'm trying to create a report for manufacturing inspections by job number. Our job numbers look like this: A762502001. The first five characters (e.g., A7625) are the actual job number. The next three (e.g., 020) is what we call the Task. The last two e.g., 01) are what we call the...