How do i can format the hightes 3 records on an Access Report?
Unfortunately the Access doesn't have the Excel have the function "Large"...
Can you help me?

I am trying to run the following procedure, which seems really slow.
The first input file rs_In has 1361 records in it. The file rs_In2 has
22690.
For each record on rs_In, the code is reading all of rs_In2 looking

I have a database.  2 columns.  I have one work sheet that needs to findest
the highest dollar amount during a period of time.
Example
10/1/2007

I'm trying to select records from several tables at once"
SELECT Units.[Unit ID], Units.Building, Units.[Room #], Units.[Hood #],
Nz(Max([Inspection Date]),"Not inspected") AS [Last Inspection],
Inspections.[Average Velocity]

The only toolbar that shows up when I open a database (after importing the
data) is the menu toolbar, containing file/window/help.  The only thing that
appears is the soil reports window.  After closing the window, I'm unable to
look at anything in the database.

Has anyone else seen this problem - occurs on many machines (20) after Office
2003 SP3 install yesterday - completely killed the application. (These are XP
machines).
Selected Forms open OK but on close get the MS screen of death - 'Access has

I imported an excel spreadsheet with 10 digit ID numbers into Access,
and it dropped all of the leading zeros in the ID number field.  I
changed the field type to text instead of numeric, but the zeros are
gone.  How can I replace those zeros without having to type them all

How do I add up the lines on my spread sheet from my coputer

I am developing an Access 2000 application that is split into a front end
and a back end and makes use of User-Level Security. The whole thing will be
distributed to several users, who will each run it independently on their
own PCs (ULS is only exploited to enable identification ...

I want to combine 2 chapters of the same book one is in Latin and one is in
English.
Each translation has many lines each line has a number.
How can I insert line nr.1 in English after line nr 1 in Latin,

I've recently converted to Access 2007 from Access 2000.  Some of the
simplest procedures no longer work in my updated databases.  For example
DoCmd.Maximize as an event procedure in the OnOpen event or DoCmd.GoToRecord
acDataForm, "HouseholdItems", acNewRec in the OnLoad event.  ...

Which is more efficient, creating relationships at the table level using
Tools->Relationships or creating the relationships between tables when I
create a query?
Thanks

Would you please tell me the problem of the following function?
Public Function GetOrderQtyIssue(StockPN As String) As Long
Dim Stemp As String
Dim Rs As ADODB.Recordset

My problem:
I have datas like
A    B
A001    2007-10-01

I have linked to a mainframe DB2 table and when I try to open the table or
run a query against it, the only thing that display is "#Deleted" in every
cell.  I know there is data in the table as I can query using Excel and get
the correct results.  Using the same simple query in ...