Is there a way to convert a string that is a file path to
a hyperlink so that way when the report is exported via
word or excel it will be "clickable"?

I have a report that is called from a form.  On the open
event of the report I set the report's data source as
follows:
   Dim stSQL As String

Our club is going to have a raffle, and we are printing our own tickets using
Access.  I know how to make incremental increases by putting =1 (or whatever
the increment is to be) as the control source.  However, we would like to
start the ticket numbers at 00001, and I can't ...

Is there a way to concatenate two pull down menu's in a report?  It doesn't seem to work for me?
-Joel

I have a report that is replacing a manual form.  The form must remain intact
and can only display 8 detail records per page.  Thanks to those who
responded to my post yesterday to help me with this.  However, I still have a
problem, there is additional information that has to ...

I want to create a graph where the data is displayed in ascending order by
week.  My data has a date field and Access uses Format([Myfield],"ww",0) to
summarise by week.  However, my data spans more than one year so the first
week should be 01 2003 then 02 2003 so I've used ...

I have a database of parents and children. I need to set up labels with the
name of the parent, and the age and gender of the children. I have a report
that does this with a subform that repeats for the number of children. Is it
possible to do this with a 1"x4" mailing label?

I am using Access 2003.  I need a field in my report to round up to the next
whole number.  For example, I am having one field multiply another field and
the result is $18.20 and it would round up to $19.00.
Any help is appreciated.

How do I get the report not to print a field if there is no data in it?  I'm
using Office 2000.

I would like when a report bases in a query to refer to specific records.
For instance
The result of the report is three records. How can I refer to record 1,
record 2 and record 3 of the report. Besides I would like when the reference

Is there a way to export one Access report into multiple reports based on
detail section breaks?  I have one big report for multiple city agencies that
I'd like to export into individual agency reports (i.e. so the Police
department doesn't have to look at a Health Department ...

I have a bunch of reports, and I am trying to change them to all use the same
input forms. I got the form [Report Date Range]![Begin Date Record Time]
working from my first 2 reports, then it faisl in ALL the rest of the
reports. These reports call in line SQl as follows:

How can I remove all the buttons that we have on the top right corner of the
REPORT which are: minimize/normalize/close buttons. Because for the reports
we don't have these options in the property window that we can change it to
'No'.

Is there a way to prevent the report footer from counting as a page in the
page numbering?
I found a technote (q209215) http://support.microsoft.com/?kbid=209215
But it talks about reseting the page numbers for different grouping based

On the print preview and in the printout my fields look like my dog ran all
over them. Is there anything I can do to improve this?