Expand|Select|Wrap|Line Numbers
- Set mydb = DBEngine.Workspaces(0).OpenDatabase("\172.22.30.41\Training-Data\Training\Gaus\Vertical Updates\Database21.mdb")
- tb = mydb.TableDefs("Sheet1") enter code hereSet fd = tb.CreateField(Me.Date1.Text, dbLongBinary, 1000)
- tb.Fields.Append fd
- mydb.Close
- Set mydb = Nothing
- MsgBox " Date Created"
- Exit Sub