no grid pane

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some my queries I cannot see a grid pane.
I'm using Access 2003.

It's just a simple select query such as

SELECT tblForecast.Product_ID, tblForecast.Description,
tblForecast.TerritoryID, tblForecast.Terr_Num, tblForecast.Territory,
tblForecast.ProdCateg_Code, tblForecast.ProdCateg, tblForecast.AdjY1F,
qryM_Terr.Aug, qryM_Terr.AugP, [AdjY1F]*nz([AugP]) AS FAug, ...
FROM tblForecast LEFT JOIN qryM_Terr ON (tblForecast.TerritoryID =
qryM_Terr.TerritoryID) AND (tblForecast.Product_ID = qryM_Terr.Product_ID);

How could I fix it?

Thanks
 
Thanks, Dan.
But, I cannot see any Design View option in the View menu in a database
window when the query is closed. When it's opened the selecting the design
view from the View menu or from the toolbar doesn't trigger the grid pane
appearance.

Dan Artuso said:
Hi,
Have you made sure that Design View is selected from the View menu?

--
HTH
Dan Artuso, Access MVP


Alex said:
For some my queries I cannot see a grid pane.
I'm using Access 2003.

It's just a simple select query such as

SELECT tblForecast.Product_ID, tblForecast.Description,
tblForecast.TerritoryID, tblForecast.Terr_Num, tblForecast.Territory,
tblForecast.ProdCateg_Code, tblForecast.ProdCateg, tblForecast.AdjY1F,
qryM_Terr.Aug, qryM_Terr.AugP, [AdjY1F]*nz([AugP]) AS FAug, ...
FROM tblForecast LEFT JOIN qryM_Terr ON (tblForecast.TerritoryID =
qryM_Terr.TerritoryID) AND (tblForecast.Product_ID = qryM_Terr.Product_ID);

How could I fix it?

Thanks
Click to expand...
Click to expand...
 
Hi,
Is it just this query that has the problem?
I've never heard of this problem before.
Though keep in mind that some queries cannot be
represented in the query grid, but if it's just a select query
it should work in design view.

--
HTH
Dan Artuso, Access MVP


Alex said:
Thanks, Dan.
But, I cannot see any Design View option in the View menu in a database
window when the query is closed. When it's opened the selecting the design
view from the View menu or from the toolbar doesn't trigger the grid pane
appearance.

Dan Artuso said:
Hi,
Have you made sure that Design View is selected from the View menu?

--
HTH
Dan Artuso, Access MVP


Alex said:
For some my queries I cannot see a grid pane.
I'm using Access 2003.

It's just a simple select query such as

SELECT tblForecast.Product_ID, tblForecast.Description,
tblForecast.TerritoryID, tblForecast.Terr_Num, tblForecast.Territory,
tblForecast.ProdCateg_Code, tblForecast.ProdCateg, tblForecast.AdjY1F,
qryM_Terr.Aug, qryM_Terr.AugP, [AdjY1F]*nz([AugP]) AS FAug, ...
FROM tblForecast LEFT JOIN qryM_Terr ON (tblForecast.TerritoryID =
qryM_Terr.TerritoryID) AND (tblForecast.Product_ID = qryM_Terr.Product_ID);

How could I fix it?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Thanks a lot Dan,

I think, the cause could be that I've started to use Win XP instead of Win
2000.

Dan Artuso said:
Hi,
Is it just this query that has the problem?
I've never heard of this problem before.
Though keep in mind that some queries cannot be
represented in the query grid, but if it's just a select query
it should work in design view.

--
HTH
Dan Artuso, Access MVP


Alex said:
Thanks, Dan.
But, I cannot see any Design View option in the View menu in a database
window when the query is closed. When it's opened the selecting the design
view from the View menu or from the toolbar doesn't trigger the grid pane
appearance.

Dan Artuso said:
Hi,
Have you made sure that Design View is selected from the View menu?

--
HTH
Dan Artuso, Access MVP


For some my queries I cannot see a grid pane.
I'm using Access 2003.

It's just a simple select query such as

SELECT tblForecast.Product_ID, tblForecast.Description,
tblForecast.TerritoryID, tblForecast.Terr_Num, tblForecast.Territory,
tblForecast.ProdCateg_Code, tblForecast.ProdCateg, tblForecast.AdjY1F,
qryM_Terr.Aug, qryM_Terr.AugP, [AdjY1F]*nz([AugP]) AS FAug, ...
FROM tblForecast LEFT JOIN qryM_Terr ON (tblForecast.TerritoryID =
qryM_Terr.TerritoryID) AND (tblForecast.Product_ID = qryM_Terr.Product_ID);

How could I fix it?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top