dcsimg

Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.62 seconds.

  1. Re: How to apply an incremental variable to a formula

    Urgghhh
    A Formula assigned from VBA-code to a cell should never go the "Value"-Property but to "Formula" (Or "FormulaLocal" if you used localized function-names).
    Depending on the Formatting of the...
  2. Re: Should vb6 Strings be converted to byte arrays when using Com port communication?

    It's not, at least acc. to your description.

    Your statement, that it works with dot Crap specifically mentiones manufacturer's machine --> and not your own.

    Maybe the "receiving" device has...
  3. Re: MSHFlexGrid - License Info Missing

    Format C:
  4. Re: Should vb6 Strings be converted to byte arrays when using Com port communication?

    Endianness?
  5. Re: How to catch a cancel button in common dialogue without error handlers

    IIRC, the OpenDialog-Object has a FileName-Property, in which the chosen FIle-(name) is returned to do with it whatever you wish.
    Without having tested it, on a "Cancel" the Property should be...
  6. Re: VBA CountIFs - What am I doing wrong

    Could you post a sample-workbook?

    EDIT: Think i found it (at least directly inside the Sheet)
    =COUNTIFS(rngSet,">=1",rngSet,"<=9")

    You still can only use 1 criteria per Range, but you just...
  7. Re: [RESOLVED] Giving access to Excel only to users who are member of groups, calling

    Well, a case for debugging.....
    Up front: I'm no expert for SQL-Server.
    The first thing i noticed:
    1) Your UDF's name is [dbo].[check_windows_group] but your call to it is...
  8. Re: Is it possible to add an enumerator to an array?

    Arnout,

    yeah, kind looks familiar with the mentioned hacks
  9. Re: Is it possible to add an enumerator to an array?

    IIRC, it works for your own "Collection"-Classes, too (independent if internally it's a collection or an array)
    I remember doing something like that some 15 years ago, but i don't have the...
  10. Replies
    7
    Views
    254

    Re: ToolTip on Menu Item

    Couldn't edit my post:
    WOOOPSS!
    Just saw qvb6 said the same
  11. Re: Is it possible to add an enumerator to an array?

    IIRC, it is possible, but as a Property Get not a Function
    I think it was something like this:
    Tools|Procedure Attributes then click Advanced
    Select NewEnum
    Set Procedure ID to -4
  12. Replies
    7
    Views
    254

    Re: ToolTip on Menu Item

    Why would a Menu-Item not have a Handle?
    GetMenu to get the Top-Level-Menu-Handle --> https://docs.microsoft.com/en-us/windows/win32/api/winuser/nf-winuser-getmenu?redirectedfrom=MSDN
    GetSubMenu to...
  13. Replies
    6
    Views
    289

    Re: VBA 7.1 Overflow Error

    No, you are the Lord and Master of your variables.
    It's your job to handle them correctly.
  14. Replies
    10
    Views
    238

    Re: Sql Server copying table

    tg, true.
    What actually baffles me (and i repeat myself: no practical experience in MSSQL): I know from SQLite and MySQL, that i can get a "CREATE"-Statement for any table (at least in DBBrowser for...
  15. Replies
    6
    Views
    289

    Re: VBA 7.1 Overflow Error

    Just to get something out of the way: replace your single-variable with a currency one (or change them all to double)

    EDIT:
    Just noticed something: On which locale are you?
    I'm on german locale,...
  16. Replies
    6
    Views
    289

    Re: VBA 7.1 Overflow Error

    InputBox returns a String, and you're assigning it directly to your variables which are currency and single, using the implicit typecast.
    before your problematic line, insert a temporary...
  17. Replies
    20
    Views
    447

    Re: Exiting a Nested For/Next Loop

    Because it's bad practice, prone to buggers....errrr... bugs, and if you're not careful, your software is going to cause a nuclear launch in North Korea....
  18. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    Couldn't edit my post

    SET TO NULL --> "wuaaaaaaa. My Parent got deleted. I've got nowhere to go. Noone loves me" --> that would be an orphan
    SET TO DEFAULT (not NULL) --> "Eh? My parent got...
  19. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    Ahh, that's nice! In comparison, SQLite has managed to drive me barmy sometimes with its behaviour, until i figured it out
  20. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    Just create a Parent-table with an Integer IDENTITIY-Primary Key, a child table with its own PrimaryKey, a Foreign Key pointing to the Parent-PK with DELETE Constraints (see my link above --> i think...
  21. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    How do you figure that????
    https://www.sqlshack.com/delete-cascade-and-update-cascade-in-sql-server-foreign-key/

    Take a look at the third screenshot on that link
  22. Replies
    20
    Views
    447

    Re: Exiting a Nested For/Next Loop

    So you actually want to jump two "For"-Levels out.
    It boils down to the age old "Flamewar" about the missing "Continue"-Statemtn which has been discussed to death here in the forum :D
    In case of...
  23. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    There should be two other choices as well: Set to NULL and Set to Default.
    Don't forget them! Even if they are used once in 100 leap years, but maybe in the end it's the one feature, the dba is...
  24. Replies
    10
    Views
    238

    Re: Sql Server copying table

    That's why i said to write a parametrised SP with an IN-Parameter
  25. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    On thing you sould try on a "dummy"-database:
    I know from SQLite (i have no practical experience whatsoever with MSSQL), that if you have designed a parent-table (with PK), and a childtable (with FK...
  26. Re: Old School Database question - Genius needed!

    ....what i said....SQL that thing....
  27. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    Something else you might consider an "unusual choice" for PrimaryKey:
    In Germany, when you order a Pizza for delivery to your home, you get asked (very often) for your phone-number (funny enough:...
  28. Replies
    10
    Views
    238

    Re: Sql Server copying table

    Or write a stored procedure with an IN-Parameter being the new tablename...
  29. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    PK, yes, the age old problem with "why would i change a PrimaryKey?"
    Try to think this way:
    If you take an IBAN for example (International Bank Account Number), it always start with 2 characters,...
  30. Re: Old School Database question - Genius needed!

    dee-u,
    ok, i misread something.
    Yes, he needs ADO to access that thing from VB6, but in his post he mentiones the .index and .seek methods of the Recordset-Object.
    My Statement, why not just SQL...
  31. Thread: Foreign keys

    by Zvoni
    Replies
    23
    Views
    337

    Re: Foreign keys

    Peekay,

    look here: https://www.sqlshack.com/delete-cascade-and-update-cascade-in-sql-server-foreign-key/
  32. Re: Old School Database question - Genius needed!

    Err? How is Field 1 supposed to contain BOTH values Cat + Dog (at the same time)?
    As for your criteria: Only OR makes sense
    Field1 contains Cat OR Dog
    Field2 contains Frog OR House
    Field3...
  33. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    There you go:
    https://www.sqlite.org/rowidtable.html
    https://www.sqlite.org/autoinc.html
  34. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    To avoid misunderstandings (AFAIK this pertains only to SQLite): On such tables i don't use AUTOINCREMENT, but i do use PrimaryKey-Columns the classic way (Integer-Column, PrimaryKey, NonNull, Unique...
  35. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    Funky,
    i want to amend my Statement: You're right, of course!
    In SQLite i don't use AUTOINCREMENT on tables which either are
    1) a solitairy table (PK is not pointing to a FK anywhere)
    or
    2) if a...
  36. Re: VBScript.RegExp can not recognize the pattern "[^]"

    Even with my extremely limited knowledge of RegEx, i think the Cap-Symbol ^ should never be alone in a pattern, since it's the negation-operator to character-classes.
    So a Pattern "[^]" should...
  37. Re: Automation Error -2147417848 The object invoked has disconnected from its clients

    If you get the same error on that debug-line as before, then it's not your html_Gallery-Object, but your Document-Object.
    Going by the description of your original problem, it sounds as if...
  38. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    Tyson,
    that's the reason why i've stopped using AUTOINCREMENT in SQLite.
    Theoretically (!!!), you could get into the situation, that you have a table, which has been filled up with 2,147,483,648...
  39. Replies
    24
    Views
    302

    Re: SQL Server not increasing by 1 but by 100

    Maybe this workaround?
    http://www.jochenhebbrecht.be/site/2015-03-06/database/sql-server-2012-auto-identity-column-value-jump-issue
  40. Re: why do I use SQL Server Management Studio to update a row of a table in SQL Serve

    Or they shouldn't give him access to SSMS in any case if he doesn't know such basic things.....
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width