|
 |
access thread: Where queries are used?
Message #1 by "Rory" <mcneillr@c...> on Wed, 12 Dec 2001 01:21:20
|
|
I'm getting a proliferation of queries, and would like to know where
they're used (especially if they're not!). Some are used in recordsets,
some in SQL (docmd.runsql ...), some as sources for combo/list boxes, some
as sources for forms, etc. Anybody have some ideas that could help me
here?
Actually, general help in cross referencing would be appreciated.
Rory
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Thu, 13 Dec 2001 10:27:36 -0800
|
|
FMS sells a product that's supposed to do this sort of thing--I hear good
things about it...
http://www.fmsinc.com/
HTH,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
From: Rory [mailto:mcneillr@c...]
Sent: Tuesday, December 11, 2001 5:21 PM
To: Access
Subject: [access] Where queries are used?
I'm getting a proliferation of queries, and would like to know where
they're used (especially if they're not!). Some are used in recordsets,
some in SQL (docmd.runsql ...), some as sources for combo/list boxes, some
as sources for forms, etc. Anybody have some ideas that could help me
here?
Actually, general help in cross referencing would be appreciated.
Rory
Message #3 by joe.dunn@c... on Thu, 13 Dec 2001 18:45:37 +0000
|
|
I use the Total Access products and the Total Access Analyzer is superb for
your requirements because it builds a database about your database (i.e.
meta-data). There are heaps of reports and forms in the database but if you
think of any other angle you wish to follow, you can write the report for
yourself (after all the analysis database is an Access database itself). It
is fairly unlikely that you will need to because the package is very
comprehensive.
I am only a satisfied user and I don't want this to sound like an advert
for FMS. If you want a cheapo solution you can build a couple of tables to
hold data extracted from your Access system tables but you would then need
to do your own reporting and searching.
I have done the cheapo solution with Access v2 and I will bring it up to
date for Access 2000 (even write it in ADO if I can) but not until the New
Year - Xmas is closing in fast! Let me know if you want to pursue that path
- it's not a big job and I will find a use for it myself for some users who
need a quick and cheap tool.
But....do try FMS....they already have a great product. They are not the
only people out there - look around the Web.
Joe Dunn
"Pardee, Roy
E" To: "Access" <access@p...>
<roy.e.pardee cc:
@lmco.com> Subject: [access] RE: Where queries are
used?
13/12/2001
18:27
Please
respond to
"Access"
FMS sells a product that's supposed to do this sort of thing--I hear good
things about it...
http://www.fmsinc.com/
HTH,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
From: Rory [mailto:mcneillr@c...]
Sent: Tuesday, December 11, 2001 5:21 PM
To: Access
Subject: [access] Where queries are used?
I'm getting a proliferation of queries, and would like to know where
they're used (especially if they're not!). Some are used in recordsets,
some in SQL (docmd.runsql ...), some as sources for combo/list boxes, some
as sources for forms, etc. Anybody have some ideas that could help me
here?
Actually, general help in cross referencing would be appreciated.
Rory
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Personal Investment Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 (also regulated by IMRO) - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
Message #4 by "Rory" <mcneillr@c...> on Sun, 16 Dec 2001 22:39:56
|
|
Thanks, Roy & Joe. FMS certainly looks as if it'll fit the bill, I'll see
if I can find the money. Joe, I could update V2 to 2000 myself (ADO next
year?) and send it back to you if you're interested. How many $$ are we
talking about?
Rory
mcneillr@c...
Message #5 by joe.dunn@c... on Tue, 18 Dec 2001 14:39:32 +0000
|
|
Call it a Christmas Gift!
I will look at this tomorrow and tidy it up then sent it to you.
"Rory"
<mcneillr@c... To: "Access" <access@p...>
et.com.au> cc:
Subject: [access] Where queries are used?
16/12/2001
22:39
Please
respond to
"Access"
Thanks, Roy & Joe. FMS certainly looks as if it'll fit the bill, I'll see
if I can find the money. Joe, I could update V2 to 2000 myself (ADO next
year?) and send it back to you if you're interested. How many $$ are we
talking about?
Rory
mcneillr@c...
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Personal Investment Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 (also regulated by IMRO) - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
|
|
|
View Cart
