VBA to search number/text and pull information from access into excel

Hi Stephen and welcome to the forum,

It seems to me you should build relationships in your Access database to tie your tables together. Then you need to build a query with a parameter of the barcode you want, using Access. Then using Access you can use this query to export an Excel workbook. It seems to me you can really do all the work using Access and then just look at it using Excel, after an Access export to Excel.

Marvin, I'm not much good with access and the idea was to type a barcode into excel then hit run macro and the report would autogenerate from that. I can't seem to get the coding right to retrieve the barcode data. Any ideas?

I keep getting error copying data when I try to run a macro for the first barcode part.

Hi,

I understand that you aren't good with Access yet, but it is the best tool for your problem. See the attached where I tried to make a PT from your data using Excel on the Timetables sheet. The values always come out numbers, because it is in Excel, and not what you want. Then look at the 3rd sheet where I've put a picture of what Access can do for you. Access allows text to be in the values area and perfect for what you are trying to do, in my humble opinion.

You are trying to get an output that is very complicated to do with Excel but a snap if you use Access.

Hi Stephen,

I do believe I attached the wrong file. I will remove the attached file as it was another problem. I didn't mean to attach an answer but just suggest you do the whole problem using Access and then export an Excel workbook from it.

I have written some code to start retrieving using VBA but it only returns the column headers and not any data, i'm not sure why