Search results

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...

Hi I have Access 2010, and found an interesting thing. Any explanations? If I run this query SELECT Reference, InStr(1,FunctionThatReturnsLongString(), ResponsiblePerson) As MyField FROM MyTable WHERE (Reference ='ShouldBeOut' OR Reference = 'ShouldBeIn1' OR Reference = 'ShouldBeIn2') It...

Hi Is it possible to spell check a single word using VBA? I've got a table with a word in column A (1 word per row). I would like to update column B on whether this word is spelled correctly, but I can't find a way to run the spellchecker via VBA and return true or false. I see that you can...

Hi. I get an error when trying to install Access Runtime 2010 on Windows XP. The machine has Office XP installed with Access 2002. The log file gives me an error: OPatchInstall: Thrown CDetectionExceptionWin32(5) See log file below: On screen error message is: "The installation of this...

Thanks - but that's not it. All my other reports perform as expected, it's only that one. If I add it for a form, the form is also slow. Strange.

I'm using Access 2010 to connect to a SQL database. I created a query that reads data from 5 subqueries (all in Access). The query performs great and return the 30 odd rows in 1 second. But when I create a brand new report, and add my query as the RecordSource (no filters or groupings), the...