Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JBBennett

    Adding ListBox Control at Runtime

    I need to query a database and build a multi-page form based on the data I find. I am working on the last page which is a list of names and what was done with them. To pass the data to the form, I am using a property and doing all the add control work in the property (since I could not figure...
  2. JBBennett

    INVALID USE OF NEW KEYWORD

    OK, thank you. Jason Bennett
  3. JBBennett

    INVALID USE OF NEW KEYWORD

    I think I understand but want to be sure. I hope to work much more with classes as I go. My technique exposes the properties and methods, allowing me to return the value of those items but not have multiple instances of the class in my external project. I would in effect have to create a new...
  4. JBBennett

    INVALID USE OF NEW KEYWORD

    Thank you all for your help. I really appreciated it. The solution at http://support.microsoft.com/kb/555159 worked but I did not like the fact that I had no intellisense and came up with another solution, similar but that gives me intellisense as I work with my code. PROJECT WITH CLASS: I...
  5. JBBennett

    INVALID USE OF NEW KEYWORD

    No, I am not using Option Explicit. Yes, the class is instancing as PublicNotCreatable. How does that affect instantiating and what can I do differently? Jason Bennett
  6. JBBennett

    INVALID USE OF NEW KEYWORD

    I am getting an "Invalid use of New keyword." error in my code. I am working on a Word 2010 VBA document. The code is: Dim Rate As clsHourlyRates Set Rate = New clsHourlyRates For intCounter = 1 to 2 Selection.GoTo What:=wdGoToBookmark, Name:="Hourly_Rate_" & intCounter...

Part and Inventory Search

Back
Top