473,394 Members | 1,750 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Form level variables - the way to do this?

It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4
subforms.

(I like tabbed forms by the way - do we all?)

Basically the subforms are different ways of looking at the data. It's the
orchestral management thing still.

So tab 1 looks at each musician, the events they're booked onto, which jobs
they're doing etc.

tab 2 looks at each job, who's doing it at which event etc.

To preserve state between tabs I've set up a few form level variables, so
that when you're on musician A on one subform when you switch to another tab
you'll be on musician A there too. Hopefully.

Is form level variables the usual way to accomplish this? If there is a
'usual' way.

TIA, Mike MacSween
Nov 12 '05 #1
4 3290
Unless you are doing something to change the state of the tabs, they should
retain whatever state they were left in.
(Unless one is in the middle of a record edit, in wich case it will attempt
to update it when it looses focus)

Mike Storr
www.veraccess.com
"Mike MacSween" <mi***********************@btinternet.com> wrote in message
news:40***********************@news.aaisp.net.uk.. .
It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4
subforms.

(I like tabbed forms by the way - do we all?)

Basically the subforms are different ways of looking at the data. It's the
orchestral management thing still.

So tab 1 looks at each musician, the events they're booked onto, which jobs they're doing etc.

tab 2 looks at each job, who's doing it at which event etc.

To preserve state between tabs I've set up a few form level variables, so
that when you're on musician A on one subform when you switch to another tab you'll be on musician A there too. Hopefully.

Is form level variables the usual way to accomplish this? If there is a
'usual' way.

TIA, Mike MacSween

Nov 12 '05 #2
On Fri, 5 Mar 2004 08:06:38 -0000, "Mike MacSween"
<mi***********************@btinternet.com> wrote:

I see nothing wrong with it. However, you could also reference the
master musician list itself, eliminating the need for a variable:
"select * from events where MusicianID=" &
subfrmMusicians.Form.MusicianID

-Tom.
It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4
subforms.

(I like tabbed forms by the way - do we all?)

Basically the subforms are different ways of looking at the data. It's the
orchestral management thing still.

So tab 1 looks at each musician, the events they're booked onto, which jobs
they're doing etc.

tab 2 looks at each job, who's doing it at which event etc.

To preserve state between tabs I've set up a few form level variables, so
that when you're on musician A on one subform when you switch to another tab
you'll be on musician A there too. Hopefully.

Is form level variables the usual way to accomplish this? If there is a
'usual' way.

TIA, Mike MacSween


Nov 12 '05 #3
"Mike MacSween" <mi***********************@btinternet.com> wrote in
news:40***********************@news.aaisp.net.uk:
It's a form, with (so far) 4 tab pages on it, each of which holds
2/3/4 subforms.

(I like tabbed forms by the way - do we all?)
Yes, I'm a tabbed form addict. My users taught me to be, as they
hate popup forms, in general, because it's too easy to get lost.

(a fascinating article on UI design errors:

http://www.catb.org/~esr/writings/cups-horror.html

I recommend that everyone read this and the followup referred to at
the end; it's not about tabbed interfaces, but it makes a number of
points that are pretty important)
Basically the subforms are different ways of looking at the data.
It's the orchestral management thing still.

So tab 1 looks at each musician, the events they're booked onto,
which jobs they're doing etc.

tab 2 looks at each job, who's doing it at which event etc.

To preserve state between tabs I've set up a few form level
variables, so that when you're on musician A on one subform when
you switch to another tab you'll be on musician A there too.
Hopefully.

Is form level variables the usual way to accomplish this? If there
is a 'usual' way.


Well, shouldn't this be data-driven?

The usual design of a parent form/subform is that the subforms are
linked to the record displayed in the parent form. That would be a
very easy way to coordinate multiple subforms.

If, on the other hand, your parent form is unbound and displays a
number of subforms that are not all children of the same parent, you
could create a control that does display the common information and
use that for your link.

That is, if you're moving between two tabs that both display
information about the same person, there ought to be a header in
common to those two tabs that displays which person the child data
is about, and also allows you to navigate to a different person.

One way to accomplish this would be to have the "header" portion of
the form be a tab control with no tabs displayed. You'd have
sufficient tabs on it to display as many different headers as you
needed, with navigation for those headers, and the tab shown on the
header would be driven in the OnChange event of the tab.

I can see possible problems with that with certain kinds of design,
but you get the idea, maybe. The principle is that there should be a
header that is shared between tabs that display the same kind of
information.

And if you need different headers, you might consider breaking the
whole thing down into separate forms. While I avoid popups so users
don't have to navigate between different forms all the time, I do
think you need to keep distinct entities separated from each other.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #4
On Fri, 05 Mar 2004 15:25:26 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote:
"Mike MacSween" <mi***********************@btinternet.com> wrote in
news:40***********************@news.aaisp.net.u k:
It's a form, with (so far) 4 tab pages on it, each of which holds
2/3/4 subforms.

(I like tabbed forms by the way - do we all?)


Yes, I'm a tabbed form addict. My users taught me to be, as they
hate popup forms, in general, because it's too easy to get lost.

(a fascinating article on UI design errors:

http://www.catb.org/~esr/writings/cups-horror.html


Neat article - thanks for the link.
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Bob | last post by:
Declaring a module level form object in multiple froms within a project to show another project form causes a stack overflow and other assorted errors. Can anyone help?
1
by: william cline | last post by:
Hi, I am a beginner and below I have code for a long in form. My goal is for the form to read a file of a list of users and thier passwords ....compare the text box inputs to the file and either...
2
by: Jim | last post by:
I have a C# Web application that has 1 Web form that has 2 command buttons on it with a label for output. I have a form level variable declared String strName = "Jim"; right below where the...
2
by: Landley | last post by:
Hi All, I have declared some class-level variables in a web user control. When a button is clicked, one of these variables is set to a specific value. The page then does a postback and the...
19
by: hamil | last post by:
I have a form with one button, Button1, and a Textbox, Textbox1 I have a class, class1 as follows. Public Class Class1 Public DeForm As Object Sub doit() DeForm.Textbox1.text = "It works"...
2
by: TD | last post by:
I've read several posts here that say global variables are reset whenever an unhandled error occurs. I want to use a custom form property instead of a global variable to store a boolean value. My...
27
by: Chris | last post by:
Hi, I have a form for uploading documents and inserting the data into a mysql db. I would like to validate the form. I have tried a couple of Javascript form validation functions, but it...
4
by: chandu | last post by:
Hello, declaring class level variables is good approach or not in c#. in C++ we used prefer diclaring class level variables more than local variables. i had a discussion with somebody that...
13
by: geosmy | last post by:
Hi everyone, First post here! I have been trying to upgrade to Acc2007 looking forward to using Split Forms. To my horror I have just discovered that Split Forms do not hold variables at...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.