Peter's Software
Helping you create better Microsoft Access applications

Table of Contents

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



2. I'm getting a compile error "User-defined type not defined" and "dbs as dao.Database" is highlighted.



3. When doing a search using the small "i", I get the error message "Error in subroutine or function 'txtLocate_Change (1) 2110 - Microsoft Access can't move the focus to the control List0'.



4. When I open the Access 2000, or Access 2002 unlimited licenses version demo I get "Error occured whn attemption to add reference to <file name> 29060 - File not found".



5. Selector doesn't open my form to the selected record. It always opens to the first record. How can this be fixed?



6. Does Selector permit multiple row selections?



7. Is Selector compatible with ADP files?



8. Each time I open the Selector form, it opens a bit higher (or lower) on the screen than the last time I opened it.



9. After opening Selector in dialog mode, it appears that some forms are opened behind the Selector form.



10. After closing a form opened with Selector and returing to the Selector form, the selected record has changed.

Answers

1. When trying to install Selector, I get the following error: "The add-in could not be installed because it is missing a USysRegInfo table".
   
   You are attempting to install Selector using the Add-In Manager. That is not the way to do it. Please see the installation instructions in the Selector help file for more information.
   [Back to the top]
    
2. I'm getting a compile error "User-defined type not defined" and "dbs as dao.Database" is highlighted.
   
   You are probably missing a reference to the DAO library. Open any module in design mode and click Tools > References. Is "Microsoft DAO 3.x Object Library" checked? If not, find it in the list of available references, check it, close the dialog, and re-compile.
   [Back to the top]
    
3. When doing a search using the small "i", I get the error message "Error in subroutine or function 'txtLocate_Change (1) 2110 - Microsoft Access can't move the focus to the control List0'.
   
   This is a known problem related to the text box autocorrect feature, and the Change event procedure. A future version will have the Locate text box autocorrect feature disabled, and this problem will no longer appear.
   [Back to the top]
    
4. When I open the Access 2000, or Access 2002 unlimited licenses version demo I get "Error occured whn attemption to add reference to <file name> 29060 - File not found".
   
   The unlimited, royalty-free distribution license with source code is delivered as an Access 97 .mdb file which can be converted to Access 2000, and Access 2002. If you do not convert the file to your version of Access, then you may get the error above. Try converting the file "sel97u_30.mdb" to "sel20u_30.mdb" for Access 2000, or "sel22u_30.mdb" for Access 2002, then open the demo again.
   [Back to the top]
    
5. Selector doesn't open my form to the selected record. It always opens to the first record. How can this be fixed?
   
   Check to see that the subroutine call
   
   Sel_FindSelectorRecord Me
   
   ... is in your target form OnOpen event procedure. This function will find the selected record and display it on your form.
   [Back to the top]
    
6. Does Selector permit multiple row selections?
   
   The current version (3.x) of Selector does not support multiple row selections. We'll keep this enhancement in mind for a future version.
   [Back to the top]
    
7. Is Selector compatible with ADP files?
   
   No. We will be working on this compatibility in the next version.
   [Back to the top]
    
8. Each time I open the Selector form, it opens a bit higher (or lower) on the screen than the last time I opened it.
   
   The toolbar setting, and the timing of when the toolbar is displayed, or removed, can affect the Selector form placement. If toolbars are not visible when the Selector form closes, then visible when the Selector form opens (or the reverse), the Selector form will appear shifted down (or up) a bit (by the width of the toolbar). If this scenario continues to exist as the Selector form is opened and closed, this could result in the form moving down (or up) the screen.

   To fix this, you can either check the "Open Selector in Dialog Mode" checkbox on the Selector Configuration form, or setup some kind of consistent toolbar setting.

   You can turn off a particular toolbar by using the following code:

   DoCmd.ShowToolbar "MyToolbarName", acToolbarNo

   You may want to do this just prior to opening the Selector form. When returning to your form after closing Selector, you can use the form OnActivate event procedure to show the toolbar again:

   DoCmd.ShowToolbar "MyToolbarName", acToolbarYes

   Also, here's some more information from Access help:

   "If you want to show a particular toolbar on just one form or report, you can set the OnActivate property of the form or report to the name of a macro that contains a ShowToolbar action to show the toolbar. Then set the OnDeactivate property of the form or report to the name of a macro that contains a ShowToolbar action to hide the toolbar."
   [Back to the top]
    

9. After opening Selector in dialog mode, it appears that some forms are opened behind the Selector form.
   
   This happens when a non-dialog form is opened from a dialog form.
   When Selector is opened in dialog mode, and "Close Selector after Open Object" is not checked, and the select button is used to open a form, Selector will open the form in dialog mode so that it will appear on top of the Selector form. However subsequent forms opened from that form will NOT be opened automatically in dialog mode, and will appear behind the Selector form.
   
   The solution is to either uncheck the "Open Selector in Dialog Mode" checkbox, or uncheck the "Close Selector after Open Object" checkbox, or make sure that your forms are opened in dialog mode.
   [Back to the top]
    
10. After closing a form opened with Selector and returing to the Selector form, the selected record has changed.
    
    This may occur when the bound column of the Selector list box is not unique. To resolve this problem, you can check the "Open Selector in Dialog Mode" check box on the Selector Config form for this instance of Selector, or change the bound column of the Selector list box to be a column with unique values.
    [Back to the top]