Guest_imported
New member
- Jan 1, 1970
- 0
What is the syntax for entering vales stored in a [red]string VARIABLE[/red] into an access text field?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Entering strings into Access from a VB6 program.
- Thread starter Guest_imported
- Start date
- Status
davidrobin
Programmer
If you are updating the record at run time you can use the following SQL
DE.AccessCnn.Execute "UPDATE <Table Name> SET <Column Name> = '" & <string variable> & "' WHERE <condition>" , adExecuteNoRecords
The DE.AccessCnn is a connection I have set up withtin the DataEnvironment object in VB. Ensure the string variable does not contain any ' characters or this will leg up the update.
DE.AccessCnn.Execute "UPDATE <Table Name> SET <Column Name> = '" & <string variable> & "' WHERE <condition>" , adExecuteNoRecords
The DE.AccessCnn is a connection I have set up withtin the DataEnvironment object in VB. Ensure the string variable does not contain any ' characters or this will leg up the update.
- Status
