Search results

What DBguy is saying is that if Msample is Null then Msample & ".pdf" will be ".pdf" which is an invalid file name

You could add another field -Reason (for leaving) ie Expelled, Transferred, Graduated

In the Update event of the combo, look up the values of Address and Mobile and insert values in the unbound text boxes. Better if you based the form's source on a query which combined the Sales and Customer details. For getting the address and mobile for a new customer, I'd have a separate pop...

"The Timeless and Universal Truths and Principles About Order and Disorder That Are Most Relevant Now. I believe that it is true for all people in all collective activities (sport, organizations, governments, etc.) that if… a) there is no acceptable way to agree on what is probably true (e.g...

Could you understand the English spoken in NZ?

When the button is clicked, call the fnElapsed routine and insert the results into an unbound text box.

Proven skills can obviate the need for a degree. I wonder how many posters on these forums have a degree in computing. I for one don't.

Have you checked for any occurrence of Dim SUrname

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.

Tesla claims 100% of its batteries are recyclable. As far as recycling metal in the car, the first Tesla reached 1 million miles of driving 12 months ago. Admittedly, the battery pack would have been replaced multiple times. ICE motors are around 40% efficient. The other 60% of the energy in...

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

Maybe it was a "socialist utopian dream" to think of a time automobiles did not need someone walking in front with a flag for safety purposes. Dick Tracy with his watch used to be comic book fiction.