Subforms issue

I hope one of you can help me out, because I know only the basics of Access ..

"cjwilkinson" wrote

I hope one of you can help me out, because
I know only the basics of Access ..

There are a lot of participants here who help people and many of them are
very good at doing so.

Good introductory online training links can be found at
http://office.microsoft.com.

Good suggestions for effective use of newsgroups can be found at
http://www.mvps.org/access/netiquette.htm. One of those will be that you
need to ask a specific question.

Larry Linson
Microsoft Access MVP

Thanks for your quick answer, and I know tghe basics like making reports,
basic databases, relationships and various queries. But in my basic knowledge
of these things, I never ended up with the same problem as this, normally I
would expect to have the possibility to have a subform for the details
(overview) of clients visited. Somehow, this possibility is unchecked in the
wizard. I thought what I was doing was pretty basic. Apparently it isn't

Larry Linson wrote:
I hope one of you can help me out, because
I know only the basics of Access ..

There are a lot of participants here who help people and many of them are
very good at doing so.

Good introductory online training links can be found at
http://office.microsoft.com.

Good suggestions for effective use of newsgroups can be found at
http://www.mvps.org/access/netiquette.htm. One of those will be that you
need to ask a specific question.

Larry Linson
Microsoft Access MVP

On Wed, 27 Dec 2006 00:32:44 GMT, "cjwilkinson" u30504@uwe wrote:

I hope one of you can help me out, because I know only the basics of Access ..

I expect someone can, but you must ask a comprehensible question to do
so. We cannot read your mind.

John W. Vinson[MVP]

I'm sorry, I'll try and make it more comprehensible:

Table1: TBL_KeyAccountManager
- KamID (autonumber)
- Initials
- FirstName
- SirName
- Team (Lookup: North / South)

Table2: TBL_Date
- KamID
- Year
- Week (up till 54 weeks for a year)
- AdministrationTime
- MeetingTime
- HolidayTime
- OtherTime
- CientsvisitedID

Table3: TBL_ClientsVisited
- ClientsVisitedID
- ClientName
- Clienttype (Lookup Prospect/Client)
- TypeANameID (refers to other table for lookup)
- TypeBNameID (refers to other table for lookup)
- Offer (Yes/No)
- Turnover
- Signed (Yes/No)

Those are the tables. What I want is a form where you select the Key Account
Manager (Table1). Then entering the Week and other general data of Table2 for
this chosen Key account manager. And finally to enter every client visited
for the specified week in a subform (Table3).

This looks very basic to me, but in the wizard, when I enter all the field.
It lets me choose which of table you would like to base on. And in any case,
there is no possibiliy to have a subform for table3. This is quite odd, or am
I doing something wrong. (I most likely am of course).

Sorry again for being uncomprehensive.

I thank you for your time in advance!!!!

Kind regards,

CJ


John Vinson wrote:
I hope one of you can help me out, because I know only the basics of Access ..

I expect someone can, but you must ask a comprehensible question to do
so. We cannot read your mind.

John W. Vinson[MVP]

First, create the Form you want to embed in the Subform Control (or the
Report you want to embed in the Subreport Control), so you can select it as
you step through the Subform/Subreport Control Wizard. That will save you a
little work over going back and adding the Form later instead of using a
Datasheet View (and I strongly advise against) using Datasheet View.

In the toolbox... default docking on the left side of the screen in Form and
Report design view, be sure the little "magic wand" is selected, then hover
your pointer over the cryptic symbols... one of them will be
Subform/Subreport Control and the control wizard will give you a little
help. Click the cryptic symbol, move the cursor to your Form/Report and
click again, and the Control Wizard will open up.

But, you still have not explained in Detail what problem you need Help with.
If you insist on some particular level of Help, guidance, etc. from one of
the Report Wizards that it doesn't provide, I can't be of Help. There are
just some things not included in the Wizards, and, although it is possible
to write your own, it is so uncommon for anyone to do so as to be almost
nonexistent.

Then, if you encounter specific problems, post back here with details and
almost certainly, someone will be able to offer suggestions.

Larry Linson
Microsoft Access MVP

"cjwilkinson" u30504@uwe wrote in message news:6b5cc5711d311@uwe...
Thanks for your quick answer, and I know tghe basics like making reports,
basic databases, relationships and various queries. But in my basic
knowledge
of these things, I never ended up with the same problem as this, normally
I
would expect to have the possibility to have a subform for the details
(overview) of clients visited. Somehow, this possibility is unchecked in
the
wizard. I thought what I was doing was pretty basic. Apparently it isn't

