Search results

Welcome. FYI, I moved your thread to a more appropriate forum.

Also, is the computer logged out or locked? It should work fine locked; perhaps not if logged out.

I've always shared Pat's viewpoint. At some point in time the clump of cells becomes a life. That life is as worthy of protection before it's born as after. Debating when that point is would be just as productive as the current debates, but at least it would be more on point. Seen another...

Welcome aboard Bob!

No problem, post back if you get stuck. I have automated apps that do this type of thing.

I would open a DAO recordset on the query and loop through it, adding to the body within the loop.

Can we assume that moderator paychecks will rise a commensurate amount? :p

Happy to help!

It was an educated guess. I haven't used VB.Net but even within Access an ADO recordset requires the % where a DAO recordset (and pretty much everything else) requires the *.

Try % instead of * as the wildcard.

I will let @Pat Hartman respond, as it was her code. I just noticed you weren't using it.

Sure, copy Pat's code.

Pay attention to Pat's code. She's looping backwards, you're still looping forwards. My gut tells me you'll keep overwriting the same file since strFile never changes, though maybe I'm missing something.

Welcome aboard!

Welcome aboard Caroline! One of my daughters and her husband lived on a boat for a couple of years. Got a little too small when they had their first child. :p

Hopefully Steve replies, I've never worked with MariaDB. My first thought was TransferDatabase to import the tables: https://learn.microsoft.com/en-us/office/vba/api/Access.DoCmd.TransferDatabase Presuming that works, it would be relatively simple to drop/import the table(s) on start up.

Welcome. I moved your thread to a more appropriate forum. Note to others, this is cross posted: https://www.accessforums.net/showthread.php?t=89505 https://excelguru.ca/a-message-to-forum-cross-posters/

That expression is also used in the US, and I've heard of the steam engine self-regulating mechanism as the origin.

If password is a numeric field try If IsNull(DLookup("userID", "tbluser", "username = '" & Me.txtUserName & "' and password = " & Me.txtPAssword)) Then

Welcome aboard!