"No current record" error during export

Updated 2009-09-24 | Filed under Geosync | PDF

Question

When I try to sync my database using Geosync, I get a "No current record" error in my VBA immediate window. It looks something like this: 

EQL: Error: export: Access.Application: SaveAsText(2,FORMNAME,...):
   (EX) No current record.

What's going wrong?

Solution

This is caused by a bug in Microsoft Access. The bug has been confirmed to exist in Access 2000, 2002, and 2003, at least. The bug causes this symptom if you have a form with no Visual Basic code in it, but which has the Has Module property set to Yes. To resolve it, try disabling that property:

  1. VERY IMPORTANT: Make a backup copy of your database before starting.

  2. Open the form (FORMNAME from the error message) in the Access Form Designer.

  3. Open the Properties window by clicking View | Properties

  4. In the Properties window, click the All tab.

  5. Scroll to the bottom of the list to find the Has Module property.

  6. Set the property to No. If asked to confirm your changes, click Yes.

  7. Save and close the form.

  8. Click the EQL Synchronize button to retry synchronization. Note that you may have more than one form with this problem, so you may need to repeat these steps with the other forms.

Related Articles

Unrelated Articles