Difficult Question Access 2000 Litwin Gibert and Getz book

[Bob]

Hi Everybody

Difficult question

Has anyone else used the "Using the Tab control as a container"
database example that comes with the above book chapter 7 on the
accompanying disc. It is a brilliant piece of design that I have used
in 2 previous projects and they have worked beautifully.

What it does is set up the tabs in a container with a different tab
for each different record in a particular field.

For example in a table of International Addresses there is a field
called "Country",
So for each different country it sets up a tab which filters the
records on the sub form to assign each record to its own country tab.

The only 2 setting you need t use in your application is to change the
code behind the form from

Table = Customers
Control = Country

I have adapted this into my own application and changed these 2 fields
to

Table = ztblProduct (Which is on a sub form)
Control =Category (Power Tool, Hand tool, Workbench etc)

That works fine. Now a step further

I have replaced ztblProduct with zqryProduct (a query) as the source
for the sub form zfrmProduct.

In zqryProduct I have the SupplierID field picking up the SupplierID
from the already open Supplier form. But no matter which way I swing
it there is always the "too few parameters error".

Strangely, it does work if you actually remove the expression from the
query zqryProduct and just put the supplierID manually, but I want it
to work dynamically, and after 5 head scratching hours I'm losing
heart.

Can anyone help

Thanks in Advance

Smiley Bob

[david epsom dot com dot au]

From first principles: they have grouped the records onto
tabs: they have grouped the records, they have grouped...

Grouping does not work on calculated fields: you get a
"too few parameters error".

Create a NEW query that only selects from your base query:
"SELECT * FROM myQuery"
and use that in zqryProduct.

New query has no calculated fields: Grouping works: tab
example works.

(david)
"Bob" <sm*******@hotm ail.com> wrote in message
news:gv******** *************** *********@4ax.c om...

Hi Everybody

Difficult question

Has anyone else used the "Using the Tab control as a container"
database example that comes with the above book chapter 7 on the
accompanying disc. It is a brilliant piece of design that I have used
in 2 previous projects and they have worked beautifully.

What it does is set up the tabs in a container with a different tab
for each different record in a particular field.

For example in a table of International Addresses there is a field
called "Country",
So for each different country it sets up a tab which filters the
records on the sub form to assign each record to its own country tab.

The only 2 setting you need t use in your application is to change the
code behind the form from

Table = Customers
Control = Country

I have adapted this into my own application and changed these 2 fields
to

Table = ztblProduct (Which is on a sub form)
Control =Category (Power Tool, Hand tool, Workbench etc)

That works fine. Now a step further

I have replaced ztblProduct with zqryProduct (a query) as the source
for the sub form zfrmProduct.

In zqryProduct I have the SupplierID field picking up the SupplierID
from the already open Supplier form. But no matter which way I swing
it there is always the "too few parameters error".

Strangely, it does work if you actually remove the expression from the
query zqryProduct and just put the supplierID manually, but I want it
to work dynamically, and after 5 head scratching hours I'm losing
heart.

Can anyone help

Thanks in Advance

Smiley Bob

[Bob]

On Tue, 11 May 2004 13:28:58 +1000, "david epsom dot com dot au"
<david@epsomdot comdotau> wrote:

From first principles: they have grouped the records onto
tabs: they have grouped the records, they have grouped...

Grouping does not work on calculated fields: you get a
"too few parameters error".

Create a NEW query that only selects from your base query:
"SELECT * FROM myQuery"
and use that in zqryProduct.

New query has no calculated fields: Grouping works: tab
example works.

(david)
Hi David

Thanks for your help

Like you suggested I have created a new Query with just 2 fields to
set up the tabs.

zqrySupplierPro ductSort
field 1 = SupplierID (Criteria = [Forms]![frmSupplier]![SupplierID])
field2 = SupplierCategor y

In the code behind the form:
Private Const adhcTable = "zqrySupplierPr oductSort"
Private Const adhcFieldName = "SupplierCatego ry"

But still " too few parameters"

BTW I have tried this with the "zqrySupplierPr oductSort" running in
the background but not joy there either.

I am missing some fundemental point I think.

Regards Smiley Bob


