Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: combo
  • Content: Threads
  • Order by date
  1. combo

    SQL data types in CREATE/ALTER TABLE queries

    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?
  2. combo

    'Wrong property setting' message in query

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

    Excel VBA Range.Cells.Count limitation

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

    Excel will handle dynamic arrays

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

    ADO error when filling JET database

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

    strange 0 kb size files in root directory

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

    Events in VBA

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

    UDT as class property type

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

    Random selection of items in excel - no VBA

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

    VBA/VBE/Excel - enhance macros

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

    Excel add-in installer

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

Part and Inventory Search

Back
Top