Wonder if anyone might be able to help me out. In the detail section of
Access report, there is three subreports laid out as follows
subreport1
subreport2

Hi there,
I'm running the following code:
Private Sub Report_Open(Cancel As Integer)
   Select Case Forms![frmReports]![optChooseReport]

One of our users complained last night that the report was not showing
the data she entered into the form. I went to verify and found that
the "report" was in the middle instead of showing at the end like it
usually did.

Its been a while since I have created any reports in a database and need a
little reminder.
I have a basic database for tracking employee training with information
about the employee and then what courses they have done.  I have created a

Hi nice people
Many thanks Albert, your conversation with Neil on 12&13 Nov. about conversion Access report to PDF and mailed automatically was very helpful to me.
1 – the line Call ConvertReportToPdf (Str……) doesn’t work, return: function not defined, same for GetNameSpace
2 -  I ...

I did a search under blanks and tried every solution given here, and nothing
seems to work. I have text boxes (not labels) running down the page like this:
text1
text2

I need to be able to get a weekly report and i need to know where I should
put this in access the date range is >=and date<= to give me a report between
cetain dates.Any sggestion gratefully received

I have an Access report with a Bound Object Frame to show an Excel Chart.  
However, it takes too long to view each record if report has multiple pages.  
Each line chart was created in Excel with about 4000 data points.  Is there
any way to take a snap shot of the chart instead of ...

I have someone who supplied me with a .rpt file from Crystal Reports. Is
there any way to import or convert this file into an Access 2003 .Rpt file? I
do not have Crystal Reports. Running A2003 on XP.
Thanks.

I currently have a vehicle movement form for work.  The main form lists out
the details (Travel ID, Date, Time, Destination, etc).  The subform pulls all
records in the 'Details' table which correspond to the Travel ID (Vehicle
Name, Trailer Towed, Vehicle Order, etc).  There is ...

I have a form that I have unbound fields to choose a beginning and ending
date to get a report to print After pressing a button.  Below is the code I
have written to accomplsh the task.  Unfortunately I get a run-time error
'2498': An expression you entered is the wrong data type ...

I'm trying to get a date to display in this fashion:
       Wednesday, Nov 14   (or Wednesday, November 14  if I must).
If I use this format "dddddd\,mmm  dd" I get this strange result:
       Wednesday, November 14,2007,Nov 14

I have a report that is based on a query. The criteria for the start date
changes and I want a form where I can input the date range (Between
#2/2/2006# and #2/4/2006#) each time the report is run. Is there a way to set
up the form so that the forms asks for the user to put in ...

I have a report that has a sub-report (sub-report1) in it. Based on the
value of a field say studID, i'd like to be able to hide/unhide the
sub-reports.
What i'd like to see in the report is

I have a single table data base for inputing expenses
I have two fields start and stop mileage
I have a query to give mileage driven but how do add this calculation on
a report