Recent content by Kowalski

I can tell that the Access and Runtime versions are the same. So if it's patch related it must be Windows I assume?

I have a strange problem. I have an Access app that has been running for many years. All of a sudden there is some subforms that display all data and does not filter according to the master record. But only on some PC's. It used to work fine on the se machines, but all of a sudden, without...

No index changes. Just a straight restore.

2011.10.7462.06

I have both. I just moved the DB from 2016 to 2019.

Hi. The SQL Server is on my local machine as it's in the dev environment. Connecting to it via odbc linked tables.

Thanks. Have not considered that. Might well be.

Not hardware resources. Interestingly, if I change from SQL2016 to 2019 the problem disappears.

I've got a weird issue that I desperately need help on. I've got an Access 365 database with a number of tables linked to SQL Server (2016) via an ODBC connection. In short the problem is that reading data from SQL is very very slow when I have a form open. When I open the database in Access...

I've upgraded an old Access 97 app to Access 2010. Now I want to replace an icon on a button with a new icon, but when I choose the new icon, which is a .png file, I get a message that: Program doesn't support the format of the file ..path...\image.png or file is too large. It's definitely not...

Tx - any setting specifically? It is correct for my country and language (English - South Africa).

I used to use commas as a parameter separator, but for some reason it is now a semicolon. How can I change it back to a comma? Currently this works: SELECT IIF(MyExpression; TrueThing; FalseThing) FROM ... Want to use (and have used before): SELECT IIF(MyExpression, TrueThing, FalseThing)...

Thanks for the replies. Just a bit of background of what I'm trying to accomplish. We have a list of personnel that all belongs to a Department. The Departments table have a field ParentDepartment in which a hierarchical structure can be accomplish. So if affect we have an organogram with...

MyTable contains 30 odd columns of which we are only concerned about 2 columns so I believe showing everything might just complicate the matter. The function also does return the expected results. The first query in my post confirms that the field ResponsiblePerson does indeed occur in the...

Hi The code for the function will be difficult to provide as it uses a whole number of sub functions and calls to other functions. I hope it will suffice to say that the value it returns looks something like: '123456','547993','753214','956156','966201','156844','112554'....... Responsible...