Search results

I have been tearing my hair out with this so I hope that someone can help. I have an Access front end linking to MySQL server tables, via connection string (dsn-less connection). I regularly change the username and password and refresh the connection using this code:- Dim Dbs As Database...

I am struggling with OrderBy and OrderByOnLoad and would appreciate some help. It seems that everytime the user sorts on a column of a query, the sort order is added to OrderBy field property and is saved if the user "Saves Changes" on exiting the query. Next time, the sort order is added to...