Access 2007 Won't Open My 2003 Report

  • Thread starter Thread starter Stacey Crowhurst
  • Start date Start date
S

Stacey Crowhurst

Hi. We just upgraded at work to Office 2007. My database was created in
Access 2003. For one of my reports, when I try to open it, it keeps asking
for the parameter value for tblChangeOrders.coAutoNumberID. The change order
autonumber is not a field in the report, it is not even in the query that
makes the report. I did the document analyzer for the report and searched
for the text "coAutoNumberID" and nothing came up. Any suggestions?

Thanks in advance :)
Stacey

Here is the SQL for the query the report is based on:
SELECT tblProjects.prjProjectManager,
qryContractChangeOrderTransactions.conCCPID, tblProjects.prjParentProjectID,
tblProjects.prjProjectName, qryContractChangeOrderTransactions.conPONo,
qryContractChangeOrderTransactions.conContractID,
qryContractChangeOrderTransactions.vdVendorName,
qryContractChangeOrderTransactions.cdCostCodeID,
qryContractChangeOrderTransactions.cocCostCodeDesc,
qryContractChangeOrderTransactions.ContractAmount,
qryContractChangeOrderTransactions.ChangeOrders,
[ContractAmount]+[ChangeOrders] AS RevisedAmount,
qryContractChangeOrderTransactions.PaidToDate, [RevisedAmount]-[PaidToDate]
AS AmountRemaining, qryContractChangeOrderTransactions.conComments,
Int([conClosed]) AS Closed, qryContractChangeOrderTransactions.PhaseCodeID,
tblProjects.prjStatusID
FROM (qryContractChangeOrderTransactions INNER JOIN tblProjects ON
qryContractChangeOrderTransactions.conCCPID = tblProjects.prjCCPID) INNER
JOIN qryProjectMaxSequence ON (tblProjects.prjSequence =
qryProjectMaxSequence.MaxOfprjSequence) AND (tblProjects.prjCCPID =
qryProjectMaxSequence.prjCCPID);
 
Stacey,

Have you checked... qryContractChangeOrderTransactions ...to see if the
field is in that query? I would also check the Query Order_By, in the
Properties WIndow, and make sure it didn't somehow end up in there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Thanks Gina. I tried your suggestions but coAutoNumberID was not to be
found. Any other places I could look?

Gina Whipp said:
Stacey,

Have you checked... qryContractChangeOrderTransactions ...to see if the
field is in that query? I would also check the Query Order_By, in the
Properties WIndow, and make sure it didn't somehow end up in there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Stacey Crowhurst said:
Hi. We just upgraded at work to Office 2007. My database was created in
Access 2003. For one of my reports, when I try to open it, it keeps
asking
for the parameter value for tblChangeOrders.coAutoNumberID. The change
order
autonumber is not a field in the report, it is not even in the query that
makes the report. I did the document analyzer for the report and searched
for the text "coAutoNumberID" and nothing came up. Any suggestions?

Thanks in advance :)
Stacey

Here is the SQL for the query the report is based on:
SELECT tblProjects.prjProjectManager,
qryContractChangeOrderTransactions.conCCPID,
tblProjects.prjParentProjectID,
tblProjects.prjProjectName, qryContractChangeOrderTransactions.conPONo,
qryContractChangeOrderTransactions.conContractID,
qryContractChangeOrderTransactions.vdVendorName,
qryContractChangeOrderTransactions.cdCostCodeID,
qryContractChangeOrderTransactions.cocCostCodeDesc,
qryContractChangeOrderTransactions.ContractAmount,
qryContractChangeOrderTransactions.ChangeOrders,
[ContractAmount]+[ChangeOrders] AS RevisedAmount,
qryContractChangeOrderTransactions.PaidToDate,
[RevisedAmount]-[PaidToDate]
AS AmountRemaining, qryContractChangeOrderTransactions.conComments,
Int([conClosed]) AS Closed,
qryContractChangeOrderTransactions.PhaseCodeID,
tblProjects.prjStatusID
FROM (qryContractChangeOrderTransactions INNER JOIN tblProjects ON
qryContractChangeOrderTransactions.conCCPID = tblProjects.prjCCPID) INNER
JOIN qryProjectMaxSequence ON (tblProjects.prjSequence =
qryProjectMaxSequence.MaxOfprjSequence) AND (tblProjects.prjCCPID =
qryProjectMaxSequence.prjCCPID);
Click to expand...


.
Click to expand...
 
Stacey,

Did you check the query properties and look at the Order_By and see if it's
there?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Stacey Crowhurst said:
Thanks Gina. I tried your suggestions but coAutoNumberID was not to be
found. Any other places I could look?

Gina Whipp said:
Stacey,

Have you checked... qryContractChangeOrderTransactions ...to see if the
field is in that query? I would also check the Query Order_By, in the
Properties WIndow, and make sure it didn't somehow end up in there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Stacey Crowhurst said:
Hi. We just upgraded at work to Office 2007. My database was created
in
Access 2003. For one of my reports, when I try to open it, it keeps
asking
for the parameter value for tblChangeOrders.coAutoNumberID. The change
order
autonumber is not a field in the report, it is not even in the query
that
makes the report. I did the document analyzer for the report and
searched
for the text "coAutoNumberID" and nothing came up. Any suggestions?

Thanks in advance :)
Stacey

Here is the SQL for the query the report is based on:
SELECT tblProjects.prjProjectManager,
qryContractChangeOrderTransactions.conCCPID,
tblProjects.prjParentProjectID,
tblProjects.prjProjectName, qryContractChangeOrderTransactions.conPONo,
qryContractChangeOrderTransactions.conContractID,
qryContractChangeOrderTransactions.vdVendorName,
qryContractChangeOrderTransactions.cdCostCodeID,
qryContractChangeOrderTransactions.cocCostCodeDesc,
qryContractChangeOrderTransactions.ContractAmount,
qryContractChangeOrderTransactions.ChangeOrders,
[ContractAmount]+[ChangeOrders] AS RevisedAmount,
qryContractChangeOrderTransactions.PaidToDate,
[RevisedAmount]-[PaidToDate]
AS AmountRemaining, qryContractChangeOrderTransactions.conComments,
Int([conClosed]) AS Closed,
qryContractChangeOrderTransactions.PhaseCodeID,
tblProjects.prjStatusID
FROM (qryContractChangeOrderTransactions INNER JOIN tblProjects ON
qryContractChangeOrderTransactions.conCCPID = tblProjects.prjCCPID)
INNER
JOIN qryProjectMaxSequence ON (tblProjects.prjSequence =
qryProjectMaxSequence.MaxOfprjSequence) AND (tblProjects.prjCCPID =
qryProjectMaxSequence.prjCCPID);
Click to expand...


.
Click to expand...
Click to expand...
 
I checked the query SQL and didn't find coAutoNumberID. I am assuming that
would cover the Order_By. Is there somewhere else I should be checking in
the query?
 
Stacey.

Yes there is another place. Follow these steps for both queries...

1. Open the Query in Design View
2. Click on the Properties icon (If when the window opens it says Field
Properties, click once in the section above the grid, that would where you
place the objects.)
3. Scroll down and see if you see anything on the Order By line. If there
is remove it.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Got it, thanks!!!

Gina Whipp said:
Stacey.

Yes there is another place. Follow these steps for both queries...

1. Open the Query in Design View
2. Click on the Properties icon (If when the window opens it says Field
Properties, click once in the section above the grid, that would where you
place the objects.)
3. Scroll down and see if you see anything on the Order By line. If there
is remove it.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm




.
Click to expand...
 
Back
Top