By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Bringing up the Expression Builder

P: n/a
I like using the expression builder for a lot of different things but it
isn't always available when I want to use it, for example in the code
window, or in all of the control properties. I am usually stuck having to go
into the database window, creating a new query, etc., and then
right-clicking in a field and selecting build.

Is there a shortcut key, a way to add a button to an Access toolbar, or
something like that so I can use to call up the expression builder?

Thanks,

Mike
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Here's the MS Help on how to start the Expression Builder:
1.. Start the Expression Builder.
2.. How?
3.. You can start the Expression Builder from most places where you write
expressions, such as in a property sheet, a Criteria cell in the query
design grid, or the Macro window.
4.. In a property sheet or the lower pane of the Macro window
1..
1.. Do one of the following:
Start the Expression Builder by opening a property sheet

a.. To set properties for a form or report, double-click the form
selector or the report selector.

b.. To set properties for the data access page, click Select Page on the
Edit menu, and then click Properties on the toolbar.
c.. To set properties for a table or query, click Properties on the
toolbar.
d.. To set properties for a section on a form or report, double-click
the section selector.
e.. To set properties for a section on a data access page, double-click
the section bar.
f.. To set properties of a query field, click the cell in the Field row,
and then click Properties on the toolbar.
g.. To set properties of a query field list, click anywhere in the list,
and then click Properties on the toolbar.
h.. To set properties for a control, click the control, and then click
Properties on the toolbar.
Open a macro in macro Design view

1.. In the Database window, click Macros under Objects.
2.. Click the name of the macro you want to open.
3.. Click the Design button on the Database window toolbar.
2.. Click the property or action argument box that will contain the
expression.
3.. Click the Build button next to the property or argument box.
If a property has more than one builder associated with it, Microsoft
Access displays the Choose Builder dialog box. Click Expression Builder and
click OK.

1.. Note If the property box or argument box where you start the
Expression Builder already contains a value, that value is automatically
copied into the expression box.
2.. In the query design grid or a macro condition
3.. You can start the Expression Builder in a Field or Criteria cell in
query Design view or in the Condition column of the Macro window.
1.. Right-click where you want to insert the expression.
2.. On the shortcut menu, click Build.
1.. Note If the cell or Condition column where you start the Expression
Builder already contains a value, that value is automatically copied into
the expression box.
"Mike Turco" <mi*********@yahooSPAM.com> wrote in message
news:z7********************@comcast.com...
I like using the expression builder for a lot of different things but it
isn't always available when I want to use it, for example in the code
window, or in all of the control properties. I am usually stuck having to
go
into the database window, creating a new query, etc., and then
right-clicking in a field and selecting build.

Is there a shortcut key, a way to add a button to an Access toolbar, or
something like that so I can use to call up the expression builder?

Thanks,

Mike





Nov 13 '05 #2

P: n/a

Ed, thank you for that. I actually read through that portion of the help
file before posting. What I'd like to know is if there is a way to open the
expression builder without having to goto a specific form property, or open
a query or macro. I use a lot of expressions in my code (as we all do, I
imagine). I'd really like to be able to get to the expression builder from
the VB programming window without having to jump through hoops. Thanks --
Mike
"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:a1*****************@monger.newsread.com...
Here's the MS Help on how to start the Expression Builder:
1.. Start the Expression Builder.
2.. How?
3.. You can start the Expression Builder from most places where you write
expressions, such as in a property sheet, a Criteria cell in the query
design grid, or the Macro window.
4.. In a property sheet or the lower pane of the Macro window
1..
1.. Do one of the following:
Start the Expression Builder by opening a property sheet

a.. To set properties for a form or report, double-click the form
selector or the report selector.

b.. To set properties for the data access page, click Select Page on
the Edit menu, and then click Properties on the toolbar.
c.. To set properties for a table or query, click Properties on the
toolbar.
d.. To set properties for a section on a form or report, double-click
the section selector.
e.. To set properties for a section on a data access page, double-click
the section bar.
f.. To set properties of a query field, click the cell in the Field
row, and then click Properties on the toolbar.
g.. To set properties of a query field list, click anywhere in the
list, and then click Properties on the toolbar.
h.. To set properties for a control, click the control, and then click
Properties on the toolbar.
Open a macro in macro Design view

1.. In the Database window, click Macros under Objects.
2.. Click the name of the macro you want to open.
3.. Click the Design button on the Database window toolbar.
2.. Click the property or action argument box that will contain the
expression.
3.. Click the Build button next to the property or argument box.
If a property has more than one builder associated with it, Microsoft
Access displays the Choose Builder dialog box. Click Expression Builder
and click OK.

1.. Note If the property box or argument box where you start the
Expression Builder already contains a value, that value is automatically
copied into the expression box.
2.. In the query design grid or a macro condition
3.. You can start the Expression Builder in a Field or Criteria cell in
query Design view or in the Condition column of the Macro window.
1.. Right-click where you want to insert the expression.
2.. On the shortcut menu, click Build.
1.. Note If the cell or Condition column where you start the Expression
Builder already contains a value, that value is automatically copied into
the expression box.
"Mike Turco" <mi*********@yahooSPAM.com> wrote in message
news:z7********************@comcast.com...
I like using the expression builder for a lot of different things but it
isn't always available when I want to use it, for example in the code
window, or in all of the control properties. I am usually stuck having to
go
into the database window, creating a new query, etc., and then
right-clicking in a field and selecting build.

Is there a shortcut key, a way to add a button to an Access toolbar, or
something like that so I can use to call up the expression builder?

Thanks,

Mike


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.