<div>
How are you returning the value in the stored procedure ? Output parameter, return value?
</div>


How are you returning the value in the stored procedure ? Output parameter, return value?

<div>
Just returning a value<br />
<br />
Also...watch for additional question
</div>


Just returning a value

Also...watch for additional question

<div>
PLease post your Stored Procedure, I know you are returning a value I need to understand what method you are using to return the value if you are at all
</div>


PLease post your Stored Procedure, I know you are returning a value I need to understand what method you are using to return the value if you are at all

<div>
<div class="content wysiwyg-content">
I have a button that on click I want to execute a stored procedure and then set a variable )strEnc) to the returned value of the column name (encContactID)<br />
<br />
Been in .Net for a while and sp can't see where I set the variable from this<br />
<br />
&nbsp; &nbsp; Set cmd.ActiveConnection = Conn<br />
&nbsp; &nbsp; cmd.CommandType = adCmdStoredProc<br />
&nbsp; &nbsp; cmd.CommandText = &quot;[usp_EncryptClientContact<wbr />ID]&quot;<br />
&nbsp; &nbsp; cmd.Parameters(&quot;@ContactID<wbr />&quot;) = Me.[Contact ID]<br />
&nbsp; &nbsp; cmd.Execute
</div>
</div>


I have a button that on click I want to execute a stored procedure and then set a variable )strEnc) to the returned value of the column name (encContactID)

Been in .Net for a while and sp can't see where I set the variable from this

    Set cmd.ActiveConnection = Conn
    cmd.CommandType = adCmdStoredProc
    cmd.CommandText = "[usp_EncryptClientContactID]"
    cmd.Parameters("@ContactID") = Me.[Contact ID]
    cmd.Execute

MS Access data from Stored Procedure

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.