Search Results - VBForums

Search:

Type: Posts; User: SamOscarBrown

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: inserting datas from vb6 to Ms access through SQL

    (Tried to highlight that you were missing an apostrophe and closed quote in between: Value (" & Text1.Text
    should be Value ("'" & Text1.Text
  2. Re: inserting datas from vb6 to Ms access through SQL

    Also, you got some other issues with this line:


    strSQl = "INSERT INTO sturec(Roll no,stuname,stuadd) Values (" & Text1.Text & ",'" & Text2.Text & "','" & Text3.Text & "')"

    probably should be:...
  3. Re: How to Sum total Hours And divide it By 60 syntax error

    Pero si se lee el libro completo, usted podrķa aprender todo
  4. Re: How to Sum total Hours And divide it By 60 syntax error

    Salsa...might I suggest:

    http://www.microsoft.com/learning/en-us/book.aspx?ID=9598&locale=en-us

    ???

    It's only 25 US Dollars
  5. Re: Help me on Total, Subtotal and Grant Total on MSHFLEX GRID

    You can use your SQL query to return the sum, as well as the individual values for each person. You can use 'group by' or query for each person individually.
  6. Re: Problem in displaying number of specific record (Access and vb6)

    also, take out the single quotes in this:
    Quer = "SELECT COUNT(StudentNo) AS 'counttemp' FROM Chores ......

    so it looks like this:

    Quer = "SELECT COUNT(StudentNo) AS counttemp FROM Chores
  7. Replies
    6
    Views
    132

    Re: Connect Access Data with VB6 Form

    @Olaf....I have not been ignoring your teaching above for the past coupla days....just trying to reassess and RE-learn. I guess my VB101 (self-taught) is probably not the way to go (at my age). Am...
  8. Replies
    8
    Views
    163

    Re: [RESOLVED] comic strip of the day?

    Don't know....it works fine....I just re-copied what you sent, created a new project, added the cmd button and the textbox (and made it invisible) and ran it, and it gives me a unique number every...
  9. Replies
    8
    Views
    163

    Re: [RESOLVED] comic strip of the day?

    When?....post your code.
  10. Replies
    1
    Views
    67

    Re: MsFlexgrid 1st column

    Seems to work fine for me.
    I put a 7 column msFlexGrid (named FGrid) on the form and used this code:


    Option Explicit

    Private Sub FGrid_dblClick()
    If FGrid.Cols > 0 Then
    ...
  11. Replies
    6
    Views
    132

    Re: Connect Access Data with VB6 Form

    Okay...here is ONE way you do what you are asking....have fun learning.
  12. Re: Parse cell contents into several columns

    Did u read dile's post? REALLY, you should post in the Office forum...you'll have LOTS more luck!
  13. Re: [RESOLVED] Assigning one array to another

    :-).....gotta have HUMOR in this business sometimes...:-)

    Cute reply!
  14. Replies
    6
    Views
    132

    Re: Connect Access Data with VB6 Form

    Welcome to the Forum, ootkhopdi.
    Are you talking about a JET database with Microsoft Access?
    What are you wanting to do? Have some textboxes where the user types in some stuff, and then clicks a...
  15. Replies
    3
    Views
    82

    Re: data grid coding help

    Trying VERY hard to understand what you want. Datagrid???? MSFlexGrid?
    what are all the names of the fields in your table?
    Which of those are boolean?
    What DATA is in the non-boolean fields?
  16. Replies
    3
    Views
    82

    Re: data grid coding help

    What have you tried so far?
  17. Re: [RESOLVED] autorun a video inside windows media player?

    Never a burden....we all gladly assist where we can.
  18. Re: Multiple conditions for a sql statement

    Please "rate this post" for those who provided you good guidance. Also, please mark this thread as RESOVLED (under Menu, THREAD TOOLS).
  19. Re: autorun a video inside windows media player?

    If you enjoy the support you are getting on this forum, in each post by someone who offered you some good advice/guidance/code, click the 6-pointed Star (rate this post), and 'Thank' the poster that...
  20. Replies
    10
    Views
    194

    Re: Why isnt this working

    In addition to the great advice procided by DataMiser, keep this in mind. Different databases (as well as differing apps) use Reserved Words. I do not know if "register", "name", "class" or...
  21. Replies
    3
    Views
    119

    Re: finding process by patch

    In my search, I found this..possibly you can work with this example:

    Private Declare Function EnumProcesses Lib "psapi.dll" _
    (ByRef lpidProcess As Long, ByVal cb As Long, _
    ByRef...
  22. Re: Multiple conditions for a sql statement

    Yes, SINGLE quotes around that 'b'. And, of course, we are assuming that the field named "Class" is a numeric, not a text. (I say this because a lot of folks on this forum tend to use text fields...
  23. Replies
    25
    Views
    313

    Re: Adding multiple controls

    ESPECIALLY when you want a BUNCH like you do.....a few simple lines of code will create them and place them where you want them. A LOT faster than copy-pase/align.
    Good suggestions DM.
  24. Replies
    10
    Views
    219

    Re: Standard deviation

    No, I meant you can drop the CALLWORD, "CALL".
    This works: FillArray(score))
    No need for the word "Call"....
  25. Replies
    3
    Views
    119

    Re: finding process by patch

    Look at Post # 2 on this thread: http://www.vbforums.com/showthread.php?447184-Check-For-Running-Process

    If that is not what you are looking for, copy THIS into your browser's URL window, you are...
  26. Re: autorun a video inside windows media player?

    So, like DM pointed out just delete that lline...does not apply.
  27. Re: autorun a video inside windows media player?

    You're right DM....I copied the code from one of my examples (which did use it, but not applicable for the MM). I just forgot to delete that along with the other code that I deleted that did not...
  28. Re: autorun a video inside windows media player?

    Try THIS (in a command button click):


    Private Sub Command1_Click()
    Dim FSO As New FileSystemObject
    MMControl1.Command = "stop"
    MMControl1.FileName = "C:\Users\Public\Videos\Sample...
  29. Replies
    10
    Views
    219

    Re: Standard deviation

    PS---You can also drop the "Call" callword.
  30. Replies
    10
    Views
    219

    Re: Standard deviation

    This post is NOT to solve your problem, BUT, I noted that you set your variables to zero (stDev=0, and Total=0) immediately after Declaring them. Those statements are not required as the Declaration...
  31. Replies
    25
    Views
    313

    Re: Adding multiple controls

    I, too, have seen this anomaly on occasion. Not very often, and now can't seem to replicate the 'reverse order paste'....BUT, I have SEEN it before. MarkT...HOW did you replicate OP's issue, and...
  32. Replies
    8
    Views
    163

    Re: [RESOLVED] comic strip of the day?

    Welcome to the Forum!
    Now, if you want a RANDOM number, whereby the next month, a different strip is selected on any given day, then do something like this:

    Put a listbox on your form and make it...
  33. Re: Urgent Looking for Old OCX Components

    Ayup....
  34. Re: [RESOLVED] Assigning one array to another

    Neither will work....InteRger is not .......aw never mind....just poking fun.....:-) Gotta smile at least ONCE a day.....SO, if that is not funny...how about "I was hooked on the Hokey Pokey, but, I...
  35. Re: Urgent Looking for Old OCX Components

    Err....not quite a correct statement. Depending upon WHEN it was copywritten, it would range from 28years to 120 (maybe more). HOWEVER, I know of NO act (United States anyway), that expires...
  36. Re: Urgent Looking for Old OCX Components

    Try putting this in the GOOGLE search box...you'll be AMAZED at the results:

    "vb6 DBGrid32 ocx download"
  37. Replies
    2
    Views
    122

    Re: Connection Test

    How many threads does this make with basically the same question?

    Subs() do not return anything
    Functions are used to return a value

    PRECISELY!!!!

    Now, if you don't want to use a Function,...
  38. Re: object variable not set rs.movenext and wend dosnt work prpoer

    Sorry....can't help with third party controls....if you were using VB intrinsic, I just might be able to. VB's StatusBar SHOULD do what you want, and using my suggested change to the one line,...
  39. Replies
    5
    Views
    219

    Re: Auto increment Alphanumeric

    Shouldn't be that difficult....(I think you left off 01 to 98)....

    for the first 99, VERY simple


    for x = 1 to 99
    if x < 10 then
    myString = "PL0" & cstr(x)
    else
    mystring = "PL" & cstr(x)
  40. Re: Assigning one array to another

    Try something like this example"

    Option Explicit
    Dim array1(128) As String
    Dim array2(256) As String


    Private Sub Command1_Click()
    Dim i As Integer
    For i = LBound(array1) To UBound(array1)
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.