Results 1 to 6 of 6
  1. #1
    wildthingcg is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    20

    Disable Form in .mde

    When creating the .mde is it possible through code to disable a form and keep that same form enabled in the .mdb?



    Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,956
    What do you mean by 'disable'. If no code calls to open the form, what is the issue?
    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.

  3. #3
    wildthingcg is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    20
    Sorry about that. The form is opened hidden in the open event of a menu. It is for an auto-backup. I only need it to run from the .mdb so I don't need it to open in the .mde.

    Thanks

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,956
    Can't really 'disable' the form. You can include a condition in the code:

    If Not CurrentDb.Name Like "*.mde" Then
    'code to run backup
    ...
    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.

  5. #5
    wildthingcg is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    20
    Thank You, I'll give it a shot.

  6. #6
    wildthingcg is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    20
    June7,

    Perfect! Just what I needed.

    Thank You

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Disable Form Design Mode
    By EddieN1 in forum Security
    Replies: 1
    Last Post: 02-16-2012, 03:10 PM
  2. Disable field edit in form
    By cdilly17 in forum Forms
    Replies: 3
    Last Post: 07-12-2011, 10:13 AM
  3. Disable master form close button
    By Carpy01 in forum Forms
    Replies: 3
    Last Post: 12-31-2010, 05:41 PM
  4. Disable checkbox on a form
    By caffe in forum Forms
    Replies: 2
    Last Post: 09-16-2010, 07:37 AM
  5. Disable Checkboxes for a row in Form
    By seshan in forum Programming
    Replies: 1
    Last Post: 02-05-2010, 07:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums