Prev: DateDiff and Count/Sum
Next: Column graph problem
From: Brad on 14 Apr 2010 21:16
We want to add a TextBox to a report that is viewed online. The data
collected in this TextBox will be used to adjust the report filter.

We want to allow our users to enter as much of a Customer Name as they want
after they see the report with all Customers shown. We then want to use
this info to change the Report Filter. We have never tried this before.
For some reason, we cannot see the data in the TextBox in our VBA code. It
appears that Access Reports behave differently than Access Forms as far as
grabbing data from TextBoxes. We must be missing something. Does anyone
have a sample of how to do this or advice on what to look out for.

Thanks,
Brad


From: Al Campagna on 15 Apr 2010 08:33
Brad,
Reports don't have editable text, or events, as forms do.
Any options you need for a report (show all, show some, show one) must
be done when the query runs.

A common solution (there are more than one method to do this) is to have
a text control on an open form... from which the
report is run. (ex. names - text control = txtCriteria and form =
frmCiteria)

Given the following crireia in the report query...
CustomerName
Like "*" & Forms!frmCriteria!txtCriteria & "*"

If Criteria = null, all CustomerNames will be returned.
If Criteria = "Man" then CustomerNames like Manning, Manchester, etc...
will be returned
The narrower the criteria, the narrower the results.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Brad" <Brad(a)discussions.microsoft.com> wrote in message
news:7D2FAB26-65B7-4072-AAA9-2703CF6A779F(a)microsoft.com...
> We want to add a TextBox to a report that is viewed online. The data
> collected in this TextBox will be used to adjust the report filter.
>
> We want to allow our users to enter as much of a Customer Name as they
> want
> after they see the report with all Customers shown. We then want to use
> this info to change the Report Filter. We have never tried this before.
> For some reason, we cannot see the data in the TextBox in our VBA code.
> It
> appears that Access Reports behave differently than Access Forms as far as
> grabbing data from TextBoxes. We must be missing something. Does anyone
> have a sample of how to do this or advice on what to look out for.
>
> Thanks,
> Brad
>
>


From: Brad on 15 Apr 2010 12:43
Al,

Thanks for your help.

I didn't know that Access Reports can not have editable text fields. This
explains what we were running into.

We will resort to using a Form to collect the info from the user.

Thanks again,

Brad


"Al Campagna" wrote:

> Brad,
> Reports don't have editable text, or events, as forms do.
> Any options you need for a report (show all, show some, show one) must
> be done when the query runs.
>
> A common solution (there are more than one method to do this) is to have
> a text control on an open form... from which the
> report is run. (ex. names - text control = txtCriteria and form =
> frmCiteria)
>
> Given the following crireia in the report query...
> CustomerName
> Like "*" & Forms!frmCriteria!txtCriteria & "*"
>
> If Criteria = null, all CustomerNames will be returned.
> If Criteria = "Man" then CustomerNames like Manning, Manchester, etc...
> will be returned
> The narrower the criteria, the narrower the results.
> --
> hth
> Al Campagna
> Microsoft Access MVP 2007-2009
> http://home.comcast.net/~cccsolutions/index.html
>
> "Find a job that you love... and you'll never work a day in your life."
>
> "Brad" <Brad(a)discussions.microsoft.com> wrote in message
> news:7D2FAB26-65B7-4072-AAA9-2703CF6A779F(a)microsoft.com...
> > We want to add a TextBox to a report that is viewed online. The data
> > collected in this TextBox will be used to adjust the report filter.
> >
> > We want to allow our users to enter as much of a Customer Name as they
> > want
> > after they see the report with all Customers shown. We then want to use
> > this info to change the Report Filter. We have never tried this before.
> > For some reason, we cannot see the data in the TextBox in our VBA code.
> > It
> > appears that Access Reports behave differently than Access Forms as far as
> > grabbing data from TextBoxes. We must be missing something. Does anyone
> > have a sample of how to do this or advice on what to look out for.
> >
> > Thanks,
> > Brad
> >
> >
>
>
> .
>
 | 
Pages: 1
Prev: DateDiff and Count/Sum
Next: Column graph problem