Search Results - VBForums

Search:

Type: Posts; User: SamOscarBrown

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: Search seven listbox and result get to 8. listbox

    In VB6, I used an array of listboxes...you can do the same in VB.NET, and then can simply use a for-loop to go through all listboxes, will shorten your code tremendously. AND, as was stated thrice...
  2. Re: Search seven listbox and result get to 8. listbox

    I certainly am also confused as to what you want. (And YES, this should be in the .NET forum).
    This is one way (In VB6) to go through your listboxes and find out what the index is for each time that...
  3. Replies
    10
    Views
    228

    Re: Marquee Text in VB 6.0

    Also confused....not quite sure what your issue is...however, the code below is, IMHO, a better way for a marque......
    See if THIS works on your system, and whatever system you have it installed...
  4. Replies
    9
    Views
    352

    Re: Delete a file record

    After you delete the record in the file, rewrite everthing from that file into a new one. That should suffice.
    Can you post your attempt so we can see what kind of file you are using?
  5. Replies
    6
    Views
    226

    Re: enter key instead of tab

    Great....forgot about SendKeys! Thx DM and MarkT.

    PS-OP--you might get "Permission Denied" on your system if running from IDE, but will work when running Exe.
  6. Replies
    6
    Views
    226

    Re: enter key instead of tab

    ....of course, my suggestions MIGHT work with a textbox, not sure about comboboxes tho, as 'validation' would not be logical....
  7. Replies
    6
    Views
    226

    Re: enter key instead of tab

    Don't know, but I SUPPOSE you could find the location of the cursor and in a Case Statement set focus to the 'next' textbox or combobox based upon where the cursor (if in a textbox/combobox)...
  8. Replies
    9
    Views
    206

    Re: Data access error

    Under the Addins Menu, select "Add-In Manager". From there, select the "Package and Deployment Wizard".
    Then, run the Wizard...it will walk you through the steps. During those steps, add the...
  9. Re: how to read the vale from registry

    Look right here on this forum:
    http://www.vbforums.com/showthread.php?563162-Working-with-Windows-Registry-using-Visual-Basic-6-A-complete-Tutorial
  10. Replies
    10
    Views
    632

    Re: closing vbmodal form

    Hmmm... you are right....OP works even if Form2 is not open. So, don't know what is meant by 'crashes'.
  11. Replies
    10
    Views
    632

    Re: closing vbmodal form

    For Each - simplest.
  12. Replies
    10
    Views
    632

    Re: closing vbmodal form

    Another:

    Dim iLoop As Integer
    Dim iHighestForm as integer
    iHighestForm = Forms.Count — 1
    For iLoop = iHighestForm To 0 Step — 1
    Unload Forms(iLoop)
    Next iLoop

    I think you get the...
  13. Replies
    10
    Views
    632

    Re: closing vbmodal form

    simply loop through the forms object..
    One way:


    Dim f As Integer
    f = Forms.Count
    Do While f > 0
    Unload Forms(f - 1)
    If f = Forms.Count Then Exit Do
    f = f - 1
  14. Re: VB6 For/ Next Loop. textbox numeric fill array

    Although what is posted may surely work (didn't review it), why not post YOUR code and someone will help you understand how to FIX it, rather than simply take someone else's code.

    Just a...
  15. Replies
    5
    Views
    3,985

    Re: MS Flexgrid Cell Alignment

    try this:

    .ColAlignment(x) = flexAlignLeftCenter
  16. Re: Problem with Coloring Cells in a MSHFlex grid

    Here's an EXAMPLE of setting the whole ROW to a color....bet you figure out from this your solution.


    Option Explicit
    Private Sub Form_Load()
    grid.Row = 1
    Dim x As Integer
    For x = 0 To...
  17. Replies
    8
    Views
    419

    Re: ln function in vb 6 ??

    THAT confused me even further! :-)
    2.73 base????
  18. Re: [RESOLVED] Operation Must Use an Updateable Query

    After playing around in Access, came up with 'a' correct sql. Thanks for all your help.


    cmd.CommandText = "UPDATE bday INNER JOIN members ON (bday.FirstName = members.FirstName) AND "...
  19. Re: Operation Must Use an Updateable Query

    No, not yet. I'll see what that results in...
  20. Re: Operation Must Use an Updateable Query

    Roger, techgnome....I usually do, but just wanted to show I tried various methods...it HAS to be something in my 'compound' SQL as individual ones (select and update) work fine. Can't seem to id the...
  21. Re: Operation Must Use an Updateable Query

    When using this method - same error:

    mySql = "UPDATE bday p set testfield = "
    mySql = mySql & "(SELECT memberrace FROM members r WHERE r.lastname = p.lastname and "
    mySql = mySql & " ...
  22. Re: Operation Must Use an Updateable Query

    and so do these (individually)

    cmd.CommandText = "select lastname, firstname from bday"

    cmd.CommandText = "select lastname, firstname from members"
  23. Re: Operation Must Use an Updateable Query

    Negative....It is located in app.path. (under my profile). I have complete write perms for this directory And the DB file is not read only.

    This by itself works fine: cmd.CommandText = "UPDATE...
  24. [RESOLVED] Operation Must Use an Updateable Query

    Simple project. 1 database, 2 tables.
    I want to update information in one table based upon what was initially updated into another one. (All after the fact once the first table has been completely...
  25. Replies
    3
    Views
    231

    Re: Msflexgrid metrics

    As each column width may be change (unlike your picture), you might try this as well.



    Private Sub Form_Load()
    Dim widthOfAllColumns As Double
    Dim heightOfAllRows As Double
    g1.BorderStyle =...
  26. Replies
    9
    Views
    386

    Re: How to test for Zorder

    Roger......I see how/why you did that, instead of just two (like my little example). Good example.

    Sammi
  27. Replies
    9
    Views
    386

    Re: How to test for Zorder

    Like: (this MAY be just like post #2).....

    Private Sub Command1_Click()
    Static gbnum As Boolean
    If gbnum = False Then
    PicPiece(0).ZOrder 0
    gbnum = True
    Else
    PicPiece(0).ZOrder...
  28. Replies
    9
    Views
    386

    Re: How to test for Zorder

    can you just do this in the click event of that button"


    PicPiece(0).ZOrder 0 'bring to front
    PicPiece(0).ZOrder 1 'send to back
  29. Replies
    2
    Views
    149

    Re: Examples using DBgrid

    Google this "sheridan dbgrid" --- LOTS of examples.
  30. Replies
    6
    Views
    313

    Re: reading words

    You may already have your solution...but here is an example that also might be of assistance:


    Private Sub Command1_Click()
    Dim SelFile As String
    Dim strdata As String
    Dim x As...
  31. Re: how do i check the last visit of a customer

    Agree with colin....it is easier, IMHO, to search your code for your entire project, and every time you access that table, change the SQLs to use a date field than it is to always having to convert...
  32. Re: how do i check the last visit of a customer

    CORRECT...the string value MUST be in a 'format' of a valid date. Good reminder, MarkT.

    EDIT: But OP can check that with a case statement, for example.
  33. Replies
    3
    Views
    209

    Re: Check if a form is an owner form

    property?
    Read this.
    http://msdn.microsoft.com/en-us/library/aa244181(v=vs.60).aspx
    If you want a property indicated (for some reason), the form that 'owns' another, you can always' create one...
  34. Re: how do i check the last visit of a customer

    like CDate()
  35. Replies
    2
    Views
    375

    Re: Reed Solomon Error Correction

    Hmmm. I wonder if this 13 year-old thread was not possibly solved before today ( or even if OP is still programming in VB6).
  36. Replies
    15
    Views
    376

    Re: Access 2013 connection string

    Thank you, Gibra...
    This is probably related to the link that DataMiser suggested I check in to the 64-bit vice 32.
    When I get the opportunity on that machine, I will re-look into DM's suggestion...
  37. Re: Opening Excel with ADO - error 91

    Thanks....sometimes just not thinking clearly.
  38. Replies
    7
    Views
    308

    Re: Wait for X second

    You 'Declare' in the Declarations section (top of code in the form).
    where you have the word 'wait', replace it with the sleep command (like shown above, Sleep 1000)
  39. [RESOLVED] Opening Excel with ADO - error 91

    Just trying to learn some old stuff....I want to use an excel file I am provided by a customer (15-50K lines, ~20 columns).
    Takes quite some time to read that file into my Access database, so wanted...
  40. Replies
    25
    Views
    832

    Re: VB6 window fitting pic imbeding

    Ok, 'partially' solved. What do you need advice on?
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.