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

P

p-rat

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.
 
M

Marshall Barton

p-rat said:
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).
 
P

p-rat

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?

p-rat said:
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 -
 
B

bhicks11 via AccessMonster.com

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 said:
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?
[quoted text clipped - 23 lines]
- Show quoted text -
 
J

John W. Vinson

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.
 
P

p-rat

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.
 
J

John W. Vinson

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.
 
P

p-rat

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.
 
J

John W. Vinson

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?
 
Joined
Feb 17, 2013
Messages
1
Reaction score
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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top