Missing fields when I import from Access to Excel...
 

Hi!, I have an auto update import on a access table, it works mostly
ok, it update all user entered fields ok, but the fields that come up
automatically when you make a selection somewhere else on the form
don't. For example, when I select member # from a drop down, the First
and Last Names come up in the respective fields automatically. The
drop down list, has the member # in one row, and the first and last
names in following rows respectively. When I import to excel, it gets
the member #, but not the first and last names. It doesn't even create
a column heading for them. Other fields that are automatically filled
in also don't get imported, but I think I can use the solution I find
here for them as well.

Thank You,

Peace and Love,
AAOO (Sean)

Missing fields when I import from Access to Excel...
 

Nevermind, this turned out to be a problem on the access side...sorry...

Missing fields when I import from Access to Excel...
 

I think you'd be better off posting this to one of the Access groups. It
sounds like the record source you're using in the Access file is looking up
certain fields of data from other tables/queries for display purposes in the
object (Form?) you're trying to import from. It may simply be a matter of
importing directly from the Form's record source rather than the Form
itself, but I can't be sure without more info about what you're starting
with in Access... And quite honestly there are more qualified sources than I
in the Access groups.

HTH |:)
Bob Jones
[MVP] Office:Mac



On 10/31/06 3:50 PM, in article
, "AAOO (Sean)"
wrote:

Hi!, I have an auto update import on a access table, it works mostly
ok, it update all user entered fields ok, but the fields that come up
automatically when you make a selection somewhere else on the form
don't. For example, when I select member # from a drop down, the First
and Last Names come up in the respective fields automatically. The
drop down list, has the member # in one row, and the first and last
names in following rows respectively. When I import to excel, it gets
the member #, but not the first and last names. It doesn't even create
a column heading for them. Other fields that are automatically filled
in also don't get imported, but I think I can use the solution I find
here for them as well.

Thank You,

Peace and Love,
AAOO (Sean)