A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Allow users to only add records and not see data source



 
 
Thread Tools Display Modes
  #1  
Old October 4th, 2005, 06:56 PM
jhicsupt via AccessMonster.com
external usenet poster
 
Posts: n/a
Default Allow users to only add records and not see data source

Is there a way for me to have a basic Access form that the user can only fill
in a form? What I am trying to do is have each employee put in their
respective information. Once they put in their information, it will reside
on a server. This is a one time thing -- the employes will enter their
information just this one time.

I want to collect all of the employee's information in one table, but I don't
want any of the employees to see anyone's else.

So basically, once they have entered their information, press "Submit", which
will write to a server. I do not want them to be able to see where on the
server or the path where the information is going to be written, so I will
want to hide the code.

Is there a way to do this?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200510/1
  #2  
Old October 4th, 2005, 07:46 PM
Larry
external usenet poster
 
Posts: n/a
Default

The easiest way to stop them from seeing other data, is to set the forms
"Data Entry" property to Yes. This will allow ONLY data entry.

Now it will not stop them from entering multiple records, but it will stop
them from seeing any other records.

HTH,
Larry

"jhicsupt via AccessMonster.com" wrote:

Is there a way for me to have a basic Access form that the user can only fill
in a form? What I am trying to do is have each employee put in their
respective information. Once they put in their information, it will reside
on a server. This is a one time thing -- the employes will enter their
information just this one time.

I want to collect all of the employee's information in one table, but I don't
want any of the employees to see anyone's else.

So basically, once they have entered their information, press "Submit", which
will write to a server. I do not want them to be able to see where on the
server or the path where the information is going to be written, so I will
want to hide the code.

Is there a way to do this?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200510/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.