Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2007

Tip: Looking for answers? Try searching our database.

Hide extra fields in a Continuous Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Del - 08 May 2007 16:19 GMT
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) ---------------->
________      ____________

-----------------------------------------------------------------------------------------------------------------------------
Klatuu - 08 May 2007 17:24 GMT
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.
Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 28 lines]
>
> -----------------------------------------------------------------------------------------------------------------------------
Del - 10 May 2007 10:43 GMT
> 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
[quoted text clipped - 37 lines]
>
> - 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,
Klatuu - 10 May 2007 12:58 GMT
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.
Signature

Dave Hargis, Microsoft Access MVP

> > 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
[quoted text clipped - 79 lines]
>
> Thanks,
Del - 10 May 2007 23:55 GMT
> 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
[quoted text clipped - 87 lines]
>
> - 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.
Douglas J. Steele - 11 May 2007 01:54 GMT
Sounds as though the blank line is there to let you add new records. Simply
set the form's AllowAdditions property to False.

Signature

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

On May 10, 7:58 am, Klatuu <Kla...@discussions.microsoft.com> 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
[quoted text clipped - 99 lines]
>
> - 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.