report to file

[Guest]

Hello,

When i send report to file (excel) the order of the
columns in the report change.
i want the order to be in the file exactly as in the form

is it posible to send query to file ?


thanks

 

[Joseph Meehan]

Hello,

When i send report to file (excel) the order of the
columns in the report change.
i want the order to be in the file exactly as in the form

is it posible to send query to file ?


thanks

I never sent a report to a file. Interesting. In any case yes you can
send the results of a query to Excel. [Tools, Office Links, Analyze with
Excel]

 

[Guest]

thank you !

Is there any kod or macro for this ?
--
תודה רבה

Hello,

When i send report to file (excel) the order of the
columns in the report change.
i want the order to be in the file exactly as in the form

is it posible to send query to file ?


thanks

I never sent a report to a file. Interesting. In any case yes you can
send the results of a query to Excel. [Tools, Office Links, Analyze with
Excel]

 

[Joseph Meehan]

thank you !

Is there any kod or macro for this ?\

"kod" ??? As for macro, I don't recall off hand if you can do it with
a macro, but it certainly can be automated if you like.

Hello,

When i send report to file (excel) the order of the
columns in the report change.
i want the order to be in the file exactly as in the form

is it posible to send query to file ?


thanks

I never sent a report to a file. Interesting. In any case yes
you can send the results of a query to Excel. [Tools, Office Links,
Analyze with Excel]

 

[James A. Fortune]

thank you !

Is there any kod or macro for this ?

For VBA kod check the help file for the OutputTo Method:

DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][,
autostart][, templatefile]

James A. Fortune
(e-mail address removed)

 

[Guest]

thank's !!!
--
תודה רבה

thank you !

Is there any kod or macro for this ?

For VBA kod check the help file for the OutputTo Method:

DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][,
autostart][, templatefile]

James A. Fortune
(e-mail address removed)

 

[Guest]

thank's again !!!!
--
תודה רבה

thank you !

Is there any kod or macro for this ?\

"kod" ??? As for macro, I don't recall off hand if you can do it with
a macro, but it certainly can be automated if you like.

???? ????? wrote:
Hello,

When i send report to file (excel) the order of the
columns in the report change.
i want the order to be in the file exactly as in the form

is it posible to send query to file ?


thanks

I never sent a report to a file. Interesting. In any case yes
you can send the results of a query to Excel. [Tools, Office Links,
Analyze with Excel]