 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / June 2006How to open a QUERY made in MSAccess2002 in VB6?
Goodevening all. I am making a project in which i need to open:- 1)Table 2)Query made in MSAccess2002 in VB6. I think i should use DAO library. But can someone tell me the command i should write for button_click() in VB6 which 1)opens the Table 2)opens the Query? Further can i modify the Tables from within VB itself, not thru MSAccess? > Goodevening all. > [quoted text clipped - 10 lines] > Further can i modify the Tables from within VB itself, not thru > MSAccess? Sounds a LOT like homework. Did you look in the Access help? how about OpenTable and OpenQueryDef? Make friends with the help file. And don't be afraid to actually learn something. > Goodevening all. > > I am making a project in which i need to open:- > 1)Table > 2)Query So what are you going to do? Open a recordset and populate a control in VB with it? bind the table to the recordset by including a data control? There are lots of ways. Try something. You'll learn a lot more from your own mistakes/sucesses than someone telling you how to do something... > made in MSAccess2002 in VB6. I think i should use DAO library. But can > someone tell me the command i should write for button_click() in VB6 > which > 1)opens the Table > 2)opens the Query? If you want to show the contents of a table or the results of a query, I'd probably bind the recordset to a flexgrid or something like that. > Further can i modify the Tables from within VB itself, not thru > MSAccess? Yes. Lots of ways to do it. > Further can i modify the Tables from within VB itself, not thru > MSAccess? how do you mean 'modify'? If you want to add/modify/delete fields, you can use pure SQL to add fields or drop them. If you want to update the data, then just use stored procedures or queries. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.