Search Results - VBForums

Search:

Type: Posts; User: SamOscarBrown

Page 1 of 13 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    9
    Views
    181

    Re: Display Record between two dates

    errr..sorry..yup, I do give examples of code, for sure (I even mentioned that), but USUALLY my examples are not what the OP needs to COMPLETE his//her mission, but rather to give examples of how to...
  2. Re: FILL combobox with start and end date of month

    BUT, maybe, just because we got them things called leap years (I'm in my 17th one), OP wanted to make sure that 29 Feb was shown, vice 28 Feb on those years....I don't know......
  3. Re: FILL combobox with start and end date of month

    Probably a homework assignment...but if the instructor really wanted day monthname year, just change Bonnie's slightly....

    replace "dd/mm/yyyy" with "dd mmm yyyy"
    and "-dd/mm/yyyy" with "-dd mmm...
  4. Replies
    13
    Views
    168

    Re: data type not compatible

    1-what are those additional double quotes ("") in there for? Not in what I posted.
    2-Of course you will hiccup if one of the fields is blank...as a matter of a fact, you have to make sure that the...
  5. Replies
    13
    Views
    168

    Re: data type not compatible

    you would want:


    RS.Open "select * from Table1" & _
    " where ID = " & Text1.Text & _
    " and datt = " & Text2.Text & _
    " and age = " & Text11.Text & _
    " and...
  6. Re: I need help in visual basic 6 with synchronizing commands one after the other

    Agree with your last statement, passel. In a loop through the Grid's rows, OP should be able to update each 'record' (row), which I would presume would work best in the click_event of the Save...
  7. Replies
    13
    Views
    168

    Re: data type not compatible

    Arghhh...yup...TOO much caffeine!
  8. Replies
    13
    Views
    168

    Re: data type not compatible

    Then use CStr() to convert when using the = sign
  9. Replies
    13
    Views
    168

    Re: data type not compatible

    I am assuming (and probably a good assumptions!) that your ID field in your table is a NUMERIC value.
    You will want something like this:

    RS.Open "Select * from Table1 where ID = " &...
  10. Replies
    9
    Views
    181

    Re: Display Record between two dates

    gibra has done your homework for you...good job, gib.

    BUT, this forum is not generally designed for folks to come and 'get code', but to 'get help' writing their own code (or in the case of the...
  11. Re: I need help in visual basic 6 with synchronizing commands one after the other

    Hmmmm....must be a VERY fast user....let me try to understand a bit more....okay, someone pastes in a bunch of cells (multiple rows and columns) on a single paste. You do some cell validation at one...
  12. Replies
    30
    Views
    408

    Re: [RESOLVED] saving multiline textbox

    Hey, tg, are you referring to my little example?
  13. Re: Time difference giving incorrect results vb 6

    Well, if I were you, I would do ALL my calculations/warnings based upon the fields in my database, where the 'appointment/birthdate' information should be stored as date/time. Forget using the grid...
  14. Re: I need help in visual basic 6 with synchronizing commands one after the other

    1-what code is under the button that you click on to make your changes?
    2-what code is under the button that you click to save the data back to the database?

    Edit---I hit the wrong button...let...
  15. Re: Time difference giving incorrect results vb 6

    You know when that (first) message box is displayed, all other processes in your program stop until someone presses that OK button (unless you have the box automatically disappear after a certain...
  16. Re: I need help in visual basic 6 with synchronizing commands one after the other

    Just by per chance, is this problem in a simple application that you can share with us by zipping it up and uploading it (Under Go Advanced button, Manage Uploads, follow instructions)? I am...
  17. Re: Time difference giving incorrect results vb 6

    Well, whoever create that grid also had little clue on how to use dates. Is this data fed from some database table or is it 'static', meaning a user would have to populate a row using VB controls?
    ...
  18. Replies
    30
    Views
    408

    Re: saving multiline textbox

    Well...look at my modified mini program...forget the buttons on the left, run this and click on the bottom RIGHT button...then look at the code on that button. (I added three lines Mustaphi, Sam and...
  19. Replies
    30
    Views
    408

    Re: saving multiline textbox

    I showed you how to save the line of one textbox; just do the same for the other two. If you were using an array of multiline textboxes, you could put it in a loop, starting with the first box, and...
  20. Replies
    30
    Views
    408

    Re: saving multiline textbox

    what function/Sub are those lines of code within? If you are doing this at run time and you are not moving through the list of the items in the combobox, all you are doing is adding whatever the ONE...
  21. Replies
    30
    Views
    408

    Re: saving multiline textbox

    Good point...however, in my tiny example when I added more lines to that one text box, I did not have any trailing line feeds....OP should check if the last line does include a VbCrLf...if yes, use...
  22. Replies
    30
    Views
    408

    Re: saving multiline textbox

    Show me how you add multiple lines to any of your three textboxes AT RUN TIME......
  23. Replies
    30
    Views
    408

    Re: saving multiline textbox

    Here is a quick example of what was discussed by others above....uses split()...when you run it, click on the first button, then check the answer by clicking on the bottom button. Then do the same...
  24. Replies
    30
    Views
    408

    Re: saving multiline textbox

    Not sure what you are after....

    What are you doing? (Or attempting to do?)
  25. Re: trying to determine the days between dates between now and the dates listed using

    look at your 'date'....the year is 216....that is a LONG time ago.....
  26. Re: [RESOLVED] Move first and previous poblem

    You're right....it sure would help if more code was posted....what called the sub, for example....I didn't see that it was a sub which was presumably called repetitively....weird way of doing...
  27. Re: [RESOLVED] Move first and previous poblem

    Hmmmmm.....In a post above, you said that more than one record could meet your criteria. So, let's say you have four records where num (poor naming convention, by the way---you should use a bit more...
  28. Re: trying to determine the days between dates between now and the dates listed using

    What DM says....
    make sure all variables are dimensioned.

    If you do something like this, it might give you the clues:


    Dim myDate as Date

    With gridMaster
    For i = 1 To .Rows - 1
  29. Replies
    2
    Views
    105

    Re: POS product code

    What code have you tried writing already?
  30. Re: vb6: Error 53: File Not Found

    Mea culpa....didn't mean to offend you....it just appeared that you were not doing too much research yourself....I see you were. Please accept my apologies.

    PS--please mark this thread as...
  31. Re: [RESOLVED] Appears picture in picturebox

    :confused: MAY appear to be working for that particular image, but go ahead and try it with different size images...you might just be surprised.
  32. Re: vb6: Error 53: File Not Found

    It is interesting how few new VB-ers use Debug at all. 'Stepping through' line by line (by placing a break prior to a line that produces an error) is a good method to view variables' values. Using...
  33. Re: Extract strings from multi line textbox stuck

    So, I THINK I know what you want, but not quite sure.

    You want to be able to search that (a) file and extract that exact string ("103913435280718590913") in all the places it occurs?
    If so, why? ...
  34. Re: [RESOLVED] type mismatch with loading a picture

    Well, you don't need two Recordsets.
    First (with RS) see if your image file exists in Image_table. If it does not, simply do another query to get the picture from the picture_table.
  35. Re: Impossible to avoid duplication !!!

    Tend to agree with Ikke....usually beginners on this Forum are using MS ACCESS, but if OP is using ACCESS (Or a JET Database to be more precise), then the word 'order' is a Reserved Word and would...
  36. Re: print grid suares with actual colors not numbers..

    Okay, but I think you might consider this instead of using the printer object to print individual squares, at least in the method you described. If I wanted to have these images placed on paper, I...
  37. Re: Need Help With a Rudimentary Translator

    1-You are doing this in a Visual Basic.Net version, not Vb6.
    2-Yes in French is Oui, no Ou..:)
    3-If you want an example in VB6, I'll gladly give you one (based upon your 'rudimentary...
  38. Re: print grid suares with actual colors not numbers..

    I am not a tree-hugger, BUT........I DO hate printing out stuff onto paper when 99% of things can (should) be done electronically. That having been said, a better (IMHO) approach would be to take a...
  39. Replies
    2
    Views
    106

    Re: modify by summing listbox item

    Once you have your listbox altered, export it like this:
    http://www.vb6.us/source-code/save-contents-list-box-file
  40. Re: [RESOLVED] Fill MS Word Plain Text Content Control using VB6 with MS Access Table

    I just wanted to update this thread to let all know that, even though Olaf's method is straightforward and is easy to implement, sorta, I elected to use instead Microsoft's Excel for these 'forms' I...
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.