Locate Table

• Previous message: Vaughn: "Locate Table"
• In reply to: Vaughn: "Locate Table"
• Messages sorted by: [ date ] [ thread ]

Date: Mon, 30 Aug 2004 00:24:05 -0700

Hi Jeff,
The ID_table ( is a two column table which requires the
first alpha characters of a surname and the second column
will contain the numeric which will be incremented) is
used to store data(ie the ID number that I want to
create). My ID_procedure will generate, maintain, and
store these ID no.
When a new customers is entered into my database, I will
call this procedure to generate a new customer number.
This unique customer ID number will be used as the key
for this customer.
This ID_table is not linked to any control on my form.
This procedure will be called when I need to generate a
customer ID. How do I reference the data in this ID_table
created in my database?
When a database is opened are all objects (eg
forms,tables,etc) opened and wait to be used ?
Thanks
-----Original Message-----
>Hi,
>I need to generate an ID number which will be stored in
a
>table created in my database. The ID comprises 3Alpha +
>3Numeric (two fields)contained in this table created.
>How do I reference this table in my procedure in order
to
>work on the data in this table.
>
>Thanks
>.
>

• Previous message: Vaughn: "Locate Table"
• In reply to: Vaughn: "Locate Table"
• Messages sorted by: [ date ] [ thread ]