Search results

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

For USPS, part of the issue is no one thought "Where will they charge?". Cost to refit a post office to allow charging is far more expensive than just buying the vehicles. Out of $2billion, I can see $1.6 billion just going to upgrading facilities so they can be ready to go the next day. Toss in...

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.

To help define what your requirement is, can you answer the business rule(s) for certification tracking? Do the certs need to come directly from the trainer? Are they self-reported by employees? Do they need to be verified before being saved? Do you need to keep physical copies, electronic...

Please note, HAVING is normally used with aggregate functions. I don't see an aggregate function so this should be part of a where clause.

I wouldn't say they are luddites, as luddites were opposed to new technologies that would displace existing workers from their existing vocations. Rather, the current batch are far more interested in creating government mandated or government provided positions, thus keeping their workers...

While I may not be able to, a Soviet Lada would be just fine.

So your database doesn't have a way to enter customers? Can't enter products? Can't report on what needs to be delivered VS what was delivered? No method to track goods damaged in transit? No way to note a customer refused delivery for reasons? I would suggest riding along for deliveries for a...

For the future, will you also need to track parts by serial number or lot/batch?

Backing up two steps, you will need to be very CLEAR on what you intend to have this database DO. "Dairy" doesn't change that this looks like a scheduled delivery of goods system. If this is true, what outputs do you need?