Search Results - VBForums

Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: run vbs from vba and output results back to vba

    The only way i can think of now.
    If you have paths incl. blanks you'll have to put the complete path into quotes (Don't forget to escape them)
  2. 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?
  3. Replies
    8
    Views
    198

    Re: VB6 Highlight Textbox Contents

    Why not use SelStart and SelLength directly inside the Keypress-Event?
  4. 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
    ...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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!...
  10. Replies
    4
    Views
    140

    Re: Communicate with VOIP phone connected to PC

    And your question relating to VB6 is what?
  11. Replies
    6
    Views
    183

    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
  12. Re: Vb to Excel formula retuns no results

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

    And since when is a standard-browser installed in the AppData-Path?
  14. 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
  15. 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
  16. Re: How to check for existence of a column at a certain position in a listview?

    hrhrhrhrhr
  17. Replies
    3
    Views
    194

    Re: convert c++ to vb6

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

    Re: Data Type Conversion Error

    Second reply --> http://objectmix.com/basic-visual/155084-mshflexgrid-error-13-a.html
  19. 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*
  20. 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...
  21. 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)

    ...
  22. Replies
    6
    Views
    259

    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...
  23. Replies
    3
    Views
    139

    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:


    ...
  24. Replies
    56
    Views
    1,134

    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...
  25. 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?
  26. 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...
  27. Replies
    3
    Views
    255

    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
  28. Replies
    9
    Views
    224

    MsOf10 Re: Reference all cells in a column

    Exactly my thoughts!
  29. Replies
    9
    Views
    224

    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...
  30. 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
  31. Replies
    9
    Views
    224

    MsOf10 Re: Reference all cells in a column

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


    If IsEmpty(Target) Then Exit Sub
  32. Replies
    9
    Views
    294

    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...
  33. 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...
  34. 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
  35. Replies
    6
    Views
    246

    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.
    ...
  36. Replies
    2
    Views
    6,525

    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...
  37. 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...
  38. 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...
  39. 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...
  40. 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...
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.