Re: VB6 ACCESS table union issue

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 423,192 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,559 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums

VB6 ACCESS table union issue

•

Join Date: Jul 2007

Location: Philippines

Posts: 187

Reputation: jireh is an unknown quantity at this point

Rep Power: 0

Solved Threads: 20

jireh

Offline

Junior Poster

Re: VB6 ACCESS table union issue

May 12th, 2008

I don't know what you really mean but if you mean that to look in a PER record I think you do the loop statement.
ie.

Help with Code Tags

(Toggle Plain Text)

SQL = "SELECT * FROM tabA UNION ALL SELECT * FROM tabB ORDER BY field"
Set rs = db.OpenRecordset(SQL)

IF NOT rs.EOF THEN
    DO WHILE NOT rs.EOF
            Text1.Text=rs!Fieldname1
            Text2.Text=rs!Fieldname2
     LOOP
END IF

Last edited by jireh : May 12th, 2008 at 8:13 pm.

Curiosity! Does it mean ignorance?
http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4