ACCESS PRIOJECT, MS GRAPH, STORED PROCEDURE

  • Thread starter Thread starter Zlatko
  • Start date Start date
Z

Zlatko

I am dealing with very frustrating problem: I don't know how to pass
parameters to the stored procedure which is row source of MS Graph in Access
PROJECT form.
The problem apears because there is no Input Parameters property on the MS
Graph (unlike forms)...
Of cours, I can pass parametrs explicitely, using EXEC NameOfStoredProcedure
'value1','value2' etc...but I should reference some controls from other form
EXEC NameOfStoredProcedure, @parameter1=ReferenceToControl,
@parameter2=ReferenceToControl....etc, which seems to be impossible because
the query is executed on SQL Server, while forms are placed in Access front
end...

If there is somebody familiar with Acces Project as front end for SQL
Server, please help me !
Is there any substitute for MS Graph if there is no solution for this
problem ?
Is there any similar easy, intuitive, user-friendly substitute for Access
front-end for SQL Server?

Thank you in advance!

Zlatko

(e-mail address removed)
 
Hi Zlatko,
i think i have answered you (or similar questuion) yesterday
idea - is to replace parameters with values
 
Back
Top