Jump to content

Insert string in access DB


Go to solution Solved by Danp2,

Recommended Posts

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.

Link to comment
Share on other sites

  • Solution

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 by Danp2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...