Insert string in access DB

[ramirez]

Hi all.

Have made some google search but couldn't found a correct answer.

I'm maked a GUI with only 2 buttons (for now) START and STOP and, after pressed they will post the time of the action in a access DB.

The script is made to, when I press start it keeps the time in a string and when I press stop it will insert the time of start and the time of the stop in a new record.

My problem is to use the string in the insert command.

I'm at home and don't have the complete code here but tomorrow I'll post.

Thanks in advace.

[Danp2]

Suggest that you review >this thread. I have been using this UDF to successfully read from and update an Access database.

Edit: Here's some code showing how to insert a record where $UserName is a string containing the value to be written --

; Try inserting a new record
$Result = _SQL_Execute(-1, "insert into usersettings (Name) VALUES ( '" & $UserName & "')" )

Edited March 10, 2014 by Danp2

[ramirez]

Thanks Danp2,

This solved the problem.

VALUES ( '" & $UserName & "')" )