Peter's Software
Helping you create better Microsoft Access applications


Home

General info

Where to buy

Mailing List

Contact


Links


ShrinkerStretcher F.A.Q. (Frequently Asked Questions)

(Ask a Question about ShrinkerStretcher by clicking Here)

Table of Contents

    General

  1. Will ShrinkerStretcher work with Access 2010?


  2. Will ShrinkerStretcher work with Access 2007?


  3. Will ShrinkerStretcher work with screen resolutions above 1024x768?


  4. Any idea what kind of performance hit there might be on opening or resizing?


  5. Will ShrinkerStretcher work with .MDE/.ACCDE files?


  6. What functionality is in the full version that is not in the trial version?


  7. Installation

  8. When trying to install ShrinkerStretcher, I get the following error: "The add-in could not be installed because it is missing a USysRegInfo table".


  9. How do I add a reference from my Access project to ShrinkerStretcher?


  10. I can't add a reference to "Microsoft ADO Ext. 2.5 for DDL and Security", because I don't have it in my available references list. I only have "Microsoft ADO Ext. 2.1 for DDL and Security".


  11. Usage

  12. My form has rescaled much smaller than expected. It is tiny and in the upper left-hand corner of the window. What can I do?


  13. My graphic images in an image control don't resize with the rest of the form. What can I do?


  14. How do you use the SSOpenForm function to open a form as a dialog?


  15. I put "SS_OnOpen Me" in my form OnOpen event procedure and nothing happens when I open my form. What did I do wrong?


  16. My non-maximized form does not scale to the current screen resolution when I utilize the "SSOneTimeOnly" feature.


  17. I used SSControl to resize one form but it resized the form too large! It is bigger than my screen!


  18. Some of my subforms on tab control pages disappear when I use ShrinkerStretcher SS_OpenForm function to open my forms.


  19. How can I use the new SS_OpenForm function when I open my forms from a switchboard?


  20. Compile Errors

  21. I'm getting a compile error "Can't find Project or Library" and it's highlighting the "Chr" function.


  22. I'm getting a compile error "Method or Data Member Not Found" and it's highlighting ".Edit".


  23. I'm using Access 2000 (or 2002) and I'm getting a compile error "User-defined type not defined" and it's highlighting "Dim cnn As Connection".


  24. I'm using Access 2000 (or 2002) and I'm getting a compile error "User-defined type not defined" and it's highlighting "Dim cat As New ADOX.Catalog".


  25. Runtime Errors

  26. I'm getting an error: SS_Rescale 6 overflow.


  27. I'm getting an error: Error (550) in SS_ResizeControls 9 Subscript out of range.


  28. I get the following error during runtime "Error in SS_FilFRArray (1) - 2684 The OLE object is empty", or "Error in SS_FilFRArray (1) - 2774".


  29. I get the following error during runtime: "There was an error finding saved form inside height and ...".


