Recent content by cheekybuddha

I'd cut Access out of the loop completely!

🤪😝 That's just daft!

Very interesting. I didn't know that the CurrentProject object had a .nam property.

Which version of the MySQL docs are you looking at. In most recent 8.4, the section you mention no longer exists: Show us the code you are using and tell us where it fails. There can be many points of failure, eg open ports on server, ODBC options and connection string, etc , etc ... What...

Me too! 🤣

Don't be lazy, Piet! 😂 Use code tags! 😵

Do you have Option Explicit declared at the top of all your code modules? ' ... MsgBox "No records for " & strCriteria, vbOKOnly, CurrentProject.nam ' ... Does that code compile?

Have you got Unload code to close and destroy the recordset object variable? Or are you just using the form's recordset via RecorSource?

Further to above, what happens in the subform? You say it's not bound. Are you using a recordset within it? Perhaps you're not destroying them properly, causing a memory leak?

' ... Me.frmImageFiles.SourceObject = "sfrmImages" 'name of the form to load in sfrmSubform2 control ' ... Probably not related, but do you really want to reload the subform on every record move? Perhaps better: ' ... If Not Me.frmImageFiles.SourceObject = "sfrmImages" Then...

Actually, this is not true. I used to think so for years until it tripped me up! A Variant defaults to Empty. Try the following in the Immediate Window (no need to declare variable 'test', it is a Variant by default): ?IsNull(test) False ?IsEmpty(test) True

Your code as is, without assigning the value of ss before reading it, will go down the false path. The variable ss will default to false when dimensioned. This will show you more clearly: Dim ss As Boolean if ss then msgbox "ss is True" else msgbox "ss is False" end if

Daniel Pineault has written something about this. (I haven't read it yet! 😬 )

Th OP said they didn't have a facebook account, not that the link went to a facebook page ;)

@DHookom Your link requires signing up to access your file: