Please help - Access Forms

[access_1]

I am new to MS Access 2007. I need to let the users fill forms in a pre-
defined order. When the user opens the database file, he should get the first
form, fill the data, click on a button that says "Next form", fill it, and so
on till the last form. The user should not have access to the table structure.
If anyone knows how to do this, please help. Thank you

 

[Keith Wilby]

I am new to MS Access 2007. I need to let the users fill forms in a pre-
defined order. When the user opens the database file, he should get the
first
form, fill the data, click on a button that says "Next form", fill it, and
so
on till the last form. The user should not have access to the table
structure.
If anyone knows how to do this, please help. Thank you

First of all I'd post your question to the Forms group, this one is for
Reports. That said, there are a couple of issues. First, whilst hiding the
db window from users is easy, it's just as easy for them to un-hide it. To
make it more difficult for them requires some advanced features. See my web
site for more information on user-level security. Work on a copy of your
file!

To make the forms open in order is fairly easy. Set the first one to open
in the start-up options. Place a command button on each form to open its
successor and to close itself, something like:

DoCmd.OpenForm "frmMySecondForm"
DoCmd.Close acForm, Me.Name

Keith.
www.keithwilby.co.uk

 

[access_1]

Thank you. I'll try your suggestions.

I am new to MS Access 2007. I need to let the users fill forms in a pre-
defined order. When the user opens the database file, he should get the

[quoted text clipped - 4 lines]

structure.
If anyone knows how to do this, please help. Thank you

First of all I'd post your question to the Forms group, this one is for
Reports. That said, there are a couple of issues. First, whilst hiding the
db window from users is easy, it's just as easy for them to un-hide it. To
make it more difficult for them requires some advanced features. See my web
site for more information on user-level security. Work on a copy of your
file!

To make the forms open in order is fairly easy. Set the first one to open
in the start-up options. Place a command button on each form to open its
successor and to close itself, something like:

DoCmd.OpenForm "frmMySecondForm"
DoCmd.Close acForm, Me.Name

Keith.
www.keithwilby.co.uk