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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting Record Locking

Status
Not open for further replies.
Malc8179

Malc8179

MIS
Joined
Oct 8, 2007
Messages
28
Location
GB
Hi Guys

Any idea on how i can set the option "Edited Record" on the record locking section on the advanced tab of the Options Menu using VBA

Malc
 
Sort by date Sort by votes
Yes.

Code: 
Const conNoLocks = 0
Const conNoRecords = 1
Const conEditedRecords = 2

Debug.Print GetOption("Default Record Locking")

SetOption "Default Record Locking", conEditedRecords
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
1K
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question Question
Open filtered for and set cursor at particular record
Replies
1
Views
833
Moss100
Moss100
renigar
  • Locked
  • Question Question
Code to write file path to field always writes to 1st record
Replies
5
Views
1K
dhookom
dhookom
Moss100
  • Locked
  • Question Question
Vba adding record to table when field is integer
Replies
8
Views
885
Moss100
Moss100
MacroAlan
  • Locked
  • Question Question
Empty recordset stops
Replies
3
Views
663
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top