Search results

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

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

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

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

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

Hi I have a Make-Table query, that pulls info from a number of subqueries and tables. When I run the query normally, it takes about 1 second to create and populate the table. But when I tun the same query via VBA like: CurrentDb.Execute "MyMakeTableQuery" then it takes about 10 seconds. The...

Is it possible in Access 2010 to change the theme for a single form? I do not want the theme for all my other forms to change, but only for 1 specific one.

I installed Access 2010 Service Pack 2 today, and now it seems like Access is corrupt. Even when I create a new database, create a form, add a button and try to set a picture to the button, I get The database cannot be opened because the VBA project contained in it cannot be read. The database...

How do you search for any number of numeric characters using wildcards? The # symbol only searches for 1, and * obviously includes letters. Example: I have: D1234 D3 D5336767 D123F My search should only retrieve the first 3 values. WHERE FieldName LIKE 'D[0-99999999]' does not seem to work.

I would like to get the Min + Max values of the data currently in the form, but without changing the sorting currently on the form. So I was hoping for this, but it is not working. The data in the recordset are not sorted. Set R = Me.RecordsetClone R.Sort = "SendOn ASC" R.MoveFirst MinDate =...

Hi Is it possible to have a dynamic whereclause to a query? I.e. one that is generated by a Function? E.g. SELECT a, b, c FROM MyTable WHERE GetWhere() GetWhere will then return a string like 'a > 3 AND b < 3' I have tested this scenario and it is not working, so maybe there is some work around?

Hi. Funny one, and lots of kudos for the one who can answer me :) I have a Access 2010 form based on a query (3 tables). When closing the form, the forms takes long to close (5 seconds) and says 'Running Query' in the status bar. If I change the query a little bit, it works fine. The funny...

Hi I have a graph on my form, an Update/Refresh button, and a textbox that display a calculted value. The textboxes controlsource is "=GetMyValue()" Now when I click the Update button on the form, I would like to have the graph to refresh first, and then the textbox should update its value by...

Hi I have a graph object on a form. When the form is resized, I set the chart properties in code to make the graph and the PlotArea wider to fit the form. However, at some point the Graph object and the PlotArea goes wider, but the ChartArea stays the same. See screenshots below. If I try to...

Hi We've got a couple of dialogs that we are opening from the windows API, for example the File Dialog and the 'Select Color Dialog'. It works fine in Windows 32 bit and 64 bit, but if you install Office 64 bit it fails. It asks that you add the PtrSafe keyword to your declarations. If I do...

Can anyone give me any reason why I should go to Access 2013 instead of 2010. Or more simply, are there anything new in Access 2010 for desktop apps? As far as I can see all the new features are for the Access Web Apps, but you cannot use VBA in that (or can you?). I can't see a single new...

Hi I upgraded my system to Windows 8 and Office 2013, and it's now 64 bit instead of 32 bit as before. Also note that I'm still using Access 2010 as before. So the following problem now arise in this new config that was not there before. When you do a calculation like '332.16 - 1', the answer...