<div>
just a slight correction<br />
<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />--------v-<wbr />put a space<br />
DoCmd.RunSQL &quot;INSERT INTO NotesTable([Notes]) VALUES ('&quot; &amp;&nbsp;ts &amp;&nbsp;&quot;')&quot;<br />

</div>


<div>
awesome, that works but could you explain why it works? i don't really understand the syntax<br />
<br />
also is there a way to include ts and my parameter of ([Enter your note]) together? so that they will be 1 record? basically a time/date stamped comment/note is all i am trying to do<br />
<br />
thank you<br />

</div>


<div>
DoCmd.RunSQL &quot;INSERT INTO NotesTable([Notes]) VALUES ('&quot; &amp;&nbsp;ts &amp;&nbsp;&quot; &quot;&nbsp;&amp; now() &amp;&nbsp;&quot;')&quot;<br />

</div>


<div>
<div class="content wysiwyg-content">
is there a way to include my variable ts with whatever the user types in the parameter box?<br />
thank you<br />
<br />
Dim ts As String<br />
ts = Now<br />
DoCmd.RunSQL &quot;INSERT INTO NotesTable([Notes])VALUES ([Enter your note])&quot;
</div>
</div>


is there a way to include my variable ts with whatever the user types in the parameter box?
thank you

Dim ts As String
ts = Now
DoCmd.RunSQL "INSERT INTO NotesTable([Notes])VALUES ([Enter your note])"

just a slight correction

----------------------------------------------------------------v-put a space
DoCmd.RunSQL &quot;INSERT INTO NotesTable([Notes]) VALUES (&#39;&quot; &amp; ts &amp; &quot;&#39;)&quot;


awesome, that works but could you explain why it works? i don&#39;t really understand the syntax

also is there a way to include ts and my parameter of ([Enter your note]) together? so that they will be 1 record? basically a time/date stamped comment/note is all i am trying to do

thank you


DoCmd.RunSQL &quot;INSERT INTO NotesTable([Notes]) VALUES (&#39;&quot; &amp; ts &amp; &quot; &quot; &amp; now() &amp; &quot;&#39;)&quot;


SQL insert into statement question (access 2007)

is there a way to include my variable ts with whatever the user types in the parameter box?
thank you

Dim ts As String
ts = Now
DoCmd.RunSQL &quot;INSERT INTO NotesTable([Notes])VALUES ([Enter your note])&quot;

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.