|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.
.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?