Hi.
i have hundreds of queries and forms. I know there are a lot of forms
and also queries that are not in use and could be deleted, but problem
is how i know which are not in use? it is very hard job to find it out
one by one, so is there any better ways?
hannu 9 1395 ha***************@niiralankulma.fi (Hannu) wrote: i have hundreds of queries and forms. I know there are a lot of forms and also queries that are not in use and could be deleted, but problem is how i know which are not in use? it is very hard job to find it out one by one, so is there any better ways?
You could have some code in a form's On Open event that writes the form's
name to a table so as to detect which forms *are* used over time. Not sure
about queries ...
Regards,
Keith.
I have a Mickey mouse database which basically lists all the objects in a
database, where they are used etc.
So for example, if I have a subform "SubFrm1" it will tell me it is used in
main form "Form1", the recordsource is Query1 and that it has a combobox in
it whose source is an SQL " SQL1000".
It does not however examine the code to see if there are any tables or
queries opened there (MyDb.OpenRecordset)
This combined with Keith's suggestion may help.
"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message
news:Xn************************@10.15.188.42... ha***************@niiralankulma.fi (Hannu) wrote:
i have hundreds of queries and forms. I know there are a lot of forms and also queries that are not in use and could be deleted, but problem is how i know which are not in use? it is very hard job to find it out one by one, so is there any better ways?
You could have some code in a form's On Open event that writes the form's name to a table so as to detect which forms *are* used over time. Not sure about queries ...
Regards, Keith.
"Phil Stanton" <di********@stantonfamily.co.uk> wrote: I have a Mickey mouse database which basically lists all the objects in a database, where they are used etc.
Are you going to give us a copy ? ;-)
Will send it directly to you.
Make sure you run it on a COPY of your database. I have never known any
problems, but its frightening to watch
Phil
"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message
news:Xn***********************@10.15.188.42... "Phil Stanton" <di********@stantonfamily.co.uk> wrote:
I have a Mickey mouse database which basically lists all the objects in a database, where they are used etc.
Are you going to give us a copy ? ;-)
On Wed, 29 Sep 2004 13:25:03 +0100, "Phil Stanton"
<di********@stantonfamily.co.uk> wrote: Will send it directly to you.
Why not just share the code with all of us? It sounds like some
interesting code.
Make sure you run it on a COPY of your database. I have never known any problems, but its frightening to watch
Phil
"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message news:Xn***********************@10.15.188.42... "Phil Stanton" <di********@stantonfamily.co.uk> wrote:
I have a Mickey mouse database which basically lists all the objects in a database, where they are used etc.
Are you going to give us a copy ? ;-)
Sorry, Can't do that.
It's a database with tables, queries, forms and code. More than happy to let
anyone have a copy (within reason) but I need to know email addresses to
send it.
Suspect yours, Keith is not quite genuine
Phil
"VRWC" <???@???.???> wrote in message
news:oh********************************@4ax.com... On Wed, 29 Sep 2004 13:25:03 +0100, "Phil Stanton" <di********@stantonfamily.co.uk> wrote:
Will send it directly to you.
Why not just share the code with all of us? It sounds like some interesting code. Make sure you run it on a COPY of your database. I have never known any problems, but its frightening to watch
Phil
"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message news:Xn***********************@10.15.188.42... "Phil Stanton" <di********@stantonfamily.co.uk> wrote:
I have a Mickey mouse database which basically lists all the objects in a database, where they are used etc.
Are you going to give us a copy ? ;-)
Phil Stanton wrote: Sorry, Can't do that. It's a database with tables, queries, forms and code. More than happy to let anyone have a copy (within reason) but I need to know email addresses to send it.
Suspect yours, Keith is not quite genuine
And just what is suspect about AwayWithYerCrap.com? :-)
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<41***********************@mercury.nildram.ne t>... Sorry, Can't do that. It's a database with tables, queries, forms and code. More than happy to let anyone have a copy (within reason) but I need to know email addresses to send it.
Suspect yours, Keith is not quite genuine
Phil
"VRWC" <???@???.???> wrote in message news:oh********************************@4ax.com... On Wed, 29 Sep 2004 13:25:03 +0100, "Phil Stanton" <di********@stantonfamily.co.uk> wrote:
Will send it directly to you.
Why not just share the code with all of us? It sounds like some
Can i have the copy, because i asked first!?!? :)
t hannu interesting code. Make sure you run it on a COPY of your database. I have never known any problems, but its frightening to watch
Phil
"Keith Wilby" <ke*********@AwayWithYerCrap.com> wrote in message news:Xn***********************@10.15.188.42... "Phil Stanton" <di********@stantonfamily.co.uk> wrote:
> I have a Mickey mouse database which basically lists all the objects in > a database, where they are used etc.
Are you going to give us a copy ? ;-)
Trevor Best <nospam@localhost> wrote: Suspect yours, Keith is not quite genuine
And just what is suspect about AwayWithYerCrap.com? :-)
Ah-ha, that be my spam trap ;-p
There's a 'contact me' or two on here www.keithwilby.org.uk :o) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dennis |
last post by:
Is there some way --using, say, DOM or javascript-- to detect the
current pixel width and/or height of a relatively sized table or of
one of its columns or rows. I'm going to be writing javascript...
|
by: Noozer |
last post by:
Is it possible to detect where on a page the click occurred when the OnClick
event of the BODY tag is fired?
Thx
|
by: joebob |
last post by:
I've got two forms, Form1 and Form2. Form1 opens invisibly when the database opens. From Form1 (or from a regular module or class module accessed by Form1), is there a way to detect when Form2...
|
by: Perquiaga |
last post by:
Hi to all
I have to detect the mouse presence and disconection if occurs to give
alerts. I'm using VB .NET, if somebody can help i'll apretiate it.
|
by: JaimeM26 |
last post by:
Does anyone know how to detect and move/resize the Taskbar in VB.NET?
I am able to determine if it is on the top or bottom by comparing the
following 2 items.
...
|
by: nsimeonov |
last post by:
Hello,
Does anyone have any idea how Gmail does this? I have a web application
and people complain sometimes about some problems and most of the time
it turns out it's the browser's cache...
|
by: Johnny |
last post by:
Hi,
Is there a way to detect the entry point of all the functions in a
project? If so, can I make a function that will be called at the every
entry point? Thanks for your consideration.
...
|
by: Phil |
last post by:
I can check for MdiChildren.Length=0, but which event handler should I put
this in to detect when a child window is closed?
TIA
Phil.
|
by: Benny |
last post by:
I am wondering if anyone has a simple approach to detecting
the location of boxes and/or lines on an image. For example, if I
have an image of a form, and want to find out where all of the boxes...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |