I am a beginer on VBA and I am lear

[carfj1]

I am a beginer on VBA and I am learning it by converting Macros to Modules...

Now I am stuck because the wizard that tranforms Macros to VBA shows the following Error:

Microsoft Access no puede encontrar el asistente o hay un error de sintaxis en la selecion de Declaraciones de un modulo de Microsoft Access del Registro de Windows.

Para asegurarse de que el asistente esta en el Registro de Windows, ejecute instalar para volver a instalar Microsoft Access y compile todos los modulos de Visual Basic en la base de Datos.

As you can see my Access version is on Spanish and its dificult for me to find the reason of this error. What this message tells me is:

1.- Access cannot find the wizard to transform Macros to VBA
2.- Or there is a sintax error on the Declarations of some module (this cannot be because a database with only a macro produces this error)
3.- Install one more time the Access (I have done this in two ways: Reparing with and without reInstalling)

NONE of this solutions have worked.

The last option is to remove all the Office 2000 and Insall it back.
I dont want to do this because I dont have the cd with the Office 2000 sr-1. To get the Sr-1 I have to download about 40MB of SR-1 and Sr-3, that I had installed to resolve some other problems. In fact I think this download create the error on the first place.

If any one can tell me how to avoid Total ReInstalation of Office I would aprreciate it a lot.

Thanks

 

[KornGeek]

I've had a problem with wizards in the past if I start Access by double-clicking on a database file. Instead, I launch Access through the Start menu, and then load the database.

I don't know if this will help you with your issue, but it's worth a try to avoid a reinstall of Access.

 

[grnzbra]

What does the macro do? What steps are involved?

 

[carfj1]

The problem appears with any macro I try to convert to VBA, the Idea is to adapt Macro functions to the procedures I am making on VBA in my forms.

The idea of Opening the Database with the strat route is not working.

Thanks for your ideas.