Search Results - VBForums

Search:

Type: Posts; User: Bobbles

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Impossible to avoid duplication !!!

    I am a bit pressed for time, so I cannot quickly find example code for you.
    If I were you I would evolve away from using a rs to do your update.
    I use ACTION queries instead.
    Using those, you can...
  2. Replies
    69
    Views
    1,843

    Re: Unrecognized database format .mdb in VB6

    I believe your mention of .move etc still implies binding ?

    Better if you describe a need you have (not how you will solve it), and we will then describe how to solve it with pure ADO code.
    EG...
  3. Replies
    69
    Views
    1,843

    Re: Unrecognized database format .mdb in VB6

    One day you will realize that -
    - Use ADO
    - Don't use Data Control
    - Don't use binding

    When that day comes (and it will), yell out, and I will help you use the printer object.
  4. Re: Separate a label caption using a period as the separator?

    I will sleep easier if you change your naming conventions -
    lblTotal
    lblDollar
    lblCents
  5. Re: after compiling a vb6 exe file does not run on win7?

    Shirley, there are some of your VB6 programs that will run in W7 ?
    Knock up a couple and try it.
    If they work, then knock up a couple more that have similar dependencies to your initial 'non...
  6. Replies
    69
    Views
    1,843

    Re: Unrecognized database format .mdb in VB6

    98% of professionals do NOT use Data Controls,and 90% of them would be using ADO (instead of DAO)
    MS does little enough to help VB6 programmers with the latest controls, why make life difficult for...
  7. Replies
    69
    Views
    1,843

    Re: Unrecognized database format .mdb in VB6

    Is that DAO ?
    Why not use ADO ?

    Have you tried obtaining a DB created with the older version of Access.
    Does that give the same error ?

    Knock up a tiny project with the bare minimum to...
  8. Replies
    10
    Views
    485

    Re: Help file in VB% using Windows 10

    DAO and ADO are the way we connect to Data Bases such as Access which comes with MS Office Pro.
    Since you are not using them, then the switch to VB6 will be a piece of cake for you.
    I purchased my...
  9. Replies
    10
    Views
    485

    Re: Help file in VB% using Windows 10

    The differences between 5 and 6 were really minor, and were improvements/additions rather than changes.
    There will be no learning curve to use it.
    Your VB5 projects, can be opened in VB6, and then...
  10. Replies
    7
    Views
    392

    Re: latest vbrun files?

    Regarding your first point, I am confused, as every version of Windows since W98SE is supposed to have the runtime.
    I must confess that I have not tried running one of my programs on W10 yet.
    ...
  11. Re: Taking a screenshot of an invisible form (BitBlt)

    Try keeping the other form visible, BUT move it left or right, so that it is off screen.
  12. Replies
    7
    Views
    392

    Re: latest vbrun files?

    I have never distributed the VB6 runtimes, as they are present in every windows since W98SE
    The earlier PCs (eg some XP PCs) may only have the runtime for SP5, but I have stuck with SP5 in my...
  13. Re: Best Practice For Database Access Format

    I use Bang's all the time, just because I love them.
  14. Re: Using Functions and Subs fro many forms

    This may not meet every need you have, but are you aware that you can create public Subs and Functions in a .bas file, and pass a reference to the form, etc into the Sub/Function
    I would sleep much...
  15. Replies
    69
    Views
    1,843

    Re: Unrecognized database format .mdb in VB6

    You should not be using -
    "data control and visual data manager in VB6"
  16. Re: Different menu fontsize running program in W10 vs W7

    What you have said there, is incorrect.
    Everything is not enlarged.
    Only the text is enlarged.
  17. Re: Different menu fontsize running program in W10 vs W7

    I am old so my memory does not work.
    - I think we have disagreed on this in the past (I recall suggesting someone should set it to 9x magnification, and see how well you can program to fix that)...
  18. Re: Simple Order BY problem please help me

    Add one line to your code -

    If rs.State = 1 Then rs.Close
    sql = "SELECT * FROM tblHallBook WHERE book_complete='0' AND book_status='1' ORDER BY book_date ASC"
    Debug.Print sql
    rs.Open sql, cn...
  19. Re: Different menu fontsize running program in W10 vs W7

    I have not read all the posts (thoroughly), but here is something to consider.
    MS have allowed in most versions of windows for the user to change the DPI setting away from normal (make the text...
  20. Replies
    17
    Views
    523

    Re: Registering ActiveX Controls Automatically

    If that were in our codebank/utilitybank (hint, hint)
    I would be one of the first to download it
  21. Replies
    16
    Views
    635

    Re: VB6 Application in LAN

    I agree with DataMiser post 2 (mainly because I don't know any other way to do it)
    I have a program, that is set up like Datamiser said.
    A couple of users with their own EXE's, and the DB on a...
  22. Replies
    24
    Views
    608

    Re: Excel upgrade

    Thanks for the feedback Elroy
    I believe there are two versions of 2013 - purchased(installable), and leased (possibly web based ? ?)
    Will it matter which version he gets ?
  23. Replies
    24
    Views
    608

    Re: Excel upgrade

    I have a friend who uses a program I wrote for him, which automates Excel.
    I have been begging him to NOT upgrade to 2013, as I am frightened that MS will break backwards compatibility in the 2013...
  24. Re: [RESOLVED] UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    It does not work fully in XP (not complaining, just remarking)
    Color changes are not applied. However I can change the Font to say Arial Black, and make it larger. Can't do much else.
    I then ran...
  25. Re: [RESOLVED] UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    OOPs,
    I am 73, and my memory is 100
    I was confusing your .frx with the controls .ctx
    The ver 3.0 lacked a .ctx, whereas the replacement did have a .ctx which I dropped in with it.
    And then my 100...
  26. Re: [RESOLVED] UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    I noticed that the ver 3.0 did not have a companion .frx There was just s single .ctl file
    Thanks for assistance/advice,
    Rob
  27. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    IT IS SOLVED I just replaced my isButton.ctl ver 3.0 with isButton.ctl ver 3.7.2

    Steve made me re-look at ver 3-7-2 (Even though I had tried it before, I may not have gotten around to retrying it...
  28. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    It is not a program I sell.
    Even though I am Scottish, I never have the heart to charge friends for anything (PC Help, Electronics help, and this program that I have written for a friend). The...
  29. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    Steve,
    After my main program crashed, I went through a series of experiments to narrow down why it was crashing. I had a gut feeling it was one of my user controls (my main form uses about 5...
  30. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    I was hoping for a tweak to isButton.ctl, so that I did not have go through the whole project replacing controls.
    That would be a massive task, plus many Forms have frames etc floating above them...
  31. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    Jonney,
    I am just about to try your isButton_ver_3-0_New
    My big project only has isButton.ctl (there are no other assisting files or classes)
    There is no extra subclassing code in my project (no...
  32. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    PS I am about to image my drive, so will be offline for a couple of hours
  33. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    $50 AU (via PayPal) to the person that can fix this for me

    I had a bash at inserting the code LaVolpe mentioned, but it still crashes (I may not know what I am doing)
    The actual version of the...
  34. Re: UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    As I mentioned, I have no experience with UCs, and I have avoided subclassing in my own code, like the plague.
    Would this info from the crash dialog, help those (more knowledgeable than myself), to...
  35. [RESOLVED] UC (.ctl) crashing on Windows Server 2008 R2 Standard SP1 (64bit)

    There is an excellent User Control (.ctl) at -
    http://www.planetsourcecode.com/vb/scripts/showcode.asp?txtCodeId=61476&lngWid=1
    It is called -
    "isButton 3.6.2 the multi style button"

    I have...
  36. Replies
    2
    Views
    147

    Re: Issue with MSDN within VB6

    I have the Oct 2000 version, and I have had to (I thought) live with it set to the entire collection, for over a decade.
  37. Replies
    13
    Views
    579

    Re: Detect if Windows 7 is the OS -- reliably

    I am curious about two things -
    - What is the need to detect W7 (just in case any of us have a similar need in the future)
    - Why VB5 ?
    The changes from VB5 to VB6 were fairly minor (Split/Join,...
  38. Re: How to pass a parameter using Like in Data Environment

    Did you do as I suggested in post 2 above -
    First place your query into a string variable, and debug.print it before executing it ?
    And if you did, Shirley you would have pasted that here as well ?
  39. Replies
    7
    Views
    292

    Re: multiline text inside picturebox

    Gibra,
    I could not find the download link (s) on that page
  40. Replies
    6
    Views
    252

    Re: Trying to import data into an array

    Instead of reading in the test file line by line, you can read it all in in one chunk.
    Then use vbcrlf (or whatever) to split the lines into an array (one line in each element of the array).
    Then...
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.