multiple tables one form VB or not ?

[Salochin]

Ive asked this question in the access thread area also: just want to see if VB coding could help to do this in a neater better way.. the answer I got was use sub forms but if im honest its not the desiered effect I want on my database..

Hi all is it possible to get more then one frm / tabel to show its controls Basics:

I have 5 tables I would like to update but rather then create mutiple forms to update and use cmdbuttons to open them individually I thought it would be neater to have 5 tab control pages so you can tab to the product or info i need (if that made sense)

Ive tried it but dont seem to get it to work, im new to VB but would love to know if it is poss or a hint at least how to do this.. not asking for anyone to do this for me as I need to learn but need a pointer or too even if its a title of a book to help me or link to a web source that can take me through it step by step..

so say I have

tbl1 with three text boxes one drop down call it tblProduct
tbl2 with 2 drop downs and 4 text boxes call it tblPrinters

etc.... so tbl1 on tab 1 and so on

Thanks in anticipation..

Sal

[kadghar]

well, if you dont want to get into the 'wonderful' world of making your dinamic views. Perhaps you should try doing the same you're doing, but instead of using multiple forms, use multiple frames, or a tabs control. that'll allow you to have all items you have in the same form, but in different spaces.

[smartchap]

If I understood your query, you want to update data in each table one at a time. If this is the question (as u already know the use of tab control), I say, Yes it is possible. You should use 5 Recordsets for 5 tables as:

Dim rs1 As New ADODB.Recordset
Dim rs2 As New ADODB.Recordset
Dim rs3 As New ADODB.Recordset
Dim rs4 As New ADODB.Recordset
Dim rs5 As New ADODB.Recordset

If using these tables in one database file then use

Dim cn As New ADODB.Connectio n

otherwise use 5 commands for Connections also.
If any other query, ask it, I will try to solve or You can post your code for clarifications.

[Salochin]

Thanks smartchap i think i got an understanding of what you have just told me:
as for code hmmm wellllll once ive got this done I will take you up on that offer please bare in mind it WILL be very crude as im totally new to this vb (and loving it)


ok now you got me intrigued kadghar "wonderfull " world of what now ? Dynamic views was is it !? erhm ok noob here whats that then or did you mean use sub forms ! is multiple frames same as tabs control.. ?

I want to be able to make this database say HI look what ive achieved , the db im designing is for

1) it is for work so i want it to look good for that reason..

but more essentialy its

2) helping my self development to improve job prospects (new career path) so new ideas and hints what to learn is more then welcome... best practice's etc... (im self taught so far apart from an intro to vb course, which was very very basic.. kinda hi this is vb good bye !!)

as always your help is apprieciated..

thanks

Sal

[smartchap]

For learning VB there are many sites on which tutorials are available. In this forum also U will get a section for this. On Google search for 'VB6 Tutorials' and thank me for a lot of sites which I think u will not be able to study all.