Search results

Maybe it has been solved, maybe not. I am aware of the length of time that has elapsed since the posting. Thanks to the dbGuy for offering a solution.

I wonder if this issue has been resolved. it's awfully easy to delete a whole field of text when it is automatically selected.

Thanks again, that was the problem. Pretty dumb of me, and clever of you.:)

Thanks, but I still get an "error in field statement" message for that. Here is the actual code: SQL = "CREATE TABLE [" & strStudent & "]" & _ "(Piece CHAR(20), Date CHAR(10))" DoCmd.RunSQL SQL:( It works with one field specified, thus: SQL = "CREATE TABLE [" & strStudent & "]" & _ "...

Trying to write an SQL string for creating a table with two fields. One field goes fine: SQL = "CREATE TABLE x" & _ " (f CHAR(5))":D DoCmd.RunSQL SQL But SQL = "CREATE TABLE x" & _ " (f CHAR(5)), (g CHAR(5))":confused: doesnt. Please tell me...