I routinely need to import some tables into Access 2003 from a fixed Excel
file. The Excel contain several sheets, which I all wonna to import to
Access. But the repeat-import is hineous, so any expert idea on how to build
a VBA sub to do this kind of job?

I have a query that returns two columns, another that returns two fields; a
count of the number of records in each of the two columns in the first query.
In a report based on the first query, I would like to add two text boxes at
the bottom of the report with their control ...

I use Access 2000, and set most forms to popup and modal...is there any way,
from my "Report" form, of being able to preview reports?  At the moment they
sit in preview behind any other forms that are open....

This is in the control source for a text box. Just trying to make everything
look neater. But it doesn't appear. Any suggestions?
="For Period: " + [Payment_Period_From] + " to " + [Payment_Period_To]

I posted this in the query newsgroup, sorry for crossposting, but I thought
maybe a report guru might know how to tackle this via report properties
rather than underlying queries.  I have:
- Production Table w/ OrderNumber

I have a table with two fields, txtvalue (a number field) and txtmonth ( a
date/time field). I want to create a report that shows the differerence in
value between the value in txtvalue in one value of txtmonth and the value
of txtvalue in another value of txtmonth and the ...

Help, think I got way in over my head in this project. I had info in old dos
database time to bring it into the new century imported in Access.
I have created a new report in access for Volunteer Fire Company fundrive.
My problem is I have a preprinted form on 8 1/2 X 11" that is ...

I see many posts have been made on this, and the advice is always to repeat
the calculated control formula itself in the group level's summing control.
Quite valid if its just simply totaling all the records.
I am setting up a database for a loyalty program in my shop. Each ...

how do I count the number of fields of a record that hold a value in a
crosstab report?
Ex:  col1 col2 col3 col4
       12          15              Count = 2

Hi there,
I would like to know if there is anyone thinking about solving a small bug
about the last line of every text box that is justified, and which no matter
what, stays always justified, giving to the last line this apearance:  R      

I have a report that should pick up individuals that have been absent
for 3-8 weeks.  It should base this off the last date attended.   I
formerly had "last" in the group field but it missed many records so I
changed to "max" and the correct individuals show.  But when I add this

I have been able to use the DatePart function to display the month with
summary data attached.  I have used Expr1 in the query to create the month
Expr1: DatePart("m",[dtmAmbulanceAuditDate]).  The problem is that I can only
get it to display the month as a numeral eg "3" for ...

I have been able to develop a report that displays summary information
attached to each month.  I have used DatePart Expr1:
DatePart("m",[dtmAmbulanceAuditDate])to pull out the month from the date but
it only displays the month as a numeral eg "3" for March. It would make the

I have designed a report that has 3 subreports in it.  The grouping is on
say name.   Each subreport has a relationship to name.
Depending on the NAME one or two of the subreports may have a null or zero
value.

We have Access2000 with WindowsXP.
We have produced a report to print out many pages of customer & supplier
addresses.
We use the "can shrink" property to shrink  (and so delete on the report)