Special view of form for users


C

carolaflaquita

Hi all,
I found very useful this group, thanks for that!
I'm used to work with excel on a daily basis, however now I have to create a form to be sent to other user, who will be feeding the database. The formis almost done but after that I really don't know how to do this: 1. When the user opens the file, s/he can only see the form ready to be filled and then; 2. the user cannot edit the form (bottoms, answer options, layouts, etc) only feeding it.
I really appreciate any help you can provide and thanks in advance :)
Best,
CaroR.
 
Ad

Advertisements

J

John W. Vinson

Hi all,
I found very useful this group, thanks for that!
I'm used to work with excel on a daily basis, however now I have to create a form to be sent to other user, who will be feeding the database. The form is almost done but after that I really don't know how to do this: 1. When the user opens the file, s/he can only see the form ready to be filled and then; 2. the user cannot edit the form (bottoms, answer options, layouts, etc) only feeding it.
I really appreciate any help you can provide and thanks in advance :)
Best,
CaroR.
Just be aware that Microsoft stopped supporting this Usenet newsgroup several
years ago. They can't kill it - newsgroups are like zombies! - but very few of
us still frequent it. See my .sig for more current peer support venues.

That said, you need to be sure your database is backed up, and convert it to a
..mde (for A2000 and earlier) or .accde for later versions. The user will not
be able to make design changes at all in this format (you should keep a copy
of the .mdb or .accdb yourself so you can create improved versions). You can
use the "Startup" options to make this form the default startup form - see the
Help for "Startup", it's a bit different for different versions. And if you
haven't done so already you should "Split" the database into a backend
(tables) and frontend (forms, queries, reports and code); the backend is
shared by all users (you and this person perhaps), and each of you gets a copy
of the frontend. See http://www.granite.ab.ca/access/splitapp.htm for a
discussion, and/or some of these tutorials:

Utter Access discussion forum and resources:
http://www.utteraccess.com

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:

http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also http://www.utteraccess.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top