asked on

Add an editable column to a bound query

I am pulling up the following query to my datagrid in a vb6 form. The resulting query results cannot be edited, However, I would like to add a temporary column at the end of the results which will enable me to add temporary data. Is this possible?

select g.Agency,g.Goal,o.Objective,p.PI,P.Method,a.[ActivityName],P.[ProjectedHours],a.Data, s.ProgressSetback
from tblOrgGoals G 
LEFT Join tblOrgObjectives O on G.GoalID = O.GoalID and g.agencyid=o.agencyid
LEFT Join tblOrgActivities A on O.ObjectiveID = A.ObjectiveID and g.agencyid=a.agencyid
LEFT Join tblOrgPI P on P.ActivityID = A.ActivityID and g.agencyid=p.agencyid
LEFT Join tblOrgMonthlyProgressSetbacks S on p.PIID = s.piid and g.agencyid=s.agencyid
Where s.AgencyID = 74 And s.monthlyid = 3 And s.piid = 1  order by G.Agency,G.Goal

Open in new window

al4629740

ASKER

This question asks how to add an additional column at the end of a table in a datagrid. Different question, but delete if you deem it to be so.

ASKER CERTIFIED SOLUTION

Brian Crowe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

al4629740

ASKER

Thank you. That's exactly what I was looking for. Is there a way to edit the column directly with the mouse? Either Datagrid or msflexgrid?

Brian Crowe

Unfortunately that's more of a VB question and I haven't done any VB programming in years.

I would suggest posting another question or googling it.