I am using Access 2003. I imported a name & address table from Excel and used
the mailing label wizard to make a mailing label report to print the mailing
labels, but I cannot get a space between the state abbreviation and the zip
code.  Can anyone help?

Not sure if I have the correct forum, so my apology if anyone thinks this is
the wrong one.  Anyway,  I have a form/subform  which I use to enter course
booking information.  Having entered the details for a customer and the
course they require on the main form/subform, I then ...

I've got a report. It looks good in Access, but all lines disappear when I
export it to RTF, Word, Excel or whatever.
Ho can I preserve the lines?
Thnxs,

I followed  the directions from an article in the database including
inserting all of the pertinent VBA code but when after I click OK on the
collection form with the drop down box,  all I get is the actual datasheet
view of the parameter query.  Somehting is missing that allows ...

Can anyone tell me how to insert an image from clip art into a database
report? Or how to access clip art from Access?
Thanks

Two quick questions
1. What is the syntax to dynamically (using VBA) assign the parent/child
linked fields for a report and its sub reports. Sometimes I want a report to
link to the sub on 2 fields and sometimes 3 fields.

Today I can Export a Report to a RIch Text or Excel File.
But I havent been able to Export a Report with a Logo of my company to a
nice format Document "this means that include all the look and field of my
original Report"

The subreport and a main report both use the same recordsource query, the
subreport just displays the data in a different way. The subreport appears
in the report footer and is only shown on the last page.
The query gets it's criteria values from a form combobox control, which may ...

I have created a chart on a report in Access using the following SELECT
statement.
SELECT (Format([DateMatterServed],"Q 'YY")),Count(*) AS [Count] FROM
[qryAdminChargeChart]   GROUP BY (Year([DateMatterServed])*4 + DatePart("q",

I am running a report in Access 97 from VBA like this:
DoCmd.OpenReport "rptTGrantsAwardLetter", acViewPreview
Printing from this preview sometimes prints 2 or more copies of the report.  
The copies are set to 1 in the printer dialog.  This behaves the same on

Is it possible to get the View constant within the Report?
As I know the acView constant is only an argument to Docmd.openreports
I want to insert a timestamp info if the user prints, but not if he uses the
Preview mode.

I have a report that will be opened with the DoCmd.Openreport command.
However the form in which this command is stated can have more then one
instances. The behavior of the report is depending on the calling form. How
can I let the report know which instance of the form called ...

Is there a formula to that counts hours minutes seconds of more than 2 days
(24 hours) and puts it into a legable outcome.
I mean : 10:45:45 + 3:65:24 + 17:45:12 = 32:36:21
The results I get are always belowe 23:59:59

I have a report which is inturn calling a parameter query. I wish to open
the query with a text box on the side saying how many records are being
displayed.
I have used dcount like this:

Hi. PC Datasheet showed me how to run a report and then
have a message box that kicks off another report.
The first report, Birthdays, requires user input to
select the correct birthday month.  I have an input form