By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

ACCESS PROJECT, MS GRAPH, STORED PROCEDURE

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.