Too Many Fields

[MarcusAntonius]

I'm trying to create a form from two tables but it errors out with: The wizard is unable to create your form or report because you chose too many fields; please try again with fewer fields.

However, I can't reduce the number of fields and it's not because I don't want to. Is there another way around this?

 

[Ukraine82]

To make a form from 2 tables is best to use a query.

Michael

 

[MarcusAntonius]

As in create a query and then create a form based on the query? That still gives me the same error.

It needs to be a form since it's for data entry and I don't want users trying to do it using the datasheet view.

 

[namliam]

Create it by hand...

 

[Ukraine82]

Are you trying make a form from 2 tables?

If so, using a query is probably the best way to go.
It shouldn't give you an error.

If you want post your db and I'll take a look at it for you.

Michael

 

[MarcusAntonius]

Are you trying make a form from 2 tables?

If so, using a query is probably the best way to go.
It shouldn't give you an error.

If you want post your db and I'll take a look at it for you.


Yes, from two tables.

Perhaps it's a bug of some sort in access whereby there's a limit on the number of fields that be used in a form. (I'm using access 2002/sp3)

Unfortunately I can't post the DB.

 

[Rich]

How many fields do you have?

 

[MarcusAntonius]

79 in one table and 13 in the other, so 92 in total.

 

[Mile-O]

79 in one table.

Normalise.

 

[MarcusAntonius]

Trust me, I wish I could but unfortunately it's not an option.

 

[Mile-O]

Why is it not an option?

 

[MarcusAntonius]

I'm importing the 79 field table from a csv file containing 30k records.

 

[duckster]

I think I'm having this same problem, except, when I create the form using the wizard, the form in form view is completely blank (only background is seen). The datasheet view is fine though.

When I use the wizard and select only a few fields from each of my 3 tables, it looks and works perfectly; however, when I add all fields, it goes blank. I'm having a hard time figuring it out as well.

Have you figured it out?

 

[MarcusAntonius]

I think there's a limit to the number of fields you can have, so just try adding a few more each time and see where you get to.

Not sure why it goes blank though, I didn't experience that problem since it just wouldn't let me create the form due to the excessive number of fields.

 

[finneyz]

I just encountered this problem. I have 25 columns.
It worked when I limited the number of columns for the report. Not sure. I guess its a bug in access. Has anyone else encountered this issue.?

 

[Pat Hartman]

Try compacting the database. Access "remembers" fields that were added and then deleted and includes them in the count. Compacting is supposed to reset everything. You might have to use the /decompile switch if compacting doesn't work. The /decompile switch is an undocumented feature and it is supposed to remove all the p-code that compact sometimes leaves behind. In the Run box, type the name of the database including the full path followed by a space and then the /decompile:

C:\Data\Work\SomeClient\Somedatabasename.accdb /decompile

Since this switch is undocumented, it is recommended that you back up the db first.

 

[finneyz]

yeah tried it. still didnt work. Thanks though