Posted to microsoft.public.excel.programming

kmoyer

external usenet poster

Posts: 2

Microsoft query won't allow parameters

I have a sql union query that works just fine but I want to let the user
choose a date in an excel field. When I input my sql code into microsoft
query I get the error:

'Parameters are not allowed in queries that can't be graphically displayed.'

I am looking for a solution to the above error.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Query - 2 Parameters	cottage6	Excel Discussion (Misc queries)	2	July 17th 08 09:16 PM
Query Parameters	Texas_Toast	Excel Discussion (Misc queries)	0	January 11th 06 03:14 PM
Microsoft Query rejects "nz" function in Access Query	Vaughan	Excel Discussion (Misc queries)	0	May 4th 05 05:20 PM
Web Query Parameters	raboo2u	Excel Programming	4	January 11th 04 08:54 PM
Query Parameters	Jeff	Excel Programming	1	November 18th 03 05:47 PM

All times are GMT +1. The time now is 09:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us