Re: The Condition in a Macro

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

Great appologies, thanks for your attempt when you did not have then needed
information.

"Ken Snell [MVP]" wrote:

> The DLookup is not going to filter anything... you asked about using a
> Condition expression, which is what I suggested. If you're wanting to filter
> a report or form, then tell us more information about what you're actually
> trying to do. Details help....
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
>
> "bert32hid" <bert32hid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:C3EC6E8B-D2C7-46DC-9C86-38ED337D3CE8@xxxxxxxxxxxxxxxx
> > The this is it is not a for, it is a Table / Query..... And I have had
> > trouble getting it across to be part of the Macro.
> >
> > Now with your DLookup, for some reason, it has every single record, which
> > this function was supposed to get out (wasn't it?).
> >
> >
> > "Ken Snell [MVP]" wrote:
> >
> >> Are you wanting to read the value from a query's record? If yes, use the
> >> DLookup function instead (your syntax will not work to find a query):
> >>
> >> DLookup("displayfile1", "Files_Topics Query1")="underwater_1"
> >>
> >>
> >> If you want to read the value from a control on an open form, your syntax
> >> is
> >> close but not right:
> >>
> >> Forms![Files_Topics Query1]![displayfile1]="underwater_1"
> >>
> >> --
> >>
> >> Ken Snell
> >> <MS ACCESS MVP>
> >>
> >>
> >> "bert32hid" <bert32hid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:6FF4D865-49E2-45D1-91FC-66DD1058BDCE@xxxxxxxxxxxxxxxx
> >> >I am having troubles with the Condition in a Macro such as the
> >> >following:
> >> >
> >> > [Files_Topics Query1]![displayfile1]="underwater_1"
> >> >
> >> > I have included many of them besides many "OutputTo" Macros so that I
> >> > would
> >> > be able to update data or the format and output all the documents in no
> >> > time.
> >> > . . . But it is taking for ever to get it done :-(
> >> >
> >> > Apart from the QUERY!FIELD="DATA" example that is shown above, I can
> >> > not
> >> > find on this web site another solution.
> >> >
> >> > If you could help please do so. Pretty please! :-)
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Updating query running from form
    ... you need to add a filter for the single record you're trying to update. ... If it's in a canned query, you can just point at the open form. ...
    (comp.databases.ms-access)
  • Passing Query Parameters from form to another VBA subroutine
    ... You can refer to fields on any open form (whether the ... >I've got a form that lets the user filter a table full ... >selecting from values in six different fields - and am ... >parameters for the underlying query. ...
    (microsoft.public.access.queries)
  • Re: Filter or WHERE
    ... I only ever load a single record at a time ... I do sometimes use the ServerFilter filter; for example Data Access Pages ... You likely should load up the form with a query, ...
    (microsoft.public.access.formscoding)
  • RE: DLookup issue
    ... Looking again at your dlookup I noticed that you have no field to compare with ... I dont understand your filter. ... >> that query you have two tables with that same field name. ...
    (microsoft.public.access.reports)
  • Re: Form Opening
    ... I have another STRANGE issues. ... I added a button to the first form 'A' to filter on a specifc column: ... Private Sub AllProjects_Click ... filter button and then tries to open form C, ...
    (microsoft.public.access.forms)