Consulting

Results 1 to 5 of 5

Thread: Persistant private data

  1. #1
    VBAX Tutor
    Joined
    Mar 2005
    Posts
    204
    Location

    Persistant private data

    Haven't been here for a long time...almost "burned out"fighting with ACCESS:
    Now:
    How do I use an ACCESS table as Persistant private data in a class?

  2. #2
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Hey, mud, wb!

    Could you, perhaps, rephrase that? What do you mean by persistent? Private? A form's class module? Another type of class? What do you want to do?

  3. #3
    VBAX Tutor
    Joined
    Mar 2005
    Posts
    204
    Location

    Persistent data

    I want to write a class, "UNIQUE" that has a method that generates a unique string and saves it to an ACCESS table.
    (I have the method).
    Then I can use such as
    UNIQUE.Make to make the unique string,
    UNIQUE.Check to look at the table to make sure there are no repeats
    and so on

    Class Unique
    Private Table1 (Contains the unique strings)
    Public Make()
    Public Return().
    etc
    I want to be able to read this table after I close the program and then reopen it thus "persistent".

  4. #4
    VBAX Tutor
    Joined
    Mar 2005
    Posts
    204
    Location

    Class Module

    With respect to my previous "Reply": I know that the snippet of a "Class' I included was wrong...that I've to write a Class Module...but the question remains the same. How to keep the private data in a class from one run to another.

  5. #5
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    It sounds like you have a pretty good handle on what you want to do. I'm not sure where you need help. Writing the procedures? Making a class module? Using a class module? Getting data from a table using VBA?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •