Help with a Response

  • Thread starter Thread starter Tom Phethean
  • Start date Start date
T

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.
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top