form wizard for subforms

[Bruno]

i have a problem. i'm using form wizard to make one main form with three
subforms. when i use the wizard the third form seems to be blank on
the form view in the one window but there is a separate file with the fields
in it for the third subform.. shouldn't all four forms be visible at the
same time in one window? also i had entered 4 records in the main table but
only one record was inserted into the main form and subforms should that have
happened after using the wizard?
i hope some one can help.
i deleted that form and subforms and tried again. but this time access 07 is
telling me it can't complete the forms ' cause there are to many fields. what
should i do?

 

[Rod Plastow]

Hi Bruno,

I'm unsure what you are doing as your terminology is not too clear; for
example subforms are contained in a form, not a window. Yes, if it's what
you want and you have set it up correctly all three subforms should be
visible on your main form and if there is corresponding data all three
subforms should not be empty.

I've never encountered the 'too many fields' message. How many fields do
you have? How many columns are on each table? How many fields are you using
for the Link Master Fields and the Link Child Fields relationships?

As for your other problems, are you basing your forms on the tables or on
queries?

Sorry, can't help you very much without more information.

Rod

 

[Bruno]

sorry about phrasing .. i have based my forms on tables. i think i'm pretty
sure i can delete many fields as there are redundancies in two tables. i have
set up my relationships and they seem good. i'll try again with fewer fields
... however just because the pop up says i have to many fields doesn't
necessarily mean that. it could possibly be some other thing
interfering.
thanks Rod.

 

[Bruno]

hi rod i checked my relationships and some tables had disappeared as i had
renamed a few. however i remade my relationships and reduced the number of
columns for the four tables to 42 columns. again i got the pop up to many
fields. however i didn't delete the columns (fields) from the tables i just
didn't add them from the form wizard to the forms. would that make a
difference?
thanks Rod for any help u can give.

 

[Rod Plastow]

Hi Bruno,

I've searched Access Help and can find no direct reference to your error.
It may however be a manifestation of a memory problem. What is the exact
wording of the error message and is there an error number?

Does your main form work on its own? Do your subforms work on their own?

What version of Access are you using?

Rod

 

[Rod Plastow]

Error 3190 - Too many fields defined? You have exceeded 255 fields.

Is it this one?

Rod

 

[Bruno]

hi rod,
thanks for helping. nope that's not the error. i have about 42 fields. so i
decided to use a form for each table sort of what u suggested. now i having a
problem with a lookup value for one of the fields in a form called kidmbrs.
its the MemberID field and i want it grabbed from the contact form memberid
field there. so here's my statement which access doesn't like
=DLookUp("[MemberID]","[kidmbrs]","[ChildID]=" & [Forms]![contact]![memberid])

 

[Bruno]

well, i became confused the second form should be a junctiontable. i can't
even run a query to find the memberid in the contact form to match a child
(children as in kids) from the junction form. in my query i've got the
following:
contact tble field =memberid ..contacttble field lastname contacttble
firstname.
it returns an error message mismatch type in expression. any clues?
Bruno

hi rod,
thanks for helping. nope that's not the error. i have about 42 fields. so i
decided to use a form for each table sort of what u suggested. now i having a
problem with a lookup value for one of the fields in a form called kidmbrs.
its the MemberID field and i want it grabbed from the contact form memberid
field there. so here's my statement which access doesn't like
=DLookUp("[MemberID]","[kidmbrs]","[ChildID]=" & [Forms]![contact]![memberid])

Error 3190 - Too many fields defined? You have exceeded 255 fields.

Is it this one?

Rod

 

[Bruno]

hi all,
i worked it all out and now the db is working great. thanks for trying to
help.

well, i became confused the second form should be a junctiontable. i can't
even run a query to find the memberid in the contact form to match a child
(children as in kids) from the junction form. in my query i've got the
following:
contact tble field =memberid ..contacttble field lastname contacttble
firstname.
it returns an error message mismatch type in expression. any clues?
Bruno

hi rod,
thanks for helping. nope that's not the error. i have about 42 fields. so i
decided to use a form for each table sort of what u suggested. now i having a
problem with a lookup value for one of the fields in a form called kidmbrs.
its the MemberID field and i want it grabbed from the contact form memberid
field there. so here's my statement which access doesn't like
=DLookUp("[MemberID]","[kidmbrs]","[ChildID]=" & [Forms]![contact]![memberid])

Error 3190 - Too many fields defined? You have exceeded 255 fields.

Is it this one?

Rod

 

[Rod Plastow]

Hi Bruno,

Glad to hear it. Sometimes just explaining things helps you find the
solution.

Good luck.

Rod

 

[Linq Adams via AccessMonster.com]

The *too many fields* message that the Form Wizard pops has nothing to do
with the 255 field/recordsource limit. The Form Wizard is designed to help
non-programmers develop relatively simple forms. The number of fields that it
can handle depends on the algorithm used for the particular form view. Forms
created in Datasheet View (where the fields expand laterally) can hold more
fields, in general, than those in Single View (which can expand to 22" x 22")
with Continuous being able to handle the fewest of all. If your skills are
such that you just have to use the Wizard and you get the *too many fields*
message when trying to create a Single View or Contuous view form, a
workaround that often works is to use the Wizard to create the form in
Datasheet View, then go into Design View and in the Properties Box change the
Default view to Single or Continuous View.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Rod Plastow]

Thanks for that. Must admit I still use the wizard to get a head start.

Rod