Re: Unbound field in query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: timeteo (timeteo_at_discussions.microsoft.com)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 07:27:04 -0800

I like that approach...that would be a good way to do it.

I wanted to try and avoid adding another field to the table since the yes/no
selection is basically "disposable" data - only needed when the form is run
and the records are selected but I guess an yes/no field won't hurt anything.

Thanks to all.

Tim

"Jeff Boyce" wrote:

> You don't mention how you are displaying the records on the form.
>
> Marsh offered one approach, binding the yes/no field to a new field in the
> table, one per row.
>
> A somewhat related approach would be to use paired listboxes. The first
> displays the rows retrieved by your query. The second is the "Use These
> Ones" list. The user would select from the first and "move them" to the
> second list. Behind the scenes, you'd need to set the yes/no and requery
> the list.
>
> --
> Good luck
>
> Jeff Boyce
> <Access MVP>
>
> "timeteo" <timeteo@discussions.microsoft.com> wrote in message
> news:F990C4D2-6D66-4746-A455-82CE69ECB6C9@microsoft.com...
> > Am I crazy or is there a way to do this!!!????
> >
> > I am trying to run a query to show certain records on a form. From there
> > the user will select which records to use in a report. Only certain
> records
> > can be used and only the user can select which ones. Basically, I was
> > thinking of using an "unbound" yes/no field on the form and then, when the
> > form ran, the user would select which records to exclude from the report.
> >
> > I'm finding it impossible to do...am I just not going about this the right
> > way? Any suggestions would be greatly appreciated.
> >
> > Thanks.
> > Tim
>
>

Relevant Pages

  • Re: Query Logic dysfunctional
    ... SQL statement of your query(s), nor the data structure from which the query ... The baby's age as of the report date is <36 months or is null ... IFSP date is>= Eligibility Date ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.queries)
  • Re: Problem with relationship??
    ... Have the SQL (or the query) refer to the form on which the user selects the ... "Jeff Boyce" wrote: ... Product] it will return ALL the products I have that require seriel ... Then you design a report, based on the data the query returns. ...
    (microsoft.public.access.gettingstarted)
  • Re: Same Parameters in all sub reports
    ... something wrong between the form and the query. ... It didn't for my regular queries. ... "Jeff Boyce" wrote: ... Build a query that will be used to provide data to your report. ...
    (microsoft.public.access.reports)
  • Re: Problem with relationship??
    ... "Jeff Boyce" wrote: ... Have the SQL (or the query) refer to the form on which the user selects the ... Product] it will return ALL the products I have that require seriel ... Then you design a report, based on the data the query returns. ...
    (microsoft.public.access.gettingstarted)
  • Re: DateAdd against textbox value
    ... Tim, there's a problem here with the data type of the text box. ... The best solution would be to add a button to your form for opening the report. ... You can leave the criteria out of the query, and the button will build the WhereCondition string for OpenReport to filter it for the desired month, or show all months if the user did not fill in any date. ... FROM tblClients ...
    (microsoft.public.access.queries)