|
ShrinkerStretcher
F.A.Q. (Frequently Asked Questions)
(Ask
a Question about ShrinkerStretcher by clicking Here)
General
- Will ShrinkerStretcher work with Access 2010?
- Will ShrinkerStretcher work with Access 2007?
- Will ShrinkerStretcher work with screen resolutions above 1024x768?
- Any idea what kind of performance hit there might be on opening or resizing?
- Will ShrinkerStretcher work with .MDE/.ACCDE files?
- What functionality is in the full version that is not in the trial version?
Installation
- When trying to install ShrinkerStretcher, I get the following error: "The add-in could not be installed because it is missing a USysRegInfo table".
- How do I add a reference from my Access project to ShrinkerStretcher?
- 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".
Usage
- 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?
- My graphic images in an image control don't resize with the rest of the form. What can I do?
- How do you use the SSOpenForm function to open a form as a dialog?
- I put "SS_OnOpen Me" in my form OnOpen event procedure and nothing happens when I open my form. What did I do wrong?
- My non-maximized form does not scale to the current screen resolution when I utilize the "SSOneTimeOnly" feature.
- I used SSControl to resize one form but it resized the form too large! It is bigger than my screen!
- Some of my subforms on tab control pages disappear when I use ShrinkerStretcher SS_OpenForm function to open my forms.
- How can I use the new SS_OpenForm function when I open my forms from a switchboard?
Compile Errors
- I'm getting a compile error "Can't find Project or Library" and it's highlighting the "Chr" function.
- I'm getting a compile error "Method or Data Member Not Found" and it's highlighting ".Edit".
- 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".
- 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".
Runtime Errors
- I'm getting an error: SS_Rescale 6 overflow.
- I'm getting an error: Error (550) in SS_ResizeControls 9 Subscript out of range.
- 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".
- I get the following error during runtime: "There was an error finding saved form inside height and ...".
Answers
-
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]
-
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]
-
Will ShrinkerStretcher work with screen resolutions above 1024x768?
Yes. ShrinkerStretcher will work with any screen resolution.
[Back to the top]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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]
-
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
|
|