changing a module into class module

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • windandwaves
    #1

    changing a module into class module

    Hi Gurus

    I have a module with a bunch of functions that tell me everything about a
    table (e.g. the number of children, whether it exists, the table
    description, etc..., data-entry quality, etc...)

    It would make sense to actually change this module into a class module,
    because then, when I program, I can use the "autocomple te" function.

    However, if I do so, then the functions would not work in queries and on
    controls on forms, etc....

    What would you suggest would be the best solution to
    a. being able to use the autocomplete and other joys of classes

    b. being able to use the individual functions in queries and controls.

    TIA

    - Nicolaas


    Tags: None
    • Tom van Stiphout
      #2
      Re: changing a module into class module

      On Sun, 29 May 2005 15:51:20 +1200, "windandwav es"
      <winandwaves@co ldmail.com> wrote:

      You can use autocomplete by using:
      <modulename>.
      and intellisense will show the public procedures in that module.

      -Tom.

      [color=blue]
      >Hi Gurus
      >
      >I have a module with a bunch of functions that tell me everything about a
      >table (e.g. the number of children, whether it exists, the table
      >description, etc..., data-entry quality, etc...)
      >
      >It would make sense to actually change this module into a class module,
      >because then, when I program, I can use the "autocomple te" function.
      >
      >However, if I do so, then the functions would not work in queries and on
      >controls on forms, etc....
      >
      >What would you suggest would be the best solution to
      >a. being able to use the autocomplete and other joys of classes
      >
      >b. being able to use the individual functions in queries and controls.
      >
      >TIA
      >
      >- Nicolaas
      >[/color]

        Comment

        • windandwaves
          #3
          Re: changing a module into class module

          Tom van Stiphout wrote:[color=blue]
          > On Sun, 29 May 2005 15:51:20 +1200, "windandwav es"
          > <winandwaves@co ldmail.com> wrote:
          >
          > You can use autocomplete by using:
          > <modulename>.
          > and intellisense will show the public procedures in that module.
          >
          > -Tom.[/color]


          Thanks again, never used that before, but it works sweet....


            Comment

            Previous template Next
            Working...