Query Limitations

M

Matt

I need more fields on a form than I can get into a Query. The info is coming
from several tables, so I cannot use that as a record source. Any help on
how to get 25+ fields into a form would be greatly appreciated. Thanks in
advance!
 
G

Golfinray

For that many fields, I would use a tabbed form or report. Break it up into
about half or one-third per tab. I don't think you will get all those on one
page and make it look right.
 
M

Matt

Background info. This form is a service form that has to be printed as is.
For now I am making several fields unbound until I can fix this problem.
Several of the fields are check boxes, and several others are dates only so
they don't take much space relative to an 8 1/2 x 11 page. I have to include
all related job information, so there are very few that can be done without
with little conflict.
 
D

Duane Hookom

A query can have up to 255 fields. A form or report can have over 600
controls. You shouldn't be running into any limitations with 25+ fields
unless the "+" is about 250.

It sounds like you are printing an Access form. You should be printing
reports if at all possible.
 
M

Matt

No, the plus is about 5! Is there a special process I need to use to insert
more fields into my query? I ran out of new boxes at 36. As far as
printing, I could make a report that mirrored the form, but wouldn't that be
a little redundant? Or could I link the print button to print a report on
that form through coding?
 
D

Duane Hookom

"I ran out of new boxes at 36"? You have several methods for getting more
fields/columns into your query design grid.
-From Insert menu
-Double-click a field name
-Select and drag a field name to the grid
-Change to SQL view and type in the field name
--
Duane Hookom
Microsoft Access MVP


Matt said:
No, the plus is about 5! Is there a special process I need to use to insert
more fields into my query? I ran out of new boxes at 36. As far as
printing, I could make a report that mirrored the form, but wouldn't that be
a little redundant? Or could I link the print button to print a report on
that form through coding?
Click to expand...
 
M

Matt

That's exactly my problem, it should be letting me add more, but there is not
another column to add a field to, and if I drag another over etc., it does
not insert another field, reacting like I've reached it's limit. Very
strange...
--
-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."


Duane Hookom said:
"I ran out of new boxes at 36"? You have several methods for getting more
fields/columns into your query design grid.
-From Insert menu
-Double-click a field name
-Select and drag a field name to the grid
-Change to SQL view and type in the field name
Click to expand...
 
D

Duane Hookom

You should always be able to drag a field from the top to the grid unless
there are more than 255 columns. What happens when you try this? What happens
when you attempt my other 3 suggestions? I expect all 4 will work for you but
I'm not able to look over your shoulder so you need to describe what happens
when you attempt the suggestions.
 
M

Matt

Insert Menu - ??
Double Click a Field name - Nothing
Select and Drag - Nothing (There is not an open column on the end to add to)
so I can drag a field over, and it lets me drop it with no error message, but
it does not add anything to it.
SQL view - For whatever reason, switching to this view, then back, then
reopening Access and the DB, there are always two blank columns at the end in
the design view. Whatever, it works. Thanks a lot for the help!

Just because I don't know, what's the difference in printing a form and a
report? Should I have people fill out the form, then switch to the report to
print, or can I add code to print the corresponding report for the form the
print button was activated off of?
 
D

Duane Hookom

When I am in query design, the word "Insert" is available on the menu at the
top. Why do you think that double-clicking a field name in the top of your
query design doesn't work. This has always inserted the field to the right of
the last column in the lower grid. Also, grabbing a field from the field list
in the top and dragging it to grid (even on top of another field) results in
adding the field to the grid.

If you view the sql and it says:
SELECT FieldA, FieldB, FieldC
FROM tblX;

You can type ", FieldD" after FieldC to get:
SELECT FieldA, FieldB, FieldC, FieldD
FROM tblX;

Each of these three methods as always worked for me.
 
Top