Wizard is unable to create form

  • Follow


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.
0
Reply Utf 2/4/2008 6:55:01 PM

I think that as a general rule, when you get that error message, it is 
because you are missing or have an incorrect link somewhere. The form wizard 
can't see how this particular data will relate to each other and so it can't 
connect. Go to relationships and check. Another possibility is that you need 
to build queries with only the necessary data for a particular form, link the 
tables in the query, and THEN build the form. Once the query is built 
properly the form should be no problem. 

"shadden" wrote:

> 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.
0
Reply Utf 2/4/2008 8:12:03 PM

The limit of fields per form (actually the limit of fields per recordset, 255)
is not the limit for creating a form with the Forms Wizard! I'm not really
sure that there is a cut and dried limit, as such,  for the Wizard; I've
never seen one listed. The Forms Wizard is intended to create ***simple***
forms for the casual user, not something along the lines that you've
described. I'm afraid that you're going to have to take the time to learn to
use the Form Design View in order to do something this in depth.

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

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200802/1

0
Reply Linq 2/4/2008 8:35:59 PM

2 Replies
905 Views

(page loaded in 0.058 seconds)


Reply: