Recent content by tmyers

My company just received the update that includes the new Python formulas. What's everyone's thoughts on this? As someone who knows how to code in Python now, I assume this isn't technically meant for me as I would just write everything in an actual IDE but am curious on everyone else's...

It is but it is up to each person whether they choose to enable OneDrive or not. Each person has a subscription and up to 1tb of storage but not everyone has it turned on and not everyone syncs the same folders (some only do documents rather than desktop). As a business it isn't something we...

The overarching question I guess would be how to detect if it is in use so I can properly direct the file to the right spot. As currently trying to force it to the desktop when it is in use results in the file becoming lost.

I have tried creating files elsewhere then tried pushing them to the desktop but that also results in the file becoming lost as OneDrive tries to redirect it. Admittedly I have not tried using the temp folder specifically.

I am trying to save files to users desktop, or even their Documents folder but several people have OneDrive enabled and are syncing either one or both of them which changes their path completely. Any code I run, whether it is Python or VBA, while it doesn't seem to explicitly fail, doesn't work...

Designing the new frontend is what made me realize just how badly designed the backend was and quite quickly at that lol. While I still kind of stink at database design, I have improved a lot when it comes to my coding in that my modules are very decoupled from one another so sweeping changes...

It is. It looks like a much cleaner approach now so thank you so much for your help! Downside now is a large portion of my front end thats based in Python will have to be reworked to account for the schema change :(

I plan on doing another pass over to make sure all my keys and such match my convention, which as Pat pointed out is me inverting the PK when it is a FK. I found that to be a really simple way to make things match and be o For #1 I originally had it all in the table but was honestly not sure...

Attached is what I have so far with the new backend. Hopefully I understood where you were going to the reel, layer and cut tables. I also tried a similar approach on the inventory side to try and keep track of such a reel should we accept a return or something and have to track it as individual...

Each "kit" would all be the same length and size as different sizes come off at different speeds so you cannot mix them. There are standard color combinations per building code but we do see instances of unusual combinations that would prevent preset color combinations unfortunately. We follow...

Imagine a large wood or metal reel/spool. We have a machine that can pull up to 4 different wire at the same time (all the same AWG size) onto that reel. We can then "stack" or "layer" it on top of each other until we reach the reels capacity which varies depending on the size of wire being ran...

I do tend to overload things with info that isn't needed. If I have a toxic trait, that would be one lol. Process: Salesman writes in order in our primary POS system and creates the sales order. Products that need cut (wire, flexible conduit) and then entered into this database as a request...

I did learn not that long ago that my company uses it as their ticket system at the help desk which i thought was neat.

I am revisiting a backend I made about 2 years ago at this point and trying to making improvements as I know a lot more than I did then and the old design isn't playing well with converting to a Python based front end. I have attached a picture of it. This is the backend for an application that...

Been awhile everyone! I just wanted to drop by and say that my current endeavors have really made me appreciate how nice Access is. I have been solely working in Python now for quite some time building an application suite for my work and I must say, I never realized how hard UI design really...