ACCESS PROJECT, MS GRAPH, STORED PROCEDURE

[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

zl**********@pliva.hr

[Steve Jorgensen]

It's been a while since I did that, but it seems to me that I solved it by
just dynamically generating the SQL. If the parameter values come from fields
on a form, just make sure the OnCurrent handler for the form regenerates the
SQL and writes it to the MS Graph object.

On Fri, 15 Oct 2004 09:03:31 +0200, "Zlatko" <zl**********@pliva.hr> wrote:

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

zl**********@pliva.hr

[Zlatko]

Thank you for the answer.
Can you please give some example ? How do you mean "dynamically generating
the SQL" OnCurrent ?
Thanks.

"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:t2********************************@4ax.com...

It's been a while since I did that, but it seems to me that I solved it by
just dynamically generating the SQL. If the parameter values come from fields on a form, just make sure the OnCurrent handler for the form regenerates the SQL and writes it to the MS Graph object.

On Fri, 15 Oct 2004 09:03:31 +0200, "Zlatko" <zl**********@pliva.hr> wrote:

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 AccessPROJECT form.
The problem apears because there is no Input Parameters property on the MSGraph (unlike forms)...
Of cours, I can pass parametrs explicitely, using EXEC NameOfStoredProcedure'value1','value2' etc...but I should reference some controls from other formEXEC NameOfStoredProcedure, @parameter1=ReferenceToControl,
@parameter2=ReferenceToControl....etc, which seems to be impossible becausethe query is executed on SQL Server, while forms are placed in Access frontend...

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

zl**********@pliva.hr