Unable to use multiple tables in one form. 1

[gandalf1]

I am building a form with over 400 fields. As you know a table is limited to 255 fields. I divided the fields into 5 tables. I would like to use all the fields in one form. So far I have been unable to do this using the form wizard or anything else I can think of. Is there a way to get all the fields in the field list under view? Or am I just going about this the wrong way?





Thank you,
Justin

 

[jfischer]

Sounds pretty exotic. I trust this is not a form that a user has to look at. Even if this is some kind of character-based grid/chart/graph situation, I'd rethink it.

If you are trying to display regular text and numbers, etc., what you might try is using five (5) subforms, each of which uses one of the subtables. The five subforms could be linked to a control (common key field value) on the main form. This technique should get all 400 fields into memory at the same time for each record. That way, if this is a hidden form used for say, logging events, then you have access to every field.

 

[Lightning]

Presumably you have relationships between all five tables?

In that case, try a main form based on the Main table, add a tab control to the form, and place each of the other tables onto a separate tab of the tab control as subforms.

All of the fields won't be visible at the same time, BUT they will all be accessible.

HTH
Lightning

 

[gandalf1]

Thank you for your help. I may have to do it that way.
Maybe a better description of what I am doing will help. I am creating a form that was once a temoplate in MS Word. There is a slider bar to designnate a "Score" of 1 to 5. To my knowledge you cannot build a slider bar in Access. So I was going to replace the slider bar with radio buttions at 1/4 increments. This is why there are so many fields. I have 20 buttons instead of a single "field" which was the slider bar.

justin

 

[Lightning]

What about the Activex Slider Control? Check out "Microsoft Slider Control V5.0" in the "More Tools" section of the Form Design Toolbox.

HTH
Lightning

 

[gandalf1]

Thanks! How do I use the slider bar with my fields? I am unsure how to link the value from the slider bar to a field on the table.

 

[Lightning]

Sorry, I can't help you there. I rarely use ActiveX controls myself because my clients rarely have access to them.

I do know that there are control properties that set the scale to be used and that you link the slider to the field by the value property, but that's about it. Try the VB ActiveX Controls forum, or the VB forum here. Maybe they can help you.

Good Luck

Lightning