|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 2nd, 2009, 05:23 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
SubForm Issue
I have a tabular form with subforms built in. One of the subforms is not
showing "New (blank) Record" at the bottom of the screen for new data entry. I have looked on the form itself as well and cannot find the problem. Any ideas as to where i can look for a solution? 
|
|
#2
October 2nd, 2009, 06:19 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
SubForm Issue
On Fri, 2 Oct 2009 09:23:01 -0700, Colby
wrote: I have a tabular form with subforms built in. One of the subforms is not showing "New (blank) Record" at the bottom of the screen for new data entry. I have looked on the form itself as well and cannot find the problem. Any ideas as to where i can look for a solution? Most likely the problem is that the Query that the subform is using as its recordsource is not updateable. What's the Query? If you open it directly, is there a new record? You could open the query in SQL view and post the SQL text here if you can't figure out why it's not accepting new data. -- John W. Vinson [MVP]
|
|
#3
October 2nd, 2009, 08:23 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
SubForm Issue
John,
When I open the form there is not a new record. The form is for entering data on physician "core measures" quarerly. It is pullind data that is directly entered into the table, just not allowing a new (blank) record. Here is the SQL text, though it looks pretty dang confusing. SELECT Core_Measures_tbl.Medical_ID, Core_Measures_tbl.Quarter, Core_Measures_tbl.AMI_Aspirin_at_Arrival_Numerator , Core_Measures_tbl.AMI_Aspirin_at_Arrival_Denominat or, Core_Measures_tbl.AMI_Aspirin_at_Discharge_Numerat or, Core_Measures_tbl.AMI_Aspirin_at_Discharge_Denomin ator, Core_Measures_tbl.[AMI_ACE/ARB_Numerator], Core_Measures_tbl.[AMI_ACE/ARB_Denominator], Core_Measures_tbl.AMI_BB_Discharge_Numerator, Core_Measures_tbl.AMI_BB_Discharge_Denominator, Core_Measures_tbl.AMI_PCI_90min_Numerator, Core_Measures_tbl.AMI_PCI_90min_Denominator, Core_Measures_tbl.AMI_Fibrinolytic_30_Numerator, Core_Measures_tbl.AMI_Fibrinolytic_30_Denominator, Core_Measures_tbl.AMI_Mortality_Numerator, Core_Measures_tbl.AMI_Mortality_Denominator, CMS_90th_percentile.AMI_CMS_90_percentile, Core_Measures_tbl.PN_Blood_prior_ABX_Numerator, Core_Measures_tbl.PN_Blood_prior_ABX_Denominator, Core_Measures_tbl.PN_Blood_24hr_ICU_Numerator, Core_Measures_tbl.PN_Blood_24hr_ICU_Denominator, Core_Measures_tbl.PN_AbxSelection_ICU_Numerator, Core_Measures_tbl.PN_AbxSelection_ICU_Denominator, Core_Measures_tbl.PN_AbxSelection_NON_ICU, Core_Measures_tbl.PN_AbxSelection_NON_ICU_Numerato r, Core_Measures_tbl.PN_AbxSelection_NON_ICU_Denomina tor, CMS_90th_percentile.PN_CMS_90_percentile, Core_Measures_tbl.CHF_EvalLVS_Numerator, Core_Measures_tbl.CHF_EvalLVS_Denominator, Core_Measures_tbl.[CHF_ACE/ARB_Numerator], Core_Measures_tbl.[CHF_ACE/ARB_Denominator], CMS_90th_percentile.CHF_CMS_90_percentile, Core_Measures_tbl.[SCIP_Prohph_Abx_w/in_1_hr_to_incision], Core_Measures_tbl.[SCIP_Prohph_Abx_w/in_1_hr_to_incision_Numerator], Core_Measures_tbl.[SCIP_Prohph_Abx_w/in_1_hr_to_incision_Denominator], Core_Measures_tbl.SCIP_Proph_Abx_Selection_Numerat or, Core_Measures_tbl.SCIP_Proph_Abx_Selection_Denomin ator, Core_Measures_tbl.SCIP_SurgPts_hair_removal_Numera tor, Core_Measures_tbl.SCIP_SurgPts_hair_removal_Denomi nator, Core_Measures_tbl.SCIP_SurgPts_VTEProph_Numerator, Core_Measures_tbl.SCIP_SurgPts_VTEProph_Denominato r, Core_Measures_tbl.SCIP_SurgPts_BetaBlockers_Numera tor, Core_Measures_tbl.SCIP_SurgPts_BetaBlockers_Denomi nator, CMS_90th_percentile.SCIP_CMS_90_Percentile, Core_Measures_tbl.OUTAMI_Fibrinolytic_30ED_Numerat or, Core_Measures_tbl.OUTAMI_Fibrinolytic_30ED_Denomin ator, Core_Measures_tbl.OUTAMI_Aspirin_Arrival_Numerator , Core_Measures_tbl.OUTAMI_Aspirin_Arrival_Denominat or, Core_Measures_tbl.OUTSCIP_Proph_1hr_incision_Numer ator, Core_Measures_tbl.OUTSCIP_Proph_1hr_incision_Denom inator, Core_Measures_tbl.OUTSCIP_Proph_AbxSelection_Numer ator, Core_Measures_tbl.OUTSCIP_Proph_AbxSelection_Denom inator FROM Core_Measures_tbl LEFT JOIN CMS_90th_percentile ON Core_Measures_tbl.Quarter = CMS_90th_percentile.Quarter; "John W. Vinson" wrote: On Fri, 2 Oct 2009 09:23:01 -0700, Colby wrote: I have a tabular form with subforms built in. One of the subforms is not showing "New (blank) Record" at the bottom of the screen for new data entry. I have looked on the form itself as well and cannot find the problem. Any ideas as to where i can look for a solution? Most likely the problem is that the Query that the subform is using as its recordsource is not updateable. What's the Query? If you open it directly, is there a new record? You could open the query in SQL view and post the SQL text here if you can't figure out why it's not accepting new data. -- John W. Vinson [MVP]
|
|
#4
October 2nd, 2009, 09:25 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
SubForm Issue
John,
I actually figured it out... but thanks "Colby" wrote: John, When I open the form there is not a new record. The form is for entering data on physician "core measures" quarerly. It is pullind data that is directly entered into the table, just not allowing a new (blank) record. Here is the SQL text, though it looks pretty dang confusing. SELECT Core_Measures_tbl.Medical_ID, Core_Measures_tbl.Quarter, Core_Measures_tbl.AMI_Aspirin_at_Arrival_Numerator , Core_Measures_tbl.AMI_Aspirin_at_Arrival_Denominat or, Core_Measures_tbl.AMI_Aspirin_at_Discharge_Numerat or, Core_Measures_tbl.AMI_Aspirin_at_Discharge_Denomin ator, Core_Measures_tbl.[AMI_ACE/ARB_Numerator], Core_Measures_tbl.[AMI_ACE/ARB_Denominator], Core_Measures_tbl.AMI_BB_Discharge_Numerator, Core_Measures_tbl.AMI_BB_Discharge_Denominator, Core_Measures_tbl.AMI_PCI_90min_Numerator, Core_Measures_tbl.AMI_PCI_90min_Denominator, Core_Measures_tbl.AMI_Fibrinolytic_30_Numerator, Core_Measures_tbl.AMI_Fibrinolytic_30_Denominator, Core_Measures_tbl.AMI_Mortality_Numerator, Core_Measures_tbl.AMI_Mortality_Denominator, CMS_90th_percentile.AMI_CMS_90_percentile, Core_Measures_tbl.PN_Blood_prior_ABX_Numerator, Core_Measures_tbl.PN_Blood_prior_ABX_Denominator, Core_Measures_tbl.PN_Blood_24hr_ICU_Numerator, Core_Measures_tbl.PN_Blood_24hr_ICU_Denominator, Core_Measures_tbl.PN_AbxSelection_ICU_Numerator, Core_Measures_tbl.PN_AbxSelection_ICU_Denominator, Core_Measures_tbl.PN_AbxSelection_NON_ICU, Core_Measures_tbl.PN_AbxSelection_NON_ICU_Numerato r, Core_Measures_tbl.PN_AbxSelection_NON_ICU_Denomina tor, CMS_90th_percentile.PN_CMS_90_percentile, Core_Measures_tbl.CHF_EvalLVS_Numerator, Core_Measures_tbl.CHF_EvalLVS_Denominator, Core_Measures_tbl.[CHF_ACE/ARB_Numerator], Core_Measures_tbl.[CHF_ACE/ARB_Denominator], CMS_90th_percentile.CHF_CMS_90_percentile, Core_Measures_tbl.[SCIP_Prohph_Abx_w/in_1_hr_to_incision], Core_Measures_tbl.[SCIP_Prohph_Abx_w/in_1_hr_to_incision_Numerator], Core_Measures_tbl.[SCIP_Prohph_Abx_w/in_1_hr_to_incision_Denominator], Core_Measures_tbl.SCIP_Proph_Abx_Selection_Numerat or, Core_Measures_tbl.SCIP_Proph_Abx_Selection_Denomin ator, Core_Measures_tbl.SCIP_SurgPts_hair_removal_Numera tor, Core_Measures_tbl.SCIP_SurgPts_hair_removal_Denomi nator, Core_Measures_tbl.SCIP_SurgPts_VTEProph_Numerator, Core_Measures_tbl.SCIP_SurgPts_VTEProph_Denominato r, Core_Measures_tbl.SCIP_SurgPts_BetaBlockers_Numera tor, Core_Measures_tbl.SCIP_SurgPts_BetaBlockers_Denomi nator, CMS_90th_percentile.SCIP_CMS_90_Percentile, Core_Measures_tbl.OUTAMI_Fibrinolytic_30ED_Numerat or, Core_Measures_tbl.OUTAMI_Fibrinolytic_30ED_Denomin ator, Core_Measures_tbl.OUTAMI_Aspirin_Arrival_Numerator , Core_Measures_tbl.OUTAMI_Aspirin_Arrival_Denominat or, Core_Measures_tbl.OUTSCIP_Proph_1hr_incision_Numer ator, Core_Measures_tbl.OUTSCIP_Proph_1hr_incision_Denom inator, Core_Measures_tbl.OUTSCIP_Proph_AbxSelection_Numer ator, Core_Measures_tbl.OUTSCIP_Proph_AbxSelection_Denom inator FROM Core_Measures_tbl LEFT JOIN CMS_90th_percentile ON Core_Measures_tbl.Quarter = CMS_90th_percentile.Quarter; "John W. Vinson" wrote: On Fri, 2 Oct 2009 09:23:01 -0700, Colby wrote: I have a tabular form with subforms built in. One of the subforms is not showing "New (blank) Record" at the bottom of the screen for new data entry. I have looked on the form itself as well and cannot find the problem. Any ideas as to where i can look for a solution? Most likely the problem is that the Query that the subform is using as its recordsource is not updateable. What's the Query? If you open it directly, is there a new record? You could open the query in SQL view and post the SQL text here if you can't figure out why it's not accepting new data. -- John W. Vinson [MVP]
|
|
#5
October 2nd, 2009, 09:33 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
SubForm Issue
On Fri, 2 Oct 2009 12:23:01 -0700, Colby
wrote: FROM Core_Measures_tbl LEFT JOIN CMS_90th_percentile ON Core_Measures_tbl.Quarter = CMS_90th_percentile.Quarter; This is probably the problem: how, if at all, are the tables Core_Mesures_Tbl and CMS_90th_percentile related in the Relationships window? Is Quarter the Primary Key of either table? You are *clearly* "committing spreadsheet" - that's far too many fields for any properly normalized database, and many of them appear from the fieldnames to be calculated values. Naturally, calculated values cannot be updated. -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
