Expression Builder available in Code Builder?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank77 - 09 Mar 2005 17:29 GMT

I've just upgraded from Access 97 to XP. It seems that in the VBA Code
Builder I can't launch the Expression builder. In Access 97 a right button
click would pop a menu with the Build ... selection which launched
Expression builder. I found Expression builder very helpful in creating the
properly qualified Form field names syntax.

Is there a way to launch Expression builder when writing VBA code? or some
equivalent way to generate properly qualified field names?

Reply to this Message

Brendan Reynolds - 09 Mar 2005 17:51 GMT

The expression builder no longer works in the VBA editor in Access 2000 or
later, but Michael Kaplan has a (free) add-in to restore it in Access 2000
or 2002 (I don't know whether it works in 2003)

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1

Signature

Brendan Reynolds (MVP)

> I've just upgraded from Access 97 to XP. It seems that in the VBA Code
> Builder I can't launch the Expression builder. In Access 97 a right button
[quoted text clipped - 5 lines]
> Is there a way to launch Expression builder when writing VBA code? or some
> equivalent way to generate properly qualified field names?

Reply to this Message

Frank77 - 10 Mar 2005 17:21 GMT

Thanks ... worked like a charm for me in XP. I don't understand why
microsoft changed this around. On MK's site he hasn't updated his comment on
likely unsupported results beyond 2000 and XP. For 2003 I suppose the low
tech solution would be to compose with Expression builder in an environment
that allows it (such as a Module Event ) then cut and paste your composition
into VBA ... an ugly way to get valid field syntax .

> The expression builder no longer works in the VBA editor in Access 2000 or
> later, but Michael Kaplan has a (free) add-in to restore it in Access 2000
[quoted text clipped - 11 lines]
> > Is there a way to launch Expression builder when writing VBA code? or some
> > equivalent way to generate properly qualified field names?

Reply to this Message

Brendan Reynolds - 10 Mar 2005 19:37 GMT

I believe the loss of the Expression Builder in Access 2000 and later was a
consequence of the separation of the VBA IDE from the main Access window.
Beyond that, I can't say, I don't use the Expression Builder any more
myself.

Signature

Brendan Reynolds (MVP)

> Thanks ... worked like a charm for me in XP. I don't understand why
> microsoft changed this around. On MK's site he hasn't updated his comment
[quoted text clipped - 25 lines]
>> > some
>> > equivalent way to generate properly qualified field names?

Reply to this Message