Search results

Amazing and thanks. It worked. However, it worked when I used the early binding. With the late binding, it will display a message that 'the operation is not allowed when the object is open'. But it works perfectly now with the early binding. Thank you @ebs17 . You are a genius.

Thank you. Will get to this if my current coding that is in progress didn't yield a result.

Thank you.

Thank you and I did both. Tick marked MS ActiviX Control 6.1 from the reference and I also replaced early binding with late binding. Now I get the following message in the qery. I tried my best to solve the missing operator error but wasn't able to. Could you recommend a fix for this? Below is...

Hi all, I have the following table in which orders are stored by each product type in a row. However, I want to bring all product types in one cell 'field' in a query by each product type as shown in the following snapshot. To achieve this, I copied over the following ADO function in a...

Changed it and it worked. I also had spell mistakes and errors in dim statements as The_Doc_Man pointed out. Thank you both for your expert advises.

Thank you for the advises, very useful. Now the problem is fixed and it works.

The following line is highlighted. Dim db As Database

Hi experts, I want to copy data from one table into another using the following code. Before copy, this codes runs through the objective field and looks for comma (,), when found it splits the word before a comma into a new row in the destination table. However, when I click on the button to run...

Hi Experts, In Table_A I have the following fields. ProjectName Sectors Tags Data in the Tags field is delimited by commas (,) such as the following: ProjectName Sectors Tags Water Supply Health Clean Water, Hygiene, Human Rights, Access to...

I did and thank you for the expert instructions.

And it worked. Many thanks, pbaldy. I am back after long and can't find the THANK YOU button.

Thank you, pbaldy. It does work for the first row of data, it doesn't move the second and more rows. The debug stops at this code code ( If TestArray(i) <> "" Then ") and the message says this 'Subscript out of range'. I tried to understand it, but it appears to be above my head at the moment...

Hi Experts, I have fields [DateEntered] and [Objective] in Table1 as following. Table1 DateEntered Objective 1/2/2016 Objective 1, Objective 2, Objective 3 I need to automatically split data in the [objective] field by each comma (,). The resultant table (assume Table2) should...