VBA code not retrieving any data

[stephen11]

Hi, I am having trouble getting my VBA code to retrieve data from access. The code is as follows

Please Login or Register  to view this content.

I am trying to tell the VBA that my criteria is a barcode in cell A2, sheet "test" of excel. However when I run the macro it only retrieves the database column headers and no data corresponding to the content of cell A2.
Anyone have any ideas where I am going wrong?

[stephen11]

I now have a code for this, thread is solved