Problems after converting from 2000 to 2003

[Liz C]

I converted a database from Access 2000 to 2003. I'm now having two issues
(that I've found so far):

On several combo boxes on forms, I have similar row source as follows:

SELECT [MeasureQ].[MeasNo], [MeasureQ].[Closed], Right([MoYr],2) AS Expr1,
[MeasureQ].[MoYr], [MeasureQ].[MeterNo], [MeasureQ].[MeterName] FROM MeasureQ
WHERE ((([MeasureQ].[MeterNo])>0)) ORDER BY [MeasureQ].[Closed] DESC ,
Right([MoYr],2) DESC , [MeasureQ].[MoYr] DESC , [MeasureQ].[MeterNo];

One problem I'm having is that "MeterName" is not showing in the combo list.
The other problem is the field "Closed" should show yes or no, but is
showing -1.

Any ideas?

Thank you in advance for any assistance!

Liz

 

[ruralguy via AccessMonster.com]

Have you already applied SP3 for Office 2003 and not yet applied the HotFix?
http://support.microsoft.com/kb/945674

I converted a database from Access 2000 to 2003. I'm now having two issues
(that I've found so far):

On several combo boxes on forms, I have similar row source as follows:

SELECT [MeasureQ].[MeasNo], [MeasureQ].[Closed], Right([MoYr],2) AS Expr1,
[MeasureQ].[MoYr], [MeasureQ].[MeterNo], [MeasureQ].[MeterName] FROM MeasureQ
WHERE ((([MeasureQ].[MeterNo])>0)) ORDER BY [MeasureQ].[Closed] DESC ,
Right([MoYr],2) DESC , [MeasureQ].[MoYr] DESC , [MeasureQ].[MeterNo];

One problem I'm having is that "MeterName" is not showing in the combo list.
The other problem is the field "Closed" should show yes or no, but is
showing -1.

Any ideas?

Thank you in advance for any assistance!

Liz

 

[Liz C]

I have applied the HotFix and it corrected the problem, but now if I try to
export something to Excel from Access, I get the following message:

"The format in which you are attempting to output the current object is not
available." Either you are attempting to output the current object to a
format that is not valid for its object type, or the formats that enable you
to output data as a Microsoft Excel, rich-text format, MS-DOS test, or HTML
file are missing from the Windows Registry. Run Setup to reinstall Microsoft
Office Access or, if you're familiar with the settings in the Registry, try
to correct them yourself. "

If I re-install Office, won't it do away with the HotFix?

Thanks!

Liz

Have you already applied SP3 for Office 2003 and not yet applied the HotFix?
http://support.microsoft.com/kb/945674

I converted a database from Access 2000 to 2003. I'm now having two issues
(that I've found so far):

On several combo boxes on forms, I have similar row source as follows:

SELECT [MeasureQ].[MeasNo], [MeasureQ].[Closed], Right([MoYr],2) AS Expr1,
[MeasureQ].[MoYr], [MeasureQ].[MeterNo], [MeasureQ].[MeterName] FROM MeasureQ
WHERE ((([MeasureQ].[MeterNo])>0)) ORDER BY [MeasureQ].[Closed] DESC ,
Right([MoYr],2) DESC , [MeasureQ].[MoYr] DESC , [MeasureQ].[MeterNo];

One problem I'm having is that "MeterName" is not showing in the combo list.
The other problem is the field "Closed" should show yes or no, but is
showing -1.

Any ideas?

Thank you in advance for any assistance!

Liz