Search Results - VBForums

Search:

Type: Posts; User: DataMiser

Page 1 of 13 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    3
    Views
    80

    Re: spltting this proper

    I'm not sure what you are asking
  2. 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.
  3. 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...
  4. 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...
  5. 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...
  6. Replies
    3
    Views
    88

    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.
  7. Thread: Need help

    by DataMiser
    Replies
    7
    Views
    112

    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...
  8. 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...
  9. Replies
    12
    Views
    261

    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...
  10. 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...
  11. Replies
    15
    Views
    293

    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...
  12. Replies
    2
    Views
    103

    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
  13. Replies
    14
    Views
    182

    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...
  14. Replies
    7
    Views
    156

    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...
  15. Replies
    7
    Views
    156

    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...
  16. Replies
    14
    Views
    182

    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...
  17. Replies
    14
    Views
    182

    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...
  18. Replies
    12
    Views
    261

    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...
  19. Replies
    14
    Views
    182

    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...
  20. Replies
    2
    Views
    126

    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...
  21. Replies
    2
    Views
    110

    Re: Whats the best download method for vb?

    GB=Bytes / (1024^3)


    Speed=TotalBytesReceived/SecondsElapsed
  22. 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.
  23. Replies
    14
    Views
    182

    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= ...
  24. Replies
    16
    Views
    318

    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.
  25. Replies
    5
    Views
    146

    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...
  26. Replies
    5
    Views
    146

    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
  27. Re: Inserting multiple txtbox values in one field and errors

    I have no idea what that means. ??
  28. Re: do i need to use here 2 where clause ?

    Why on earth did you do this. Is RS even a valid object at the point where you reference it?


    StrSql = "SELECT * FROM Customers where fullname = '" & txtSubject.Text & "' and DAY(DateBirth) = '"...
  29. Replies
    14
    Views
    182

    Re: parsing again with two splits

    Use code tags when posting code to retain formatting

    Is that supposed to be buffer2 on the 4th line or is that a mistake?

    Since you did not tell us what data you are parsing or what you are...
  30. Re: Inserting multiple txtbox values in one field and errors

    .Addnew is for adding a new record

    .Edit is not required if you are using ADO. It is required if you are using DAO. I can't tell which you are using from the code posted
  31. Replies
    11
    Views
    428

    Re: [RESOLVED] Automatically copy

    Agreed, He should have started his own thread or better still looked at the example in the online help.
  32. Re: do i need to use here 2 where clause ?

    Why would you change it from RS.Open to CN.Execute?
    Your first post is using RS.Open so I would expect that you would continue to do that rather than change it to CN.Execute

    Is it that you do...
  33. Re: do i need to use here 2 where clause ?

    Maybe the problem is that you do not understand English very well?

    Look at Sams post #21

    When you use AND you are telling it that you want to check for more than one thing

    Imagine a set of...
  34. Re: do i need to use here 2 where clause ?

    Post what you tried?

    There is an error in Sams code as well, that ,CN should not be on the variable assignment, it should be on the end of the open statement.

    If you typed it rather than...
  35. Re: Read efficiently the variable in a file using vb6

    Don't do it like this

    Dim KSM, KCM as integer
    This will dim KSM as Variant, KCM as Integer

    You need to specify the type for every variable you declare, do not let them default to variant...
  36. Re: do i need to use here 2 where clause ?

    Apparently you just copied that code from post #17. That was just an example of how to write code in order to be able to use debug.print to show your query. The actual query was from a previous post...
  37. Re: do i need to use here 2 where clause ?

    Another thing that is important, especially when you are trying to find an issue in a query is rather than do this


    rs.Open "SELECT * FROM Customers WHERE FullName = '" & txtSubject.Text & "' & ...
  38. Re: Inserting multiple txtbox values in one field and errors

    Yes it is possible to save everything in one field but you should not even think of doing it that way.
    You should have multiple fields, one for each item of data.

    You need to make sure that you...
  39. Replies
    18
    Views
    316

    Re: Employee ID maker

    Have you considered using a report?
  40. Re: do i need to use here 2 where clause ?

    That Red & should be AND

    To answer the thread question no, you do not use two where clauses. If and when you need to filter by more than one thing you use AND or you use OR depending on you needs....
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.