4 questions-Note: I am a new user!!help...

[Guest]

1) I have setup a form, but I need to ensure the users complete certain
fields and not just tab to the next field. I have tried setting up a macro
with a msg indicating this field can not be left blank, but I can not figure
out where to set it. It does not have an option for tab, it offers key up
key down mouse up, etc. but the users will be tabbing...any suggestions.
2.) In one of the fields need to have the numbers entered in on box and then
re-entered in the next field to verify the the numbers were entered correctly
the first time. (like when entering a password and it ask you to re-enter it
and it compares the two to ensure they match).
3.) I need to save this form to an outlook file so many users can use it at
the same time. How can this be done.
4.) When one users completes the form, it is sent to another user. The
other user will perform the tasks indicated on the form and then on the form
they need to enter their name. What I need is when the first user sends it,
none of their information they entered can be changed by any other user.
Then the person that receives it needs to have 3 fields they can enter data
on.

 

[Carl Rapson]

1) You can use the AfterUpdate event of a field to test for validity. Put
your test in that event.

2) Not sure what you're asking here, but from your description I would just
add a second, unbound field to the form, then in its AfterUpdate event check
that the value entered matches what is in the other field.

3) Again, not sure what you're asking here. You can copy an Access file to
multiple users' PCs. I would recommend that you split the database into a
back-end, containing the tables, and a front-end, containing all other
objects. Place the back-end on a server and place a copy of the front-end on
each user's machine. Use the Linked Table Manager (under Tools | Database
Utilities) to ensure that the path to the tables in the back-end is valid
for all users (all users must use the same drive letter for the server where
the back-end file resides, or you could use the URL instead of a drive
letter). You can search the Access newsgroups (try the multiuser group) for
more information about database splitting.

4) In the Current event for the form, you could check to see if the first
user's name is filled in, and if it is lock all fields (<fieldname>.Locked =
True) but the three you want. Note: be sure to unlock all fields if the
first user's name is NOT filled in. If you really mean "send", however, you
may want to look at using Outlook forms instead of Access. Access forms
can't be "sent" from one user to another.

HTH,

Carl Rapson