A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

tab control subform



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2009, 07:31 PM posted to microsoft.public.access.forms
chriske911[_2_]
external usenet poster
 
Posts: 13
Default tab control subform

I want to use a tabcontrol where I show a number of records filtered
per tab page

it is meant to be a nicer looking alternative to the plain subform
showing records filtered according to the record shown in the parent
form
since I have few parent records I can get away with the number of tab
pages required

what would be the nicest and most performant way to do this at the same
time?

thnx


  #2  
Old April 21st, 2009, 07:51 PM posted to microsoft.public.access.forms
Arvin Meyer MVP
external usenet poster
 
Posts: 640
Default tab control subform

If you do this you won't be able to enter or edit your data since 2 or more
different forms will be locking the table. By click on a scroll bar, the
next group of records are always displayed. How is that different from
clicking on a tab?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"chriske911" wrote in message
...
I want to use a tabcontrol where I show a number of records filtered per
tab page

it is meant to be a nicer looking alternative to the plain subform showing
records filtered according to the record shown in the parent form
since I have few parent records I can get away with the number of tab
pages required

what would be the nicest and most performant way to do this at the same
time?

thnx




  #3  
Old April 21st, 2009, 08:07 PM posted to microsoft.public.access.forms
chriske911[_2_]
external usenet poster
 
Posts: 13
Default tab control subform

on 4/21/2009, Arvin Meyer MVP supposed :
If you do this you won't be able to enter or edit your data since 2 or more
different forms will be locking the table. By click on a scroll bar, the next
group of records are always displayed. How is that different from clicking on
a tab?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"chriske911" wrote in message
...
I want to use a tabcontrol where I show a number of records filtered per tab
page

it is meant to be a nicer looking alternative to the plain subform showing
records filtered according to the record shown in the parent form
since I have few parent records I can get away with the number of tab pages
required

what would be the nicest and most performant way to do this at the same
time?

thnx



I don't want a recordset per tab page but just show a filtered set of
records per tab page,
you can only see 1 tab at the same time anyway

the main form would retrieve the full recordset anyway

I know it sounds odd but it seemed a nice idea from a designer point of
view,

now it is up to me to create it

grtz


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.