I have a report with a row of text boxes all the same height in a particular
report section which is set to grow. All text boxes are set to grow but it's
only the last one, containing comments, that would actually have enough
content to make it grow.

I have seen more than one post on this subject but no answer that resolves
problem. I have a main report whose fields are provided by query against main
order which supplies also the related engineer and supplier from the related
one-to-many relationships.

I have a bunch of tasks which need key personnel assigned... 4 personnel with
different job titles for each task. I want to develop a report based on a
query which shows me when one or more of the "key players" for a task remains
unassigned. In my report, I want null fields to ...

I found this arry code that man can take the last word from Pagefoot to
PageHead.
    Dim strLastItems(500) As String
    strLastItems(Me.Page) = Me.LName

I have Report and Field called: NName.
On the Report I created: NName Header
In "NName Header" Show only First chracter and it follow on detail same
first chracter as phone list.

I have a report in which I would like to compare last months figures with
this months figures. I do not want to see the previous months figure. I only
need to know if the figure increased, decreased, or stayed the same. Any
suggestions?

I have changed the design of one  report in my access database at the main
office.
how do I get this one updated report into my other office's databases.
we all have separate data but the same tasks.

I am dealing with a field that is desc with age. I have decimal numbers
after the whole number that i would like truncated. Of course, i would
not like to have this number rounded up but instead keep the number as
is. For example.... 25.75  would be truncated to 25 .... is this

I would like to put line item numbers in the left-most column of my Access
reports, to facilitae easier team communications during review meetings.  Can
that be done?

Working in Access 97, I want to add a textbox to a report that shows the
latest revision date for the database (including addition of new data).
I  assume that I use the FileDateTime function. But what do I use for
the argument?

I just revised the format of a check printing routine, and it prints just as
I want it, except that now it ejects a blank sheet at the end of the checks.  
With a single check, it previews both the single check and a blank page.  
With multiple checks, it previews the checks with ...

Can anyone point me to how to print a check with 2 "skirts" below the check
itself?  Right now I can only print the distribution of amounts charged (e.g.
Gross Pay, Federal Income Tax, etc.) on one of the skirts, since it uses the
"header" section to print all the fixed ...

Hi I use the following code to pull off a daily report.  Entering i.e.
txtStartDate  14/12/05    txtEndDate 14/12/05 it returns no data found when
files have been closed on that date.
yet if you enter txtStartDate  14/12/05    txtEndDate 15/12/05 it returns

good day all,
I have a report (rptlabels) that I use for new inventory items. I would
like to be able to choose 1 or many serial numbers (field value: serialnum)  
for the report to print? How would I do this? Would I have to create a new

In ACCESS 2003 -
I can write as many files as I need now, but I have to hard code the output
path and filename.  Filenames are working, but isn't there a default string
for the path to any user's MyDocuments folder?