Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IDE behaviour (Access 2002 SP3)

    At work we have just started using Access 2002 to develop an application (using Visual Source Safe) & we have a few questions about the behaviour of the IDE :

    1. How do you ensure that the code window opens in a full screen the first time it is opened

    2. We have noticed a problem in that when we click on a module to edit some code the IDE shows a completely different module if it is already open. Has anybody else come across this, and what did they do about it ?

    3. A further issue is that when we open a form in Design mode which contains subforms, we are then asked if we want to edit the subforms too

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IDE behaviour (Access 2002 SP3)

    1) The Visual Basic Editor should "remember" whether the VBE itself was maximized and whether modules within the VBE are maximized.
    2) and 3) Never seem this, perhaps someone who also uses Visual SourceSafe can comment.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: IDE behaviour (Access 2002 SP3)

    There are some substantial changes from Access 97 to the 2000/2002/2003 IDE, and you've run into a couple of them that affect the way VSS behaves. Unless you carefully close all of the module windows and then save the project, you will see those windows open the next time you open the IDE. Also note that you may see modules from other VBA projects if you have references to to them - i.e. library or add-in databases (if they are not hidden and protected).

    As to the subform question, I presume you are getting that from VSS, not from Access. With 2000 and beyond the default design view of a form or report also shows you the subforms or subreports on that object in design view as well. So that is why VSS asks you the question when you check out an object.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: IDE behaviour (Access 2002 SP3)

    If you aren't already using it, I highly recommend the MZ-Tools addin, which includes a handy tool to close all those code windows in the IDE at once. That helps eliminate the odd code windows that aren't the one you wanted. I use it with Access 2002 and source safe with no problems and it saves me tearing my hair out at times.

    In Source Safe, each form or subform is saved as a separate file. If you open and check out a form, that doesn't check out any objects like subforms in it, so you are asked if you want to do so. It is simply the way source safe handles the thing. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IDE behaviour (Access 2002 SP3)

    Charlotte, Wendell

    Thank you for your useful comments. I will certainly remember to close the modules first, then do the save.

    I am using MZ-Tools, which is great, but I had not picked up on the Close windows option.

    Thanks again

    Nick

Posting Permissions

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