Open another recordset within current recordset vba

**aman1234** · 09-01-2015, 02:03 PM

Hi Guys

I am writing the following code to copy data from Access table to Excelsheet. The thing is there is one more table that stores all the barcodes for each UniqueID. I want to display all the barcodes from a different table in the below code for each UniqueID. I can't close the recorset as I am looking for a option to open another recorset within this. Is it possible?

Please Login or Register  to view this content.

Any help will be much appreciated.

Thanks

**tehneXus** · 09-02-2015, 04:32 AM

Hi aman1234,

I could think of 2 possibilities here:
1. Change the SQL statement of your existing recordset to include the 2nd table using a join so you'll have the barcode directly

Please Login or Register  to view this content.

OR 2. Use a 2nd recordset with a query to your 2nd table like:

Please Login or Register  to view this content.

Open another recordset within current recordset vba

LinkBack

Thread Tools

Rate This Thread

Display

Open another recordset within current recordset vba

Re: Open another recordset within current recordset vba

Thread Information

Users Browsing this Thread

Similar Threads

run a sql statement in for loop and open a recordset

Open the recordset in access and use table name in dmax statement

Recordset Query : how to open and retrieve DB

Thow exception 0x80040e14 when I want to open RecordSet of excel via ado

[SOLVED] Need ADO Recordset Help

Open recordset using ODBC

[SOLVED] How to open Access recordset via Query in Excel VBA???

[SOLVED] Recordset's RowID as part of Recordset

Bookmarks

Bookmarks

Posting Permissions