Changing the Caption Name of a Query

[veraloopy]

Hi

Does anyone know how to change the Caption/Description Name of a query in Access 2007 so that when users run the query in view mode it shows something meaning full such as "Demo Reports Not Input By User" instead of the query name "qrySalesTabDemoReportNotInputByUser"

I've tried changing the Description and Caption in the properties box of the query itself but it doesnt seem to make any difference

I've attached a snapshot of where the name is just in case I havent explained very well

Many thanks in advance

 

[vbaInet]

veraloopy,

1. Create a form based on your query
2. Set the Default View property to Datasheet
3. Set the Caption property of the form to "Demo Reports Not Input By User"
4. Save your form and run it.

That will look just like your query but with the caption you've always wanted

 

[veraloopy]

Thanks for the reply,
I have done this already on some queries but it's too long winded and increases the size of the database in general to have queries and forms for the same thing...

 

[vbaInet]

The increase in size is very negligible. You don't have to base your report on a query, you can also base it on the SQL statement from the query.

There's no other way - Forms or Reports.

 

[Brianwarnock]

IMHO users should not see Tables or Queries , only Forms or Reports which can be formatted to provide exactly what they require.

Brian