This was a very useful video. I was going nuts trying to find a way to "send to back" the tab control so that my fields could be visible again and it was as simple as cut and paste. Than you so much!
Totally agree with you about tabs, yet I sometimes get projects from clients that have tabs, and pages, and sometimes they're even within subforms that dynamically load on the page.
One way to use different background colors for each tab is to put subforms on the tabs. Have each subform cover up the entire area of each tab. Each tab will, of course, have the background color of each subform. If you have an order form, invoice form, customer form, etc., you can put them all on one form under different tabs, making it easier for the user to get to each form. Assign letter shortcuts to the tabs, such as &Customer form, &Invoice form, &Order form, so the user can press Alt-C, Alt-I, Alt-O to get to the forms.
Hello Richard - great videos thanks. I can see that you use of subforms is better - but how can I refer to a page in a tab control which we currently have on our database? I want to be able to refer to a specific page within the tabs with a command button on another form. Thanks :)
Be careful to use many subforms with a bunch datas in the tab control. When you listing in main form, each subform refreshing data so if you have complex database, it's can produce lags... If I have subforms in tab control, I set source of record I set the record source only when selecting a specific tab (After leaving, change tab I clean source of record on not active tabs.). This ensures that when browsing through the data in the main form, only the necessary data that the user can see is retrieved. Of course, this solution requires more programming.
Hello Sir., I want to ask one thing .. How can create one save, record and other related button for these three forms or tab pages to control all pages in One and record related data? Thanks a lot!
For Instance, I Have One Form and tow sub form(All in One Form) so, I want You one Button for theseform that means If Add New Record for those three form use one Button
Definitely. I cover how to switch between multiple subforms in my ABCD database. If there's enough interest, I could make a TechHelp video on it. 599cd.com/ABCD
@@599CD If I have a main form and in the main form I am using one subform which is a continous form which has suppose column1 and it is linked to a table which is non editable . But in my main form that column should be made editable on dbl click or replaced with another text box. How can we do it ?
![[UNCUT]"ตุลามรณะ"ย้อนฟังคำทำนาย หมอดูทุกสาย ดวงเมืองร้อน (หมอปลาย ฟองสนาน อ.โอเล่)I คนดังนั่งเคลียร์](http://i.ytimg.com/vi/lE5az5VvT9M/mqdefault.jpg)
This was a very useful video. I was going nuts trying to find a way to "send to back" the tab control so that my fields could be visible again and it was as simple as cut and paste. Than you so much!
You're welcome!
Totally agree with you about tabs, yet I sometimes get projects from clients that have tabs, and pages, and sometimes they're even within subforms that dynamically load on the page.
Oh, I hate that.
One way to use different background colors for each tab is to put subforms on the tabs. Have each subform cover up the entire area of each tab. Each tab will, of course, have the background color of each subform. If you have an order form, invoice form, customer form, etc., you can put them all on one form under different tabs, making it easier for the user to get to each form. Assign letter shortcuts to the tabs, such as &Customer form, &Invoice form, &Order form, so the user can press Alt-C, Alt-I, Alt-O to get to the forms.
Yeah, I do the same thing but without the tabs. I just use labels to change the SourceObject property of the subform.
I agree working with a database with tabs and they are a pain. Tried dragging a new form into a new tab and it would not accept it.
As for as I understand the use of Tabs is to use Single Form for many Fields/Text Boxes to show all text boxes in a single form.
Sounds about right.
Hi dear, thanks for your great tutorial videos, I want to know how can I make a tab control to have two rows of pages
599cd.com/ask
Hello Richard - great videos thanks. I can see that you use of subforms is better - but how can I refer to a page in a tab control which we currently have on our database? I want to be able to refer to a specific page within the tabs with a command button on another form. Thanks :)
599cd.com/ask
Thanks! Very nice
Glad you like it!
Thank you
You're welcome
Be careful to use many subforms with a bunch datas in the tab control. When you listing in main form, each subform refreshing data so if you have complex database, it's can produce lags...
If I have subforms in tab control, I set source of record I set the record source only when selecting a specific tab (After leaving, change tab I clean source of record on not active tabs.). This ensures that when browsing through the data in the main form, only the necessary data that the user can see is retrieved. Of course, this solution requires more programming.
Thanks for sharing
Hello Sir., I want to ask one thing .. How can create one save, record and other related button for these three forms or tab pages to control all pages in One and record related data? Thanks a lot!
This makes no sense.
For Instance, I Have One Form and tow sub form(All in One Form) so, I want You one Button for theseform that means If Add New Record for those three form use one Button
Subforms are the way to go.
Definitely. I cover how to switch between multiple subforms in my ABCD database. If there's enough interest, I could make a TechHelp video on it. 599cd.com/ABCD
@@599CD - Yes please! Very interested.
How can I use continuous form in replacement of Active control MSFLXGRD
I don't use Flex Grid
@@599CD If I have a main form and in the main form I am using one subform which is a continous form which has suppose column1 and it is linked to a table which is non editable . But in my main form that column should be made editable on dbl click or replaced with another text box. How can we do it ?
Where can I learn to do the sub-forms that look like tab controls you show on 9:47?
599cd.com/ABCD
@@599CD it's giving me a "service unavailable" message.
Try again now.
@@599CD on which part of the course is that ?