Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.21 seconds.

  1. Replies
    5
    Views
    161

    Re: Getting row value from another value

    Ah, well. I stand corrected.

    In that case: Full steam ahead.....
  2. Replies
    5
    Views
    161

    Re: Getting row value from another value

    Or if you use a regular ComboBox you can use the ItemData-Property to store the ID while you populate your ComboBox.
    Nota Bene: IIRC, the ItemData-Property is Type Integer, so careful with values...
  3. Re: how to make tlb by vb6 for Declare windows api

    https://classicvb.net/hardweb/mckinney2a.htm
    Scroll down to Chapter 2 - Page 46
  4. Re: how to make tlb by vb6 for Declare windows api

    Agree with baka.

    another bottleneck is the algorithm itself.
    nested loops come to mind.
    or harddrive-access
  5. Re: how to make tlb by vb6 for Declare windows api

    Why would you delete an entry? Whatever for?
    You only need a TLB during developement (a.k.a. you don't have to ship it with your app), and only those entries you actually use in your app get...
  6. Re: how to make tlb by vb6 for Declare windows api

    I remember Bruce McKinney providing "his" source-code for "his" WinApi-TLB in "Hardcore Visual Basic".
    I took that as a starting point and wrote my own TLB for the ODBC-dll, basically doing what...
  7. Re: Any troubleshooting ideas to solve CR causing VS crash?

    I remember doing some tests with a Label-Printer (instead of "regular" Laserprinter) and i encountered something similiar, since the printer-driver seemed to be very picky about sent parameters.
    1)...
  8. Replies
    18
    Views
    704

    Re: Is vb6 really native ?

    You want to put money on that statement?
  9. Re: SHChangeNotify for adding and removing disks

    I've seen a lot of posts about "mounted" network-shares/external sites (ftp) which still show in Explorer but which are definitely disconnected.
    By any chance: Is your K-Drive showing a red X in...
  10. Replies
    18
    Views
    704

    Re: Is vb6 really native ?

    wqweto, thx.
  11. Replies
    18
    Views
    704

    Re: Is vb6 really native ?

    From the sidelines: you'll only get a "native" executable, if you actually activate "native" compiling in Project Options
    IIRC, the Default is P-Code

    But i admit: I have no idea if that makes a...
  12. Replies
    12
    Views
    417

    Re: GetFileSize - What is the best code?

    Errr?
    DiskCapacity - FreeSpaceOnDisk?
  13. Replies
    9
    Views
    423

    Re: Autocomplete only considers the 1st letter?

    How about "forcing" the ComboBox (if it is a ComboBox) to search for the Edit-content in the List?
    SendMessage with CB_FINDSTRING as constant
    ...
  14. Re: adding the shortcut CTRL+P in order to print a form

    Create a Menu, assign CTRL+P as shortcut to the MenuItem, write code to print in the Event-Handler.
    Optional: Set Menu invisible
  15. Thread: Listview problem

    by Zvoni
    Replies
    3
    Views
    290

    Re: Listview problem

    Huh? How is that not enough?
    One of the easiest things to do with a ListView

    IIRC, the Property of ListView.SelectedItem returns the Item for the currently selected item/row (Don't start with...
  16. Replies
    10
    Views
    331

    Re: Current User inside Trigger Mysql

    Ken, as a last thing you should maybe try:
    What about multiple Users at the "same" time?
    have you tried the same with 2 (or more) Users logged in at the same time, and firing Updates against that...
  17. Replies
    10
    Views
    331

    Re: Current User inside Trigger Mysql

    Ah, OK

    Found something:
    https://stackoverflow.com/questions/45979390/get-current-user-in-mysql-trigger-returns-incorrect-value
    https://dev.mysql.com/doc/refman/5.7/en/information-functions.html...
  18. Replies
    10
    Views
    331

    Re: Current User inside Trigger Mysql

    That's because your "client" probably uses an Application-User (vs. a "real" MySQL-User).

    OTOH, if users have to provide login-data on the client-side, there's probably a user-table somewhere in...
  19. Replies
    3
    Views
    202

    Re: Syntax error in FROM clause

    Nevermind that everybody knows now, that his Database is a mdb-Access-File, which is on the Desktop of User "Dennis" (his first name?)
  20. Replies
    3
    Views
    202

    Re: Syntax error in FROM clause

    Use code-tags.

    As to your error:
  21. Replies
    10
    Views
    462

    Re: why loop_2 is faster more than loop_1?

    For me loop 2 is faster than loop 1

    At a guess (and probably wrong by a wide margin):
    id(i) is nested within ccc as a "calculated" Index, and in loop 2 i is accessed "directly" within the loop...
  22. Re: how do we fill in school.xlsx file age column from age.xlsx file by using name co

    Why in blazes VBA?
    That's a simple vlookup
  23. Re: Using registry to determine Window's OS name, any downside?

    Nothing wrong there.
    Might take a look at this: https://stackoverflow.com/questions/31072543/reliable-way-to-get-windows-version-from-registry
  24. Replies
    6
    Views
    310

    Re: MSSQL Login for Stored Procedure

    Quick question from the sidelines: In which context is a SP executed?
    Let's stay with the requirement:
    User shall have GRANT's (only those) to execute, create, change and delete a (specific) SP
    ...
  25. Re: Quantum Resonance Magnetic Body Analyzer 52 Reports MINI - error message

    Is it even VB6?.....
  26. Re: Allow users to build WHERE clauses

    I feel you.
    I've had users trying to formulate such a WHERE-Clause running into a "deadlock" (at least i call it a deadlock --> basically the one filter excluding the other) returning an empty...
  27. Re: Allow users to build WHERE clauses

    Do you mean like providing a TextBox the user can enter "WHERE Salary>=2000"?

    I'd rather first check, if the way i'd usually do something like this would be feasable (if i ever would get such an...
  28. Re: VB6 QUESTION: Detecting when PC comes back from sleep mode

    Use the API
    https://docs.microsoft.com/en-us/windows/win32/api/powerbase/nf-powerbase-powerregistersuspendresumenotification?redirectedfrom=MSDN

    Or by subclassing:...
  29. Re: Does New-Basic really need class inheritance?

    The age-old question........
    For what it's worth: IMO inheritance is a basic principle, which should be implemented in any language, which wants to be taken seriously.

    Example:
    Base class...
  30. Replies
    10
    Views
    1,031

    Re: Cannot debug 'Subscription out of range error'

    Yes, you're right.
    Got confused with it. I rarely use Ranges in my VBA
  31. Replies
    7
    Views
    386

    Re: VBA Function returns 0

    Which solution are you using?
    If you use mine, you shouldn't assign the result of the StrSpn-API-Call directly to the Function-Result (as in my example, that was quick and extremely dirty!)

    It...
  32. Replies
    10
    Views
    1,031

    Re: Cannot debug 'Subscription out of range error'

    Yes, that's possible to "interpose" the Range-Object there.
    The Cells following after it are then refering to the Range, not the Sheet (Think as in "offset").
    Cells(1,1) would be the Top-Left cell...
  33. Replies
    10
    Views
    296

    Re: Delete all records in a table

    Gary, thx.
    As i said: Never had/used SQL-Server, so i'm not familiar with the intricacies/pitfalls of it

    But, as i said: as long as that table is NOT a Parent/Master to a Detail-Table.....
    ...
  34. Replies
    10
    Views
    296

    Re: Delete all records in a table

    You're welcome.
    Any thoughts on my DROP TABLE/CREATE TABLE Approach?
    Wouldn't mind some performance-results with a few 100K/1M rows
  35. Replies
    10
    Views
    296

    Re: Delete all records in a table

    To me it actually makes perfect sense, to not use the '*' in the DELETE statement (contrary to a SELECT).
    In a SELECT i can choose which columns to show, or all with '*'
    But in a DELETE i will...
  36. Replies
    10
    Views
    296

    Re: Delete all records in a table

    Have you tried "DELETE FROM dbo.CellNumbers"? No Asteriks
    https://docs.microsoft.com/de-de/sql/t-sql/statements/delete-transact-sql?view=sql-server-ver15


    EDIT: If that Table is not a...
  37. Replies
    10
    Views
    1,031

    Re: Cannot debug 'Subscription out of range error'

    Eh, no!
    The OP correctly states using Type 8 in the Inputbox
    Look here: https://docs.microsoft.com/en-us/office/vba/api/excel.application.inputbox
  38. Re: VB6 application not connecting to Access database 2016 in windows 10

    ... or throw Micro s h i t where it belongs, and use sqlite for local, filebased database
  39. Replies
    10
    Views
    1,031

    Re: Cannot debug 'Subscription out of range error'

    What are the values for i and j when your code throws the error?
    And how many Columns and Rows does that Range have?
    If you have a Range, say A3:B4, you have 2 columns and 2 rows, but your Loop...
  40. Re: is there other Copymemory faster than WinAPI ?

    I'm trying to understand what you're trying to do.....
    Looks like "shifting" an array "down" an element (a.k.a removing first element)
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width