Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how can I make a form in access read-only?

Status
Not open for further replies.
JodieK

JodieK

Instructor
Jul 27, 2001
15
0
0
GB
This is the code I have so far, but I can still edit the form...


Private Sub Command14_Click()

DoCmd.OpenForm "mainfrmCurrentEmployees"

AllowEdits = False

End Sub

Thank you

Jodie
 
Sort by date Sort by votes
goto the properties of the form and set the following to No:
Allowedits
Allowdeletions
allowadditions

or in code

me.allowedits = false
me.alowadditions = false etc etc

Nick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
95
Andrzejek
Andrzejek
Andrzejek
  • Question
Outlook VBA - Trust access
Replies
3
Views
226
hermanlaksko
hermanlaksko
huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
121
strongm
strongm
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
163
SkipVought
S
K
  • Question
How to resolve define worksheets array
Replies
1
Views
165
combo
combo

Part and Inventory Search

Sponsor

Back
Top