ACCESS FEED: Re: [MS_AccessPros] Append to table

Selasa, 23 April 2013

Re: [MS_AccessPros] Append to table

Duane,
Thanks. I have changed the control names from text252, text260 to meaningful names.

Regards,
kumar

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Kumar,
>
> I'm glad to hear you got this working.
>
> IMO, If you want to kick your development up a notch, never be satisfied with control names like text252, text260,... Take the time to make these names more explicit.
>
> Duane Hookom MVP
> MS Access
>
>
> ----------------------------------------
> > From: access_kri@...
> >
> > Hi Duane,
> > I got it working and SQL view is as follows:
> > INSERT INTO T_KPI ( PlannedStartDate, JobCount, PercentScheduled, PercentCompleted )
> > SELECT [Forms]![F_LaundryjobList]![cboPlannedDate] AS PlannedDate, [Forms]![F_LaundryjobList]![text252] AS JC, [Forms]![F_LaundryJobList]![Text260] AS PercentScheduled, [Forms]![F_LaundryjobList]![Text262] AS PercentCompleted;
> >
> > Earlier, I made a mistake of adding T_KPI in the append query and hence not working/
> >
> >
> > Thanks and Regards,
> > Kumar
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > >
> > > Kumar,
> > >
> > > We don't generally recommend storing data that can be calculated.
> > >
> > > We do recommend providing he SQL view of the query when you ask why the query isn't working ;-)
> > >
> > > Duane Hookom MVP
> > > MS Access
> > >
> > > ----------------------------------------
> > > > From: access_kri@
> > > >
> > > > Hello all,
> > > > I have a form where I have various textboxes to display the daily report results. The results are displayed using Dlookup of queries. I want to now save the results/data in a MIS table through a command button.
> > > > I created a blank MIS table and used append query to add data from MIS form. Somehow, no data is appended to the table. Why?
> > > >
> > > > Kind Regards,
> > > > kumar
>