by Adam Collis (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 16th February 2001
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Connects and Creates Tables with Multiple Columns and Data Types - EASILY
API Declarations
'Sets Database Name and Path to Current App's Path
Set db = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\DATABASE.mdb")
'and Make Three Columns to it consisting of:
'Date - Text Field, NumTimes - Number Field, TotalTime - Memo
db.Execute "Create Table [" & strUserName & "] ([Date] text, [NumTimes] number, [TotalTime] memo)"
db.Close
No comments have been posted about Connects and Creates Tables with Multiple Columns and Data Types - EASILY. Why not be the first to post a comment about Connects and Creates Tables with Multiple Columns and Data Types - EASILY.