I am new to Access 2000. My operating system is Windows 2000.
In the early stage of development I noticed something weird. On my form, I have
a Command Button named "btnAlbumUp ". The first time that I reference this
button in VBA code, the Visual Basic Editor capitalizes the P changing
btnAlbumUp.SetF ocus
to
btnAlbumUP.SetF ocus
I double checked that the control was defined on the form with a small p (it
was). I did a Edit/Find search for "btnAlbum" and confirmed that I hadn't
mistyped the name somewhere else in the VBA code (this is the first and only
reference to this control in VBA code). I am in the very early stages of
development and do not have much code for the problem to hide in so I doubt I
missed any references.
Everything seems to work OK so my question is not critical, but I WOULD like to
understand where and WHY the editor changes case (it does this in many places,
mostly for BASIC keywords).
Are there any situations where case is critical?
Any help in understanding this is appreciated.
Paul Core co************@ aol.com 6 10228
Try typing
Me.
in the form's code module. When you hit the period, it should give you a
list of available commands, including the controls on the form. Scroll down
this list, how does it show the capitalization? If it doesn't show the
capital P and if you use the Me. in front of the control name, does it still
capitalize the P? If not, then it is getting it from something somewhere
else in the database.
--
Wayne Morgan
"Corepaul" <co******@aol.c ombvwertz> wrote in message
news:20******** *************** ****@mb-m14.aol.com... I am new to Access 2000. My operating system is Windows 2000.
In the early stage of development I noticed something weird. On my form, I
have a Command Button named "btnAlbumUp ". The first time that I reference this button in VBA code, the Visual Basic Editor capitalizes the P changing
btnAlbumUp.SetF ocus
to
btnAlbumUP.SetF ocus
I double checked that the control was defined on the form with a small p
(it was). I did a Edit/Find search for "btnAlbum" and confirmed that I hadn't mistyped the name somewhere else in the VBA code (this is the first and
only reference to this control in VBA code). I am in the very early stages of development and do not have much code for the problem to hide in so I
doubt I missed any references.
Everything seems to work OK so my question is not critical, but I WOULD
like to understand where and WHY the editor changes case (it does this in many
places, mostly for BASIC keywords).
Are there any situations where case is critical?
Any help in understanding this is appreciated.
Paul Core co************@ aol.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
It's a peculiarity (mild bug/annoyance) in the VBA development
environment. Sometimes compacting the project cures it.
The code is not case sensitive - so it doesn't matter much.
- --
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP5cSHYechKq OuFEgEQIxmQCfaC WxaWYx2PEjHv0UV 6atRcGZ9FYAn0ay
q/gZmL1ApO9E0r+fR Gddevgw
=yJzd
-----END PGP SIGNATURE-----
Corepaul wrote: I am new to Access 2000. My operating system is Windows 2000.
In the early stage of development I noticed something weird. On my form, I have a Command Button named "btnAlbumUp ". The first time that I reference this button in VBA code, the Visual Basic Editor capitalizes the P changing
btnAlbumUp.SetF ocus
to
btnAlbumUP.SetF ocus
I double checked that the control was defined on the form with a small p (it was). I did a Edit/Find search for "btnAlbum" and confirmed that I hadn't mistyped the name somewhere else in the VBA code (this is the first and only reference to this control in VBA code). I am in the very early stages of development and do not have much code for the problem to hide in so I doubt I missed any references.
Everything seems to work OK so my question is not critical, but I WOULD like to understand where and WHY the editor changes case (it does this in many places, mostly for BASIC keywords).
Are there any situations where case is critical?
Any help in understanding this is appreciated.
Paul Core co************@ aol.com
Subject: Auto Capitalization in VBA Editor - WHY? From: co******@aol.co mbvwertz (Corepaul) Date: 10/22/2003 3:07 PM Central Daylight Time Message-id: <20************ *************** @mb-m14.aol.com>
I am new to Access 2000. My operating system is Windows 2000.
I have a Command Button named "btnAlbumUp ". The first time that I reference this button in VBA code, the Visual Basic Editor capitalizes the P changing
btnAlbumUp.Se tFocus
to
btnAlbumUP.Se tFocus
I double checked that the control was defined on the form with a small p (it was). I did a Edit/Find search for "btnAlbum" and confirmed that I hadn't mistyped the name somewhere else in the VBA code (this is the first and only reference to this control in VBA code).
Everything seems to work OK. Paul Core co*********** *@aol.com
Subject: Re: Auto Capitalization in VBA Editor - WHY?
From: "Wayne Morgan" co************* **************@ hotmail.com
Date: 10/22/2003 3:47 PM Central Daylight Time
Message-id: <c1************ ******@newssvr3 3.news.prodigy. com>
Try typing
Me.
in the form's code module. When you hit the period, it should give you a list of available commands, including the controls on the form. Scroll down this list, how does it show the capitalization? If it doesn't show the capital P and if you use the Me. in front of the control name, does it still capitalize the P? If not, then it is getting it from something somewhere else in the database.
-- Wayne Morgan
Adding the self-reference explicitly (Me.btnAlbumUP. Set Focus ) did not help.
When I looked at the list of controls as you suggest, it is spelled btnAlbumUP,
even though it is spelled with a small p in the objects list in the form design
view.
Paul Core
Subject: Re: Auto Capitalization in VBA Editor - WHY? From: MGFoster me@privacy.com Date: 10/22/2003 6:26 PM Central Daylight Time Message-id: <qm************ ****@newsread3. news.pas.earthl ink.net>
It's a peculiarity (mild bug/annoyance) in the VBA development environment. Sometimes compacting the project cures it.
The code is not case sensitive - so it doesn't matter much.
I am an amateur programmer working by myself on personal projects. Small
projects compared with commercial efforts. Anyway, I never compacted a project.
I tried completely removing the control and ALL references to it, saving the
project, and reinstalling the control being VERY careful to use a small p the
first time, and every other time, the control name is entered. The behavior did
NOT change (small p in design view, cap P in VB code).
You are correct that it does not affect performance, the program runs fine.
When I see something I don't understand, I can't help thinking about it. Excuse
my quixotic pursuit, but I would like to test whether or not removing the
control and then compacting the project before reinserting the control will
work. However, I am afraid to try it without advice from someone who has done
this before.
What are the steps to compact a project?
Are there any potential problems I should watch for? Any hints not easily found
in the on-line help?
Under what other conditions should a project be compacted?
Thanks for the comments.
Paul Core
Compacting a database is routine maintenance. The database size will grow from use and the
only way to recover the wasted space is to compact the database. Access 2000 and newer
combined repairing and compacting into a single command. Go to Tools|Database Utilities on
the menu bar and click Compact and Repair Database... The database will close momentarily
while Access compacts it, then it will reopen.
--
Wayne Morgan
Microsoft Access MVP
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
- From the menu bar: Select Tools > Database Utilities > Compact
Database.
Compact the file every-now-and-then to reduce its file size, reset
AutoNumbers and get rid of "ghost" objects (objects that have been
deleted, but not yet removed from the database file).
HTH,
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP5jCaYechKq OuFEgEQIq9ACeNY N8VYYpvHTcJz4Va in7IpfmQHwAoJJi
cQklvLLWJEVpqgG TDs8teyxI
=5Mzl
-----END PGP SIGNATURE-----
< SNIP > ... ... compacting the project before reinserting the control will work. However, I am afraid to try it without advice from someone who has done this before.
What are the steps to compact a project? Are there any potential problems I should watch for? Any hints not easily found in the on-line help? Under what other conditions should a project be compacted? Thanks for the comments.
Paul Core
>- From the menu bar: Select Tools > Database Utilities > Compact Database.
Sounds easy enough. Thanks to Wayne Morgan and MG Foster for your patient help.
Paul Core This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Seth |
last post by:
How can I completely turn off the auto formatting of Html
in Visual Studio 7? I have tried all possible
combinations (at least I think I have) of the Tools /
Options / Text Editor / HTML XML / Formatting. This is a
big annoyance because with a rather large page it can be
very time consuming to reformat by hand, and very time
consuming to search through and work with the mangled
formatting that often happens do switching to the design...
|
by: Agoston Bejo |
last post by:
Tools / Options / Text Editor / HTML/XML / Format / Capitalization
Usually I use
Tags: Uppercase; Attributes: Uppercase
but now I edit XML pages and I set them both to "As entered". However, the
editor behaves as if I had set it to "Lowercase". Is this a bug or what? How
can I simply enter xml tags without being either uppercased or lowercased?
|
by: Robin Tucker |
last post by:
Hi there,
I have this really frustrating problem with Visual Studio (Microsoft Visual
Basic .NET 2003 69586-335-0000007-18843). I have got used to using the
autocomplete and auto indent features of this excellent source editor but
recently it has only operated on some of my source files and not others. I
have made sure the settings in "tools->options->text editor" are set
correctly but to no avail. For example, hitting enter at the...
|
by: Aaron |
last post by:
I like some of the auto-formatting features of VB.NET (god help me) but I
really prefer to use CSharp (C#) is there any way to get the features of
auto-indenting, auto-capitalization, and advanced intellisense like VB does?
|
by: David P. Donahue |
last post by:
I've always used VB in Visual Studio and have just started porting some
of my stuff to C#, but I'm noticing something odd in Visual Studio
(2003, if that's important). When writing VB code, the IDE would always
show me all the classes/properties/etc. available to me at any given
time in a dropdownlist as I typed. However, that doesn't seem to be
happening with C#. It seems to be a case of the IDE not knowing the
reference paths or...
| |
by: Brakeshoe |
last post by:
I would like to find out how to turn on the Auto Complete variable names
feature while editing source code in Visual Studio. It seems to appear on
intermittantly, and when it does the variable list is incomplete or contains
variables that do not even exist in the project being worked on. It seems
like there should be a setting to turn this on and keep it up to date but I
cannot find anything in MSDN. It is also a complete mystery why it...
|
by: John Holmes |
last post by:
I saw a similar post that went unanswered about a month ago. I am annoyed by
the auto-formatting that occurs when creating my form. I'll make changes to
the code (HTML tab) and then view them in Design mode and when I go back to
the HTML mode the code I just typed in has been reformatted. It doesn't
always do it the same either. I usually don't capitalize tag names and it
will auto-capitalize the ending tags sometimes. I've gone through...
|
by: Tim |
last post by:
I just bought VS .Net, and am getting up to speed. One thing I can't find,
though, is how to get the editor to automatically capitalize keywords
(Public, As, Imports, etc.), the way the VB 6.0 editor did. Does anyone
know how to do this, or was this capability dropped in .NET? Thanks.
--
Tim
|
by: DebadattaMishra |
last post by:
Introduction
In case of rich applications, you must have observed that a text field behaves like a dynamic combo box. When the user enters some characters in the text field, a popup will come up with a list of values as suggestions to the user. This feature is called auto completion. In case of Eclipse editor, you must have
seen while writing java code, if the developers presses "Ctrl+Space" a dynamic list box come up with multiple...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |