Recent content by buhal004

I will try linking. Thanks.

How do you link from access to excel ? Tks.

Could it be something with the part of the code “CurrentDB.execute” ?

The excel file has a procedure to clear blank rows before the transfer. This is carried out each time. Even so I cannot understand how the access table saturates with blank records.

I utilise a vba program on an Excel workbook to transfer data to a temporay table in access. The following is the code on the excel workbook. It is activated by a command button on the excel sheet. Data is transferred to a temporary file in an Access application, named "WorkitemsTemp". Sub...

Thanks for your interest. The original problem is still outstanding. I had a long code which works well most of the time. I posted it in my first post. However at times a specific part of this code ( an update SQL statement) did not execute. The whole procedure ran to its termination and one...

Thanks for this useful information. The thing is that if it were a WIFI issue the procedure would be interrupted. In fact one would not realize that the code did not run well. Only later one finds that part of the code ran and that part I mentioned did not as the relevant records did not update...

Yes. Some are using WIFI

I am more than happy to tell you that the code now worked like a song. I will now have to wait for some time to see whether the modified code executes its purpose consistently. I am very appreciate to theDBguy. I thank you. How do I thank you officially ?

Yes I had a look at the code. I do not understand it well. I need an explanation on how to put it in practice to solve my problems.

I have been using access for some years now. I am self taught but use access-programmers forum for some intuition. The code that I have written does a lot of things to my data and I doubt whether one can do all that without writing code. I could be wrong of course and look forward to have...

Thank you. I appreciate that. But what I meant was how do you know from the code which form is unbound.

I know that sometimes the query does not work because SOMETIMES the procedure executed a new record in invoicelog is created but the table servicelog is not updated.

Forgive me for asking for further clarification but which is the inbound form ? I must tell you I’m self taught in VBA and learn by asking about issues like this. Thank you.

Many thanks for your replies. I am trying to change DoCmd.RunSQL StrSQL And instead use CurrentDB.execute, StrSQL But even here I am encountering a problem. I’m getting “Too few parameters. Expected 4. Run-time error ‘3061’. I’ve never used this piece of code. Please give me some directions.