Search Results - VBForums

Search:

Type: Posts; User: DataMiser

Page 1 of 13 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    3
    Views
    63

    Re: Data to Tally

    What is Tally?
  2. Re: What's wrong in this code ? Please Help.

    It would return the wrong result for August as today is August 31st but the code would show only 30 days in August

    You also do not need the Or statements on the Cases

    Case 1, 3, 5, 7, 8, 10, 12
  3. Replies
    8
    Views
    166

    Re: How can I upload image

    The method for uploading files to a web site can vary based on the site in question. Whatever method used has to be one supported by the website in question. So giving some site as an example other...
  4. Re: how can i view/display data to a datagrid through a users input from a textbox in

    The db here is the connection object which has been opened previously.

    the 2 and 3 are flags but should not be used as literal numbers, there are constants that should go there instead which are a...
  5. Re: how can i view/display data to a datagrid through a users input from a textbox in

    Have you tried searching for examples? There are tons of them all over the net.
  6. Replies
    8
    Views
    132

    Re: Integer to return smallest integer

    Int() should do it as mentioned in Post #4 and #6

    Int() drops anything after the decimal point
    CInt() will round the result up or down as the case may be
  7. Replies
    13
    Views
    221

    Re: From Excel To Listview

    When you get the error on that line hover your mouse over the intRFQItemsCount part and see what the value is then compare that with the actual number of items in the listview1
  8. Re: savedata from textbox without commondialog

    As mentioned above never hard code a path
    You also should not be writing to the windows folder nor any subfolder thereof

    This thread may help you get the proper appdata folder no matter which...
  9. Replies
    13
    Views
    221

    Re: From Excel To Listview

    Try changing this


    Set l = ListView1.ListItems(ListView1.SelectedItem.Index)
    To

    Set l = ListView1.ListItems(intRFQItemsCount)
    and see what happens

    Also you should use code tags when...
  10. Replies
    13
    Views
    221

    Re: From Excel To Listview

    So what you are saying is that you would like to add the data from the second file on the same rows but in new columns?

    If that be the case then the first thing you need to consider is that if the...
  11. Replies
    13
    Views
    221

    Re: From Excel To Listview

    The point is that you already have headers once you add them the first time. You can change the text on them if needed. As coded I would expect that after that second set of add headers you would...
  12. Replies
    13
    Views
    221

    Re: From Excel To Listview

    Your code at the bottom would be simply changing the values of the selected item in the listview. Nothing is being added.

    You only need to add the headers once
  13. Replies
    13
    Views
    221

    Re: From Excel To Listview

    Without seeing some code there is not much to be said other than make sure you are not clearing the listview between items and make sure that you actually ADD each item as you go.

    On second look I...
  14. Replies
    3
    Views
    111

    Re: spltting this proper

    I'm not sure what you are asking
  15. Re: Drop a control on constituent controls of a user control

    Whatever dude, clearly you just feel like arguing even if it means moving the posts. Feel free to use as many OCXs in OCXs as you like and have fun with the issues that come with them.
  16. Re: Properly referring to data / subs inside a module

    You need to be clear what you are talking about here. I have a feeling you do not mean passing these vars to the subs but rather accessing them from the subs.

    To pass a var to a sub you use...
  17. Re: Drop a control on constituent controls of a user control

    If you read the OP it says

    Also note that I said I would not want to use a UC that had several other UCs within it, it can cause a lot of issues and you have those extra dependencies of all the...
  18. Re: Drop a control on constituent controls of a user control

    If you read the OP it says

    But yes there are cases were a user control would contain more than one control, a textbox and a label for example, but when you start placing other user controls...
  19. Replies
    3
    Views
    107

    Re: Duplicate Item Problem

    You could also set up your table to not allow duplicate data and have it throw an error when an attempt is made to insert duplicate data.
  20. Thread: Need help

    by DataMiser
    Replies
    7
    Views
    161

    Re: Need help

    You would use the DateAdd() function, a quick search will turn up an example.

    Also in future try to give your threads a meaningful title. Pretty much all threads are asking for help so a title...
  21. Re: Properly referring to data / subs inside a module

    Yes there is a limit to how big a procedure [sub/function] can be.

    It is good practice to limit the size well below the limit. As a general rule of thumb it is good to keep a procedure short...
  22. Replies
    12
    Views
    279

    Re: need help coding an "interrupt" button

    Well, first off it looks like you are using VB.Net but you are posting in the VB6 section of the forum so first step is to have the thread moved to the proper forum.
    Secondly an semi endless loop...
  23. Re: Drop a control on constituent controls of a user control

    Well, normally you would do some mapping but I think the drop event can only be mapped to one thing so if you are trying to get it to be able to drop on possibly more than a single control within...
  24. Replies
    15
    Views
    311

    Re: Retrieve Last Inserted ID in MS Access

    If you look at the other posts he is adding a record so there is nothing wrong with the query. It is intentionally returning an empty recordset which is fine even preferred if you are just wanting to...
  25. Replies
    2
    Views
    116

    Re: Filter In Report

    What does that even mean? Access supports SQL

    Sounds like you just need a simple SQL statement with a proper Where clause using AND

    Where Name='David' AND Code=555
  26. Replies
    14
    Views
    192

    Re: parsing again with two splits

    Static is only used in a procedure and only for local vars
    When you dim at the form level you would generally use Private or simply Dim which is private. In some cases you may use Public.

    The...
  27. Replies
    7
    Views
    183

    Re: controls limit

    As a quick test I just created a form and placed a label, a text box and a button on it. I copied each of them and then pasted saying yes to create an array and then I just held down CTRL+V to create...
  28. Replies
    7
    Views
    183

    Re: controls limit

    For labels in many cases there is no problem with Label1(x).

    I can't say I have ever saw the control limit in VB6

    I have however mocked up a sample form with a single winsock control on it...
  29. Replies
    14
    Views
    192

    Re: parsing again with two splits

    Another note is that you really should not be using a select case here

    Select Case Asc(Mid(buffer2, 2, 1))
    Case 54

    There is only one case being processed so an If statement would make more...
  30. Replies
    14
    Views
    192

    Re: parsing again with two splits

    You changed the var that would hold the data to be processed to use the buffer instead and commented out the part that would remove the processed data from the buffer so it would process the same...
  31. Replies
    12
    Views
    279

    Re: need help coding an "interrupt" button

    Your program will ignore everything while running code within a procedure unless you are using doevents [which comes with its own set of issues] to allow other stuff to happen while the code is...
  32. Replies
    14
    Views
    192

    Re: parsing again with two splits

    Basically you add any data that comes in to your buffer
    Once you have added data to the buffer you could use INSTR() to test for the existence of those characters and the location of them if they...
  33. Replies
    2
    Views
    138

    Re: infinite loop...

    VB uses events, the serial port fires an event when data is received. code for processing that data would go there.

    In general you would not use a loop for that but yes you can set up an infinite...
  34. Replies
    2
    Views
    120

    Re: Whats the best download method for vb?

    GB=Bytes / (1024^3)


    Speed=TotalBytesReceived/SecondsElapsed
  35. Re: Transfer LONG to SINGLE (and vice versa) with pure math.

    Good luck ;) To me that would be a waste of time in VB given that there are functions to convert one type to another already.
  36. Replies
    14
    Views
    192

    Re: parsing again with two splits

    Given that I would probably use a single split() and the vbcrlf to get the lines broken out into an array.
    I would then loop through that array and check for the existence of uid= and nickname= ...
  37. Replies
    16
    Views
    329

    VS 2013 Re: Help me with this code.

    No you should never set a timer interval to 1

    I would not set it to anything under 50, generally a setting of 100 or 200 is fine.
  38. Replies
    5
    Views
    162

    Re: run time error 1004 - see script below:

    As I said there does not appear to be a valid filename there

    This should also be moved to the Office forum as it is not a VB6 question.
    Excel Macros are VBA

    btw You should always state the...
  39. Replies
    5
    Views
    162

    Re: run time error 1004 - see script below:

    For i = O To UBound(qfile)

    I assume that is supposed to be a 0 and not an upper case O

    There also does not appear to be a valid filename there to open
  40. Re: Inserting multiple txtbox values in one field and errors

    I have no idea what that means. ??
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.