Search results

  1. G

    Reference to a list of JET/ACE functions

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

    Exchange Solar Power for Beer

    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/
  3. G

    Conditionally Enable Simulated Checkbox Implemented as a Class

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

    Pasting Dates - Why do they become formatted as Time

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

    Unexpected error when CTE used in query

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

    String_split

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

    Access bug on Update queries

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

    Porting Access VBA to VB.NET CLR Functions in SQL Server

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

    Porting Access VBA to VB.NET CLR Functions in SQL Server

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

    Single User Mode

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

    ConditionalFormat where values in two fields match

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

    Trump on Pregnancy

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

    Opening a New document from a template served by a browser

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

    Bug/ Incorrect Documentation in WeekdayName()

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

    Site problems

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

    Edit OLE Embedded Word Document In Excel

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

    Rollover banner ads

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

    MSSQL Server Studio Corrupts View

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

    Object Dependencies Tool

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

    Substitute requested data

    The database has hundreds of thousands of records holding pdf files as Attachments. These files consist of the same header image and a few kb of actual text data that varies between them. I would like to reduce this by storing the pdfs with the text data and inserting the image on demand...
Top Bottom