query caption field

[mikeba1]

I have a form where the user enters 12 date periods. an excel spreadsheet is produced based on the periods, is there anyway I can amend the query caption property to reflect the periods on the form.

 

[LaurieHamlin]

I'm not sure what you're asking. Do you just want the query field to have a different name?
Please also include the versions you're using.

 

[mikeba1]

I just need to be able to change the query captions based on the information on the form not the fields selected.
The query selects data based on the form which changes based on the requirements.
Version 2003

 

[SkipVought]

Select fieldName As 'Something Different'

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mikeba1]

That is not the answer.
The field names are the same when the query is run even though the selection will be different depending on the input form.
I want to change only the caption using information from the input form.
If the caption cannot be changed by vb then I cannot achieve what I want.

 

[PHV]

What is the name of the query, its SQL code and the fields you want to modify the caption.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

mikeba1,
Are you actually referring to the worksheet tab name after the query is exported to Excel? If so, I would use automation to change worksheet name.

Duane
Hook'D on Access
MS Access MVP

 

[mikeba1]

Thanks guys
It's now 7pm and i am going grey and losing the will to live.
Will continue am

 

[SkipVought]

Holy mackerel! I've been gray since 11/6/2000 19:00, an still have LOTS of will!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}