Hide extra fields in a Continuous Forms

I have a Continuous Forms based on a query. The query pulls data based
on a date and the data is displayed on a form. The form has several
fields but only two fields that are able to be edited (Filled Qty, and
Filled By). Once these field are completed the user can then generate
a report and email it to a different department.

The issue is when the form opens all the data is displays correctly,
how ever there is an additonal line containing the Filled Qty, and
Filled By fields. If the user TABs to these fields and then runs the
report the report is blank because there isn't any data for these
fields. I need to eliminate / hide these extra fields.

Example: Since I can't attach a screen shot I'll have to try to
describe the form this way. If I run my report for the date of
05/07/2007 the report would look something like this.


Report Name
Requested Date - 05/07/2007
-----------------------------------------------------------------------------------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

-----------------------------------------------------------------------------------------------------------------------------

The only reason you would need those additional two fields in your query is
if the report uses the same query as the continuous form. If this is the
case, you still don't have to bind every field in the query to a control.
Just delete the controls in the form that you have bound to those two fields.
--
Dave Hargis, Microsoft Access MVP


"Del" wrote:

I have a Continuous Forms based on a query. The query pulls data based
on a date and the data is displayed on a form. The form has several
fields but only two fields that are able to be edited (Filled Qty, and
Filled By). Once these field are completed the user can then generate
a report and email it to a different department.

The issue is when the form opens all the data is displays correctly,
how ever there is an additonal line containing the Filled Qty, and
Filled By fields. If the user TABs to these fields and then runs the
report the report is blank because there isn't any data for these
fields. I need to eliminate / hide these extra fields.

Example: Since I can't attach a screen shot I'll have to try to
describe the form this way. If I run my report for the date of
05/07/2007 the report would look something like this.


Report Name
Requested Date - 05/07/2007
-----------------------------------------------------------------------------------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

-----------------------------------------------------------------------------------------------------------------------------

On May 8, 12:24 pm, Klatuu wrote:
The only reason you would need those additional two fields in your query is
if the report uses the same query as the continuous form. If this is the
case, you still don't have to bind every field in the query to a control.
Just delete the controls in the form that you have bound to those two fields.
--
Dave Hargis, Microsoft Access MVP



"Del" wrote:
I have a Continuous Forms based on a query. The query pulls data based
on a date and the data is displayed on a form. The form has several
fields but only two fields that are able to be edited (Filled Qty, and
Filled By). Once these field are completed the user can then generate
a report and email it to a different department.

The issue is when the form opens all the data is displays correctly,
how ever there is an additonal line containing the Filled Qty, and
Filled By fields. If the user TABs to these fields and then runs the
report the report is blank because there isn't any data for these
fields. I need to eliminate / hide these extra fields.

Example: Since I can't attach a screen shot I'll have to try to
describe the form this way. If I run my report for the date of
05/07/2007 the report would look something like this.

Report Name
Requested Date - 05/07/2007
---------------------------------------------------------------------------*--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

---------------------------------------------------------------------------*--------------------------------------------------- Hide quoted text -

- Show quoted text -

I don't understand what you mean, and I see my orignal post may have
been part of the problem.
I stated in my example that

" If I run my report for the date of 05/07/2007 the report would look
something like this."

What meant to say is " If I open my form for the date of 05/07/2007
the form would look something like this."

Also instead of the example saying Report Name it should have said
Form Header like this.

Form Header
Requested Date - 05/07/2007
---------------------------------------------------------------------------*--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By


101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________


---------------------------------------------------------------------------*--------------------------------------------------

The issue is that there is a button that allows the user to send an
email report to an other department once they have completed the form.
If the user tabs into one of the extra two fields at the bottom of the
form and then send the email the report is blank. This is because the
report to be emailed is based on the Requested Date from the form, and
when either of the extra fields have focus there the Requested Date
field is blank. So I'm trying to eliminate those two fields from the
form to prevent blank reports from being generated and emailed. This
is a continuous form, and the query does not have the extra fields.

Thanks,

Now I am confused. If the extra fields are not part of the query, which
query are you talking about? I still don't understand why you can't just
delete the extra fields from the form or make them invisible.
--
Dave Hargis, Microsoft Access MVP


"Del" wrote:

