Create table/table name from textbox

[dododo]

Hi,

I'm trying to create table in my access database that would have name like i type in Textbox and than i have to click the button

With code like this :
Private Sub Command0_Click()
Dim strsql
strsql = "create table '" & txttablename.Value & "' ( id integer , gender char(1) default ""F"");"
CurrentProject.Connection.Execute strsql


CurrentProject.Connection.Close
Me.Application.RefreshDatabaseWindow
End Sub

**Note: txttablename is the name of my textbox

I got error. Please help me to correct it.

[Dal Jeanis]

1) What exactly does the error say?
2) use either msgbox or debug.print to print out your SQL. Read it and see if there is an obvious error.
3) Is "Char(1)" a valid field type in Access? Probably should be Text.

[dododo]

Hi,

I'm trying to create table in my access database that would have name like i type in Textbox and than i have to click the button

With code like this :
Private Sub Command0_Click()
Dim strsql
strsql = "create table '" & txttablename.Value & "' ( id integer , gender char(1) default ""F"");"
CurrentProject.Connection.Execute strsql
CurrentProject.Connection.Close
Me.Application.RefreshDatabaseWindow
End Sub

**Note: txttablename is the name of my textbox

I got error. Please help me to correct it.

thanks. Now i can do it.

[Dal Jeanis]

1) Please post what solved the problem, so that others can learn from the solution.

2) Please mark the thread "solved". Top of page, under "thread tools".

Thanks!