Results 1 to 5 of 5
  1. 05-14-2019, 12:03 AM #1
    Archer's Avatar
    Archer
    Archer is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2019
    Location
    Down Under
    Posts
    16

    Setting Form Properties using VBA

    Hi guys.



    I have a form that I want to open in 'read only' or 'locked' mode. That is simple enough. I then want to add a button that allows users to 'edit' existing data on that form when clicked. I've tried using the 'locked' property but keep getting errors. Absolute beginner with VBA. Tried to find some tutorial on YouTube but can't find anything specific. Any help greatly appreciated.
    Reply With Quote Reply With Quote
  2. 05-14-2019, 12:50 AM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,897
    What errors? Provide code and error message.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 05-14-2019, 01:27 AM #3
    Archer's Avatar
    Archer
    Archer is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2019
    Location
    Down Under
    Posts
    16
    Managed to get it sorted.

    Thankyou.
    Reply With Quote Reply With Quote
  4. 05-14-2019, 05:33 AM #4
    orange's Avatar
    orange
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    And the solution is/was? It may help someone else.
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  5. 06-20-2019, 01:51 AM #5
    Archer's Avatar
    Archer
    Archer is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2019
    Location
    Down Under
    Posts
    16
    Quote Originally Posted by orange View Post
    And the solution is/was? It may help someone else.
    Just simply using the 'allow edits' property.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Setting Default Printer Properties with VBA Cocde
    By EddieN1 in forum Programming
    Replies: 2
    Last Post: 12-04-2014, 11:02 AM
  2. Setting db properties with autoexec routine
    By bdaniel in forum Programming
    Replies: 10
    Last Post: 07-17-2014, 12:43 PM
  3. Setting properties while Looping through ControlS
    By Paul H in forum Forms
    Replies: 2
    Last Post: 08-28-2012, 03:43 PM
  4. Setting Field Properties for Numbers
    By Tim Hardison in forum Access
    Replies: 1
    Last Post: 12-09-2009, 06:47 AM
  5. Setting combo box properties
    By rathfam4 in forum Programming
    Replies: 1
    Last Post: 12-28-2005, 02:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums