Search Results - VBForums

Search:

Type: Posts; User: SamOscarBrown

Page 1 of 13 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: Read data using vb6 by matching variables

    Correct MarkT...it doesn't....In your 'error' line, note that KPCM is equal to IGM and JGM plus 5, so that really doesn't need to be read it, but if it is, it can be ignored. (and of course, if is...
  2. Re: Read data using vb6 by matching variables

    Clear.
    However, I have this question. Will you KNOW in advance, before loading the file, what variable names will be in that file? And will you have already declared those variables? Will the...
  3. Re: Read data using vb6 by matching variables

    A couple of things....
    1-Your text file has two tabs between the first and second columns (except for the last line, which has a bunch of spaces). I modified to file to have two tabs for ALL...
  4. Re: do i need to use here 2 where clause ?

    Good point...."I" prefer the msgbox as can "I" can usually immediately see the issue within the message; however, beginners (or experienced developers using complex SQLs) may elect your alternative....
  5. Replies
    14
    Views
    198

    Re: parsing again with two splits

    Can you post the incoming data? That would help us understand better. And, kinda looking for what you are trying to find....is it all UIDs and all NickNames? Just wondering.
  6. Re: do i need to use here 2 where clause ?

    It would behoove you (that means, it would be to your benefit) if you would download the "Black Book" for Visual Basic 6, available HERE. Go through it, page by page, you can learn a lot from this...
  7. Re: do i need to use here 2 where clause ?

    You REALLY have extremely little knowledge of how to code in VB. Like I suggested a long time ago, go to class, get a book, STUDY!



    StrSql = "SELECT * FROM Customers where fullname = '" &...
  8. Re: do i need to use here 2 where clause ?

    oops, sorry...darn cut/paste...was trying to merge salsa's code with mine...as DM says:

    StrSql = "SELECT * FROM Customers where fullname = '" & txtSubject.Text & "' and DAY(DateBirth) = '" &...
  9. Re: Find total number of lines which has "+" sign

    Read the file in line by line, and each time the line includes a + sign, increment a counter.
    Like:


    Dim myLine As String
    Dim selfile As String
    Dim y as Integer
    dim numLinesWithPlusSign as...
  10. Re: do i need to use here 2 where clause ?

    It READS:

    SELECT everything from the customers table WHERE the fullname field is equal to the text value of txtSubject AND the day of datebirth is equal to the day of today AND the month of...
  11. Re: do i need to use here 2 where clause ?

    Salsa...you didn't listen to DM....this works:



    StrSql = "SELECT * FROM Customers where fullname = '" & txtSubject.Text & "' and DAY(DateBirth) = '" & DAY(Date) & "' AND MONTH(DateBirth) = '"...
  12. Re: do i need to use here 2 where clause ?

    Oh yeah, I didn't 'fix' that first part of the line....I DO have 'AND' in MY query.

    Good catch.
  13. Re: do i need to use here 2 where clause ?

    Not in MY database...works fine for me. Are you checking for ucase/lcase, that is, does the upper and lower case of FullName (in your database) match exactly what is in txtSubject.text?
  14. Re: do i need to use here 2 where clause ?

    try this:

    Dim rs As New ADODB.Recordset
    rs.Open "SELECT * FROM Customers WHERE FullName = '" & txtSubject.Text & "' & DAY(DateBirth) = '" & DAY(Date) & "' AND MONTH(DateBirth) = '" &...
  15. Re: do i need to use here 2 where clause ?

    I also did a couple programs using an msflexgrid to temporarily hold all the 'data' on a person, and used GMAIL to send me the notification....here's the section that populates the grid using...
  16. Re: do i need to use here 2 where clause ?

    Salsa....yes, please check your old posts...I gave you an example on how to use datediff to do just what you wanted to do. As I told you before, as well, I have a program (a couple, actually), that...
  17. Re: Can MSHFlexgrid calculate the total of a column with "group by"?

    Have you researched Data Reports?
    Good tutorial at this link: http://www.vbtutor.net/vb6/lesson40.html (Yes, it's for VB6.)
  18. Re: [RESOLVED] Show % in PrgBar Dosnt seem to work

    Good point, DM....didn't even look at the logic of his code. I suppose, if there were 6 million records, then the progress bar would move 'slower', but still, nothing is being "loaded", Salsa. If...
  19. Re: [RESOLVED] Show % in PrgBar Dosnt seem to work

    If his pbar (Bar) IS a 3rd-P, then probably Bar.text = Int(Bar.Value * 100 / Bar.Max) & "%" would work
  20. Re: Show % in PrgBar Dosnt seem to work

    To show percent IN A LABEL, you can do this:


    Label1.Caption = Int(ProgressBar1.Value * 100 / ProgressBar1.Max) & "%"

    ..where, in this example, the progressbar is named (the default)...
  21. Re: Show % in PrgBar Dosnt seem to work

    A progressbar does not have a text or textalignment property. Don't see how you are not getting an error with bar.text and bar.textalignment.
    Bar IS your progressbar, correct?
  22. Re: Retrieve Last Inserted ID in MS Access

    like:



    select max(id) as maxid from tablename
  23. Re: Retrieve Last Inserted ID in MS Access

    have you tried "max id"?
  24. Re: Can MSHFlexgrid calculate the total of a column with "group by"?

    Instead of resurrecting a 5 year old thread....
    Why don't you just post in a new thread what you want. "...need some help like this program..." doesn't tell us anything.
    What are you doing?
    What...
  25. Replies
    4
    Views
    162

    Re: Error on Creating Excel File

    Take a look at this link....EXCELLENT tutorial on using Excel with VB6.
    http://www.vbforums.com/showthread.php?391665-Tutorial-FAQ-How-to-Automate-Excel-from-VB6-(or-VB5-VBA)
  26. Replies
    36
    Views
    34,358

    Re: something color with MSFlexGrid

    Here's an example....place an MSFlexgrid on the form. Make it 5 columns (0-4), and make the top row Fixed.

    Option Explicit
    Private Sub Form_Load()
    grid.Row = 1
    Dim x As Integer
    For x = 0 To...
  27. Re: Resize ImageBox and Label arrays with Mouse Wheel

    Look at this: http://www.vbforums.com/showthread.php?437885-mouse-wheel-event-how-to-set-picturebox-scroll
  28. Replies
    4
    Views
    122

    Re: MDIchild to appear in center

    1-As you will have many child forms, use something like this in a module....

    Public Sub CenterForm(frm As Form, frmParent As Form)

    frm.Left = (frmParent.ScaleWidth / 2) - (frm.Width / 2)
    ...
  29. Replies
    4
    Views
    122

    Re: MDIchild to appear in center

    Something like this work for you?

    Private Sub MDIForm_Load()
    frmMDIChild.Move (Me.ScaleWidth - frmMDIChild.Width) / 2, (Me.ScaleHeight - frmMDIChild.Height) / 2
    End Sub
  30. Re: Select the Linked cell of the selected checkbox

    1. You have posted in the wrong Forum....this one is for VB6 and Earlier Versions of VB. There is a separate one for VBA questions.
    2. There are probably several ways of doing what you ask. The...
  31. Re: Removing all extra characters at the end of a line of a DAT file?

    Roger, DM....I also posted the same line for OP to remove Tabs....
  32. Re: Removing all extra characters at the end of a line of a DAT file?

    I added these two line before your first REPLACE command, and it works (in MY example file):

    strLine = Replace(strLine, vbTab, "")
    strLine = Replace(strLine, " ", "")
  33. Re: Removing all extra characters at the end of a line of a DAT file?

    Welcome to the forum.

    Sure....that clue will help, however, to test what I post later, can you attach a sample of the dat file? (Use "Go Advanced" button and Manage Attachments to attach the...
  34. Re: Adding a new control to newly created tab in sstab

    Put your call to the AddListBoxes sub in form_initialize (I believe that was mentioned far above).

    Private Sub Form_Initialize()
    AddListBoxes
    End Sub
    Also, no need to use the Call...
  35. Re: Extract the most left 5 characters from list box

    Okay....you guys want to shoot me...fine. I am just trying to understand and help OP.

    @OP---here is a small example that lets you do what you asked in your first post (extract the most left 5...
  36. Re: Extract the most left 5 characters from list box

    Thx...okay, I think I got it....(i THINK---jms thinks I'm a little slow today)
    Anyway, I assume you want to simply increase the Number from D0001 to D0002 and populate the first text field (KundNr),...
  37. Re: Adding a new control to newly created tab in sstab

    Er---list1(0) set on Tab0...

    What do you mean invalid?

    Here's an example....117791
  38. Re: Adding a new control to newly created tab in sstab

    Gee, jms...what gives? I ASSUME OP knows how many rows he has in his grid....what's wrong with it?...works just fine in my example.
    (I have a msflexgrid1 with 3 rows in it (set in IDE); an invisible...
  39. Re: Extract the most left 5 characters from list box

    Agree totally with your two middle lines (and the latter half of the first), but not the first and last sentences (see my quote) ~smile~

    And I assume you (TLP) and jms totally understand this? (I...
  40. Re: Adding a new control to newly created tab in sstab

    NOTE-if you want the listboxes to be in the same left position on each tab, then change

    list1(aa).Left = (myWidth * aa) + 50

    to

    list1(aa).left = 250 (for example)

    (And remove the dim...
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.