Vba mapping from Access 2002 fields to outlook 2002 (contacts) ?

[Marc]

Hello,


do you know how to adress access 2002 fields
with the same name ?
->
I have 2 fields with the same name : "City"
but from 2 different tables.
(one named TableA.City, the other TableB.City)

I try the following synthax but with no success :
. HomeCity = ![TableA.City]
. BusinessCity = ![TableB.City]

does it have somthing to do with alias on the Access side ?
What is the synthax to write these fields so they can be
assigned to Outlook contact fields ?


Thank you !
M.

 

[Ken Slovak - [MVP - Outlook]]

You are better off posting Access questions to an Access newsgroup,
but does this work any better?

.. HomeCity = ![TableA].[City]

Are you getting a recordset object in your code and iterating that
recordset object? How are you getting a reference to the database and
the tables in it?