Search results

Suddenly, sometime between 5 Oct and yesterday, the Workbook path property is returning NullString. Application.Workbooks(ThisWorkbook.Name).Path Also happens on a new workbook with the expression run from Immediate Window. No updates to Windows or Office 365. What else could cause it?

Does anyone have a reference with a definitive list of the Jet/ACE engine functions? Following up from this thread it seems some developers don't realise the standard functions used in queries are NOT the VBA functions that have the same names, but are integral to the engine itself. I tried to...

Surely a world first. In Australia we can directly exchange our solar power for beer. This is the perfect system since more sun buys more beer. https://www.vbsolarexchange.com.au/

The attached demo is my version of a simulated checkbox with conditional enabling implemented using a Class. It is precisely designed to emulate the focus behaviour of a checkbox. It shows little bit of flicker on update but I think that is not unusual with Conditional Formatting.

When pasting data from SQL Server query results into Excel, dates always become formatted as Time even when the column has already been explicitly formatted as Date. Office applications can make some really dumb decisions trying to second guess what is required but this one is ridiculous. The...

I have a CTE I want to use in a big query. The CTE works perfectly. The big query works perfectly until I join in the simple subquery that uses the CTE. Once combined, the big query returns two records then throws an error: 'Cannot convert a char value to money. The char value has incorrect...

We upgraded our SQL server recently and today I found a feature we didn't have before that is making my life very easy. STRING_SPLIT is does what it says with a nominated deliminator just like VBA Split() except it returns a table with a separate record for each item.Microsoft introduced it in...

Microsoft has advised of this Access bug in the recent updates. It affects UPDATE queries and displays an error saying the query is corrupt. https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

I posted this over in SQL Server section but it is relevant to Access developers interested in porting VBA functions for use in SQL Server back ends. Best add any discussion over there. https://www.access-programmers.co.uk/forums/showthread.php?t=305744

Today I opened a door in SQL Server and discovered a whole extra wing of machinery, particularly useful for Access VBA developers using SQL Server back ends. Turns out it is quite easy to port VBA code into SQL Server functions and gain a whole lot of performance improvement on the way. CLR...

I was having problems obtaining a lock on a table in a multiuser database. I connected as dbo via Management Studio on the host server machine and changed the Restrict Access Option to SINGLE_USER. The warning was displayed that all other connections would be dropped and the database then...

Conditional Formatting a table. I want values in a field to be highlighted where they are equal to a value in the same record of another field. I know I have done something similar before and it automatically propagated to the whole field. I am pretty sure the expression changed to a field...

Giving birth in the ninth month is wrong and has to change. https://www.facebook.com/PokeHQ/videos/1977347935638823/

Is there a way to serve an Office Template document via Internet Explorer so that the client's office application will open a new document based on the template without having to go through the extra step of downloading the template file to a location then double clicking it there? We have...

As documented, WeekDay() uses a default of Sunday for the first day of the week. The documentation for WeekDayName() also claims that its default for the first day of the week is Sunday. This is incorrect. In fact WeekDayName() uses the System Regional Setting for First Day of the Week. This...

Since yesterday my posts are dropping the carriage return/linefeeds as they post. I noticed this in IE11. I also cannot use the Insert Link button. This problem is with both IE11 and Chrome.

I am trying to edit a Word form letter embedded in an Excel 2010 spreadsheet. I seem to be ending up in a state somewhere between what happens when selecting Edit and Open from the Document Object context menu on the embedded object. With the code below I can get the document into a Word...

I know the site runs on advertising but I am finding the rollover banner ads quite annoying as I move to the menus from the body of the page. Are other uses getting this too? I guess if we are stuck with this arrangement then I will get accustomed to going around them.

When I use a CTE in a View, and open it in Design mode, MSSQL Server Studio 2008 says it cannot represent the SQL text in the grid and diagram panes. That wouldn't matter except it and strips out the first of the parts it can't handle (WITH whatever AS), turning perfectly valid SQL into...

I changed one of the base queries of many of my report queries from a local Access query to an SQL Server View. To be sure, I decided to check the Object Dependencies before I deleted the original base query. It still says the queries depend on the old base query yet the SQL clearly does not...