'用VB建立Access数据库结构
Private Sub Command1_Click()On Error GoTo Err100'注释:定义表与字段
Dim DefDatabase As Database
Dim DefTable As TableDef, DefField As FieldSet DefDatabase = Workspaces(0).OpenDatabase(App.Path & "\vbeden.mdb", 0, False)
Set DefTable = DefDatabase.CreateTableDef("VB编程乐园")'注释:dbBinary = 9
'注释:dbBoolean = 1
'注释:dbByte = 2
'注释:dbChar=18
'注释:dbDate=8
'注释:dbInteger=3
'注释:dbLong=4
'注释:dbMemo=12
''注释:dbText=10'注释:建立Name字段为8个字符型
Set DefField = DefTable.CreateField("Name", dbText, 8)
DefTable.Fields.Append DefFieldSet DefField = DefTable.CreateField("Sex", dbText, 2)
DefTable.Fields.Append DefField'注释:该字段允许为空
DefField.AllowZeroLength = True
'注释:建立Age字段为3个的常整型
Set DefField = DefTable.CreateField("Age", dbInteger, 3)
'注释:字段追加
DefTable.Fields.Append DefField'注释:表追加
DefDatabase.TableDefs.Append DefTableMsgBox " VB编程乐园数据库建立完成!", vbInformationExit SubErr100:
MsgBox "对不起,不能建立表。请先再建表前建立VBEden数据库? ", vbCriticalEnd SubPrivate Sub cmdCreate_Click()On Error GoTo Err100'注释:建立名为 VBEDEN 的数据库
CreateDatabase "VB-CODE", dbLangGeneralMsgBox "数据库建立完成! ", vbInformationExit SubErr100:
MsgBox "不能建立数据库! " & vbCrLf & vbCrLf & Err.Description, vbInformationEnd Sub
//转贴
Private Sub Command1_Click()On Error GoTo Err100'注释:定义表与字段
Dim DefDatabase As Database
Dim DefTable As TableDef, DefField As FieldSet DefDatabase = Workspaces(0).OpenDatabase(App.Path & "\vbeden.mdb", 0, False)
Set DefTable = DefDatabase.CreateTableDef("VB编程乐园")'注释:dbBinary = 9
'注释:dbBoolean = 1
'注释:dbByte = 2
'注释:dbChar=18
'注释:dbDate=8
'注释:dbInteger=3
'注释:dbLong=4
'注释:dbMemo=12
''注释:dbText=10'注释:建立Name字段为8个字符型
Set DefField = DefTable.CreateField("Name", dbText, 8)
DefTable.Fields.Append DefFieldSet DefField = DefTable.CreateField("Sex", dbText, 2)
DefTable.Fields.Append DefField'注释:该字段允许为空
DefField.AllowZeroLength = True
'注释:建立Age字段为3个的常整型
Set DefField = DefTable.CreateField("Age", dbInteger, 3)
'注释:字段追加
DefTable.Fields.Append DefField'注释:表追加
DefDatabase.TableDefs.Append DefTableMsgBox " VB编程乐园数据库建立完成!", vbInformationExit SubErr100:
MsgBox "对不起,不能建立表。请先再建表前建立VBEden数据库? ", vbCriticalEnd SubPrivate Sub cmdCreate_Click()On Error GoTo Err100'注释:建立名为 VBEDEN 的数据库
CreateDatabase "VB-CODE", dbLangGeneralMsgBox "数据库建立完成! ", vbInformationExit SubErr100:
MsgBox "不能建立数据库! " & vbCrLf & vbCrLf & Err.Description, vbInformationEnd Sub
//转贴
解决方案 »
- 两天登录csdn n次
- 请大家看看sql语句为什么出现这种错误?
- 如何能构把345000这样的秒数转化为像21:00:32这样的字符串???
- 200分求助!!!SQL2000连接问题!!!在线等待!!参与者有分!解答对者我另开贴给分
- Vb里的注释……
- 我看CSDN的作弊。倒分现象。原来我们那么多的星级用户是这么来的呀。原来花上几个小时倒分,可以从一个三角,一下升到专家总榜榜上有名。
- 缩小字体填充用什么
- recordset.filter的问题,高手看过来(100分)
- 小弟,新来的,请各位大哥、大姐们多关照!!!
- sqlserver 中导出表到外部的文本文件 出错,但在ACCESS97 ,ACCESS2000可以
- 请教一个Datagrid的问题?
- help me!Wait for you!
Set Pw_Tbl = New Table
''''MDB フィールド名リスト
Mw_FldNames = Array("YBN_NO", "YBN_NO_1", "JSY_001", "JSY_001_1", "JSY_002", _
"JSY_002_1", "JSY_003", "JSY_003_1", "IRK_NAM_001", "IRK_NAM_001_1", _
"IRK_NAM_002", "IRK_NAM_002_1", _
"SMI_MEI", "SMI_MEI_1", "ISK_TRK_COD", "ISK_TRK_COD_1")
''''テーブルデザイン
Pw_Tbl.Name = Gw_PrgID
'出错
' Pw_Tbl.AllowZeroLength = True With Pw_Tbl.Columns .Append Mw_FldNames(0), adVarWChar, 8 'SEQ
.Append Mw_FldNames(1), adVarWChar, 8 '会区
.Append Mw_FldNames(2), adVarWChar, 22 '請求先コード
.Append Mw_FldNames(3), adVarWChar, 22 '請求先郵便番号
.Append Mw_FldNames(4), adVarWChar, 14 '住所上段
.Append Mw_FldNames(5), adVarWChar, 14 '住所中段
.Append Mw_FldNames(6), adVarWChar, 21 '住所下段
.Append Mw_FldNames(7), adVarWChar, 21 '医療機関名称上段
.Append Mw_FldNames(8), adVarWChar, 14 '医療機関名称下段
.Append Mw_FldNames(9), adVarWChar, 14 '請求先名称上段
.Append Mw_FldNames(10), adVarWChar, 35 '請求先名称下段
.Append Mw_FldNames(11), adVarWChar, 35 '敬称
.Append Mw_FldNames(12), adVarWChar, 16 '発行部署コード
.Append Mw_FldNames(13), adVarWChar, 16 '発行部署名称(課)
.Append Mw_FldNames(14), adVarWChar, 6 '発行部署名称(係)
.Append Mw_FldNames(15), adVarWChar, 6 '請求年月日
' Pw_Tbl.Columns.Item(1).Type = adEmpty
' Pw_Tbl.Columns.Item(1).RelatedColumn = adEmpty
End With
DefField.AllowZeroLength = True
Dim db As Database
Set db = OpenDatabase("数据库全路径名")
db.TableDefs("表1").Fields("字段1").AllowZeroLength = True‘or false
db.TableDefs("表1").Fields("字段1").Required = True ‘or false
db.Close
Pw_Tbl.Columns.Item(0).Attributes = adColNullable
非常感谢各位!
结贴了!