var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to assign form item value into VBA sql
I developed a data enter form in access 2007
The form item value as
strCOMMENTS = Me.COMMENTS
I can capture strComments value.
However, I put these items in sql as
DoCmd****nSQL "insert into test values (strComments);"
but I got a enter parameter value box. I need to put a value in box and data is added into database.
How to avoid parameter box display during VBA code running?
Try this (I would expect you to have to specify the field, unless there's only one in the table):
DoCmd****nSQL "insert into test values ('" & strComments & "');"
If the comments might contain a single quote, that will have to be modified. More info in this tutorial:
Building SQL in VBA