Answers

  1. Will ShrinkerStretcher work with Access 2010?

    Yes, ShrinkerStretcher version 11 will work with Access versions 2010 through 2000..

    ShrinkerStretcher version 10 will work with Access 2010 as long as you have no tab controls on your forms.
    [Back to the top]
     
  2. Will ShrinkerStretcher work with Access 2007?

    Yes. Version 10.0 of ShrinkerStretcher works with Access 2007 (and Access 2003, 2002, and 2000).

    Version 9.2 of ShrinkerStretcher will work in Access 2007 with an application converted from a previous Access version, and with new Access 2007 applications that do not utilize the new layout grouping, and horizontal and vertical anchoring of controls features. Control placement and size will appear distorted if these new features are used with ShrinkerStretcher. A new version designed to handle these new features is coming soon.

    Also, one small fix needs to be made if you are using .accde files. The line is in the function SS_IsMDE

    If InStr(1, strProjectName & ";", ".mde;") Then
    ... Should be changed to:

    If InStr(1, strProjectName & ";", "de;") Then
    This change will be incorporated into the next release of ShrinkerStretcher.
    [Back to the top]
     
  3. Will ShrinkerStretcher work with screen resolutions above 1024x768?

    Yes. ShrinkerStretcher will work with any screen resolution.
    [Back to the top]
     
  4. Any idea what kind of performance hit there might be on opening or resizing?

    The performance hit depends on the speed of the PC. My old 133mhz would take an extra 1-2 seconds to open a moderately busy form. Any performance hit at form open time can be COMPLETELY eliminated by using static rescaling. More information is included in the help file that accompanies the trial version.
    [Back to the top]
     
  5. Will ShrinkerStretcher work with .MDE/.ACCDE files?

    ShrinkerStretcher works in two modes, dynamic (where forms are rescaled with each form resize event) and static (where a form is rescaled and saved beforehand, then opened at the rescaled size).

    Dynamic rescaling works with .MDB/.ACCDB and .MDE/.ACCDE files. Static rescaling works with .MDB/.ACCDB files, but not with .MDE/.ACCDE files.
    [Back to the top]
     

  6. What functionality is in the full version that is not in the trial version?

    The trial version is fully functional. The only differences are: You don't have access to the source code, and nag messages appear. With the registered version, you get all the source code, and no nag messages.
    [Back to the top]
     
  7. When trying to install ShrinkerStretcher, I get the following error: "The add-in could not be installed because it is missing a USysRegInfo table".

    You are attempting to install ShrinkerStretcher using the Add-In Manager. That is not the way to do it. Please see the installation instructions in the ShrinkerStretcher help file for more information.
    [Back to the top]
     
  8. How do I add a reference from my Access project to ShrinkerStretcher?

    OK, this is how you do it step by step:

    1. Open your Access database application.
    2. Click modules tab.
    3. If there is no module, create one (click "new").
    4. If there already is a module, open it in design mode.
    5. On the menu, click "Tools" > "References". The references dialog box should appear.
    6. Click "Browse".
    7. In the "Files of Type" combo box, select "ACCDE Files (*.accde)" if you have installed the ShrinkerStretcher demo, select "ACCDB Files (*.accdb)" if you have installed the ShrinkerStretcher registered version. Select .mde or .mdb files if you have a version of Access prior to 2007.
    8. Find the ShrinkerStretcher .accde, or .accdb file. It should be in a folder named "C:\ProgramData\Peters Software\ShrinkerStretcher".
    9. Select the ShrinkerStretcher .accde or .accdb file that corresponds to your installed Access version and click "Open".
    10. Click "OK" to close the references dialog box.
    11. That's it. Now you should be able to reference the code in the ShrinkerStretcher module.
    [Back to the top]
     

  9. I can't add a reference to "Microsoft ADO Ext. 2.5 for DDL and Security", because I don't have it in my available references list. I only have "Microsoft ADO Ext. 2.1 for DDL and Security".

    Just check "Microsoft ADO Ext. 2.1 for DDL and Security". When you close the references dialog, and open it again, it becomes "Microsoft ADO Ext. 2.5 for DDL and Security".
    [Back to the top]
     
  10. My form has rescaled much smaller than expected. It is tiny and in the upper left-hand corner of the window. What can I do?

    Open your form in design mode and look for any empty form space on the far right or bottom. Remove this empty form space if it is not needed. Save the form and open it again to see if the problem persists.
    [Back to the top]
     
  11. My graphic images in an image control don't resize with the rest of the form. What can I do?

    Try setting the image control SizeMode property to "Zoom" or "Stretch" instead of "Clip".
    [Back to the top]
     
  12. How do you use the SSOpenForm function to open a form as a dialog?

    Set your form PopUp and Modal properties to "Yes". OR, don't use SS_OpenForm to open the form, and instead use "Usage 2" (put the subroutine calls "SS_OnOpen Me" and "SS_OnResize Me" in your form's OnOpen and OnResize event procedures, respectively) and open the form with
    DoCmd.OpenForm "MyFormName", , , , , acDialog

    [Back to the top]
     
  13. I put "SS_OnOpen Me" in my form OnOpen event procedure and nothing happens when I open my form. What did I do wrong?

    If you are using "Usage 2" as described in the help file, you need to put a call to "SS_OnOpen Me" in your form OnOpen event procedure AND a call to "SS_OnResize Me" in your form OnResize event procedure. For this usage, you need both subroutine calls to get the form to rescale.
    [Back to the top]
     
  14. My non-maximized form does not scale to the current screen resolution when I utilize the "SSOneTimeOnly" feature.

    Version 9.2 - There is a new way to scale forms only when they open: "Resize=OneTimeOnly" in the OpenArgs parameter of the SS_OpenForm function. See the help file for more information.
    [Back to the top]
     
  15. I used SSControl to resize one form but it resized the form too large! It is bigger than my screen!

    Try this:
    1. Restore the form from the backup ("MyForm (SSOriginal)").
    2. Put the text "SSStaticRescale" in the form tag property.
    3. Try the static resize using the SSControl form again.

    Without the "SSStaticRescale" text in the form tag property, a statically rescaled form that has the SS subroutine calls in the OnOpen and OnResize event procedures may be over-scaled.
    [Back to the top]
     

  16. Some of my subforms on tab control pages disappear when I use ShrinkerStretcher SS_OpenForm function to open my forms.

    Apparently Access sets the visible property of subforms on tab control pages (other than the first page) to false when the form is opened, or being opened. Then it sets the visible property to true at some point later. ShrinkerStretcher versions greater than 9.1 will take this (quirk? Anomaly?) behavior into account. The resolution is to modify one line of code in the SS_Rescale function like so:

            '*** Replace the following line with the one below it: ***
            'If SS_apiIsZoomed(frm.hwnd) Then
            If SS_apiIsZoomed(frm.hwnd) Or processing_a_subform Then

    The code is in a section that starts with the comment "Set resolution adjustment flag", and is about 1/2 way down in the SS_Rescale function:

    '* Set resolution adjustment flag
    AdjustRes = False
    If conAdjustToRes And JustOpened Then
        If (DisplayLogPixelsY = 0) Or (iOrigHt = 0) Then
            ResFactor = 1
        Else
            AdjustRes = True
            ResFactor = SSResFactor
        End If
        '* Special processing for autocenter forms
        If frm.AutoCenter = True Then
            '*** Replace the following line with the one below it: ***
            'If SS_apiIsZoomed(frm.hwnd) Then
            If SS_apiIsZoomed(frm.hwnd) Or processing_a_subform Then
    
    

    [Back to the top]
     
  17. How can I use the new SS_OpenForm function when I open my forms from a switchboard?

    You should be able to replace the "Docmd.OpenForm" statements in the Switchboard form module HandleButtonClick routine with "SS_OpenForm". Like so:

    ...
    ' Open a form in Add mode. 
    Case conCmdOpenFormAdd 
        'Note the number of commas in the SS_OpenForm statement:
        'DoCmd.OpenForm rst![Argument], , , , acAdd
        SS_OpenForm rst![Argument], , , acAdd 
            
    ' Open a form. 
    Case conCmdOpenFormBrowse
        'DoCmd.OpenForm rst![Argument]
        SS_OpenForm rst![Argument]
    ...
    

    [Back to the top]
     
  18. I'm getting a compile error "Can't find Project or Library" and it's highlighting the "Chr" function.

    You may have a problem with your library references. Open any module in design mode and click Tools > References. Are any checked libraries in the list "MISSING:"? If so, you must resolve these before continuing. Either remove or fix (click browse and find the library) the missing references. If the missing references can't be resolved, an Access re-install may help.
    [Back to the top]
     
  19. I'm getting a compile error "Method or Data Member Not Found" and it's highlighting ".Edit".

    Version 8.0.82 running under Access 2000 - This compile error can occur when your reference to ADO (Microsoft ActiveX Data Objects 2.1 Library) is ABOVE your reference to DAO (Microsoft DAO 3.6 Object Library).

    Try switching their order in the references dialog, or remove the reference to ADO.
    [Back to the top]
     

  20. I'm using Access 2000 (or 2002) and I'm getting a compile error "User-defined type not defined" and it's highlighting "Dim cnn As Connection".

    This error occurs because you have imported the 2 ShrinkerStretcher modules, and you are missing a reference from your database to "Microsoft ActiveX Data Objects 2.1 Library". If you import the modules, this reference, as well as "Microsoft ADO Ext. 2.x for DDL and Security" is required.

    You can resolve this by adding a reference from your application to the library(s) above, or you can remove the ShrinkerStretcher modules from your application and instead add a reference from your application to the ShrinkerStretcher library .mdb file.
    [Back to the top]
     

  21. I'm using Access 2000 (or 2002) and I'm getting a compile error "User-defined type not defined" and it's highlighting "Dim cat As New ADOX.Catalog".

    This error occurs because you have imported the 2 ShrinkerStretcher modules, and you are missing a reference from your database to "Microsoft ADO Ext. 2.x for DDL and Security". If you import the modules, this reference is required.

    You can resolve this by adding areference from your application to the library above, or you can remove the ShrinkerStretcher modules from your application and instead add a reference from your application to the ShrinkerStretcher library .mdb file.
    [Back to the top]
     

  22. I'm getting an error: SS_Rescale 6 overflow.

    This overflow error can occur when ShrinkerStretcher attempts to rescale a form or place a control beyond the Access 22 inch limit. Open your form in design mode and check how wide it is, and check the length. Is it close to the 22 inch limit? Remember that when scaling to a larger size, the size of the form will increase, so the size of the form in design mode should be much less than 22 inches.

    Is your form a continuous form? The saved form window size will affect the resulting form size. Try opening the continuous form in design mode, resize the form window to roughly the desired end result form proportions, and then save the form. This should improve results.
    [Back to the top]
     

  23. I'm getting an error: Error (550) in SS_ResizeControls 9 Subscript out of range.

    This is a bug that occurs when opening an .mdb file with Access 2010. To fix it, replace the following code in the basShrinkerStretcher module:

    #If VBA7 Then
        For iCA = 0 To CALastRow

    With this code:

    #If VBA7 And Access2007 Then
        For iCA = 0 To CALastRow

    This error will be fixed in ShrinkerStretcher v11.7 and later versions.
    [Back to the top]
     

  24. I get the following error during runtime "Error in SS_FilFRArray (1) - 2684 The OLE object is empty", or "Error in SS_FilFRArray (1) - 2774".

    Version x.0.9 - ShrinkerStretcher is having a problem trying to find/set the font size for the OLE control. To fix the problem, make the following code changes to the SS_FillFRArray, and SS_SetFontSize subroutines:

    Replace the second instance of the following line:

    If Err = 438 Or Err = 2455 Then
    

    With:

    If Err = 438 Or Err = 2455 Or Err = 2684 or Err = 2774 Then
    

    [Back to the top]
     
  25. I get the following error during runtime: "There was an error finding saved form inside height and ...".

    Version x.0.9 - This error means that there may be a problem maintaining the aspect ratio when rescaling a long (multi-page) form. If you don't have any long forms, you can ignore and/or comment out the MsgBox statment that produces this error.

    The problem occurs when the SS_OnOpen routine does not execute before the SS_OnResize routine. Using the SS_OpenForm function to open your form will eliminate the problem, or, if you must use the SS_OnResize routine, make sure you also include the SS_OnOpen routine in the form OnOpen event procedure.
    [Back to the top]
     

Register this software.

Ask a Question about ShrinkerStretcher

Back to ShrinkerStretcher Page

 

 

Copyright 1998-2000 Peter's Software