Larry Linson wrote:
I hope one of you can help me out, because
I know only the basics of Access ..

There are a lot of participants here who help people and many of them are
very good at doing so.

Good introductory online training links can be found at
http://office.microsoft.com.

Good suggestions for effective use of newsgroups can be found at
http://www.mvps.org/access/netiquette.htm. One of those will be that you
need to ask a specific question.

Larry Linson
Microsoft Access MVP

If your main form has a Record Source of the TBL_KeyAccountManager, there
appears to be a Foreign Key in TBL_Date that relates to it. But there is no
Foreign Key to either TBL_KeyAccountManager nor TBL_Date in
TBL_ClientsVisited.

At best, there is a ClientsVisitedID in both TBL_Date and
TBL_ClientsVisited, but that would only allow a one-to-one relationship, and
I don't think that is what you want. It appears you have a logical problem
in your table design.

My guess is that you need to have a Foreign Key that relates to TBL_Dates
(that would include a reference to KamID, Year, and Week -- or a surrogate
key, maybe an autonumber, to simplify joining)... then the
TBL_ClientsVisited would have a one-to-many relationship from TBL_Dates and
be suitable for being added as a Subform in the Form for TBL_Date... a
second-level subform.

But, see, if you give us details, we may be able to help. If what I've
written is confusing, post back asking about the puzzling parts, and I'll
try to clarify, or someone will.

Larry Linson


"cjwilkinson" u30504@uwe wrote in message news:6b5d22a73dc0e@uwe...
I'm sorry, I'll try and make it more comprehensible:

Table1: TBL_KeyAccountManager
- KamID (autonumber)
- Initials
- FirstName
- SirName
- Team (Lookup: North / South)

Table2: TBL_Date
- KamID
- Year
- Week (up till 54 weeks for a year)
- AdministrationTime
- MeetingTime
- HolidayTime
- OtherTime
- CientsvisitedID

Table3: TBL_ClientsVisited
- ClientsVisitedID
- ClientName
- Clienttype (Lookup Prospect/Client)
- TypeANameID (refers to other table for lookup)
- TypeBNameID (refers to other table for lookup)
- Offer (Yes/No)
- Turnover
- Signed (Yes/No)

Those are the tables. What I want is a form where you select the Key
Account
Manager (Table1). Then entering the Week and other general data of Table2
for
this chosen Key account manager. And finally to enter every client visited
for the specified week in a subform (Table3).

This looks very basic to me, but in the wizard, when I enter all the
field.
It lets me choose which of table you would like to base on. And in any
case,
there is no possibiliy to have a subform for table3. This is quite odd, or
am
I doing something wrong. (I most likely am of course).

Sorry again for being uncomprehensive.

I thank you for your time in advance!!!!

Kind regards,

CJ


John Vinson wrote:
I hope one of you can help me out, because I know only the basics of
Access ..

I expect someone can, but you must ask a comprehensible question to do
so. We cannot read your mind.

John W. Vinson[MVP]

Thanks Larry for your answer,

After going through it over and over again, I noticed that certain
relationships seemed logical, but they weren't. I have fixed the problem and
now it works fine as I wanted. The problem, I'm nearly the only one at work
whocan work access a bit and so this means, I'm the only one who can review
it. Sometimes it's hard to find your own subtle mistakes.

Thanks again,

Christopher

Larry Linson wrote:
If your main form has a Record Source of the TBL_KeyAccountManager, there
appears to be a Foreign Key in TBL_Date that relates to it. But there is no
Foreign Key to either TBL_KeyAccountManager nor TBL_Date in
TBL_ClientsVisited.

At best, there is a ClientsVisitedID in both TBL_Date and
TBL_ClientsVisited, but that would only allow a one-to-one relationship, and
I don't think that is what you want. It appears you have a logical problem
in your table design.

My guess is that you need to have a Foreign Key that relates to TBL_Dates
(that would include a reference to KamID, Year, and Week -- or a surrogate
key, maybe an autonumber, to simplify joining)... then the
TBL_ClientsVisited would have a one-to-many relationship from TBL_Dates and
be suitable for being added as a Subform in the Form for TBL_Date... a
second-level subform.

But, see, if you give us details, we may be able to help. If what I've
written is confusing, post back asking about the puzzling parts, and I'll
try to clarify, or someone will.

Larry Linson

I'm sorry, I'll try and make it more comprehensible:

[quoted text clipped - 55 lines]

John W. Vinson[MVP]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1