Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2006
    Posts
    4

    Need Help Getting to Code

    Hello,

    A client has given me a DB created by a contractor and would like me to make some changes. I am a bit rusty when it comes to Access programming and can't seem to open the code window or form designer.

    I have tried alt+F11 which gets me nothing and the developer also removed the majority of the tool bars and the ones left are severely restricted.



    Oh, the DB opens directly to a Form and all additional choices are through forms.

    Before I go back to the client, hat in hand, and tell them I can't even get into design mode, are there any things that I can try?

    I appreciate any and all help!

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Is this an MDE file? If so, you are out of luck: in MDEs, the code is completely compiled and locked away, forever out of reach to mere mortals.

    Patrick

  3. #3
    Join Date
    Feb 2006
    Posts
    4
    nope, it is a .MDB file.

  4. #4
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    If the mdb has security applied, it could be that your user/group permissions do not grant you access to design objects...

  5. #5
    Join Date
    Feb 2006
    Posts
    4
    ok, I appreciate the feedback.

    I should be able to get to the design objects or code by typing alt+F11 correct?

    If not, that means there is security enabled?

    I appreciate the patience,

  6. #6
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Snuffles,

    To be honest, I am not an expert on Access security. I know enough about it that I do not recommend using it :shock:

    Alt-F11 should call up the VB Editor, unless of course your predecessor implemented code that disabled that hotkey combination (I know how to do that in Excel, but not in Access, but presumably it's possible).

    Patrick

  7. #7
    Join Date
    Feb 2006
    Posts
    4
    Thanks Patrick,

    You gave me enough confidence to go back and ask how to get at the code or get the DB into design mode.

    Wanted to make sure that I did not miss something really simple!

  8. #8
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Good luck with your project!

  9. #9
    ehenriquez is offline Novice
    Windows Vista Access 2003
    Join Date
    Apr 2008
    Location
    Chatsworth, CA
    Posts
    1

    Hello

    Try Shift + F11

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

Similar Threads

  1. Code Trouble?
    By briancb2004 in forum Access
    Replies: 0
    Last Post: 10-08-2008, 04:47 PM
  2. Need help with code
    By hoenheim in forum Programming
    Replies: 9
    Last Post: 09-11-2008, 04:19 PM
  3. Navigation Code
    By henryclay in forum Forms
    Replies: 2
    Last Post: 11-15-2006, 09:48 AM
  4. Problem with Code
    By cujee75 in forum Programming
    Replies: 0
    Last Post: 03-10-2006, 02:40 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
  •  
Other Forums: Microsoft Office Forums