"Bob" <sm*******@hotm ail.com> wrote in message
news:gv******* *************** **********@4ax. com...

Hi Everybody

Difficult question

Has anyone else used the "Using the Tab control as a container"
database example that comes with the above book chapter 7 on the
accompanying disc. It is a brilliant piece of design that I have used
in 2 previous projects and they have worked beautifully.

What it does is set up the tabs in a container with a different tab
for each different record in a particular field.

For example in a table of International Addresses there is a field
called "Country",
So for each different country it sets up a tab which filters the
records on the sub form to assign each record to its own country tab.

The only 2 setting you need t use in your application is to change the
code behind the form from

Table = Customers
Control = Country

I have adapted this into my own application and changed these 2 fields
to

Table = ztblProduct (Which is on a sub form)
Control =Category (Power Tool, Hand tool, Workbench etc)

That works fine. Now a step further

I have replaced ztblProduct with zqryProduct (a query) as the source
for the sub form zfrmProduct.

In zqryProduct I have the SupplierID field picking up the SupplierID
from the already open Supplier form. But no matter which way I swing
it there is always the "too few parameters error".

Strangely, it does work if you actually remove the expression from the
query zqryProduct and just put the supplierID manually, but I want it
to work dynamically, and after 5 head scratching hours I'm losing
heart.

Can anyone help

Thanks in Advance

Smiley Bob

[Bob]

On Tue, 11 May 2004 08:28:16 +0100, Bob <sm*******@hotm ail.com> wrote:

Hi david

I have done some experimenting, and your 1st post contained the reason
why this does not work. You can't group on a calculated field.

If I manually put the supplierID number in by hand, the tabs get set
set up grouped in the way I want.

The problems only come when I try to do this with the query
Criteria = [Forms]![frmSupplier]![SupplierID] .... No Go! Even when I
put that query as the data source for another query to be the tab set
up query.

At the moment I've put it aside and am using a combo box to sort the
records, but it would be nice...........

Anyway, Thanks for pinpointing what the problem was.

Regards Smiley Bob

On Tue, 11 May 2004 13:28:58 +1000, "david epsom dot com dot au"
<david@epsomdo tcomdotau> wrote:

From first principles: they have grouped the records onto
tabs: they have grouped the records, they have grouped...

Grouping does not work on calculated fields: you get a
"too few parameters error".

Create a NEW query that only selects from your base query:
"SELECT * FROM myQuery"
and use that in zqryProduct.

New query has no calculated fields: Grouping works: tab
example works.

(david)

Hi David

Thanks for your help

Like you suggested I have created a new Query with just 2 fields to
set up the tabs.

zqrySupplierPr oductSort
field 1 = SupplierID (Criteria = [Forms]![frmSupplier]![SupplierID])
field2 = SupplierCategor y

In the code behind the form:
Private Const adhcTable = "zqrySupplierPr oductSort"
Private Const adhcFieldName = "SupplierCatego ry"

But still " too few parameters"

BTW I have tried this with the "zqrySupplierPr oductSort" running in
the background but not joy there either.

I am missing some fundemental point I think.

Regards Smiley Bob

"Bob" <sm*******@hotm ail.com> wrote in message
news:gv****** *************** ***********@4ax .com...

Hi Everybody

Difficult question

Has anyone else used the "Using the Tab control as a container"
database example that comes with the above book chapter 7 on the
accompanying disc. It is a brilliant piece of design that I have used
in 2 previous projects and they have worked beautifully.

What it does is set up the tabs in a container with a different tab
for each different record in a particular field.

For example in a table of International Addresses there is a field
called "Country",
So for each different country it sets up a tab which filters the
records on the sub form to assign each record to its own country tab.

The only 2 setting you need t use in your application is to change the
code behind the form from

Table = Customers
Control = Country

I have adapted this into my own application and changed these 2 fields
to

Table = ztblProduct (Which is on a sub form)
Control =Category (Power Tool, Hand tool, Workbench etc)

That works fine. Now a step further

I have replaced ztblProduct with zqryProduct (a query) as the source
for the sub form zfrmProduct.

In zqryProduct I have the SupplierID field picking up the SupplierID
from the already open Supplier form. But no matter which way I swing
it there is always the "too few parameters error".

