can't add new record to sub-form (continuous)

Discussion in 'Access Forms Coding' started by p-rat, May 11, 2009.

  1. p-rat

    p-rat Guest

    I have a form where we enter data. On this main form there is a sub-
    form. It is continuous form. I can add as many items as I need and it
    works great.

    I can then go through an EDIT button on my switchboard and it'll ask
    for example the Ticket Number. I type in the ticket number and it'll
    pull up the form with all the data that was entered during the data
    entry process. I can change things throughout; even in the sub-form,
    but I can't ADD a record in the sub-form.

    In data entry process you can TAB through the continuous sub-form and
    it'll create as many records as needed. When tabbing through in the
    EDIT phase it won't create any new records.

    How do I solve this? I need to be able to add another record. Thanks.
     
    p-rat, May 11, 2009
    #1
    1. Advertisements

  2. Look at your form properties and see if it is set to not allow additions. It
    will be in the Data tab of the property sheet.

    Bonnie
    http://www.dataplus-svc.com/document_scanning/document_scanning.htm

    p-rat wrote:
    >I have a form where we enter data. On this main form there is a sub-
    >form. It is continuous form. I can add as many items as I need and it
    >works great.
    >
    >I can then go through an EDIT button on my switchboard and it'll ask
    >for example the Ticket Number. I type in the ticket number and it'll
    >pull up the form with all the data that was entered during the data
    >entry process. I can change things throughout; even in the sub-form,
    >but I can't ADD a record in the sub-form.
    >
    >In data entry process you can TAB through the continuous sub-form and
    >it'll create as many records as needed. When tabbing through in the
    >EDIT phase it won't create any new records.
    >
    >How do I solve this? I need to be able to add another record. Thanks.


    --

     
    bhicks11 via AccessMonster.com, May 11, 2009
    #2
    1. Advertisements

  3. p-rat wrote:

    >I have a form where we enter data. On this main form there is a sub-
    >form. It is continuous form. I can add as many items as I need and it
    >works great.
    >
    >I can then go through an EDIT button on my switchboard and it'll ask
    >for example the Ticket Number. I type in the ticket number and it'll
    >pull up the form with all the data that was entered during the data
    >entry process. I can change things throughout; even in the sub-form,
    >but I can't ADD a record in the sub-form.
    >
    >In data entry process you can TAB through the continuous sub-form and
    >it'll create as many records as needed. When tabbing through in the
    >EDIT phase it won't create any new records.
    >
    >How do I solve this? I need to be able to add another record. Thanks.



    .... and check the switchboard EDIT button's Click event
    procedure. Look at the OpenForm line and make sure the
    Datamode argument is acFormEdit (or not specified if the
    form's properties have bot AllowEdits and AllowAdditions set
    to Yes).

    --
    Marsh
    MVP [MS Access]
     
    Marshall Barton, May 11, 2009
    #3
  4. p-rat

    p-rat Guest

    i've checked AllowEdits and AllowAdditions and they are both set to
    yes. i also checked the EDIT button and don't see any code as Marshall
    mentioned. when run a query i can't add either. is this normal?

    On May 11, 5:42 pm, Marshall Barton <> wrote:
    > p-rat wrote:
    > >I have a form where we enter data. On this main form there is a sub-
    > >form. It is continuous form. I can add as many items as I need and it
    > >works great.

    >
    > >I can then go through an EDIT button on my switchboard and it'll ask
    > >for example the Ticket Number. I type in the ticket number and it'll
    > >pull up the form with all the data that was entered during the data
    > >entry process. I can change things throughout; even in the sub-form,
    > >but I can't ADD a record in the sub-form.

    >
    > >In data entry process you can TAB through the continuous sub-form and
    > >it'll create as many records as needed. When tabbing through in the
    > >EDIT phase it won't create any new records.

    >
    > >How do I solve this? I need to be able to add another record. Thanks.

    >
    > ... and check the switchboard EDIT button's Click event
    > procedure.  Look at the OpenForm line and make sure the
    > Datamode argument is acFormEdit (or not specified if the
    > form's properties have bot AllowEdits and AllowAdditions set
    > to Yes).
    >
    > --
    > Marsh
    > MVP [MS Access]- Hide quoted text -
    >
    > - Show quoted text -
     
    p-rat, May 12, 2009
    #4
  5. Some queries are not updateable. It depends on how they are related and
    normalized. Sorry, I don't know the answer otherwise.

    Bonnie
    http://www.dataplus-svc.com

    p-rat wrote:
    >i've checked AllowEdits and AllowAdditions and they are both set to
    >yes. i also checked the EDIT button and don't see any code as Marshall
    >mentioned. when run a query i can't add either. is this normal?
    >
    >> >I have a form where we enter data. On this main form there is a sub-
    >> >form. It is continuous form. I can add as many items as I need and it

    >[quoted text clipped - 23 lines]
    >>
    >> - Show quoted text -


    --

     
    bhicks11 via AccessMonster.com, May 12, 2009
    #5
  6. On Mon, 11 May 2009 17:42:25 -0700 (PDT), p-rat <> wrote:

    > when run a query i can't add either. is this normal?


    Normal... for a non-updateable query, which would also cause the other
    symptom!

    There are many reasons why a query might not be updateable. A multitable query
    will only be updateable if the joins are from fields with a unique index (such
    as a primary key) to an indexed field; if there are too many tables even that
    might not help. No Totals query, nor any query containing a Totals query, is
    ever updateable; a UNIQUE VALUES query (starting with SELECT DISTINCT... in
    SQL view) isn't; a UNION query isn't; other reasons. Perhaps you could open
    the query in SQL view and post it here.
    --

    John W. Vinson [MVP]
     
    John W. Vinson, May 12, 2009
    #6
  7. p-rat

    p-rat Guest

    Sorry I'm not more versed in Access, but I can ADD directly to table
    and ADD during data entry. Here is the SQL for the query used on
    subform during EDIT:

    SELECT

    dbo_PayrollDetail.DailyWorkTicketNumber,
    IIf(dbo_PayrollDetail.Date Is
    Null,dbo_MercerDailyWorkTicketHdr.Date,dbo_PayrollDetail.Date) AS
    Date1,
    dbo_PayrollDetail.EmployeeNumber, dbo_PayrollDetail.EmployeeName,
    dbo_PayrollDetail.JobTitle, dbo_PayrollDetail.TravelTime,
    dbo_PayrollDetail.WorkTimeOnJob, dbo_PayrollDetail.CoTime,
    dbo_PayrollDetail.CostCenter, dbo_PayrollDetail.Hours,
    dbo_PayrollDetail.PayCategory, dbo_PayrollDetail.Misc_Text_Field_1,
    dbo_PayrollDetail.Misc_Text_Field_2,
    dbo_PayrollDetail.Misc_Text_Field_3

    FROM dbo_PayrollDetail INNER JOIN dbo_MercerDailyWorkTicketHdr ON
    dbo_PayrollDetail.DailyWorkTicketNumber =
    dbo_MercerDailyWorkTicketHdr.DailyWorkTicketNumber;


    thanks for any help.



    On May 11, 9:41 pm, John W. Vinson
    <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
    > On Mon, 11 May 2009 17:42:25 -0700 (PDT), p-rat <> wrote:
    > > when run a query i can't add either. is this normal?

    >
    > Normal... for a non-updateable query, which would also cause the other
    > symptom!
    >
    > There are many reasons why a query might not be updateable. A multitable query
    > will only be updateable if the joins are from fields with a unique index (such
    > as a primary key) to an indexed field; if there are too many tables even that
    > might not help. No Totals query, nor any query containing a Totals query,is
    > ever updateable; a UNIQUE VALUES query (starting with SELECT DISTINCT... in
    > SQL view) isn't; a UNION query isn't; other reasons. Perhaps you could open
    > the query in SQL view and post it here.
    > --
    >
    >              John W. Vinson [MVP]
     
    p-rat, May 12, 2009
    #7
  8. On Tue, 12 May 2009 07:26:06 -0700 (PDT), p-rat <> wrote:

    >Sorry I'm not more versed in Access, but I can ADD directly to table
    >and ADD during data entry. Here is the SQL for the query used on
    >subform during EDIT:
    >
    >SELECT
    >
    >dbo_PayrollDetail.DailyWorkTicketNumber,
    >IIf(dbo_PayrollDetail.Date Is
    >Null,dbo_MercerDailyWorkTicketHdr.Date,dbo_PayrollDetail.Date) AS
    >Date1,
    >dbo_PayrollDetail.EmployeeNumber, dbo_PayrollDetail.EmployeeName,
    >dbo_PayrollDetail.JobTitle, dbo_PayrollDetail.TravelTime,
    >dbo_PayrollDetail.WorkTimeOnJob, dbo_PayrollDetail.CoTime,
    >dbo_PayrollDetail.CostCenter, dbo_PayrollDetail.Hours,
    >dbo_PayrollDetail.PayCategory, dbo_PayrollDetail.Misc_Text_Field_1,
    >dbo_PayrollDetail.Misc_Text_Field_2,
    >dbo_PayrollDetail.Misc_Text_Field_3
    >
    >FROM dbo_PayrollDetail INNER JOIN dbo_MercerDailyWorkTicketHdr ON
    >dbo_PayrollDetail.DailyWorkTicketNumber =
    >dbo_MercerDailyWorkTicketHdr.DailyWorkTicketNumber;
    >
    >
    >thanks for any help.


    First off... why are you joining the payrolldetail table to the work ticket
    hdr table for this form? Typically - not universally, but typically - one
    would use a Form for the "one" side table and a Subform for the "many". I'm
    not clear which is which in this case.

    Secondly, obviously the Date1 field will not be updateable since it's
    calculated. Other than that, is DailyWorkTicketNumber the Primary Key of
    MercerDailyWorkTicketHdr? It should be in order for the query to be
    updateable. You may also need to include tat field from both tables in the
    query's SELECT clause.
    --

    John W. Vinson [MVP]
     
    John W. Vinson, May 12, 2009
    #8
  9. p-rat

    p-rat Guest

    Subform is for the 'many'. On the main form it is for header
    information such as customer, location, etc. The sub-form are the
    employees who worked on that ticket (could be 1 employee or many
    employees on that 1 ticket).

    Problem is that not all employees have hours on a work ticket. So I
    have two data entries for payroll hours. One being the DailyWorkTicket
    form and another just a form that only captures payroll
    information ....not all or any ticket information. This payroll
    information from both places is in one table. I believe why they did
    things this way was that if the hours were on a DailyWorkTicket then
    the date came from this table, but if the hours came from the payroll
    form then the date came from this table. Kind of screwy. Hope this
    might clear some of that up.



    On May 12, 10:52 am, John W. Vinson
    <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
    > On Tue, 12 May 2009 07:26:06 -0700 (PDT), p-rat <> wrote:
    > >Sorry I'm not more versed in Access, but I can ADD directly to table
    > >and ADD during data entry. Here is the SQL for the query used on
    > >subform during EDIT:

    >
    > >SELECT

    >
    > >dbo_PayrollDetail.DailyWorkTicketNumber,
    > >IIf(dbo_PayrollDetail.Date Is
    > >Null,dbo_MercerDailyWorkTicketHdr.Date,dbo_PayrollDetail.Date) AS
    > >Date1,
    > >dbo_PayrollDetail.EmployeeNumber, dbo_PayrollDetail.EmployeeName,
    > >dbo_PayrollDetail.JobTitle, dbo_PayrollDetail.TravelTime,
    > >dbo_PayrollDetail.WorkTimeOnJob, dbo_PayrollDetail.CoTime,
    > >dbo_PayrollDetail.CostCenter, dbo_PayrollDetail.Hours,
    > >dbo_PayrollDetail.PayCategory, dbo_PayrollDetail.Misc_Text_Field_1,
    > >dbo_PayrollDetail.Misc_Text_Field_2,
    > >dbo_PayrollDetail.Misc_Text_Field_3

    >
    > >FROM dbo_PayrollDetail INNER JOIN dbo_MercerDailyWorkTicketHdr ON
    > >dbo_PayrollDetail.DailyWorkTicketNumber =
    > >dbo_MercerDailyWorkTicketHdr.DailyWorkTicketNumber;

    >
    > >thanks for any help.

    >
    > First off... why are you joining the payrolldetail table to the work ticket
    > hdr table for this form? Typically - not universally, but typically - one
    > would use a Form for the "one" side table and a Subform for the "many". I'm
    > not clear which is which in this case.
    >
    > Secondly, obviously the Date1 field will not be updateable since it's
    > calculated. Other than that, is DailyWorkTicketNumber the Primary Key of
    > MercerDailyWorkTicketHdr? It should be in order for the query to be
    > updateable. You may also need to include tat field from both tables in the
    > query's SELECT clause.
    > --
    >
    >              John W. Vinson [MVP]- Hide quoted text -
    >
    > - Show quoted text -
     
    p-rat, May 12, 2009
    #9
  10. On Tue, 12 May 2009 12:33:02 -0700 (PDT), p-rat <> wrote:

    >Subform is for the 'many'. On the main form it is for header
    >information such as customer, location, etc. The sub-form are the
    >employees who worked on that ticket (could be 1 employee or many
    >employees on that 1 ticket).
    >
    >Problem is that not all employees have hours on a work ticket. So I
    >have two data entries for payroll hours. One being the DailyWorkTicket
    >form and another just a form that only captures payroll
    >information ....not all or any ticket information. This payroll
    >information from both places is in one table. I believe why they did
    >things this way was that if the hours were on a DailyWorkTicket then
    >the date came from this table, but if the hours came from the payroll
    >form then the date came from this table. Kind of screwy. Hope this
    >might clear some of that up.


    Wow, no; it makes it considerably more confusing!

    I'm not sure what a "work ticket" is; nor why it's still necessary to base the
    subform on a joined query. It SOUNDS like the subform could be based just on
    the PayrollDetail table, using the DailyOrkTicketNumber as the master/child
    link field. If not, try opening the query as a query datasheet. Is *IT*
    updateable? If it's not, is DailyWorkTicketNumber the primary key of
    MercerDailyWorkTicketHdr, or does it have a unique Index?

    >
    >
    >
    >On May 12, 10:52 am, John W. Vinson
    ><jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
    >> On Tue, 12 May 2009 07:26:06 -0700 (PDT), p-rat <> wrote:
    >> >Sorry I'm not more versed in Access, but I can ADD directly to table
    >> >and ADD during data entry. Here is the SQL for the query used on
    >> >subform during EDIT:

    >>
    >> >SELECT

    >>
    >> >dbo_PayrollDetail.DailyWorkTicketNumber,
    >> >IIf(dbo_PayrollDetail.Date Is
    >> >Null,dbo_MercerDailyWorkTicketHdr.Date,dbo_PayrollDetail.Date) AS
    >> >Date1,
    >> >dbo_PayrollDetail.EmployeeNumber, dbo_PayrollDetail.EmployeeName,
    >> >dbo_PayrollDetail.JobTitle, dbo_PayrollDetail.TravelTime,
    >> >dbo_PayrollDetail.WorkTimeOnJob, dbo_PayrollDetail.CoTime,
    >> >dbo_PayrollDetail.CostCenter, dbo_PayrollDetail.Hours,
    >> >dbo_PayrollDetail.PayCategory, dbo_PayrollDetail.Misc_Text_Field_1,
    >> >dbo_PayrollDetail.Misc_Text_Field_2,
    >> >dbo_PayrollDetail.Misc_Text_Field_3

    >>
    >> >FROM dbo_PayrollDetail INNER JOIN dbo_MercerDailyWorkTicketHdr ON
    >> >dbo_PayrollDetail.DailyWorkTicketNumber =
    >> >dbo_MercerDailyWorkTicketHdr.DailyWorkTicketNumber;

    >>
    >> >thanks for any help.

    >>
    >> First off... why are you joining the payrolldetail table to the work ticket
    >> hdr table for this form? Typically - not universally, but typically - one
    >> would use a Form for the "one" side table and a Subform for the "many". I'm
    >> not clear which is which in this case.
    >>
    >> Secondly, obviously the Date1 field will not be updateable since it's
    >> calculated. Other than that, is DailyWorkTicketNumber the Primary Key of
    >> MercerDailyWorkTicketHdr? It should be in order for the query to be
    >> updateable. You may also need to include tat field from both tables in the
    >> query's SELECT clause.
    >> --
    >>
    >>              John W. Vinson [MVP]- Hide quoted text -
    >>
    >> - Show quoted text -

    --

    John W. Vinson [MVP]
     
    John W. Vinson, May 12, 2009
    #10
  11. p-rat

    bpatrickmfrncesa6015

    Joined:
    Feb 17, 2013
    Messages:
    1
    Likes Received:
    0
    Internet

    The prestige of positioning the domain
    Anyone who has in any case stopped to take-home pay a AS FAR AS SOMETHING IN empire had to pass a plight of time to invent the appropriate names How not to weaken formerly and affluence, how to engender a domain respect that leave be healthy in terms of positioning of the page?
    It intention be a well-known year! We are preparing more hints and tips such as the search representing a all right idea in return a charge, getting financing and customer acquisition
    twoj rzeszow pl/2013/01/25/pozyczka-rzeszow/]chwilówka
    Keywords in the property name
    eerinrpg com/index php?title=User:vcdjtte ]homepage
    All-embracing, the thesis of the search appliance (Google) depends on two factors - the companionship of search words / phrases in the satisfaction and links with the phrase pointing to the page I be required to note that URLs are treated in the rank of content, so the keyword appearing to include this part positioning
    goodfamilyrecipes com/reklama-warszawa/ ]zobacz wiecej
    Excuse's move to sire the domain If the kingdom is to be euphemistic pre-owned for the convention's website, this happening is simpler
    hdmac org/forum/profile php?id=236164 ]website
    Start beside creating a record of keywords associated to your business Then chosen a few key These words can be used to form a domain name

    If all domains are busy you can whack at to annex the "e-" in front of the lands name an eye to archetype: e-ogrzewanie pl
    ceconsult hu/wiki/index php?title=User:auwwuvajhr ]homepage
    If your role operates locally, it is value to acquisition bargain a province in preference to of local realm ending in Eng - norm - I purchased the realm client ogrzewanie bialystok pl - the main collocution (Heating Białystok) in which the positions page-boy is included in the domain The effects are good

     

    Unfortunately, in some industries tournament is stupendous and most of the domains with the keyword is used In this patient, I advocated the take of the company name If he would like to purchase a empire with the word SEO is I had to conceive a domain-polinfor positioning -> + or institution name word This is a dependable crumble as long as the friends esteem and keyword are more short and serenely to remember

    The following illustration of the effectiveness of the keyword in the domain - the expression "AdWords Campaigns" - (Google thickens keywords):
    kartikonline co in/guitar/members/unsulnepisa/activity/1481 ]zobacz wiecej


    eleo-budmax com pl/NARZEDZIA-BUDOWLANE_LASERY-PUNKTOWE(2,34644,) aspx]lasery punktowe
    How to fix up your episode using the tricks of the address?
    Sub-domain - a good deceit is to create an additional mini-sites for distinctive keywords and burden them in the sub-domain service As you can take care in the heavens instance - the intelligence in the sub-domain adds a few points to establish - that is the +
    Warm-hearted links - supervised this tag lies a resourceful way to make a sub-address (including software deals with the website or webmaster - depends on the implementation of the technology, with me doing my CMS) Here is an example at home links - the phrase "adwords campaigns bounty list":
    Catalogs - if the directory contains the address of the name can be used alongside placing the keyword there - eg polinfor pl / Positioning /
    These not many tricks should improve you bring off richer reconsider results positioning
    asfwe kredytnaszybko eu/23816-strona-Wysokie odszkodowania ]upon
    dbd10 071magazine pl/e/Reklama-Warszawa,19391 ]zobacz wiecej
    hgp hr/members/addeneicvak/activity/2140 ]homepage
    Laconic:
    Domain with the keyword / clich‚ and placing keywords in the attendant direct and website pages helps in positioning

    In good time I bequeath discuss the bearing of the elements and the content optimization tricks
     
    bpatrickmfrncesa6015, Feb 17, 2013
    #11
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.