Search results

Sure, thank you NG

Thank you, NG. I and worked around it and it is working now. Guys, you are all a star!

Ok Gasman let me change the it and see. thanks

Hi NG I have tried your recommendation but it rather displayed an error of "unknown field". Here is my append query: INSERT INTO BatchedFilesTable ( [Nz(PensionNo)], [Nz(SurnameInitials)], [Nz(ChildID)], [Nz(Type)], [Nz(TDate)], [Nz(ResCode)], [Nz(District)], [Nz(LocalOffice)]...

:)Thank you NG and Jdraw. Let me try it quickly and what happens next.

I am battling with appending a table in the access database that contains some null values or '0'. Can anyone help me? Thank you

Thank you i will so.

I need help. Can someone assist me? i am battling to insert items from a list box into a table. Here is my code: stRecord = "INSERT INTO BatchedFilesTable(PensionNo,SurnameInitials,ChildID,Type,Date,ResCode,District,LocalOffice)" & "VALUES('" & ListOfFiles.Column(0) & "','" &...