Can somebody help me decipher a parameter statement

Giganews Newsgroups
Subject: Can somebody help me decipher a parameter statement
Posted by:  Patrick Finucane (patrickfinucane…@gmail.com)
Date: Sat, 13 Apr 2019

I am working on an Adp file, not an accdb.  The backend is SQL Server.  The following is a code snippet in a module.

With cmdCheck
        .ActiveConnection = GetBEConnection
        .CommandText = strspLocalCheck
        .CommandType = adCmdStoredProc

        .Parameters("@" & cPrintID).Value = frmSelect.Controls(cPrintID).Value
        .Parameters("@" & cLocalStaff).Value = gstrStaff

Can anyone figure out what the heck the parameter statements are doing?

Could the parameter be passed to a stored procedure?  In an adp is a stored procedure visible to the developer or is it hidden?

when I open a query in design mode, often the query builder is blank with no tables or fields displayed.  is that normal?

Replies