Won't work in Office 2007

  • Thread starter Thread starter David
  • Start date Start date
D

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.
 
David said:
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.
Click to expand...


That works fine for me. Is VBA code enabled in the database? Is it in a
trusted location?
 
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.
Click to expand...
Control source =CurrentDb.TableDefs("ItemMainInfo").[Connect] gives me
the path and name inOffice2003 but gives an error ( #Name? ) in
Office2007.
Click to expand...

That works fine for me.  Is VBA code enabled in the database?  Is it in a
trusted location?
Click to expand...
 
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.
Click to expand...
Control source =CurrentDb.TableDefs("ItemMainInfo").[Connect] gives me
the path and name inOffice2003 but gives an error ( #Name? ) in
Office2007.
Click to expand...

That works fine for me. Is VBA code enabled in the database? Is it in a
trusted location?
Click to expand...
 
David said:
Thanks, but now I have to study Office 2007 to figure out your answer.
Click to expand...


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