Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: [RESOLVED] Type Mismatch problem regarding an If Else statement

    Does anyone remember the "Rem"-Keyword?
    It still works in vb6.....


    Sub Main()
    Rem This is a comment

    End Sub
  2. Re: [RESOLVED] Type Mismatch problem regarding an If Else statement

    And exactly because of that i declare all my variables each in its own line, and i'm making no difference which language i use (C, VB, Pascal)

    Ask yourself a question: What's more important for...
  3. Re: [RESOLVED] Type Mismatch problem regarding an If Else statement

    ...and V and B are not Strings, but Variants
    and just reading that code-snippet i have no idea how V and B can be anything else than empty
  4. Replies
    3
    Views
    151

    MsOf365 Re: Delete blank columns with VB.NET

    Go backwards through the columns
    You're going forward from 1 to Count, but by deleting a column you change the count (Deleting column B means Column C shifts one to the left and becomes Column B)...
  5. Replies
    5
    Views
    218

    Re: Trickish Situation With Data Range Search

    Because it's a Database.
    And filtering your resultset on the Server-side via SQL will always beat a seek on a complete table.

    EDIT: IIRC, seek only works on a single Comparator. In OP's case he...
  6. Replies
    5
    Views
    218

    Re: Trickish Situation With Data Range Search

    SELECT * FROM tabjrecord WHERE 6300 BETWEEN Col3 AND Col4

    And i agree with Arnout: No Banana, but Apple instead
  7. Re: Remove dead COM entries in the registry.

    Well, your question was how to backup. Restore wasn't part of the question :D
    Another way: Copy/Backup the Files directly -->...
  8. Re: Remove dead COM entries in the registry.

    Huh?
    Open Reg-Editor, right-click on "Computer" (upper left corner in left window, It's the root of the TreeView) --> Export
  9. Re: Remove dead COM entries in the registry.

    On a "sensitive" machine, after a clean install, setup of apps/programs, and everything runs like it's supposed to do, i do a backup of the disk (!!) with CloneZilla.
    So i get my partition layout,...
  10. Replies
    2
    Views
    220

    Re: SQL Server fulltext - Search failures

    1) Since you're using double quotes (simple_term = exact match case insensitive), have you tried the LIKE-Operator instead? Maybe lower casing everything before comparing
    Just to test if the results...
  11. Replies
    29
    Views
    717

    Re: Reference a .NET DLL in VB5

    In the VB5-IDE go to references and look for your objects from that dll.
    they should appear there
  12. Replies
    2
    Views
    154

    Re: Looking for workflow-advice

    In regards to "available stock at Level30 and below"? Yes



    That was my first thought, too, but then i was confronted with the scenario "and if the ladies have a lazy week, and don't scan...
  13. Replies
    2
    Views
    154

    Looking for workflow-advice

    Hi Folks,

    situation:
    Warehouse with Stock called "H1"
    An item can be on multiple locations (separated by incoming-date, lot-no and some other criteria).
    The locations are separated by...
  14. Replies
    29
    Views
    717

    Re: Reference a .NET DLL in VB5

    And you followed all steps mentioned?
    https://web.archive.org/web/20120210204121/http://support.microsoft.com/kb/817248
  15. Thread: Excel timer

    by Zvoni
    Replies
    7
    Views
    336

    Re: Excel timer

    I'm trying (and failing) to wrap my mind around this


    Range("D29") = Range("D29") - TimeValue("00:00:00")

    TimeValue("00:00:00")???
    Huh?
  16. Replies
    13
    Views
    572

    Re: calculate percentage

    I Wrote "Tested in SQLite"
    Each DBMS has its own Dialect/Syntax
    I could not detect which DBMS you are using
  17. Replies
    13
    Views
    572

    Re: calculate percentage

    I edited my post: Use LEFT JOIN instead of INNER JOIN and look at the IFNULL's

    This gives the Percentage of each VType to the Total of all Barcodes
    If you want the Percentage Within a VType-Group...
  18. Replies
    13
    Views
    572

    Re: calculate percentage

    The only crash you can get, is when you don't have any Barcodes => The Table is Empty
  19. Replies
    13
    Views
    572

    Re: calculate percentage

    Your Percentage-Thing:
    Tested in SQLite


    SELECT
    T1.VType,
    IFNULL(T2.Reserved / (SELECT COUNT(Barcode) FROM tblOPVoucher)*100,0) As ReservedPerc,
    IFNULL(T3.NoReserved / (SELECT COUNT(Barcode)...
  20. Replies
    13
    Views
    572

    Re: calculate percentage

    1) Is this a Typo?
    "1111112,1,2" --> IsReserved has Value 2
    in your WHERE-Clause you compare IsReserved=1 --> meaning that one with Value 2 is ignored
    2) How do you figure in your first example,...
  21. Replies
    10
    Views
    267

    Re: SQL statement problem

    Then you're having a typo in your fieldname
  22. Replies
    10
    Views
    267

    Re: SQL statement problem

    ?
    "AND TBL.NAME2<>'" & Chr(32) & "'"
  23. Re: Is it possible to convert an .exe file to 64-bit?

    Follow-up question: IIRC, vb6.exe emitts c-code which is passed to c2.exe, which then creates the OBJ-Files and links everything together (correct me if i'm wrong)
    Is it possible to intercept THAT...
  24. Replies
    39
    Views
    928

    Re: Binary Search Not Finding Capitals

    If you do not read the file into memory beforehand, then yes, you need random mode.
    BUT: AFAIK, the File must be saved in Random mode beforehand, meaning you probably need to change everything to...
  25. Replies
    3
    Views
    175

    Re: shellexecute and ffmpeg

    Usually, ShellExecute is for shelling a file to its Standard-Programm
    e.g. "ShellExecute MyForm.hWnd, "open", "MyDocument.docx",,,SW_SHOWNORMAL

    If you want to Execute your commandline-string,...
  26. Replies
    39
    Views
    928

    Re: Binary Search Not Finding Capitals

    The difference is 32 (I nearly wrote 42....)


    Dim s As String
    s = "A"
    Debug.Print Chr(Asc(s) Xor 32) '--> Returns "a"
    Debug.Print Chr(Asc(s) Or 32) '--> Returns "a"
    s =...
  27. Replies
    39
    Views
    928

    Re: Binary Search Not Finding Capitals

    How big is that Array?
    IMO a BinarySearch only makes sense if we're talking a few thousand entries.
    An alternative might be the Filter-Function for String-Arrays.
    The Filter-Function works like...
  28. Replies
    26
    Views
    847

    Re: Strange behaviour of vb6

    You gotta be kidding me........
    So, basically the OP put the first textbox in his Form, set its Index to 1, and copied the Textbox 11 times, missing that the first copy had Index 0 and the last copy...
  29. Replies
    26
    Views
    847

    Re: Strange behaviour of vb6

    Just out of curiosity (because i don't remember it anymore since i haven't fired up my vb6 in 10 years):
    If you place a control on a form, then you go to its Index-Property to declare it as an...
  30. Replies
    3
    Views
    347

    Re: Treeview control in Access form

    Sounds like a borked installation.

    Have you tried "regsrv32 mscomctl.ocx" (In System32 resp. SysWoW64)?
  31. Replies
    17
    Views
    656

    Re: Program to rename / copy mp3 files

    Open Form2 in Modal mode
  32. Replies
    26
    Views
    847

    Re: Strange behaviour of vb6

    Do a "Debug.Print LBound(Text1)" and "Debug.Print UBound(Text1)" if you don't believe us......
  33. Replies
    26
    Views
    847

    Re: Strange behaviour of vb6

    And if you're unsure about the Array-Bounderies, there is always
    For i=LBound(Text1) To UBound(Text1)
  34. Replies
    18
    Views
    793

    Re: Type MisMatch

    Array is declared as String
    "Is Nothing" checks if it's an Object
  35. Replies
    17
    Views
    656

    Re: Program to rename / copy mp3 files

    There is no "rename all files at once"
    either, you collect all filenames, rename them in memory, and then loop through the result firing off the "name" function
    or you run through your files and...
  36. Replies
    17
    Views
    656

    Re: Program to rename / copy mp3 files

    Use split-function on full path with \ as delimiter.
    filename is in highest member of the resultarray
  37. Replies
    17
    Views
    656

    Re: Program to rename / copy mp3 files

    Why anyone would rename to all Upper case on a Case-agnostic OS escapes me......
    as to the question:
    I love my linux......
    http://manpages.ubuntu.com/manpages/impish/man1/mmv.1.html
  38. Re: Setting Edge Default Download Folder via Registry

    Wrong registry-key.
    https://www.isunshare.com/windows-10/how-to-change-default-download-location-in-microsoft-edge.html#option3
  39. Replies
    18
    Views
    694

    Re: Duplicate rows returned

    To stay in DM's terminology:
    You have an Owner, who can own none, one or more cars
    You have an Owner, who can rent none, one or more spaces
    If the Owner owns one or more cars, each car can only be...
  40. Re: Is it possible to make the query quick to search, given that I'm using Access ??

    Only those fields you'll be using as a search-criteria
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width