Can I set how the sequence of AutoNumbering to change with
the year example: 04-001, 04-002, 04-003 etc.?
Also is there a way to have the database alert me to when
there are monthly duties due like in Outlook with the

How can I format a column to show dates as mm/dd/yyyy
3/31/2004?
Paul

When I run a compact and repair on my Access 2000 database, I get an hourglass and it runs forever. Task manager shows no activity in MSACCESS.EX
Does anyone know what this means
I can open and use the database and nothing seems amiss with it. But not being able to compact and ...

I would like to force all dates to be formatted as 2 digit
years in a particular database. All reports and forms were
created for 2 digit years and now the 4 digit dates aren't
legible. I can't remember what I was told regarding the

Suddenly, my XP operating system has decided my Access
program running under Office 97 professional is not
licensed for my computer.
It had been running fine, until I loaded Access from Office

Is there any way to install both Access 2000 and Access
2002 on the same PC?

We are converting alot of databases from 97 to 2003 and
are runnning into people getting the Network Disk Error
message and then they have to close out of Access and
come back in again. This did not happen with the 97

Everytime I load access, I get the "Installing Microsoft Access Feature" pop-up.  This has only started occuring since ! upgraded from Win2K to Win XP.  Currently Running Office XP
In additional, my switchboard form refuses to open.  Reported error is
"The expression On Open you ...

I have a table with information I am trying to update. The name of the table is called Call Error Xref Table. It is in relation to another table called Call Table. The call table saves CallID fields and the Call Error Xref Table save CallErrID fields in relation to each different ...

I have a summary table and a transactions table joined by I
i need to update the summary table by the sum of transactions Groubed by I
I wrote the sql statemen
" UPDATE  Summary_Table INNER JOIN  Trans_Table ON Trans_Table.ID = Summary_Table.I

I'm having problems in MS Access XP.  Each time I open a database file, Acees wants to "Compact and Repair Database" Then is does "Send Report to MicroSoft" screen.
If I open the database on another computer I get a table named MSysCompactError and it contains a row

We have Access2000 on a W2k PC and need A97 installed on the same PC. I
followed the MS bulletin about installing these 2 versions on the same PC.
It installed okay and I can use A97. However, when I try to use the Linked
table wizard I get the 'Wizard not installed' error message. ...

I have been using Office 97 for years. Some days ago I
installed Access-2002 in a separate directory, without de-
installing Access 97. And now I see that I cannot create
new tables in Access 97, even if I create quite a new and

We just upgraded our computers to Windows 2000
Professional and Office XP Professional. I converted the
Access 2000 application to the 2002 format. In both
instances (whether running it as a 2000 file or 2002

Have recently upgraded to windows 2000 and now I get a no
licence error whey I try to start access.  Have tried
reloading from the office 97 disk and have re-entered the
cd key etc.