Problems after converting from 2000 to 2003

  • Thread starter Thread starter Liz C
  • Start date Start date
L

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
 
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


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

Liz said:
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
Click to expand...

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
Click to expand...
 
Back
Top