<div>
you need to enclose the fields in ()
</div>


<div>
Totally missed that, thank you.<br />
<br />
Sandra
</div>


<div>
Going to ask another question as the first field needs to be an auto number, fyi.
</div>


Going to ask another question as the first field needs to be an auto number, fyi.

<div>
<div class="content wysiwyg-content">
I have the below and it sure seems OK to me, but it does not work!<br />
Public Sub TestCode()<br />
On Error GoTo ErrorHandler<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; CurrentDb.Execute &quot;CREATE TABLE hldIntegerValueModelSS RecNumber INTEGER, IntegerValue INTEGER &quot;<br />
<br />
Exit_ErrorHandler:<br />
&nbsp; &nbsp; Exit Sub<br />
ErrorHandler:<br />
&nbsp; &nbsp; MsgBox &quot;Error Number: &quot;&nbsp;&amp; Err.Number &amp;&nbsp;&quot; Description: &quot;&nbsp;&amp; Err.Description<br />
&nbsp; &nbsp; Resume Exit_ErrorHandler<br />
End Sub
</div>
</div>


I have the below and it sure seems OK to me, but it does not work!
Public Sub TestCode()
On Error GoTo ErrorHandler

        CurrentDb.Execute "CREATE TABLE hldIntegerValueModelSS RecNumber INTEGER, IntegerValue INTEGER "

Exit_ErrorHandler:
    Exit Sub
ErrorHandler:
    MsgBox "Error Number: " & Err.Number & " Description: " & Err.Description
    Resume Exit_ErrorHandler
End Sub

ACCESS 2010 Create Table VBAstatement keeps giving a syntax error

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.