Search results

@ Uncle Gizmo One thing ChatGPT is NOT is non-binary!

With the number of objects you have, I'd estimate your application has very poor agility. Case in point is your asking for help in clearing individual records from 50 tables when in a normalized database this would be a simple delete query OR use of referential integrity to delete the required...

Back to the original, I've a feeling asking someone to grab your rubbers (or Wellies) out of your boot would confuse most Americans. Not sure if those are still common terms in the UK though. For the US, that would be grabbing your rain boots (Galoshes) out of the trunk. 😁 I've always had fun...

When we hear the angles sing, it will be Freddy, Ozzy, and Tom. Unfortunately we me join them soon if Putin drops the bomb.

DELETE FROM table_name WHERE condition; I'd suggest doing a little reading on SQL.

@ Jen-Jen, You are asking to enter only time. Is this because you really want to track how much time has elapsed? If so, remember that using a DATE won't let you show a time value of greater than 24 hours. Instead, as the time portion is the decimal, you get your time to wrap. If you don't keep...

Honestly if they are committing thread necromancy, it would be far more fun to have icons appear to let them know. Say Marty Feldman for recently dead threads to an old Voodoo priest in a top hat and skull face for old threads. Ancient threads would just get a picture of Chicago's Mayor Daley...

You may want to look at your table structure. 80 fields seems excessive for this type of data. If you find yourself adding extra columns from time to time this definitely points to non-normalized data.

@Doc, I've a feeling a total AI OS would just be a rebranding of the "Porn hub" site?

I hope that included "How much each component should LEAK per flight hour" field! :ROFLMAO::ROFLMAO::ROFLMAO: I've worked with enough aviation mechanics to realize "If it doesn't leak, that's because its out of some vital fluid!"

Gets worse when you have serial numbers. Components 123-456-7890, 123-654-9876, and 987-654-3210 in cabinet 245-678-9956 gets to be great fun. As it had to meet Nevada gaming regulations, each component needed a complete history from manufacturer to assembly. Sad to say it required more oversite...

Only time I had to set this up I had to start with base items. Relationship table then linked the base items into "assembly" units. You could also use assemblies as base items to go up and make bigger items. Only difference between a base item and an assembly is an assembly has child records...

Depending on industry, you may have an end item that is also a component. Think "We make a bolt and nut for sale, plus a pair are included with a bracket as an item we sell".

If your users know exactly which customers need to be emailed, the multiselect drop down would be the way to go. If your users need to spend a bit of time and have a "Working list", you will need a split table for this. You would have a table in your front end that keeps the Company_ID of each...

I've noticed a lot of thread necromancy lately. I wouldn't expect this much until October!

Special note for images, you will want to make sure they are in PNG format to avoid some not rendering when loaded into an image control.

This is the easy part. Set the "Visible" property to all of the affected fields/labels to "No". In the field where you select what type of account this is, in the after accept you can then set each all of the now relevant fields/labels "Visible" property to "Yes".

As I understand, ROUND only works server side for SQL. What back end are you accessing?

I can see having Access start the process, but why do you want your users to go back through Access to close the viewer? From a user perspective, I can see wanting to choose when to close it myself. Hate to have users complain about not being to have two images open for comparison because "The...

Special note, if you are using images in a report you will want them in .png format. Reports can occasionally not display other formats. Bit of a headache, and a real pain to hunt down when I first hit it.