Search results

Welcome aboard Ricardo!

Welcome Andy!

Welcome Heide!

Completely agree. A Tesla in our area in self-driving mode failed to merge out of a lane that was ending. Drove up on the curb and had a close encounter with a pole. Never slowed down or swerved.

My first thought isn't code, it's a query against a table with the 36 values, getting a Cartesian product. A quick example using a table with the 24 hours: SELECT tblHours.StartHour, tblHours_1.StartHour FROM tblHours, tblHours AS tblHours_1 This produced the expected 576 records.

You've reversed the arguments: https://www.theaccessweb.com/general/gen0018.htm

Welcome aboard!

I've been using DSN-less linked tables for awhile, but if memory serves when you link a table via the ODBC data sources, there's a checkbox somewhere along the line that lets you save the password.

Welcome aboard!

Working code with personal bits removed: Option Compare Database Option Explicit Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup directory. Const cdoSendUsingPort = 2 'Send the message using the network (SMTP over the network). Const cdoAnonymous = 0 'Do not...

It does not work for me, using my creds and From address.

I use Daniel's code with O365: https://www.devhut.net/vba-cdo-mail/

The only way to get an accde to run on 64bit Access is to create it with 64bit Access. Do you have a computer available with that?

Is the subform's Allow Additions property set to No by chance?

Welcome aboard!

I've only scanned the article, but I don't see the connection to Covid. They mention a freeze in screenings that started in 2012.

Welcome. FYI I moved your thread out of the intro forum.

I would have stayed with 32bit in the Vegas office but IT there went to O365 64bit for all the users, so I had to switch as well. I think it (the 64bit decision) was because of a few heavy Excel users, but I'm not really sure. As we all know it doesn't really benefit Access.

I develop for operations in 2 cities. In one I have 32bit 2016, in the other I got forced on to O365 64bit. The 64bit conversion wasn't bad, but I hate being on the bleeding edge updates-wise. I've already been bitten by a couple of update related bugs.

I have no knowledge on the subject, but I would speculate that military aircraft need the ability to turn it off if, in a combat situation, it would broadcast their location. Not good if the enemy can see where you are. That said, I can think of no reason it should have been off in this situation.