Search Results - VBForums

Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. MsOf13 Re: Delete fields that were not modified

    I remember doing something similiar some 7-8 years ago, and i think i did with bookmarks, which you can apply to the controls
  2. Re: [RESOLVED] DB2: SQL Grouping by month showing columns as rows (monthly sales)

    Yep.
    And trust me: Yes, Wind-Tunnel is fun, but it's a completely different thing to see a plexiglas-thing in front of you and the net 4-5 feet below you, and standing at an open door and looking...
  3. Re: DB2: SQL Grouping by month showing columns as rows (monthly sales)

    Whoaa.
    Wouldn't have expected my question to kick off such a discussion.

    Ah, well. Got my Problem solved, the question was just out of curiosity,
    and the weekend with brilliant conditions to...
  4. Re: DB2: SQL Grouping by month showing columns as rows (monthly sales)

    OK, i got it.
    LGTENR=PartNo.
    LGLIDA=ShippingDate in Numeric Format YYYYMMDD
    LGLIMG=ShippedQuantity



    SELECT LGTENR,

    SUM(CASE WHEN SUBSTR(LGLIDA, 5, 2)='01' AND LEFT(LGLIDA, 4)='2015' THEN...
  5. Re: DB2: SQL Grouping by month showing columns as rows (monthly sales)

    Hi Guys,

    sorry for late reply.
    Yes, i want to group by year and month (sorry, i forgot), since the time-window may include several years, but i wouldn't expect it to be that much more complicated...
  6. [RESOLVED] DB2: SQL Grouping by month showing columns as rows (monthly sales)

    Hi all,

    Issue:
    In a table, there are columns for part-no, shipping date, quantity etc.

    I want to group this table (actually it's going to be an SQL-Query for a report) by month, the months...
  7. Replies
    4
    Views
    306

    Re: problem list1 and text1 or text2

    Nevermind that i see a whole bunch of issues with his code (initializing the indices to the last index and other stuff)

    Entire file of what?
    You do realize that you're creating a separate file...
  8. Re: Changing the value of a property of an object (Class)

    Why not change the function around (See my code-sample)?
    Inside your Sum-Function you're checking against illegal Return-Values, so instead of giving a boolean back, give the result back
    (btw: Is...
  9. Replies
    7
    Views
    648

    Re: Object Library not registered

    Maybe this one here: http://www.vbforums.com/showthread.php?790019-Why-does-MSCOMCTL-OCX-give-me-an-error
  10. Replies
    10
    Views
    602

    Re: Read and write new csv file

    And now i'll throw a bolt into the gear-Box: What if the very first (topmost) value is negative?

    EDIT: The actual algorithm to get what he wants is IMO pretty easy (and i know that i'm ignoring...
  11. Replies
    15
    Views
    928

    MsOf10 Re: File Not Found Error Message

    I'll not go through the complete code, but two things:
    Avoid your Goto Jump/Skip.
    If you have to use Goto in a For-Next-Loop then your Algorithm needs to be reworked.

    After Your MsgBox "Update...
  12. Re: How to get the number of items in one field

    And where in your code are you setting the limits for the month(s)?
  13. Replies
    10
    Views
    921

    MsOf07 Re: Speed comparison with DAO and ADO

    Since when does a TextBox-Control have the AddItem-and Clear-Methods??? *confused*
  14. Replies
    7
    Views
    587

    Re: VBA - Skipping every other cells

    hrhrhrhrhr



    Dim i As Long
    Dim MyArray() As String
    Dim MyJoin As String
    Dim MySplit() As String

    ReDim MyArray(1 To LVW.ColumnHeaders.Count)
  15. Thread: Datagrid

    by Zvoni
    Replies
    11
    Views
    596

    Re: Datagrid

    He doesn't know, how to make the communication between parent-form and child-form
    Parent-Form has a commandbutton, and probably some labels or textboxes.
    He hits the command-button, another form...
  16. Replies
    17
    Views
    1,579

    Re: Why does MSCOMCTL.OCX give me an error?

    If i remember correctly, you have to register the OCX from the System32-folder, not the Syswow64 (64-Bit OS?).
    I had the same issue with 64-Bit-Windows, and placing it in the System32, registering...
  17. Replies
    17
    Views
    1,579

    Re: Why does MSCOMCTL.OCX give me an error?

    OK, so i'll throw in another solution, that worked for me:

    The reason why that OCX stopped working for me, was, that a windows update disabled that control in the registry.
    Finding several...
  18. Replies
    6
    Views
    476

    Re: Problems with exporting to excel

    Two things:
    is that just a typing error?
    in your MkDir you have "Taget" as foldername (an "r" missing?)

    you're using xls as the file-extension which implies Excel2003 or older.
    if i remember...
  19. Replies
    4
    Views
    703

    Re: change background color in cell of listview

    Every reference i found had the imagelist-component, so no idea if it's possible

    http://www.vbforums.com/showthread.php?277027-Listview-small-icon-image-on-subitems-Resolved
  20. Replies
    4
    Views
    703

    Re: change background color in cell of listview

    As far as i know not possible in Office/VBA, since the only way to change the backcolor of a listview in VB is with a picture-box, and you don't have picturebox in VBA

    EDIT: Of course, you could...
  21. Re: TextOut: printed text displaced on paper, correct when printing to PDF

    Just a thought: The PDF and the real printer use the same paper-"size"?
    e.g. PDF is set to A4, while the real printer is set to letter
  22. Re: Join listbox value into one string

    Why not just put the Listitems into an array, and then use the Join-Function?
    No need to wrack your brain, why there is a leading or trailing comma.....
  23. Re: TextOut: printed text displaced on paper, correct when printing to PDF

    Then the only explanation i'd have is, that the "real" printer displaces the position due to border-issues (which logically a PDF-Printer shouldn't have)
    since CurrentX and CurrentY are logical...
  24. Re: TextOut: printed text displaced on paper, correct when printing to PDF

    OK.
    let's do it this way:

    Debug your code and read all values before printing.
    CurrentX, CurrentY, Printer.ScaleWidth etc. and everything else.
    Read them for your PDF-Printer, and then read...
  25. Re: TextOut: printed text displaced on paper, correct when printing to PDF

    Every reference i found had to do with the SetTextAlign-Function
  26. Thread: C to VB

    by Zvoni
    Replies
    3
    Views
    337

    Re: C to VB

    Not sure about this one:


    'Step 1 and 2
    argste(pste_indx + 1).pcmFirst = argste(pste_indx + 1).pcmFirst - 1


    Since a pointer is a 32-bit integer (a Long) i would have expected
  27. Re: [Excel 2010 - VB 7.1] finding "TargetRow" for User Form

    Look at my attachment.
    Enter something in a cell in Column "F" and follow the code
  28. Re: [Excel] Need to read Excel file and generate SQL Insert statements

    As for your bulk insert: i don't see any need to write it out into a file.

    The question remains: Do you want to build/concatenate your SQL-String (fixed part and variable part) on the fly through...
  29. Re: [Excel 2010 - VB 7.1] finding "TargetRow" for User Form

    Did you delete your declaration at the head of the worksheet?
    The Declaration of MyRow should be only once within the whole workbook

    EDIT: I've attached a very small sample for you, taking your...
  30. Replies
    15
    Views
    908

    Re: Finding word on Text File

    Agree with Sam. Your input-file leaves a lot to be desired.
    Do you have any influence on how this input-file is created?
    If you have, then maybe getting it in INI-Format would make your life a lot...
  31. Replies
    11
    Views
    555

    Re: Running a form depending on login

    Such posts always baffle me, in that the OP basically answers his own problem without noticing it.

    Even if a Select Case is too tall an order, this at least should give him a clue:
  32. Re: [Excel 2010 - VB 7.1] finding "TargetRow" for User Form

    And there is your Problem:

    Your Variable "Myrow" is Public from the Worksheet-Object, meaning:
    It works like a property of the Worksheet (Sheet10 in your case)

    You either have to address it in...
  33. Re: [Excel 2010 - VB 7.1] finding "TargetRow" for User Form

    And you've entered something in a cell in Column 6 (meaning: you've triggered the Change-Event)?
    Why don't you just put a breakpoint inside the event, then you can see, if/when it's triggered
  34. Replies
    2
    Views
    301

    Re: Visual basic Programming help Arrays

    to get you started.....



    Private Type UDTPerson
    FirstName As String * 20
    LastName As String * 20
    Birthday As Date
    End Type
  35. Replies
    2
    Views
    368

    Re: Difference in Hours

    MsgBox DateDiff("h", format(rs0.Fields("gtime"), "hh:mm:ss"), ServerTime)
  36. Re: [Excel] Need to read Excel file and generate SQL Insert statements

    Just to understand you correctly:
    You have an Excel-File with two rows (!)
    First row being the "Header" (containing the fabrics across columns), and the second row with the seasons (s/s - f/w)
    ...
  37. Re: Excel: Import sheets from various workbooks into another workbook using VBA

    Excel2003 can only handle some 65k of rows per sheet, so like vbfbryce said: does the imported sheet has more than 65k of rows

    EDIT: i forgot:
    you have to rename each imported sheet after...
  38. Re: Excel: Import sheets from various workbooks into another workbook using VBA

    If you name this specific sheet in each workbook you'd like to import from the same (e.G. "SheetToImport") you can use this String/Name to directly pick the sheet from the Sheets-Collection

    Get...
  39. Replies
    6
    Views
    481

    Re: how to make list from a string

    Has anyone understood what he wants?

    How about you use real words/sentences (and not that gibberish), to show us what the problem is
  40. Replies
    14
    Views
    885

    Re: Read Text From .txt

    Don't forget that VBA in Office doesn't support Control-Arrays.
    Even if he says "his VB6-Program", nowadays you never know if it's Visual Studio or if it's VBA/Office he uses
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.