Peter's Software
Helping you create better Microsoft Access applications

Table of Contents

1. How do I enter the Registration Key?



2. After adding a reference to Cub Reporter and attempting to open a report, I get the error: "Error in subroutine or function 'cr_CriteriaFormOpen (1): 3078 the Microsoft Jet Database Engine cannot find ...".



3. When I try to use Cub Reporter in my database, I get a compiler error: "User-defined type not defined".



4. I don't know what you mean when you say add a reference to Cub Reporter. Can you show me how to do this step by step?



5. I'm getting "Error in xg_SetLocalMachine Reg Ket Value Str (1) 2" when I'm trying to enter the Reg Code/Product Key for my Access 2000 or 2002 version of Cub Reporter?



6. I'm getting an error "'cr_GetQueryFieldNamesFromList (2)': 3270 - property not found.". What is this about?

Answers

1. How do I enter the Registration Key?
   
   Open the Cub Reporter Demo and click the "How To Register" button. The registration form should appear.
   [Back to the top]
    
2. After adding a reference to Cub Reporter and attempting to open a report, I get the error: "Error in subroutine or function 'cr_CriteriaFormOpen (1): 3078 the Microsoft Jet Database Engine cannot find ...".
   
   There's a good chance that you have set a reference to the wrong library. Make sure you add a reference to "CR92.mde" (for Access 2000), not "CR92demo.mde".
   [Back to the top]
    
3. When I try to use Cub Reporter in my database, I get a compiler error: "User-defined type not defined".
   
   When used with Access 2000, Cub Reporter requires a reference to Microsoft DAO 3.6 Object Library. The absence of this reference, or the placement of this reference below the Microsoft ADO 2.1 Object Library reference could cause the problem you describe.

   Open a module in design mode, and check Tools>References. Is DAO 3.6 checked? Is ADO 2.1 checked?

   What you need to do is:
   1. Add a reference to DAO 3.6 if it is not already there.
   2. If there is no reference to ADO 2.1, then your problem should be solved. Cub Reporter should work fine now.
   3. If the reference to ADO 2.1 is present, make sure that the reference to DAO 3.6 is ABOVE the reference to ADO 2.1.
   [Back to the top]
    

4. I don't know what you mean when you say add a reference to Cub Reporter. Can you show me how to do this step by step?
   
   OK. Here's what you do if you have Cub Reporter for Access 2000 (for the Access 97 version of Cub Reporter, the file name is "cr82.mde").

   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 "MDE Files (*.mde)".
   8. Find "cr92.mde". It should be in a folder named "Cub Reporter v2 for Access 2000".
   9. Select "cr92.mde" and click "Open".
   10. Click "OK" to close the references dialog box.
   11. That's it. Now you should be able to reference the Cub Reporter module.
   [Back to the top]
    

5. I'm getting "Error in xg_SetLocalMachine Reg Ket Value Str (1) 2" when I'm trying to enter the Reg Code/Product Key for my Access 2000 or 2002 version of Cub Reporter?
   
   There appears to be a problem with Access 2002 and the registry write routine we are using. The work around for now is to manually place the Product Key into the registry. Here's how to do it:

   1. Open the registry editor c:\windows\regedit.exe
   2. Click the "+" sign next to "HKEY_LOCAL_MACHINE"
   3. Click the "+" sign next to "SOFTWARE"
   4. Click the "+" sign next to "PetersSoftware" if it exists. If it doesn't exist, create it by right clicking on "SOFTWARE", then New > Key. Type "PetersSoftware" as the name of the new key.
   5. Create a CubReporter key under PetersSoftware by right clicking on "PetersSoftware", then New > Key. Type "CubReporter" as the name of the new key.
   6. Create a new string value under the CubReporter key, by right clicking on "CubReporter", then New > String Value. Type "ProductKey" as the name of the string value.
   7. Double-click on "ProductKey" to bring up the Edit String dialog box. Enter the Cub Reporter Product Key in the "Value data" text box.
   8. Close the text box, and close Regedit.

   The registration screens should no longer appear.

   This problem has been fixed in version 2.1.
   [Back to the top]
    

6. I'm getting an error "'cr_GetQueryFieldNamesFromList (2)': 3270 - property not found.". What is this about?
   
   This error occurs when there is no caption property for a table field that appears in your report. This will be fixed in version 2.1 so that a missing field caption does not cause this message to appear, but for now the solution is to go into table design and provide a caption for each field that appears on your report. The error message is a warning only, and Cub Reporter will use a default caption, and continue processing.
   [Back to the top]