ACCESS PRIOJECT, MS GRAPH, STORED PROCEDURE

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)
 
A

Alex Dybenko

Hi Zlatko,
i think i have answered you (or similar questuion) yesterday
idea - is to replace parameters with values
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Graph, parameters, strored procedure 5
Using Stored Procedures With Access Data Project 2
recordset (VBA) for graph ? 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
From Access how to create stored procedure in SQL server 4
Stored procedure with two parameters 3
Create Stored Procedure in SQL server from Access VBA? 4
ADODB Command (Stored Procedure) 14

Top