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 strongm 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
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

sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
208
sal21
sal21
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
187
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
461
hermanlaksko
hermanlaksko
huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
210
strongm
strongm
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
323
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top