Form containing more thatn 256 fields

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I have a paper form that would require more than 256
fields entries on an Access form. Is there a way that I
can have a form pull/put information from more than one
table without using a subform? The subform window would
not work, I think, because it has a window border around
it. I have created a form to look exactly like the paper
form, and so far my attempts with a subform give me a
window. Can a form be built on two tables?
 
mike said:
I have a paper form that would require more than 256
fields entries on an Access form. Is there a way that I
can have a form pull/put information from more than one
table without using a subform? The subform window would
not work, I think, because it has a window border around
it. I have created a form to look exactly like the paper
form, and so far my attempts with a subform give me a
window. Can a form be built on two tables?
Click to expand...


Firstly it is nearly always a very bad idea to use a paper system form
as the basis for your database design. The basic steps are to analyse
and normalise the data into interrelated Table structures, then design
Queries, Forms and Reports to do the tasks needed.

Having said that, subforms do not need a border, they can merge into
the main Form so you cannot see the join. Only one table can be used
as the direct record source for a Form. If you need the data from more
than Table then you need to use a Query. Then use that Query as the
record source for your Form. To do this successfully, you must have
carried out the basic steps I've outlined above.

hth

Hugh
 
-----Original Message-----



Firstly it is nearly always a very bad idea to use a paper system form
as the basis for your database design. The basic steps are to analyse
and normalise the data into interrelated Table structures, then design
Queries, Forms and Reports to do the tasks needed.

Having said that, subforms do not need a border, they can merge into
the main Form so you cannot see the join. Only one table can be used
as the direct record source for a Form. If you need the data from more
than Table then you need to use a Query. Then use that Query as the
record source for your Form. To do this successfully, you must have
carried out the basic steps I've outlined above.

hth

Hugh
.
Hugh,
Click to expand...
Thanks for the reply. Can a query contain more than 256
fields if I pull them from multiple tables?

Mike
 
If you have that many fields even from two different tables, your database
has some serious design flaws. I would read up on Normalization, Setting
Relationships, and Setting Referential Integrity from help or visit
Microsoft's Knowledge Base.
 
Back
Top