Search Results - VBForums

Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Locating the position of four consecutive bytes in the header of a binary file

    If you read the header into a string-variable, wouldn't you need to convert the string to ASCII, since Strings in VB are Unicode?
  2. Replies
    8
    Views
    143

    Re: VB6 Highlight Textbox Contents

    Why not use SelStart and SelLength directly inside the Keypress-Event?
  3. Re: MDB Relationships "Showing" After Added through VB6 with the DAO

    HEUREKA (well, at least i think so *g*)

    look at this thread (read it through to the end):
    http://bytes.com/topic/access/answers/193179-any-way-examine-manipulate-relationships-layout-code
    ...
  4. Re: MDB Relationships "Showing" After Added through VB6 with the DAO

    After thinking about it more, and playing around with this relationships-form, it kind of reminds of a MDI-form and its children.
    Another way might be, that the tables kind of look like a listbox or...
  5. Re: MDB Relationships "Showing" After Added through VB6 with the DAO

    Well, to be honest, since i use access only as a backend, and access itself only for designing the initial database, i don't bother with the relations-show-me-everything-thingy :-)
    but i got...
  6. Re: How to add many .bas modules to project

    Yes, if you want to import the original module, but if you want a copy, because you know you'll have to change something in it, you have to copy the module(s) manually beforehand.

    By coding a...
  7. Re: MDB Relationships "Showing" After Added through VB6 with the DAO

    Thinking logically about it, i'm pretty sure that what you're looking for has nothing to do with DAO (or RDO, ADO, CIA, NSA or whatever 3-letter-abbreviation) but with Access itself,
    since you can...
  8. Re: How to add many .bas modules to project

    Why not just code a small tool?
    Something like:
    1) Please select your VBP-File
    2) Please select the BAS (or other Modules) you want to import to the previously selected VBP-File (Multiselect!...
  9. Replies
    4
    Views
    130

    Re: Communicate with VOIP phone connected to PC

    And your question relating to VB6 is what?
  10. Replies
    6
    Views
    169

    Re: 2d array VB6

    hrhrhrhrhrhrhrhr



    Sub SearchAuthors()
    Dim strBooks(0 To 4, 0 To 1) As String
    Dim arrBooks(0 To 9) As String
    Dim Result As String
    Dim ResultLength As Long
    Dim Search As String
  11. Re: Vb to Excel formula retuns no results

    Try FormulaLocal instead of Formula
  12. Re: Using ShellExecute to launch default Web Browser

    And since when is a standard-browser installed in the AppData-Path?
  13. MsOf13 Re: [Access2013] VBA code to change column header in linked table creation

    That's IMHO the only way i can think of to circumvent the OP' problem
  14. MsOf13 Re: [Access2013] VBA code to change column header in linked table creation

    https://social.msdn.microsoft.com/Forums/office/en-US/4a440bba-b6e4-42c8-89a5-b42a3f8b0563/changing-an-existing-field-name-in-a-linked-table?forum=accessdev
  15. Re: How to check for existence of a column at a certain position in a listview?

    hrhrhrhrhr
  16. Replies
    3
    Views
    193

    Re: convert c++ to vb6

    *sigh*
    And what error are you getting? My Divination-skills are a little bit rusty.....
  17. Replies
    6
    Views
    257

    Re: Data Type Conversion Error

    Second reply --> http://objectmix.com/basic-visual/155084-mshflexgrid-error-13-a.html
  18. Re: Using VBA to find and move data from one sheet to another

    excerpt from his code


    *snip*

    For J = 0 To UBound(strArray)
    Found = Found Or Not (rngCells.Find(strArray(J)) Is Nothing)
    Next J
    *snip*
  19. Re: Using VBA to find and move data from one sheet to another

    Loop backwards through sheet1 (For i=123456 to 2 step-1)
    Keep a counting variable J (or x or whatever) you increase +1 for everytime you find your criteria in sheet1 and use this variable as the...
  20. Re: Need help for barcode reader to have cursor jump to next row

    I assume that the OP scans directly into a cell, so he can still do it manually if the scanner/barcode itself doesn't support CR



    Private Sub Worksheet_Change(ByVal Target As Range)

    ...
  21. Replies
    6
    Views
    257

    Re: Data Type Conversion Error

    Don't forget that a Date can be represented by a Long-Type, a DateTime by a Double-Type (the Time being represented by the part after the decimal-separator), so i agree with Phill: Never compare...
  22. Replies
    3
    Views
    137

    Re: Help with using Array and/or Loop

    If the Values to be assigned (depending on the Index) are constant, an approach might be to use an INI-File and/or database (db could even be a small textfile with UDT's)

    Something like:


    ...
  23. Replies
    56
    Views
    1,131

    Re: Find file in each Drive and Sub Folder

    Errr... nevermind, that i still have to see how you can delete a file from a CD/DVD (and don't start arguing with "rewritable" CD/DVD), i highly, highly recommend against doing anything with...
  24. Re: VBA swaps month and day pre the 13th day of the month

    You do realize, that you use the variable "Data" to build your Save-FileName, and that Data gets its value from range("F2")?
    What's the Value in F2?
  25. Re: Listview control help: Header and selected line color

    For the headers: No Idea. Probably to do with systemcolors and/or color-themes
    For the selected line: if i remember correctly, there are several color-properties for the ListView. I'd check out some...
  26. Replies
    3
    Views
    254

    Re: Add each list view item into string array

    This should work



    Sub Something()
    Dim MyArray() As String

    ReDim MyArray(1 To lvF.ListItems.Count)

    For i = 1 To lvF.ListItems.Count
  27. Replies
    9
    Views
    223

    MsOf10 Re: Reference all cells in a column

    Exactly my thoughts!
  28. Replies
    9
    Views
    223

    MsOf10 Re: Reference all cells in a column

    Well, since Target is a Range-object, i would have expected a Is-Nothing-Expression, since IsEmpty refers to numeric or string-values



    EDIT: Or did i just fell for the Trap with the...
  29. Re: hide Excel instance and show only the userform

    Don't forget if you have code running which crossreferences another workbook like


    ActiveSheet.Cells(2,7)=Workbooks(2).sheets(1).Cells(5,9)


    That's a pre-programmed timebomb
  30. Replies
    9
    Views
    223

    MsOf10 Re: Reference all cells in a column

    errr..... am i supposed to understand this line?


    If IsEmpty(Target) Then Exit Sub
  31. Replies
    9
    Views
    286

    Re: Disable Ctrl-Tab in MDI child forms

    What's wrong with Max's suggestion in Post #7?

    If everything else doesn't work, i'd rather do the subclassing-approach than starting some weird magic with hidden picture-boxes

    EDIT: You'd have...
  32. Re: Run Time error -624820215 (dac20009)

    Why not use an OERN right before the loop, with an On Error Goto 0 after the loop?
    He could even check inside the loop for the error and count the failed extraction attempts, like
    "18 Items...
  33. Re: Problem : Generating Unique Number (too slow)

    I think your problem's in the datatype, since you're using MAX on a Textfield (think sorting by string)
    But i'm not sure about it. It's been over 10 years I've done anything serious with Access
  34. Replies
    6
    Views
    243

    Re: Changing Array Index Numbers

    Sounds like a chess game.
    Turning a chessboard around you get the same board (Background) again (White square in upper left corner), but now the black pieces are at the bottom instead on the top.
    ...
  35. Replies
    2
    Views
    6,522

    Re: How do I use SendMessage and GetMessage?

    I'd rather subclass the windows-procedure on the receiving end with a unique message-header sent by the sender (e.g. WM_Custom or something) with the pertinent data sent in lparam or wparam.
    In that...
  36. Re: Upload to FTP-Server using the wininet-InternetFunctions

    I don't have any access to other FTP-sites.

    Could someone of you, who has an FTP-Server, make me an account, and PM me the Login-data?

    EDIT: I tried to upload the file via a Web-FTP-Provider...
  37. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Nope.

    Getting the file back is an empty file

    I just called the FTP-operator.
    They had an update last week on monday (the day my code started to misbehave!), but according to him, the update...
  38. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Something else:

    I just tried to upload the file using the ftp.exe commandline-program

    Strange thing:
    after entering put c:\temp\myfile.xml (which is 6KB)
    200 PORT command successful
    150...
  39. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Very curious.

    I tried pete's suggestion with the Shell-Object, and i got the following phenomenon:

    I have a Windows-Explorer open connected to the Folder on the FTP-Server (for watching in...
  40. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Nice, pete.

    didn't think on that. Will try on monday. In germany is holiday tomorrow, and i took off friday, so next i'll be able to test it will be coming monday.


    will report on monday if it...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.