Search results

I met him once at a Microsoft convention in 1999 where he was a co-speaker at an Access session. My impression of him was a humble man who cast a big shadow.

You're missing something - a join table between your products and parts. In your post #3, the same part appears multiple times eg ProductDetailID 2267,1167, 542, 580 etc If ProductID 904 had 3 of PartID 204, the join table would have an entry ProductID with 904, PartID 204 and a Quantity of...

There are some redundant fields. Total Time can be derived. Also, I would guess, the fact of the flight being in Overtime would be determined by Flight Arrival/Departure times. I'd have all the crew/passenge in a separate table including the Captain

Play with expensive toys. The difference between men and boys is the price of their toys. The difference between men and the politicians is that they play with people and like bigger and better armaments.

Anyone read Zen and the Art of Motorcycle Maintenance? There's one bit in the book on the difference between motorcycling and travelling in a car. The former is where you're part of the landscape, can smell the grass and trees whereas in a car you're in a bubble and looking at the surroundings...

Yes, don't save the PDF file in your DB. Save it as a PDF in a sub folder and if necessary save only the name of the PDF in your DB.

Why do you have 2 tables? The table StockNumber is repeats one of the fields in the other table.

The recordsource for frmTransactionsMain is set for Transaction type 1. When you try to open it with a Transaction type 3, there will obviously be no records.

Sorry. What I meant was Why would you want to pull up the same dialog form with the same message every time anyone clicks in that text box?

Why would you want to pull up the same message box every time anyone clicks in that text box?

Use enabled for the option selections to grey out some of the options but keep them visible select case me.openargs case is = "Receipt" me.option1.enabled = true me.option2.enabled = true me.option3.enabled = false me.option4.enabled = false me.option5.enabled =...

I'd say that needs to be qualified. Agreed when users are sharing the one FE. However, there are circumstances where users do not have a C drive on which to store the FE. One is where corporate IT blocks Access dbs from running on C drives. Another is working remotely via thin wire...

Too harsh. For those trying not to be drunks.

If the Water Cooler forum can accept posts on Genital Mutilation and Sexual Orientation, then motor cycles is pretty tame.

A letter writer to the local paper has come up with the brilliant idea of mounting a fan on the bonnet of EVs to generate electricity.

mkdir "c:\users\" & environ("username") & "\documents\xxx- xx2"

@NauticalGent, hope you like it. Let's know your reaction. @Jon, I remember the smell of freshly cut grass or trees in blossom when on a bike. Doesn't happen when in a car or greatly reduced. Memories, ah...

@Jon, I remember well the sentiments but I did have to do a search for the exact quote. I've lost the book somewhere over time between house moves. I might well buy another copy even though I gave up riding bikes 30 years ago when I realized the vulnerabilities but I learned to watch, not the...

@ Minty, tempVar is redundant code to be able to generate the progress message

What you are wanting is too complicated. Just make a normal autonumber ID. (Autonumber is a long integer and what you are wanting is a primary key which would be text.) Have a date field. It's easy in code to generate the inquiry order on the same day from the autonumber. But then again why...