On May 8, 12:24 pm, Klatuu wrote:
The only reason you would need those additional two fields in your query is
if the report uses the same query as the continuous form. If this is the
case, you still don't have to bind every field in the query to a control.
Just delete the controls in the form that you have bound to those two fields.
--
Dave Hargis, Microsoft Access MVP



"Del" wrote:
I have a Continuous Forms based on a query. The query pulls data based
on a date and the data is displayed on a form. The form has several
fields but only two fields that are able to be edited (Filled Qty, and
Filled By). Once these field are completed the user can then generate
a report and email it to a different department.

The issue is when the form opens all the data is displays correctly,
how ever there is an additonal line containing the Filled Qty, and
Filled By fields. If the user TABs to these fields and then runs the
report the report is blank because there isn't any data for these
fields. I need to eliminate / hide these extra fields.

Example: Since I can't attach a screen shot I'll have to try to
describe the form this way. If I run my report for the date of
05/07/2007 the report would look something like this.

Report Name
Requested Date - 05/07/2007
---------------------------------------------------------------------------Â*--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

---------------------------------------------------------------------------Â*--------------------------------------------------- Hide quoted text -

- Show quoted text -

I don't understand what you mean, and I see my orignal post may have
been part of the problem.
I stated in my example that

" If I run my report for the date of 05/07/2007 the report would look
something like this."

What meant to say is " If I open my form for the date of 05/07/2007
the form would look something like this."

Also instead of the example saying Report Name it should have said
Form Header like this.

Form Header
Requested Date - 05/07/2007
---------------------------------------------------------------------------Â*--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By


101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________


---------------------------------------------------------------------------Â*--------------------------------------------------

The issue is that there is a button that allows the user to send an
email report to an other department once they have completed the form.
If the user tabs into one of the extra two fields at the bottom of the
form and then send the email the report is blank. This is because the
report to be emailed is based on the Requested Date from the form, and
when either of the extra fields have focus there the Requested Date
field is blank. So I'm trying to eliminate those two fields from the
form to prevent blank reports from being generated and emailed. This
is a continuous form, and the query does not have the extra fields.

Thanks,

On May 10, 7:58 am, Klatuu wrote:
Now I am confused. If the extra fields are not part of the query, which
query are you talking about? I still don't understand why you can't just
delete the extra fields from the form or make them invisible.
--
Dave Hargis, Microsoft Access MVP



"Del" wrote:
On May 8, 12:24 pm, Klatuu wrote:
The only reason you would need those additional two fields in your query is
if the report uses the same query as the continuous form. If this is the
case, you still don't have to bind every field in the query to a control.
Just delete the controls in the form that you have bound to those two fields.
--
Dave Hargis, Microsoft Access MVP

"Del" wrote:
I have a Continuous Forms based on a query. The query pulls data based
on a date and the data is displayed on a form. The form has several
fields but only two fields that are able to be edited (Filled Qty, and
Filled By). Once these field are completed the user can then generate
a report and email it to a different department.

The issue is when the form opens all the data is displays correctly,
how ever there is an additonal line containing the Filled Qty, and
Filled By fields. If the user TABs to these fields and then runs the
report the report is blank because there isn't any data for these
fields. I need to eliminate / hide these extra fields.

Example: Since I can't attach a screen shot I'll have to try to
describe the form this way. If I run my report for the date of
05/07/2007 the report would look something like this.

Report Name
Requested Date - 05/07/2007
---------------------------------------------------------------------------**--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

---------------------------------------------------------------------------**--------------------------------------------------- Hide quoted text -

- Show quoted text -

I don't understand what you mean, and I see my orignal post may have
been part of the problem.
I stated in my example that

" If I run my report for the date of 05/07/2007 the report would look
something like this."

What meant to say is " If I open my form for the date of 05/07/2007
the form would look something like this."

Also instead of the example saying Report Name it should have said
Form Header like this.

Form Header
Requested Date - 05/07/2007
---------------------------------------------------------------------------**--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

---------------------------------------------------------------------------**--------------------------------------------------

The issue is that there is a button that allows the user to send an
email report to an other department once they have completed the form.
If the user tabs into one of the extra two fields at the bottom of the
form and then send the email the report is blank. This is because the
report to be emailed is based on the Requested Date from the form, and
when either of the extra fields have focus there the Requested Date
field is blank. So I'm trying to eliminate those two fields from the
form to prevent blank reports from being generated and emailed. This
is a continuous form, and the query does not have the extra fields.

