Search results

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

Sorry Galaxiom I meant to say I know how to do the CREATE table in code. It’s the putting of the stuff together dynamically before the CREATE and the columns can be very big or small as stated above. I really hope that is very clear. Thank you very much in advance.

I have no I deal how to do it as the result of the record set above can be very large or small. For example 30 columns or 5 columns each time the lookup table is updated. Can you please show me an example I know that is too much to ask. Thank you for your advice.

it runis and displays row by row all fied names and datatype. thats all it does.

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