Recent content by pbaldy

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!