I've been working with Access for many years (early days of 2.0). Since
leaving 2.0, one of my greatest frustrations with the product is the
difficulty of locating procedures within a module. Other IDE's (Eclipse for
instance) provide a list of procedures which make it easy to navigate within
a module. Does anyone have a suggestion for easing this problem, or is
there such thing as a third party product that will help?
8  1694 
At least the last 4 versions of Access have 2 drop-down boxes at the top of
the code window. Left one lists objects. Right one lists procedures.
Guess I'm missing something here.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:X1*****************@newssvr19.news.prodigy.co m... I've been working with Access for many years (early days of 2.0). Since
leaving 2.0, one of my greatest frustrations with the product is the
difficulty of locating procedures within a module. Other IDE's (Eclipse
for
instance) provide a list of procedures which make it easy to navigate
within
a module. Does anyone have a suggestion for easing this problem, or is
there such thing as a third party product that will help?
On Fri, 21 Jan 2005 06:11:03 GMT, "Randy Harris" <ra***@SpamFree.com> wrote: I've been working with Access for many years (early days of 2.0). Since
Greetings, fellow veteran.
leaving 2.0, one of my greatest frustrations with the product is the
difficulty of locating procedures within a module. Other IDE's (Eclipse for
instance) provide a list of procedures which make it easy to navigate within
a module. Does anyone have a suggestion for easing this problem, or is
there such thing as a third party product that will help?
Allen already gave the answer that came to my mind, but I'm guessing you might
already know about that, and have the same issue with it that I do. The
drop-down doesn't list all the procedures, but just the ones in a particular
group, so it's hard to see, for instance, cboName_AfterUpdate in a list.
If I'm correctly understanding your issue, my suggestion is to use the Object
Browser (F2 from the code editor). If you pick your project from the
drop-down in the upper-left, you'll see a list of just the modules in your
project, and when you select a module, you'll see a list of all the
procedures, properties, and events defined in the module.
Unfortunately, this window cannot be docked, and in form and report modules,
it also clutters the list with the myriad of standard (inherited) members of a
Form or Report object, but at least the custom members are in bold, so they're
easy to pick out as you scroll through the list.
Okay, another useful shortcut: If you are viewing code that calls a proc,
click in the procedure name and press Shift+F2.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:j1********************************@4ax.com... On Fri, 21 Jan 2005 06:11:03 GMT, "Randy Harris" <ra***@SpamFree.com>
wrote:
I've been working with Access for many years (early days of 2.0). Since
Greetings, fellow veteran.
leaving 2.0, one of my greatest frustrations with the product is the
difficulty of locating procedures within a module. Other IDE's (Eclipse
for
instance) provide a list of procedures which make it easy to navigate
within
a module. Does anyone have a suggestion for easing this problem, or is
there such thing as a third party product that will help?
Allen already gave the answer that came to my mind, but I'm guessing you
might
already know about that, and have the same issue with it that I do. The
drop-down doesn't list all the procedures, but just the ones in a
particular
group, so it's hard to see, for instance, cboName_AfterUpdate in a list.
If I'm correctly understanding your issue, my suggestion is to use the
Object
Browser (F2 from the code editor). If you pick your project from the
drop-down in the upper-left, you'll see a list of just the modules in your
project, and when you select a module, you'll see a list of all the
procedures, properties, and events defined in the module.
Unfortunately, this window cannot be docked, and in form and report
modules,
it also clutters the list with the myriad of standard (inherited) members
of a
Form or Report object, but at least the custom members are in bold, so
they're
easy to pick out as you scroll through the list.
On Fri, 21 Jan 2005 15:36:42 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote: Okay, another useful shortcut: If you are viewing code that calls a proc,
click in the procedure name and press Shift+F2.
Yes, and Ctrl+Shift+F2 to, among other things, jump back where you came from
after Shift+F2 - highly useful.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au... Okay, another useful shortcut: If you are viewing code that calls a proc,
click in the procedure name and press Shift+F2.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:j1********************************@4ax.com... On Fri, 21 Jan 2005 06:11:03 GMT, "Randy Harris" <ra***@SpamFree.com>
wrote:
I've been working with Access for many years (early days of 2.0). Since
Greetings, fellow veteran.
leaving 2.0, one of my greatest frustrations with the product is the
difficulty of locating procedures within a module. Other IDE's (Eclipse
for
instance) provide a list of procedures which make it easy to navigate
within
a module. Does anyone have a suggestion for easing this problem, or is
there such thing as a third party product that will help?
Allen already gave the answer that came to my mind, but I'm guessing you
might
already know about that, and have the same issue with it that I do. The
drop-down doesn't list all the procedures, but just the ones in a
particular
group, so it's hard to see, for instance, cboName_AfterUpdate in a list.
If I'm correctly understanding your issue, my suggestion is to use the
Object
Browser (F2 from the code editor). If you pick your project from the
drop-down in the upper-left, you'll see a list of just the modules in
your project, and when you select a module, you'll see a list of all the
procedures, properties, and events defined in the module.
Unfortunately, this window cannot be docked, and in form and report
modules,
it also clutters the list with the myriad of standard (inherited)
members of a
Form or Report object, but at least the custom members are in bold, so
they're
easy to pick out as you scroll through the list.
I guess that sums up my perception of the shortcomings pretty well. Allen
mentioned the Shift-F2, I do use that frequently. The drop down lists at
the top never seem to have the procedure that I need to locate, so I rarely
use them. Since Access 2.0, I've found the Schema Browser absolutely
useless. To begin with, it is extremely clumsy to use, and as you've noted,
in form modules it is so cluttered that it's nearly impossible to find
anything. To locate procedures I generally search manually (control up/down
arrows work well). In very large modules I often put little notes with my
initials, at the top of commonly accessed procedures, that I can search on.
I would gladly pay well for a small, dockable window that compactly listed
procedures.
Several years ago I started working on a program that would go through each
module, identify each procedure by name and add the list of names at the top
of the module as comments. One of these days I might finish that project.
Randy Harris wrote: "Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
Okay, another useful shortcut: If you are viewing code that calls a proc,
click in the procedure name and press Shift+F2.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:j1********************************@4ax.com. ..
On Fri, 21 Jan 2005 06:11:03 GMT, "Randy Harris" <ra***@SpamFree.com>
wrote:
I've been working with Access for many years (early days of 2.0). Since
Greetings, fellow veteran.
leaving 2.0, one of my greatest frustrations with the product is the
difficulty of locating procedures within a module. Other IDE's (Eclipse
for
instance) provide a list of procedures which make it easy to navigate
within
a module. Does anyone have a suggestion for easing this problem, or is
there such thing as a third party product that will help?
Allen already gave the answer that came to my mind, but I'm guessing you
might
already know about that, and have the same issue with it that I do. The
drop-down doesn't list all the procedures, but just the ones in a
particular
group, so it's hard to see, for instance, cboName_AfterUpdate in a list.
If I'm correctly understanding your issue, my suggestion is to use the
Object
Browser (F2 from the code editor). If you pick your project from the
drop-down in the upper-left, you'll see a list of just the modules in
your
project, and when you select a module, you'll see a list of all the
procedures, properties, and events defined in the module.
Unfortunately, this window cannot be docked, and in form and report
modules,
it also clutters the list with the myriad of standard (inherited)
members
of a
Form or Report object, but at least the custom members are in bold, so
they're
easy to pick out as you scroll through the list.
I guess that sums up my perception of the shortcomings pretty well. Allen
mentioned the Shift-F2, I do use that frequently. The drop down lists at
the top never seem to have the procedure that I need to locate, so I rarely
use them. Since Access 2.0, I've found the Schema Browser absolutely
useless. To begin with, it is extremely clumsy to use, and as you've noted,
in form modules it is so cluttered that it's nearly impossible to find
anything. To locate procedures I generally search manually (control up/down
arrows work well). In very large modules I often put little notes with my
initials, at the top of commonly accessed procedures, that I can search on.
I would gladly pay well for a small, dockable window that compactly listed
procedures.
Several years ago I started working on a program that would go through each
module, identify each procedure by name and add the list of names at the top
of the module as comments. One of these days I might finish that project.
You can also do a Ctrl+F to find the function. If you know it's a
function then search for "N FunctionName". If its a Sub, check for "B
SubName" and do a global search.
> I guess that sums up my perception of the shortcomings pretty well. Allen
mentioned the Shift-F2, I do use that frequently. The drop down lists at
the top never seem to have the procedure that I need to locate, so I
rarely use them. Since Access 2.0, I've found the Schema Browser absolutely
I said Schema Browser, I meant, of course, Object Browser. (too much Oracle
work lately)
useless. To begin with, it is extremely clumsy to use, and as you've
noted, in form modules it is so cluttered that it's nearly impossible to find
anything. To locate procedures I generally search manually (control
up/down arrows work well). In very large modules I often put little notes with my
initials, at the top of commonly accessed procedures, that I can search
on. I would gladly pay well for a small, dockable window that compactly listed
procedures.
Several years ago I started working on a program that would go through
each module, identify each procedure by name and add the list of names at the
top of the module as comments. One of these days I might finish that project.
"Randy Harris" <ra***@SpamFree.com> wrote in
news:4p******************@newssvr17.news.prodigy.c om: In very large modules I often put little notes with my
initials, at the top of commonly accessed procedures, that I can
search on. I would gladly pay well for a small, dockable window
that compactly listed procedures.
If your code is attached to controls or the form itself, is it not
easier to go to the form design window, select the object and get to
the code from there?
If it's *not* attached to anything (i.e., free-standing
sub/function), then just hit Ctrl-End and then the right-hand
dropdown will list the free-standing subroutines.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: David Isaac |
last post by:
Default parameter values are evaluated once when the function definition is
executed.
Where are they stored? (A guess: in a dictionary local to the function.)
Where is this documented?
As a...
|
by: urocrane |
last post by:
i'm using visual c++ and it doesn't seem to have graphics header file.
where can i get it?
i've always had a wierd thought about prototypes, do you really need
them? in my case, i think it looks...
|
by: Christian |
last post by:
HI,
I have a function that is used to constrain a query:
Select COl1, Col2
From MyTable
WHERE col1 = ...
AND col2 = ...
And MyFunction(col1) = ...
My problem is that MyFunction is executed...
|
by: Jonas Rundberg |
last post by:
Hi
I just started with c++ and I'm a little bit confused where stuff
go...
Assume we have a class:
class test {
private:
int arr;
};
|
by: heruti |
last post by:
Hi all...
I've been stumped by this for days. Bit of ASP code: (IIS)
Set LocalConn = CreateObject("ADODB.Connection")
LocalConn.CursorLocation = adUseClient
LocalConn.CommandTimeout = 0...
|
by: Dixie |
last post by:
I have a problem using Dev Ashish's excellent module to concatenate the
results of a field from several records into one record.
I am using the code to concatenate certain awards onto a...
|
by: Peter Alberer |
last post by:
Hi there,
i have a problem with a query that uses the result of a plsql function
In the where clause:
SELECT
assignments.assignment_id,
assignments.package_id AS package_id,...
|
by: John |
last post by:
Hi
I have a form with tow fields for dates in dd/mm/yyyy format. I am trying to
use the fields in a query's where clause as below;
"SELECT * " & _
"FROM Orders " & _
" WHERE Orders.)>= #" &...
|
by: amit.man |
last post by:
Hi, i have newbie qestion,
when i write
#include <somthing.h>
the precompiler subtitue that line with the lines from "somthing.h"
header file.
when, where and how the compiler insert the...
|
by: Steven D'Aprano |
last post by:
I defined a nested function:
def foo():
def bar():
return "bar"
return "foo " + bar()
which works. Knowing how Python loves namespaces, I thought I could do
this:
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
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: 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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
