A97 allows separate procedures in a form module to share common
label names. Access 2.0 would puke when that happened. For instance,
if I had 2 procedures in an Access 2.0 form module with labels both
named ERR_MyButton_Cl ick, compiling loaded modules produced
an error. I'm glad to see this is not the case in Access 97. Access
2.0 went so far as to disallow me from using the same line numbers
in two different procedures of a form module. If I numbered one of
them with 100, 110, 120 and 130. I would have to number the next
procedure's lines with 101, 111, 121, 131 or something else that
didn't conflict. That was a pain.
Anyone know of a setting in Access 2.0 that overcomes the problem?
2  1442 
MLH wrote: A97 allows separate procedures in a form module to share common
label names. Access 2.0 would puke when that happened. For instance,
if I had 2 procedures in an Access 2.0 form module with labels both
named ERR_MyButton_Cl ick, compiling loaded modules produced
an error. I'm glad to see this is not the case in Access 97. Access
2.0 went so far as to disallow me from using the same line numbers
in two different procedures of a form module. If I numbered one of
them with 100, 110, 120 and 130. I would have to number the next
procedure's lines with 101, 111, 121, 131 or something else that
didn't conflict. That was a pain.
Anyone know of a setting in Access 2.0 that overcomes the problem?
Stop using line numbers?
Access 97 overcomes these problems because the VBA for forms is stored
in a Class module, which has its own namespace. Access 2.0 doesn't
really do Class modules.
If you want to call a common VBA function from other forms, then factor
the function out into a separate module, and just have the event
handlers call it. You will want to have a good understanding of how the
"Me" reference shortcut works...
I was just curious really. It was a problem only with line numbers for
me in access 2.0.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxx
Stop using line numbers?
Access 97 overcomes these problems because the VBA for forms is stored
in a Class module, which has its own namespace. Access 2.0 doesn't
really do Class modules.
If you want to call a common VBA function from other forms, then factor
the function out into a separate module, and just have the event
handlers call it. You will want to have a good understanding of how the
"Me" reference shortcut works...
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: WSeeger |
last post by:
When creating a new class, is it encouraged to always include error
handling routines within your LET and GET procedures? It's seems that
most text books never seem to include much about error handling within
classes. Just hoping to hear some programmer's thoughts on error
handling.
|
by: Jarrod Morrison |
last post by:
Hi All
I was wondering if there is a way to call a stored procedure from inside
another stored procedure. So for example my first procedure will call a
second stored procedure which when executed will return one record and i
want to use this data in the calling stored procedure. Is this possible ?
Thanks in advance
|
by: serge |
last post by:
How can i delete all user stored procedures and all table triggers very fast
in
a single database?
Thank you
|
by: Brian |
last post by:
I'm wondering what the group thinks is the best way to display the
<label> element. The default rendering in Moz and MSIE/Win (probably
others, too) only changes the mouse cursor (that's a strange term) from
text-select to default (an arrow). That, to me, is too subtle, and is a
bit like "mystery meat" navigation. The user must hover the mouse before
they know there was something special.
Simon Willison suggested changing the cursor to...
|
by: Confessor |
last post by:
Having just figured out the function of the *sender* argument in control
events, I now have 85 labelX_Click procedures that perform the exact same
function: Call ColorChange(sender). That's it.
I could make one procedure to handle them all, of the form:
Sub GUITileProc() Handles Label1.Click, Label2.Click... all
the way to Label85.Click.
But that would be really messy, and if there's one thing I hate, it's messy
| | |
by: Chris Smith |
last post by:
Hola, pythonisas:
The documentation for the logging module is good, but a bit obscure.
In particular, there seems to be a lot of action at a distance.
The fact that getLogger() can actually be a call to Logger.__init__(),
which is mentioned in para 6.29.1, also bears stressing on 6.29. I
grasp _why_ you'd implement it that way, but I may not be the only
coder who feels queasy with the word 'get' being used both to fetch
an instance and...
|
by: Galen Somerville |
last post by:
In two different Form modules
FFTcls.Currfrm = Me
In FFTcls class module
Dim CurrForm As System.Windows.Forms.Form
Public WriteOnly Property Currfrm() As System.Windows.Forms.Form
Set(ByVal Value As System.Windows.Forms.Form)
CurrForm = Value
|
by: Neil |
last post by:
I am using Access 2003, and have an ongoing problem of every once in a while
losing an event procedure
for a form or control. The procedure's still in the code module, but the
form or control's property sheet does not show "". I have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least, how to
tell if there are any of these "detached" event procedures? It's extremely...
|
by: Jean-Paul Calderone |
last post by:
On Mon, 16 Jun 2008 08:39:52 +1000, Ben Finney <bignose+hates-spam@benfinney.id.auwrote:
Maybe. I'm no expert on Debian packaging. However,
exarkun@boson:~$ ls -l /usr/lib/python2.{4,5}/site-packages/sqlite/main.py
lrwxrwxrwx 1 root root 63 2007-12-27 15:29 /usr/lib/python2.4/site-packages/sqlite/main.py -/usr/share/pycentral/python-sqlite/site-packages/sqlite/main.py
lrwxrwxrwx 1 root root 63 2007-12-27 15:29...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
