ACCESS FEED: RE: [MS_AccessPros] Append to table

Senin, 22 April 2013

RE: [MS_AccessPros] Append to table

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@yahoo.com
>
> 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