Search results

I use: lngLastRow = xl.Cells.SpecialCells(11).Row

You can change an option but that only fixes it on your computer. https://www.baldyweb.com/SQLWarnings.htm

I'd use this which would be more flexible (any number of inputs): http://allenbrowne.com/func-09.html

Sorry, I missed the big picture.

How about .Fields("ReleaseSingleEntry") = Me.chkReleaseALL

I suspect the Nz() function is causing the variables to be seen as text. Try D1 = CDate(Nz(D1, #1/1/2999#))

No, one was at Mildenhall the other at Lakenheath.

My daughter is an officer in the US Air Force, as is her husband. Years ago they were stationed in England for 3 years. Her squadron gave her a truncheon as a going away present. It was engraved with a "thank you..." message, etc. Clearly a souvenir. Airport security at Heathrow found it in...

Also make sure it didn't get undocked and sitting behind the form or something.

Can you post a pic of the entire Access window after clicking on Properties?

At first glance you may think the properties window is gone here, but if you look closely you can see the edge of it has been dragged very close to the edge of the Access window.

Make sure the edge didn't get dragged all the way to the side of the screen. If it has, you should be able to grab it and widen it back again.

That's okay Jon, no judgment here. This is a safe place. 😀

Welcome aboard!

No worries, you're not the first. ;)

FYI you clicked on Report instead of Reply with your first reply. No worries.

No problem, good luck. Moke knows his stuff.

Sure, but on the original thread, not here.

No worries, it's just a courtesy. That second link explains it better than I can.

I meant the quality of the product, not the location of the source. :p