--------------------------------------------------------------------------------
I would like like to convert some of my Access 2003 databases to 2007. I am
on a stand alone pc running Vista Business and Office 2007.
When I follow the "convert" instructions using either the SAVE AS ...

I am using Access 2000, and am wondering if it is possible to create an
interactive timeline.
Basically, users input changes with an effective date (and other
information), and I would like to plot these changes on a time line with a

I have a report that gets data from a query. In the footer of the report
I have a number of calculated fields that work with the same recordset
to display numerical calculation results. Each of these uses a DAvg
function call with specific criteria to filter out some of the data ...

We have an ADP project created using Access 2000. This project is
under source control (using the Access' standard add-on that
integrates Access with SourceSafe).
Now we use Access 2003 to work with this project. Everything seems to

Table1 has 3 fields: customerid, goodstype, salesongoods, no pk.
Want results as following:
    PC    TV    Refrigeratory    Microwave oven
PC               

I work at an alternative school that has rolling enrollment, and a student
may come and go several times in a year.   I have a table that tracks student
attendance.  The date that students are dropped from enrollment is encoded in
the table and easy to find with a simple query, ...

Sign In
Windows Live ID requires JavaScript to sign in. This web browser either does not support JavaScript, or scripts are being blocked.
To find out whether your browser supports JavaScript, or to allow scripts, see the browser's online help.

警：你在幾點進入店內？
我：店員指控你竊取牛仔褲跟腰包你做何解釋？
我：我進入店內逛逛，看到牛仔褲我有想購買，我把牛仔褲放到褲子裡面，
衣服有蓋住，我還沒走出店門口，我沒有想偷的念頭，店員先說我有拿

I wonder if there is a way to force an email on the close of a form to a
specific person or group. I have a form that has several tabs. Each section
may get completed at a different time, but for each update, I have a group of
"gatekeepers" that need to be made aware of this ...

if you receive try to call me back.......................

I am trying to do a crosstab query, and even though I have a table
with all the possible locations (as row headings) it won't display
them if they have no value.  It only displays the row if it finds a
value in the column even though I have linked them and told it to

I have been working off the replica database for a couple of weeks.  I now
want to change the Master, but cannot find where it is stored.  Is there a
way that the Replica points to the Master

I have a table profs with PK field  Abbrev Text (length 5).
I have on a form an (unbound) combo box displaying abrev and other
field.
SELECT Profs.ABREVIATION, [Nom] & " " & [prenom] AS Expr1

Accrss 2003 Excel 2003 all up-to-date
Access export to Excel stops at about 45,000 records.  The version of Excel
(2003) will hold 65,000+ records.  How do I get around this error?
Access gives this error:  Run-time error '2036':