Search results

The practice of consuming faeces is not uncommon in the animal world to get the bacteria to digest food.

Thanks Josef. #4 fixed it.

That coding gives me a compile error in the calling routine.

Is it possible to pass a type variable to a suboutine in a module? Option Compare Database Option Explicit Type ItemList FeeCode As String UnitValue As Currency End Type Public Sub Test() Dim ItemArray(3) As ItemList TestPass (ItemArray) End Sub Sub TestPass(ItemArray As Variant)...

When does Donald Trump make the announcement?

In your accdb file, you can attach to tables in other data sources, everything from another data source in Access, Excel or SQl Server. Use the External Data tab in your accdb.

in #1, the code used docmd.openform "frmTraining" , , , , , acFormAdd, Me.PositionID has incorrect syntax Use docmd.openform "frmTraining" , , , , acFormAdd , , Me.PositionID That is 4 commas before and 2 commas after, the acFormAdd rather than 5 and one

Real estate. Are you thinking only of private dwellings or including also commercial and industrial real estate? I used to have a portfolio of houses but got to the stage where I sold them all and put the money into the stock market. With stock assets, there are no ongoing taxes on the fact...

See Microsoft article on co-authoring I was of the opinion that a spreadsheet was read only for second and subsequent users until an Excel guru proved me wrong.

I told my physio early in the treatment that I knew he had a plan for me - a Work Harder Incentive Plan

I don't think anyone who has not ridden would fully understand the descriptions in the book.

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

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?