Won't work in Office 2007

[David]

I have a form with a control that is supposed to show the link for a
table in the mdb.

Control source =CurrentDb.TableDefs("ItemMainInfo").[Connect] gives me
the path and name in Office 2003 but gives an error ( #Name? ) in
Office 2007.

Help me.

 

[Dirk Goldgar]

I have a form with a control that is supposed to show the link for a
table in the mdb.

Control source =CurrentDb.TableDefs("ItemMainInfo").[Connect] gives me
the path and name in Office 2003 but gives an error ( #Name? ) in
Office 2007.

That works fine for me. Is VBA code enabled in the database? Is it in a
trusted location?

 

[David]

Thanks, but now I have to study Office 2007 to figure out your answer.

I have a form with a control that is supposed to show the link for a
table in the mdb.

Control source =CurrentDb.TableDefs("ItemMainInfo").[Connect] gives me
the path and name inOffice2003 but gives an error ( #Name? ) in
Office2007.

That works fine for me.  Is VBA code enabled in the database?  Is it in a
trusted location?

 

[Douglas J. Steele]

See whether what Jeff Conrad has at http://accessjunkie.com/faq_01.aspx
helps.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)



Thanks, but now I have to study Office 2007 to figure out your answer.

I have a form with a control that is supposed to show the link for a
table in the mdb.

Control source =CurrentDb.TableDefs("ItemMainInfo").[Connect] gives me
the path and name inOffice2003 but gives an error ( #Name? ) in
Office2007.

That works fine for me. Is VBA code enabled in the database? Is it in a
trusted location?

 

[Dirk Goldgar]

Thanks, but now I have to study Office 2007 to figure out your answer.

Please let me know if the link Doug posted doesn't answer your questions.