Hi, IS there a VBA code to open the Link Table windows. SF
6 '69 Camaro Feb 13, 2007 #2 Hi. IS there a VBA code to open the Link Table windows. Click to expand... No. However, one may write a VBA procedure to open the Link table dialog window. Try: Public Function linkTbl() On Error GoTo ErrHandler RunCommand acCmdLinkTables Exit Function ErrHandler: MsgBox "Error in linkTbl( )." & _ vbCrLf & vbCrLf & _ "Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description Err.Clear End Function HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blog: http://DataDevilDog.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
Hi. IS there a VBA code to open the Link Table windows. Click to expand... No. However, one may write a VBA procedure to open the Link table dialog window. Try: Public Function linkTbl() On Error GoTo ErrHandler RunCommand acCmdLinkTables Exit Function ErrHandler: MsgBox "Error in linkTbl( )." & _ vbCrLf & vbCrLf & _ "Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description Err.Clear End Function HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blog: http://DataDevilDog.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.