Re: uer

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: DZ (anonymous_at_discussions.microsoft.com)
Date: 02/04/04 

Date: Wed, 4 Feb 2004 02:32:04 -0800

Thanks for responding Steve.

I'm sorry for not being clear enough. Let me try to
explain more clearly this time.

I'm creating a query in design view. In one of the column
headings in design view of the Query, I want to use a
function to create a calculated field.

So I type a name for the calculated field "NewFieldName",
followed by the function. For function argument, I insert
the field name, "Field1", so that the function will
process each record in the field named "Field1"

I have used functions in queries before that were either
built-in functions or custom functions that were located
in a standard module with no problem.

So, normally, I would type the following expression in a
column heading in the query (I'm using a built-in
function as an example)

NewFieldName: UCase([Field1])

But I want to use my custom function and it is not located
in a standard module. It is located in the module of a
currently open form. The reason that the function is
located in the form is that I want to encapsulate all of
the functionally of this program inside one form.

I need to know the syntax for referring to my function
that's located in a form.

In a column in query design view, I typed the following
but it did not work.

NewFieldName: Forms!FormName!FunctionName([Field1])
and
NewFieldName: [Forms]![FormName]!FunctionName([Field1])

Thanks form any help

DZ

Relevant Pages

  • Re: uer
    ... > I'm creating a query in design view. ... > function to create a calculated field. ... > So I type a name for the calculated field "NewFieldName", ...
    (microsoft.public.access.queries)
  • RE: FE Running Slow with BE on Network
    ... live, production data. ... For instance, when laying out a new report linked to a brand new query, I ... Or if I take the MDB file off site to design at ... Yes, I could put the calculated field in the in the query, which I may do, ...
    (microsoft.public.access.tablesdbdesign)
  • FE Running Slow with BE on Network
    ... For instance, when laying out a new report linked to a brand new query, I ... Or if I take the MDB file off site to design at ... Yes, I could put the calculated field in the in the query, which I may do, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: uer
    ... you can't refer to the ... >will have to put it in a standard module. ... been able to fiquire out how to do it from a query. ... >> I'm creating a query in design view. ...
    (microsoft.public.access.queries)
  • Re: cant find where to change data type
    ... that allowed me to switch to table design, ... Now, about the query! ... There's the chance you want to create the calculated field on the form instead of the query. ... Open the table and ensure the DefaultValue is 0 for each fld to be summed (If the DefaultValue says Null or is blank, enter a zero). ...
    (comp.databases.ms-access)