Search:

Type: Posts; User: PhilJeary; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    344

    Missing bits in VB6 (VB6)

    Not sure if anyone can help as you all use .net these days, but you may remember it from yesteryear /forums/images/smilies/smile.gif

    My References, Components and Properties menu items have...
  2. Re: Object VHow do you reference a user control? (VB6)

    Unfortunately, from a job role point of view at least, upgrading to .Net will involve me getting a new job. Bummer.
  3. Replies
    0
    Views
    762

    Close button on a usercontrol (VB6)

    I have a user control that contains all of the Sales Order Processing functionality for my project.

    If I have a save and close button on my user control, is there a way I can pass something back...
  4. Re: Object VHow do you reference a user control? (VB6)

    Found it!

    You have to:
    declare an object as a variable on the sub form i.e. public T1 as textbox
    set the object on the sub form as the object on the user control i.e. set form1.textbox =...
  5. Re: Object VHow do you reference a user control? (VB6)

    Unfortunately i'm back to struggling with this.

    I have attached a demo app. If you run the ocx from VB i'd like to press the button, open form1, edit text1, press the button and have the contents...
  6. Project Management with Scheduled reports (No idea)

    Hi all,

    This isn't a MS Project question, but I thought this would be the best place to ask it.
    A colleague is trying to find some project management software that has the ability to schedule in...
  7. Replies
    10
    Views
    852

    Re: Slow programming (VB6)

    Thanks Chris.

    I do have a small library of re-usable code I find useful, so its not that I dont do that at all. I generally try to be kept informed about any such functions that the other 2...
  8. Replies
    10
    Views
    852

    Re: Slow programming (VB6)

    By "to get it done", that applies to stuff for customers. The average scenario follows: customer demands changes and give us 2 weeks > code gets written so it works. I prefer to put in some...
  9. Replies
    10
    Views
    852

    Re: Slow programming (VB6)

    Thanks for the tip Steve. I use both of those tools. I have used MZ tools for a few years now, but you highlighted smart indent to me a couple of months back - has come in very handy as the bosses...
  10. Replies
    10
    Views
    852

    Re: Slow programming (VB6)

    I did try and think of how to highlight examples before I posted, but I couldnt think of a way. However:

    do they give you a timeframe for any jobs - YES
    and you overrun it? - YES
    Are they...
  11. Replies
    10
    Views
    852

    Slow programming (VB6)

    For well over 2 years now my boss has told me that my programming takes too long. However, it has become more and more frequent and I dont actually remember doing a piece of work in the last 6...
  12. Replies
    5
    Views
    3,180

    Re: Exporting SQL data to Excel in VB6 (VB6)

    Maybe that syntax just doesnt work with SQL.

    For now I have gone with looping an ADO recordset and adding the records in that way, but i'll keep an eye out for a method of bulk inserting as...
  13. Replies
    5
    Views
    3,180

    Re: Exporting SQL data to Excel in VB6 (VB6)

    Thanks for your reply Hans.

    Just out of interest, when you changed it to suit your situation, was AdoCN still connected to an SQL database or did you connect it to an Access database? I've seen a...
  14. Replies
    5
    Views
    3,180

    Exporting SQL data to Excel in VB6 (VB6)

    What is the best way to export data from a table in SQL to Excel from a VB project?

    I tried AdoCN.Execute "SELECT channelid INTO [Excel 8.0; Database=C:Book2.xls].[Sheet1] FROM tblChannels" but it...
  15. Replies
    7
    Views
    1,331

    Re: Running with missing references (VB6)

    I had a brief read - that sounds like it would be ideal! Thanks Chris.

    I'll have a more in depth look when I get a sec (sec not being in the literal sense!).
  16. Replies
    7
    Views
    1,331

    Re: Running with missing references (VB6)

    So referencing the object but making sure all of the code relating to it is isolated in its own module would avoid any issues where the Excel dlls are missing? Would putting it in a dll be any...
  17. Replies
    7
    Views
    1,331

    Re: Running with missing references (VB6)

    Doh, I keep forgetting about late binding. I've only ever used it once as most of my programming has been for internal use where we have full Office 2003 (or 2000 in years past), hence I always...
  18. Replies
    7
    Views
    1,331

    Running with missing references (VB6)

    Hi all, quick references question for you:

    Will an application run fine with missing references if it doesnt actually run the code that requires the reference? i.e. I have a bit of code to choose...
  19. Replies
    2
    Views
    420

    Re: Memory errors in my app (VB6)

    We have a live update program that updates the dll's. I set them all to download and got the customer to run it so in theory they should all be up to date and new (just in case any got corrupted). ...
  20. Replies
    2
    Views
    420

    Memory errors in my app (VB6)

    Before I start - i'm not necessarily after the answer, I just need to know where to start to try and solve it....

    I have an application that is currently used by various different companies...
  21. Replies
    19
    Views
    823

    Re: Where do you put your code? (VB6)

    Remembering to add the arg in and pass the error to it is the easy bit - dealing with it in a more useful way than my example is a bit more challenging!

    I have a function that writes to an error...
  22. Replies
    19
    Views
    823

    Re: Where do you put your code? (VB6)

    I originally declared my functions as Strings and passed the error back as err.number & ":" & err.description, or "SUCCESS" if it succeeded.
    However, my current technique is to pass an optional...
  23. Replies
    19
    Views
    823

    Re: Where do you put your code? (VB6)

    I've been using MZTools for a few years (I'm the only one though), but that Smart Indenter looks like it could come in really handy, thanks Steve!
  24. Replies
    19
    Views
    823

    Re: Where do you put your code? (VB6)

    Most of my program is based on databases and alot of the errors come from incorrect/missing data which I try and deal with the best I can in the error handling, but I don't always find it too easy -...
  25. Replies
    19
    Views
    823

    Re: Where do you put your code? (VB6)

    Woohoo, I am doing it right after all!

    At the moment, all of my code that, for example, opens a recordset, runs some SQL, populates a combo box etc is sitting in modules and the bulk of the code...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4