S
S. Whitney
[Also posted under Modules:]
Today I implemented user-level security on an Access 2000
application we use.
Everything seems OK except for a particular module
designed to fill fields with values from the prior record.*
Now, when accessing the form that calls the module during
OnOpen, I get a MS Visual Basic error: "Compile error:
User-defined type not defined." and the debugger opens
with the following lines highlighted:
Function AutoFillNewRecord(F As Form)
Dim RS As DAO.Recordset, C As Control
I don't think I've changed anything, although to create
the user-level security I had to create a new database and
import all of the objects from the old one.
Thoughts?
swhitney at peelmaster dot com
* -- Module was created from code available in
ACC2000: Fill Record with Data from Previous Record
Automatically
http://support.microsoft.com/default.aspx?scid=kb;en-
us;210236
PS -- For any new users having trouble implementing user-
level security based on the help files and FAQ's at
microsoft.com, I strongly suggest the following site:
http://www.geocities.com/jacksonmacd/AccessSecurity.html
Today I implemented user-level security on an Access 2000
application we use.
Everything seems OK except for a particular module
designed to fill fields with values from the prior record.*
Now, when accessing the form that calls the module during
OnOpen, I get a MS Visual Basic error: "Compile error:
User-defined type not defined." and the debugger opens
with the following lines highlighted:
Function AutoFillNewRecord(F As Form)
Dim RS As DAO.Recordset, C As Control
I don't think I've changed anything, although to create
the user-level security I had to create a new database and
import all of the objects from the old one.
Thoughts?
swhitney at peelmaster dot com
* -- Module was created from code available in
ACC2000: Fill Record with Data from Previous Record
Automatically
http://support.microsoft.com/default.aspx?scid=kb;en-
us;210236
PS -- For any new users having trouble implementing user-
level security based on the help files and FAQ's at
microsoft.com, I strongly suggest the following site:
http://www.geocities.com/jacksonmacd/AccessSecurity.html