Module preperty wizards in Access 2000/2/3?

  • Thread starter Thread starter Boutang
  • Start date Start date
B

Boutang

I'm migrating my development tools & code builders from Access 97 to
2003.

In an Access 97 code window, you could right-click, choose Build...
and launch a module property wizard that could insert text into the
module. This was ideal for rapid entry of common code snippets, code
templates, etc.

I can't find any way to reproduce this functionality in Access 2003.

In Access 97, you enabled the property wizard by entering appropriate
keys/values into the following registry key:

HKEY_CURRENT_ACCESS_PROFILE\Wizards\Property Wizards\Module\[Your
Builder Name]

This doesn't work in Access 2003.

This nice thing about the property wizard approach is that tool
"knows" what module & procedure you're in and can incorporate this
information into your code stub. There's no need to pick your module
or procedure name. Also, you can write directly into the code window,
without a need to copy anything from the clipboard (like FMS's tools
make you do).

I can't believe Microsoft would drop this incredibly useful
functionality, so I'm sure I just haven't figured out how to interact
with the new design environment.

Any thoughts?
 
hi,

from access 2000 you have to write com addin to make such things in VBA
editor. you can find sample code at msdn site.
 
Hi Boutang,

From your description, I understand that in Access 97, you could
right-click, choose Build... and then luanch "Expression Builder". You want
to know how to find it in Access 2003. Have I understood the issue
correctly and completely? If there is anything I misunderstood, please feel
free to let me know.

First of all, I am so sorry to say that Expression Builder is no longer
available in VB Environment from Access 2000. Earlier versions of Microsoft
Access used a native Visual Basic editor rather than the shared Visual
Basic Environment used by other Microsoft Office programs. Because the
native Visual Basic editor was built into Microsoft Access directly, it was
possible to use the Expression Builder within it. However, Microsoft Access
2000 now uses the shared Visual Basic Environment that is used by the other
Microsoft Office 2000 programs, expression builder is not available any
more.
For detailed information of this, you can have a look at Knowledge Base:
ACC2000: Expression Builder Is Not Available in Visual Basic Environment
http://support.microsoft.com/?id=245181

Secondly, you can follow this as a workaround
1. In the Database window, click Queries, click New, click Design View,
and then click OK. If the Show Table dialog box is visible, close it.
2. In the query design grid, right-click in any Field cell, and then
click Build on the shortcut menu.
3. Build your expression, and then click OK.
4. Select the entire expression, and then click Copy on the Edit menu.
5. In your code module, click Paste on the Edit menu to paste the
expression into the code.
6. Close the query without saving it.

Moreover, which might be the MOST helpful. There is a free third-party
utility available from Trigeminal Software, Inc. that
will invoke the Expression Builder from the VBE if using Access 2000/2002.
The third-party products that are discussed in this article are
manufactured by companies that are independent of Microsoft. Microsoft
makes no warranty, implied or otherwise, regarding the performance or
reliability of these products.

You can obtain this utility TSI Xpression 9.0 from Trigeminal's world wide
web site.
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1


Hope this help and please feel free to post in the group if this solves
your problem or if you would like further help. We are here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Or, to put it a different way, now you need a VBA code builder
instead of an Access code builder.

Access 2000 Developer edition (MOD) included a COM Add-in Designer:
you need VB6 or equivalent to built COM objects.

Code Crafter and FMS sell COM add-ins for Access.
http://www.mvps.org/access/downloads/linenumbers.zip is a free COM add-in

(david)
 
Hi Boutang,

I am just checking on your progress regarding the information that was sent
you! Have you tried the tools I provided to you? Have you see the KB I give
you, which explained why Expression Builder is not available in visual
basic environment any more?

I wonder how the testing is going. If you encounter any difficulty, please
do not hesitate to let me know. Please post here and let me know the status
of your issue.

Looking forward to hearing from you soon


Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Hi folks. Ok, so I understand from the threads back and forth that I
may have to build a COM add-in. No problem there, I can figure the
coding part out.

But so far, I haven't seen any COM add-ins that can interact directly
with the environment. For example, every code builder I've seen so far
makes you copy a generic code stub to the clipboard and then paste it
into your code window. Blerk!!! Especially when Access 97 was so
straightforward.

I've uploaded an MDE version of my Access 97 code builder to
www.simonassociates.ca. To see the functionality I'm trying to
reproduce:

1. Download the add-in.
2. Open Access 97.
3. Install the add-in using Add-In Manager.
4. In a module code window, right-click and choose Build.
5. In the Choose Builder window, choose FLEET Procedure Builder
6. Complete the dialog, including the Creator & other controls.
7. Click OK.

The builder builds a procedure stub.

You can get the same effect by right-clicking in an event procedure
stub in a form/report's class module, and then choosing FLEET CBF
Builder in the Choose Builder window.

This nice thing about this tool is that it "knows" what module &
procedure you're in and can incorporate that into your code stub.
There's no need to pick your module or procedure name. Finally, it
writes directly into the code window, without a need to copy anything
from the clipboard (like FMS's tools make you do).

Is this functionality gone in Access 2000/2/3?
 
Hi Boutang,

Have you tried the third party tools that I reommand?

TSI Xpression 9.0 is a ComAddIn written in VB6 that you can stick on your
machine, register, and get this functionality back, which will allows you
to even call the Expression Builder yourself in VBA code!

you can obtain this utility TSI Xpression 9.0 from Trigeminal's world wide
web site.
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1

After you download the package to your hard disk, unzip it to a folder and
run
Regsvr32 to register it. For example:

1. Click Start, and then click Run.
2. Type "regsvr32" (without the quotation marks) followed by the path to
your file
TsiXpr90.dll. Enclose this path in quotation marks. For example: (The
following
command assumes that the file is unzipped to the root folder of your drive
C:)

regsvr32 "C:\TsiXpr90.dll"

Once you have installed and registered the add-in as above, simply
right-click on
code in a module in the VBE and you will get the expression builder.

Please feel free to post in the group if this solves your problem or if you
would like further help. We are here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

========================================================================
This response contains a reference to a third party World Wide Web site.
Microsoft
can make no representation concerning the content of these sites. Microsoft
is
providing this information only as a convenience to you: this is to inform
you that
Microsoft has not tested any software or information found on these sites
and
therefore cannot make any representations regarding the quality, safety, or
suitability of any software or information found there. There are inherent
dangers
in the use of any software found on the Internet, and Microsoft cautions
you to
make sure that you completely understand the risk before retrieving any
software on
the Internet.
 
Hi Boutang,

I am just checking on your progress regarding the information that was sent
you! Have you tried TSI Xpression 9.0? Do you see the Expression Builder it
provides?Please post here and let me know the status of your issue. If you
encounter any difficulty, please do not hesitate to let me know.

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
 
Back
Top