Thanks,- Hide quoted text -

- Show quoted text -

There is one query that is used to populate a continuous form. If I
run the query by itself it returns just just the data expected. When I
open the continuous form, the query is run and the form is populated.
The issue is if the query returns 5 lines of data, when the form is
open the 5 lines of data are displayed with the two fields that can be
edited in the form, plus there is another line of no data but this
line has the editable fields.

Example: The two editable fields are Filled Qty and Filled By

Query Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______


Form Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______
________
_______

I would like to get rid of the two extra lines in the form. If I
change the Visable setting on the Filled Qty and Filled By to No then
none of those fields will be displayed.

Sounds as though the blank line is there to let you add new records. Simply
set the form's AllowAdditions property to False.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Del" wrote in message
oups.com...
On May 10, 7:58 am, Klatuu wrote:
Now I am confused. If the extra fields are not part of the query, which
query are you talking about? I still don't understand why you can't just
delete the extra fields from the form or make them invisible.
--
Dave Hargis, Microsoft Access MVP



"Del" wrote:
On May 8, 12:24 pm, Klatuu wrote:
The only reason you would need those additional two fields in your
query is
if the report uses the same query as the continuous form. If this is
the
case, you still don't have to bind every field in the query to a
control.
Just delete the controls in the form that you have bound to those two
fields.
--
Dave Hargis, Microsoft Access MVP

"Del" wrote:
I have a Continuous Forms based on a query. The query pulls data
based
on a date and the data is displayed on a form. The form has several
fields but only two fields that are able to be edited (Filled Qty,
and
Filled By). Once these field are completed the user can then
generate
a report and email it to a different department.

The issue is when the form opens all the data is displays correctly,
how ever there is an additonal line containing the Filled Qty, and
Filled By fields. If the user TABs to these fields and then runs the
report the report is blank because there isn't any data for these
fields. I need to eliminate / hide these extra fields.

Example: Since I can't attach a screen shot I'll have to try to
describe the form this way. If I run my report for the date of
05/07/2007 the report would look something like this.

Report Name
Requested Date -
05/07/2007
---------------------------------------------------------------------------**--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

---------------------------------------------------------------------------**---------------------------------------------------
Hide quoted text -

- Show quoted text -

I don't understand what you mean, and I see my orignal post may have
been part of the problem.
I stated in my example that

" If I run my report for the date of 05/07/2007 the report would look
something like this."

What meant to say is " If I open my form for the date of 05/07/2007
the form would look something like this."

Also instead of the example saying Report Name it should have said
Form Header like this.

Form Header
Requested Date - 05/07/2007
---------------------------------------------------------------------------**--------------------------------------------------
Seq # Requested Part Description Req Qty Filled
Qty Filled By

101 12345ADE Blue Part 25
________ ____________
102 243897fh6 Red Part 100
________ ____________
103 SHR479HH Some Part 1
________ ____________
(These are the fields I want to get rid of) ----------------
________ ____________

---------------------------------------------------------------------------**--------------------------------------------------

The issue is that there is a button that allows the user to send an
email report to an other department once they have completed the form.
If the user tabs into one of the extra two fields at the bottom of the
form and then send the email the report is blank. This is because the
report to be emailed is based on the Requested Date from the form, and
when either of the extra fields have focus there the Requested Date
field is blank. So I'm trying to eliminate those two fields from the
form to prevent blank reports from being generated and emailed. This
is a continuous form, and the query does not have the extra fields.

Thanks,- Hide quoted text -

- Show quoted text -

There is one query that is used to populate a continuous form. If I
run the query by itself it returns just just the data expected. When I
open the continuous form, the query is run and the form is populated.
The issue is if the query returns 5 lines of data, when the form is
open the 5 lines of data are displayed with the two fields that can be
edited in the form, plus there is another line of no data but this
line has the editable fields.

Example: The two editable fields are Filled Qty and Filled By

Query Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______


Form Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______
________
_______

I would like to get rid of the two extra lines in the form. If I
change the Visable setting on the Filled Qty and Filled By to No then
none of those fields will be displayed.