Hi Sir/Mdm,
I encountered a problem when i run my report as can't open too many
databases. i already tried to open and closed every recordset in my modules.
so any other way to avoid the problem?

How can we export report output in excel format?
Can any one give sample code or link so I can have a look.
Thanx for your help..

Ok....... I am have a great time trying to get a page break to happen the way
I want it to.  :)
On the first page, data from a sub-report will print anywhere from mid-page
to end of page.  There is another sub-report that prints after it.  I cannot

hi sir/mdm,
i have a huge db where i set it to auto compact when it close to avoid it
corrupt due to the db size is very huge. If i do not compact it when it close
it encounter corruption problem few times. it works fine if only one user

I made a report in Access but every other page is blank.  How do I get rid of
them as I tried everything but nothing works.  Please Help!

Access 2003
I'm trying to change a label's text direction from (Left to right) to (up to
bottom)
when I try to change it in the properties under Other. there is an option

I have a report that On Open opens a form from which the user selects a name
from a dropdown box, then what should happen is the query runs, populates the
report and I'm done...
Problem,  It doesn't work.  The from pops up perfect when I open the report,

I want to label each row of data once on the left side of each page.  Not
each column on the top.  I am using Access 97.

Can anyone tell me what's wrong with this formula?
([Sum Of txtClients0]*[txtclientstotal])/ [Sum Of txtClientsTot]
TxtClientstotal is a calculated on the report the other controls come from a
query.

I have been able to place a sum in the page footer following Article ID

However, when I try to sum multiple columns of values, the sums are
incorrect. Below is the code I am using to sum "Fee" and "Rent" values.

thanks for the input, I do have an autonumber field and I can do the max to
that.  for the print out 3x I have used VB but not a ton-  do I tie an event
procured to the on click of the command button and what would the Print code
say to get 3 labels on the same sheet( 3label ...

I want the form that sets up a report to be able to choose the sort order.
Say if Forms!MyForm!MyFrame = 1, then Sort by Creditor Name and if =2 then
sort by date of last payment. Say the report has a report header, a detail
section, but no section headers/footers. Can anyone ...

I am currently using an accounting software program that interfaces with
Access. We recently upgraded the software to the next version as well as
upgraded from Access 2000 to 2002 as required. We have the ability to preview
reports from the accounting software as well as export ...

I have a report that shows each department and their schedule by day.  It
basically has group header "department", and group header "day".  Under the
day header it shows everyone scheduled and the time they work, and the total
of their shift.  I can get the running sum to work if ...

Thanks for taking the time to read my question.
I have a main report with one small sub report.
I have them linked and it all works fine. The sub report displays one value
and is placed in the detail section.