By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,401 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,401 IT Pros & Developers. It's quick & easy.

Creating a simple standalone query

P: n/a
I'm a database marketing manager for a small non-profit. I created a
query that prompts you for a company name and then pulls a list of all
of our contacts in the database in that company. Our sales folks are
always asking for company contact lists and I just plug it in to this
query and send them the list in excel.

I want to give them the capability of using this query themselves
without going through me. But I want them to do this without having to
open up Access, shuffle through all the tables and queries that make up
this query to find this query and then running it. Ideally I would
love to have a shortcut in one of our network drives that they click on
and it automatically prompts them for the company name.

Do you know the best way to do this? Any advice appreciated.

Thanks!

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the query prompts for a parameter, Access has to open to display the
prompt. You could set up a VBA macro in Excel that uses ADO or DAO to
get the data from the Access DB. It would have an Excel prompt to get
the parameter. That parameter would be used in the macro to get the
data from the db & the results would be inserted into wherever the user
has placed a cursor; or a specified cell.

Read the Excel VBA Help to figure out how to do this. If you don't know
VBA & DAO/ADO hire someone who does.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQl7RSIechKqOuFEgEQJAogCfTqCTKUSgJ7guO+H05ztb2p 8vZuoAoJ6T
JwIQMAnF5y2a7LmTzz6Dk5gn
=3gE3
-----END PGP SIGNATURE-----
li*****@msn.com wrote:
I'm a database marketing manager for a small non-profit. I created a
query that prompts you for a company name and then pulls a list of all
of our contacts in the database in that company. Our sales folks are
always asking for company contact lists and I just plug it in to this
query and send them the list in excel.

I want to give them the capability of using this query themselves
without going through me. But I want them to do this without having to
open up Access, shuffle through all the tables and queries that make up
this query to find this query and then running it. Ideally I would
love to have a shortcut in one of our network drives that they click on
and it automatically prompts them for the company name.

Nov 13 '05 #2

P: n/a
Yes, the query prompts for a parameter. I would like to stay away from
VBA if possible - we don't have a programmer on staff and we don't have
the money to hire someone. I'm really looking at a simple solution.
If there isn't a simple solution, I'll just create a simple database
for them to use.

Nov 13 '05 #3

P: n/a
On 14 Apr 2005 13:10:29 -0700, li*****@msn.com wrote:
I'm a database marketing manager for a small non-profit. I created a
query that prompts you for a company name and then pulls a list of all
of our contacts in the database in that company. Our sales folks are
always asking for company contact lists and I just plug it in to this
query and send them the list in excel.

I want to give them the capability of using this query themselves
without going through me. But I want them to do this without having to
open up Access, shuffle through all the tables and queries that make up
this query to find this query and then running it. Ideally I would
love to have a shortcut in one of our network drives that they click on
and it automatically prompts them for the company name.

Do you know the best way to do this? Any advice appreciated.

Thanks!

You could use a small Visual Basic program to do this. If you use VB,
I can explain the details to you if you are not familiar.

The database will not open and you can keep it "safe" from the users.

Greg
Nov 13 '05 #4

P: n/a
li*****@msn.com wrote in
news:11**********************@g14g2000cwa.googlegr oups.com:
Yes, the query prompts for a parameter. I would like to stay
away from VBA if possible - we don't have a programmer on
staff and we don't have the money to hire someone. I'm really
looking at a simple solution. If there isn't a simple
solution, I'll just create a simple database for them to use.

All you have to do is create a form use the form design wizard to
put 2 buttons on the form, the first one runs the query. the second
quits the application. The wizards make this easy. Once the form
works to your satisfaction, seletc tools->startup from the menubar.
Fill in the form name in the box.

Now create a shortcut and send it to the users. have them copy it
to their desktop.

All done. Good luck.
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #5

P: n/a
Any reason why you can't let them query your database directly from
Excel for themselves?
in Excel:
Under the Data menu,
Import External Data,
New Database Query...

from there the wizard pretty much walks you through the whole thing,
and they can dump all the data into Excel for themselves.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.