Order of Data export to Excel

[Stefan Hoffmann]

hi Imran,

Thanks for your reply. There are no typos used in my query, as its just
using one parameter value that I'v mentioned in the previous post. Previously
I's using a query which'd three parameters, so the error message was
specifying about 3 missing values, now its mentioning about just one missing
value, in this query. I'd much appreciate your valuable guidance about how to
mention the value of the parameter in the module, posted by you.

Open your query in the design view. Switch it to the SQL view. Does it
start with a line beginning with PARAMETERS?


--> stefan <--

 

[Imran Ghani]

Hi Stefan
The query does not start with a line beginning with PARAMETERS, when it is
changed from the design to sql view. Further to that following is the code of
the query:
SELECT invrgstr.[Invoice Ref] AS [Invoice No], invrgstr.datiss AS [Date
Issued], invrgstr.solref AS [Your Reference], invrgstr.erref AS [Our
Reference], invrgstr.cname AS [Client Name], invrgstr.invamt AS [Invoice
Amount], invrgstr.curdat AS [Current Date], invrgstr.daysoutstanding AS [Days
O/s], invrgstr.thrMonths AS 3Months, invrgstr.sixMonths AS 6Months,
invrgstr.ninMonths AS 9Months, invrgstr.twlvMonths AS 12Months,
invrgstr.yrplusMonths AS [12 Plus Months], invrgstr.solnam, invrgstr.invstatus
FROM invrgstr
WHERE (((invrgstr.solnam)=forms!frmsolinvrgstr!cbosolnam) And
((invrgstr.invstatus)="full o/s"))
ORDER BY invrgstr.[Invoice Ref], invrgstr.solnam;
Regards,
Imran.

 

[Stefan Hoffmann]

hi Imran,

The query does not start with a line beginning with PARAMETERS, when it is
changed from the design to sql view.

Okay, then I've got no clue at the moment. Can you send me a reduced
sample .mdb? Then I can take a closer look at it...


mfG
--> stefan <--

 

[egerds]

WHERE (((invrgstr.solnam)=forms!frmsolinvrgstr!cbosolnam) And
((invrgstr.invstatus)="full o/s"))

The where clause contains form based data.
The form based criteria is causing the too few parameters

Back in March i posted code to dump query / sql with param's to a new
instance of excel

http://groups.google.com/group/micr...837d6/1cd21e726f54f493?hl=en#1cd21e726f54f493

http://support.microsoft.com/kb/181782