You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Excel MVP Michael Alexander wanted to share this tip about running an Access parameter query from Excel. He describes the problem thusly:
An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter queries are useful when you need to ask the query different questions using different criteria each time you run it. Now we all know you can pull data from Access into Excel using MS Query. The problem is that MS Query doesn't let you pull in Parameter queries. There may be a technical reason for this, but I like to think it's just Microsoft's way of keeping things interesting. After all, technical roadblocks are the spice of life. If you've had enough spice, I'll show you a VBA workaround that will enable you to run an Access parameter query from Excel.
An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter queries are useful when you need to ask the query different questions using different criteria each time you run it.
Now we all know you can pull data from Access into Excel using MS Query. The problem is that MS Query doesn't let you pull in Parameter queries. There may be a technical reason for this, but I like to think it's just Microsoft's way of keeping things interesting. After all, technical roadblocks are the spice of life. If you've had enough spice, I'll show you a VBA workaround that will enable you to run an Access parameter query from Excel.
Click over to Michael’s blog to learn about his solution to the problem.
Comments: (1) Collapse
Thanks for the link to Michael's blog.
Comments: (loading) Collapse