Help with a Response

[Tom Phethean]

this was the method suggested for my earlier problem
(see "Query Help" message on 14/7/03 )

Create the enrollment table, enter the key values.
Create a VBA proc that opens a recordset, based on the
enrollment table.
(Note: Open it with a locking scheme that only allows
ONE user into the
table at a time.)
Within the proc, assign the user to the key, then return
the key value.

The only problem is that i dont know any VBA, and so would
anyone be willing to write out the code for the above
procedure.

Many thanks in advance.
TP.

 

[RobFMS]

Tom

If you are interested in learning about VBA, please see the link below.
There are several great books on Access.

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm


--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-