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 <--

 

[JimBurke via AccessMonster.com]

I don't think the SQL is from a String field in VBA. It sounds like
he viewed the stored query, then switched to SQL view and
copied it so that he could post it here. If you
use a form-based value in a stored query column's criteria that is
how it will appear when you view the SQL. My guess
is that the form is not open when the query is being run, so
Access cannot find the value.