Convert Access 97 to Access 2002

[Moira Triance]

Can anyone help please? I have an Access 97 VBA conversion to 2002 to perform and I don't know the code equivalents. One problem is this:
Dim objWord As Word.Application
what is the 2002 equivalent please?

Is there anywhere a list of 2002 code equivalents?

Any help greatly appreciated

 

[MarionD]

Hallo Moira - is it not perhaps an ADO / DAO problem that you are having. From the design view in any module check under references. Microsoft DAO 3.6 should be ticked and have a higher priority than the reference to ActiveX Objects. Then compile and you should be able to run the DB with no problems witout any changes to the code.

Marion
Knittlingen, Germany

 

[Moira Triance]

Hallo Marion
Thank you for your help, I have a tick against the following references in this order:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for Applications Extensibility 5.3

I cannot move the DAO reference up the list and when I try to compile I get the error referred to in my first post. There may be other compile errors that haven't appeared yet. I am really grateful for any help as I am totally out of my depth here.

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Hi Moira

Because you are referring to Word I think you need to set the reference to Microsoft Word as well.(Tick in the references) I wouls also tick the Microsoft Office reference. The Priority of these should not matter.
Try the above and if it still doesn't help perhaps you'd like to mail me your DB and I could have a look at it here.

Marion

 

[MarionD]

Sorry about that - I keep getting a message that the page cannot be opened! But apparently it worked anyway!
Can't say I stopped trying can you!

 

[Moira Triance]

Thank you so much Marion, I think you have solved it! I will try it on my client site tomorrow (Friday) and let you know if it works. It did work on my test copy.

You are a star!!

 

[MarionD]

My pleasure!