having report open in Excel

  • Thread starter Thread starter f
  • Start date Start date
F

f

Hi,

I have a report that is too complex to run, because it
has too many controls on the one page. The report
requires that it have all of the infomraiton on the same
page.

So, I want to know if anyone can direct me to info on how
to program a macro to link a txt file of the information
to be connected to an Excel spreadsheet?
 
How many Controls are you talking about? The limit is something over 400. If
you have 400 Controls on a single page, seems to me it would be a bit
crowded, and "busy", even if half those were labels identifying the others
which control data.

Please follow up here in the newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 
I have 320 controls. The page returns the error
message "query is too complex". The page isn't busy. It
si readable, and required. It is a data report. And
because it is a page of totals by quarter for 20
categories, it's all calculations. I used IIf statements
for each control. I do not know of any other way.
 
You might look at totals queries, using criteria instead of IIFs. I had a
colleague who used Report calculations instead of calculations in the Record
Source Query who suffered various problems until he made such a change.

Can you successfully run the Query alone, without the Report?

If it is a Query problem, as it seems it is, have you considered asking the
question in the microsoft.public.access newsgroup devoted to Queries?

But, in any case, if you will post the SQL for the Query here, maybe someone
will be able to help. Otherwise, it would just be a guess and could, at
best, provide a generic answer like "simplify the query" (which would likely
not be any help at all).

Please follow up here in the newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 
Back
Top