Total Access Components
Frequently Asked Technical Support Questions

• What version of Total Access Components do I need? What versions of Access does Total Access Components support?

• Can I try Total Access Components before I buy it?

• Can I use Total Access Components Resize control to create screen resolution independent forms?

• Using a Total Access Components control on a subform in datasheet view doesn't work.

• How can I switch between tabs on the FMS Tab control with the keyboard? How can I use the tab key to set focus from the FMS Tab control to another control?

• Can I left justify rotated text in the Text Effects control?

• Can I resize fonts using the Resize control?

• My controls show as white boxes on my form, or I receive the error "There is no object in this control."

• I am receiving error 438 -- "Object does not support this property or method." in my database with one of your controls.   What causes this?

What version of Total Access Components do I need? What versions of Access does Total Access Components support?

• Total Access Components 2003 supports Access 2000, 2002, and 2003.
• Total Access Components 97 supports Access 95 and Access 97.

Check the Product Compatibility Chart for version information for all of our products.

Can I try Total Access Components before I buy it?

Download the Trial Version to try Total Access Components before you buy it.

Also, remember that FMS products come with a 30-day money back guarantee, so you can buy with confidence!

Can I use Total Access Components Resize control to create screen resolution independent forms?

This functionality is not included in Total Access Components. However, you can do this if you write code to get the screen resolution in addition to using the Resize control.

Here is information found in an MSDN KnowledgeBase Article regarding how to determine the screen resolution in MS Access:

The following example demonstrates how to create and use the sample GetScreenResolution() function.

NOTE: You may have some Microsoft Windows API functions defined in an existing Microsoft Access library; therefore, your declarations may be duplicates. If you receive a duplicate procedure name error message, remove or comment out the declarations statement in your code.

Create a new module, and type the following Declarations and function:

'*****************************************************************
' DECLARATIONS SECTION
'*****************************************************************

Option Explicit

    Type RECT
        x1 As Long
        y1 As Long
        x2 As Long
        y2 As Long
    End Type

    ' NOTE: The following declare statements are case sensitive.

    Declare Function GetDesktopWindow Lib "User32" () As Long
    Declare Function GetWindowRect Lib "User32" _
        (ByVal hWnd As Long, rectangle As RECT) As Long

    '*************************************************************
    ' FUNCTION: GetScreenResolution()
    '
    ' PURPOSE:
    ' To determine the current screen size or resolution.
    '
    ' RETURN:
    ' The current screen resolution. Typically one of the following:
    ' 640 x 480
    ' 800 x 600
    ' 1024 x 768
    '
    '*************************************************************
    Function GetScreenResolution () as String
        Dim R As RECT
        Dim hWnd As Long
        Dim RetVal As Long
        hWnd = GetDesktopWindow()
        RetVal = GetWindowRect(hWnd, R)
        GetScreenResolution = (R.x2 - R.x1) & "x" & (R.y2 - R.y1)
    End Function


On the View menu, click Debug window.

Type the following line in the Debug window, and then press ENTER:
? GetScreenResolution()

Note that the current screen resolution is displayed in the Debug window. If the current resolution is standard VGA, the following is displayed in the Debug window:

640x480

Once the Screen Resolution is found, you can then resize the form to the resolution size found. If you have a Resize control on it, when the form is resized, the OnResize event for the form will also fire, thus firing the code for the control.

Using a Total Access Components control on a subform in datasheet view doesn't work.

Due to a limitation of Microsoft Access, Custom controls don't work in the Datasheet or Continuous Form view.

How can I switch between tabs on the FMS Tab control with the keyboard? How can I use the tab key to set focus from the FMS Tab control to another control?

You may notice that when you use the FMS Tab control, certain keyboard navigation shortcuts are not built in.

If you would like to set the focus to another control when the tab key is pressed, please use the following code. This code was written to be pasted into tab demo 2 in the components demo. Specifically, you will have to update the field named "txtCAStreet" to the name of the control which you want to receive the focus.

Private Sub tabAddress_KeyDown(KeyCode As Integer, ByVal Shift As Integer)
   If (KeyCode=9) And (Shift=0) Then
      'move to next control
      txt CAStreet.SetFocus
   End If
End Sub

Can I left justify rotated text in the Text Effects control.

The Text Effects control was designed to support centered text only.

Can I resize fonts using the Resize control?

Total Access Components 2002 and later allow you to optionally resize fonts on forms by setting the ResizeFonts property to True. Please refer to the Resize and Resize Fonts Property sections of the user manual or help file for details.

Unfortunately, this option is not available in versions of Total Access Components prior to 2002.

My controls show as white boxes on my form, or I receive the error "There is no object in this control."

This problem can occur for 2 reasons:

1. The control was not registered properly. To register the control properly, run the file TACRUN(version).EXE on the users machine. 

   If you are using ODE and TACRUN(version).EXE, please include this file and no other files listed as distributable in the manual.  If you include all the support files and the .OCX, then TACRUN.EXE may not register the controls properly.  Please ensure that you are not distributing any other files related to components except TACRUN.EXE.

    

2. Due to a bug in Microsoft Access (2.0, 95, and 97 only), you may encounter this problem if the control (or the form containing the control) was copied. Delete and reinsert the Total Access Component control(s) using the Insert | ActiveX Control menu. 

I am receiving error 438, "Object does not support this property or method" in my database with one of your controls.

The following are all reasons this error can occur:

1. This can occur if you specify a method of a control that does not exist for that control type.  For example, the .Eject method applies to the CD Player control, and does not apply to any other control.  If you tried to use that method for another control type (e.g. RESIZEControl.Eject), the error would occur.
   
   Please ensure that you are using the proper method for the control you are using. Each of the controls has a list of methods associated with them and can be found in the user manual and help file.
    
2. The control is not registered properly. Please ensure that you have registered the control properly using the Runtime distribution program (TACRUN.EXE).
    
3. The control is being called from the On_Open event of the form in the project. You must allow Access time to set up the controls before trying to invoke any methods for them. Please move the code to the On_Load or On_Activate event instead.
    
4. Due to a bug in Microsoft Access (2.0, 95, and 97 only), you may encounter this problem if the control (or the form containing the control) was copied. Delete and reinsert the Total Access Component control(s) using the Insert | ActiveX Control menu. 

Back to Technical Support FAQ Page