Recent content by cheekybuddha

Yeah, you used code tags, but where are the emoticons? 😝 :ROFLMAO:

12 more posts and then you can post links (unless the threshold has increased from 100)

Yes, I already found it, and made another whole post that seems to have disappeared :unsure: Probably lost by a mod trying to move this part of the thread out of the Introduce Yourself board. (Or perhaps I never hit 'Post reply' and refreshed my browser? 😬 )

There is no Access backend

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