S
shadden
Hello all, Hope you can help.
I am using Access 2000 SP-3 on an IBM Thinkpad running Windows 2000.
I have created a database (my first) with 27 tables. I have about 150 fields
total among the tables. I'm somewhat familiar with database structure and
design and think it's ok. I've followed all the conventions about naming and
linking with primary and foreign keys, etc. Also, had one of IT folks take a
look and he gave it his blessing.
I'm trying to create a data entry form for this db. I am using the wizard to
create my form (since I can't figure out how to do it in Design View which I
would prefer). Only a few fields actually require text data to be entered,
most are selections from drop down menus or Y/N. I can successfully create
forms for all the tables singly and in various combinations. But when I try
to put too many together (or all of them), I get the error message "The
wizard is unable to create your form".
Unfortunately, I can't tease any more clues out of Access to give me a hint
about why it's failing. I've search the internet but have only found one
reference to excess fields but I'm under that limit.
Any suggestions would be helpful. Please let me know if you need any more
info.
I am using Access 2000 SP-3 on an IBM Thinkpad running Windows 2000.
I have created a database (my first) with 27 tables. I have about 150 fields
total among the tables. I'm somewhat familiar with database structure and
design and think it's ok. I've followed all the conventions about naming and
linking with primary and foreign keys, etc. Also, had one of IT folks take a
look and he gave it his blessing.
I'm trying to create a data entry form for this db. I am using the wizard to
create my form (since I can't figure out how to do it in Design View which I
would prefer). Only a few fields actually require text data to be entered,
most are selections from drop down menus or Y/N. I can successfully create
forms for all the tables singly and in various combinations. But when I try
to put too many together (or all of them), I get the error message "The
wizard is unable to create your form".
Unfortunately, I can't tease any more clues out of Access to give me a hint
about why it's failing. I've search the internet but have only found one
reference to excess fields but I'm under that limit.
Any suggestions would be helpful. Please let me know if you need any more
info.