Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.40 seconds.

  1. 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)...
  2. Replies
    18
    Views
    667

    Re: Is vb6 really native ?

    You want to put money on that statement?
  3. 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...
  4. Replies
    18
    Views
    667

    Re: Is vb6 really native ?

    wqweto, thx.
  5. Replies
    18
    Views
    667

    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...
  6. Replies
    12
    Views
    391

    Re: GetFileSize - What is the best code?

    Errr?
    DiskCapacity - FreeSpaceOnDisk?
  7. Replies
    9
    Views
    397

    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
    ...
  8. 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
  9. Thread: Listview problem

    by Zvoni
    Replies
    3
    Views
    275

    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...
  10. Replies
    10
    Views
    304

    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...
  11. Replies
    10
    Views
    304

    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...
  12. Replies
    10
    Views
    304

    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...
  13. Replies
    3
    Views
    187

    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?)
  14. Replies
    3
    Views
    187

    Re: Syntax error in FROM clause

    Use code-tags.

    As to your error:
  15. Replies
    10
    Views
    431

    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...
  16. 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
  17. 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
  18. Replies
    6
    Views
    276

    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
    ...
  19. Re: Quantum Resonance Magnetic Body Analyzer 52 Reports MINI - error message

    Is it even VB6?.....
  20. 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...
  21. 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...
  22. 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:...
  23. 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...
  24. Replies
    10
    Views
    1,011

    Re: Cannot debug 'Subscription out of range error'

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

    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...
  26. Replies
    10
    Views
    1,011

    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...
  27. Replies
    10
    Views
    264

    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.....
    ...
  28. Replies
    10
    Views
    264

    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
  29. Replies
    10
    Views
    264

    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...
  30. Replies
    10
    Views
    264

    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...
  31. Replies
    10
    Views
    1,011

    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
  32. 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
  33. Replies
    10
    Views
    1,011

    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...
  34. 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)
  35. Re: is there other Copymemory faster than WinAPI ?

    I'm trying to understand what you're trying to do.....
  36. Replies
    7
    Views
    361

    Re: VBA Function returns 0

    Yes, you're right.
    I edited my post, and i forgot that one
  37. Replies
    7
    Views
    361

    Re: VBA Function returns 0

    Assuming numeric Portion is at the beginning/left of the string:
    No Error-Handling whatsoever!


    Private Declare PtrSafe Function StrSpn Lib "SHLWAPI" Alias "StrSpnW" (ByVal lpSource As LongPtr,...
  38. Replies
    9
    Views
    442

    Re: get data from html table

    That's Excel-VBA (see that "Sheets(1).Cells-Thingy?)
    IIRC, each Cell on a Worksheet has a Hyperlink-Property and an Event FollowHyperlink
  39. Replies
    8
    Views
    270

    Re: Open file with specific application

    GAHHH!!!

    I'm an Idiot!

    Which "Directory" did i have opened in the Registry? Correct, HKCU .......

    *SlamHeadOnTable* *facepalm*
  40. Replies
    8
    Views
    270

    Re: Open file with specific application

    Company-Laptop. I'm definitely NOT going to step into that minefield......
    I'm at odds with our IT-Department enough as it is.... :D
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width