Search results

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!

Happy it helped!

You got it. ;) I unsubscribed after Adam answered and will again after posting this, so forgive me for that. :p I probably fall into the "spiritual but not religious" camp. I don't believe any of the books are "divine", they're written by people trying to understand the unknowable. I simply...

If all you want is to see if anything is selected: If ctl.ItemsSelected.Count = 0 Then

Adam, I'm wondering how your priest/preacher/God would feel about your calling people names. Not favorably I'm guessing. You can treat people with respect even if you disagree with them.

Will you be able to tolerate taking 4 hours to play instead of 30 minutes? :ROFLMAO:

Happy to help! I also mentioned trying that back in post 6. ;)

Again, it's not required. See post 14.

I create PDF's on this computer all day long, printers below. Can you open the report manually? If so try creating a PDF from print preview.

It would need to be CLng(). ;)