Member Avatar for arezz09

how to combine this 2 statment..

IsConnected("Select * from manager_table", False)
        Call Loader()
 
IsConnected("Select * from Clerk_table", False)

 Call Loader()

i hve 2 listview, 2 table from accessdatabase..i put listview in tabcontrol..1 in tab 1 & second in tab 2...

  • 3 Contributors
  • 4 Replies
  • 119 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Jx_Man

Recommended Answers

All 4 Replies

Member Avatar for Jx_Man

combine to what?
to preview in which listview?

Member Avatar for debasisdas

You need to join both the tables using SQL if tables are related.

Why two separate tables for managers and clerks ?

Member Avatar for arezz09

to preview data in access table in listview...


IsConnected("Select * from clerk_table", False)
Call Loader()this for cerk listview

IsConnected("Select * from manager_table", False)
Call Loader() this for manager listview

i can't put both code in same load form bcause i will get error or nothing hppen...

Member Avatar for Jx_Man

what error? can u post your Loader code?
Are you want to preview clerk and manager in one listview or preview on each listview?
As debasisdas said if you want to show both of them in one listview then you need to join using SQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.