Creating a simple standalone query

[lis0122@msn.com]

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!

[MGFoster]

Re: Creating a simple standalone query

-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQl7RSIechKq OuFEgEQJAogCfTq CTKUSgJ7guO+H05 ztb2p8vZuoAoJ6T
JwIQMAnF5y2a7Lm Tzz6Dk5gn
=3gE3
-----END PGP SIGNATURE-----


lis0122@msn.com wrote:[color=blue]
> 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.[/color]

[lis0122@msn.com]

Re: Creating a simple standalone query

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.

[Greg Teets]

Re: Creating a simple standalone query

On 14 Apr 2005 13:10:29 -0700, lis0122@msn.com wrote:
[color=blue]
>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![/color]


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

[Bob Quintal]

Re: Creating a simple standalone query

lis0122@msn.com wrote in
news:1113510949 .217001.306720@ g14g2000cwa.goo glegroups.com:
[color=blue]
> 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.
>[/color]
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.

[pietlinden@hotmail.com]

Re: Creating a simple standalone query

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.