Strangely, it does work if you actually remove the expression from the
query zqryProduct and just put the supplierID manually, but I want it
to work dynamically, and after 5 head scratching hours I'm losing
heart.

Can anyone help

Thanks in Advance

Smiley Bob

[david epsom dot com dot au]

> No Go! Even when I put that query as the data source for

another query to be the tab set up query.
When all else fails.... create a table to write the criteria to.
Update the criteria table as required.

(david)

"Bob" <sm*******@hotm ail.com> wrote in message
news:9m******** *************** *********@4ax.c om... On Tue, 11 May 2004 08:28:16 +0100, Bob <sm*******@hotm ail.com> wrote:

Hi david

I have done some experimenting, and your 1st post contained the reason
why this does not work. You can't group on a calculated field.

If I manually put the supplierID number in by hand, the tabs get set
set up grouped in the way I want.

The problems only come when I try to do this with the query
Criteria = [Forms]![frmSupplier]![SupplierID] .... No Go! Even when I
put that query as the data source for another query to be the tab set
up query.

At the moment I've put it aside and am using a combo box to sort the
records, but it would be nice...........

Anyway, Thanks for pinpointing what the problem was.

Regards Smiley Bob

On Tue, 11 May 2004 13:28:58 +1000, "david epsom dot com dot au"
<david@epsomdo tcomdotau> wrote:

From first principles: they have grouped the records onto
tabs: they have grouped the records, they have grouped...

Grouping does not work on calculated fields: you get a
"too few parameters error".

Create a NEW query that only selects from your base query:
"SELECT * FROM myQuery"
and use that in zqryProduct.

New query has no calculated fields: Grouping works: tab
example works.

(david)

Hi David

Thanks for your help

Like you suggested I have created a new Query with just 2 fields to
set up the tabs.

zqrySupplierPr oductSort
field 1 = SupplierID (Criteria = [Forms]![frmSupplier]![SupplierID])
field2 = SupplierCategor y

In the code behind the form:
Private Const adhcTable = "zqrySupplierPr oductSort"
Private Const adhcFieldName = "SupplierCatego ry"

But still " too few parameters"

BTW I have tried this with the "zqrySupplierPr oductSort" running in
the background but not joy there either.

I am missing some fundemental point I think.

Regards Smiley Bob

"Bob" <sm*******@hotm ail.com> wrote in message
news:gv****** *************** ***********@4ax .com...
Hi Everybody

Difficult question

Has anyone else used the "Using the Tab control as a container"
database example that comes with the above book chapter 7 on the
accompanying disc. It is a brilliant piece of design that I have used
in 2 previous projects and they have worked beautifully.

What it does is set up the tabs in a container with a different tab
for each different record in a particular field.

For example in a table of International Addresses there is a field
called "Country",
So for each different country it sets up a tab which filters the
records on the sub form to assign each record to its own country tab.

The only 2 setting you need t use in your application is to change the
code behind the form from

Table = Customers
Control = Country

I have adapted this into my own application and changed these 2 fields
to

Table = ztblProduct (Which is on a sub form)
Control =Category (Power Tool, Hand tool, Workbench etc)

That works fine. Now a step further

I have replaced ztblProduct with zqryProduct (a query) as the source
for the sub form zfrmProduct.

In zqryProduct I have the SupplierID field picking up the SupplierID
from the already open Supplier form. But no matter which way I swing
it there is always the "too few parameters error".

Strangely, it does work if you actually remove the expression from the
query zqryProduct and just put the supplierID manually, but I want it
to work dynamically, and after 5 head scratching hours I'm losing
heart.

Can anyone help

Thanks in Advance

Smiley Bob

[Bob]

On Thu, 13 May 2004 09:40:59 +1000, "david epsom dot com dot au"
<david@epsomdot comdotau> wrote:

No Go! Even when I put that query as the data source for
another query to be the tab set up query.

When all else fails.... create a table to write the criteria to.
Update the criteria table as required.

(david)

Thanks David.

I shall duck out of the wife's shopping trip this Saturday and spend
some time at home to try and put that one into action.

Regards Smiley Bob