Search results

Hi I would like update a table column values separated by “;” For example 1. ColumA has no data, I want to do an update and place a comma at the end 2. If ColumA has already value do not delete add new valued at the end where “;” if found. My start attempt as follow: qry_test= "UPDATE...

First of all apologies for restarting this post as the previous one I did not explain myself properly. I hope I have done a better job now. I would appreciate anyone who could spare their time to have a look at this issue I am having. Please let me know if you need any further clarifications...

Hi After I add a table or delete a table is Ado. How do I refresh Navigation pane “Tables” with code. Thank you

I need to create a new table in current databases using ADODB whose properties are defined in a lookup table. Public Function Create table() Dim cnnDB As ADODB.Connection Dim myRecordSet As ADODB.Recordset Dim tblname As String Dim qry_Issues As String ' Get connection to current database...