Search results for query: *

I found a list a list of Access SQL data types from MS here. However, this article refers to Access 2013. In the meantime Access introduced large number and extended datetime fields handling. Is it possible to generate new types fields with access query, if so - what type names should be used?

Scenario, Access 2016: I have an intermediate query that combines required data, with ~50 kRecords in output. It runs without problem. This query is used as input in two other queries, one with more details, ~100 records, and the second, a copy of the first one and removal of two aggregation...

Some worksheet events expose Target As Range argument to check processed range before executing the rest of code. In one of my old workbooks I had, to first check if one or more cells were selected: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) If...

Misrosoft is testing dynamic arrays in excel. Currently they are available for users in Office 365 Insiders Program. This seems to be very useful feature, it will allow to solve a a lot of tasks with lists, also asked on this forum, in seconds. A preview of this feature is here. combo

I am creating JET database (excel VBA, ADOX) and populate tables with code (excel VBA, ADO). The code stops after writng part of the data (in the example below: i varies within 8000-12000), due to lock, error no. 80040e21. Both tables are in the same database, they are populated paralelly. There...

Win 98SE, IE6, AVG7 av software. Occasionally 0 kb size files are created in the root directory, with variable length filenames, that look like a part of system or help files. No errors reported by scandisk, no viruses, no ad software. Anyone knows the reason or solution? Thanks in advance. combo

Hi, like many others, after over one year of frequent posting, I will not be able to be here so often in the future (in practice my answers have already been limited for some time). As a tribute to nice TT society, welcome to my four-part FAQ on events – partly a result of some posts here, not...

Hi, Suppose I have UDT: UDType Enabled as Boolean Value as Double ObjValue as Object End Type Having private UDType variable "iUDTypeVariable" in the class module to store values, is it possible (if so, how?) to define "UDTypeProperty" Property Let/Set and Get...

Random selection of items in excel - no VBA I've just found an easy way to randomly (pseudo!) get, on demand, any subset of given items. Their type does not matter. Suppose we want to get two random unique integers between 1 and 5. Starting from A1, the formulas are (column 'C' is empty)...

Excel interface offers Tools>Macro>Macros dialog (options button) to add descriptions and hotkeys to subs and functions (functions cannot be selected, but are accessible after writing their names). Function description is next visible when creating function with function wizard. VBA offers more...

Here's the way I implemented to distribute excel add-in file. Necessary tools: - file (1) - excel add-in ("addin.xla"), to be updated/installed, - file (2) - excel file ("TheFile2.xls") with supplementary code, - installer, here used free Inno Setup from...