Recent content by AccessVBANewbie

Thank you very much. It is exactly what I wanted. :)

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...

Thank you much appriciated.

Hi that is true. How about if I want it to search in part 2 instead of 1 and look for "_&" at the same time. LLLLXXXXXX_&LLLLXXXXXX_LLLLXXXXXX Thanks

Hi is it possible to include 2 "&&" with the following combination: If InStr(strProjectCode, "&") = 11 Then SubString = Left(strProjectCode, 10) ElseIf InStr(strProjectCode, "&&") = 11 Then SubString = Left(strProjectCode, 10) end if I was wondering if I am able to make InStr...

Sorry Paul, I hope you are not upset. I deleted it and started a newone beause I thought no one was understanding me with your help I have re-written problem in a more clear manner.

Thank you will give it a test run.

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...

Thank you pr2-eugin it worked nicely for me. Thank you all for your help

Hi No backend server just one database current database. Thanks

Hi CurrentDb.TableDefs.Refresh Above does not force navigation pane to refresh, still takes 5-10 seconds to do it itself. Thanks

qry_test = "CREATE TABLE Test" & "(" & _ " Field1 TEXT(20) null, " & _ Set rs = cnnDB.Execute(qry_test) ‘Here the refresh should go to force a Navigation Pane refresh

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

Hi Below is a loop that displays the required info, how do I Concatenate this information into a string so that i build the sql Create command. as you can see when I get out of the loop I only get one result the last one but I need to stay in the loop to get all one by one. how do I store the...

Hi Have a look at this example: ConnectString = "ODBC;DRIVER={MySQL ODBC 5.1 Driver}" _ & ";SERVER=" & strServerIp _ & ";DATABASE=" & strDatabaseName _ & ";UID=" & strUserName _ & ";PWD=" & strPassword _ & ";OPTION=2" and to use the connection as follow...