That was easy. Thanks.
Now, the decision of which record sources to create as SP in SQL, and which as PT queries in Access. That's more of a business/personnel question than a technical one. I'm not the SQL dba. Either way, I can write most of the SQL code.
- Create unbound text/combo fields on top of the bound fields. When clicking into the bound field, unhide and move focus to the unbound field.
- Write SQL, and VBA to execute the SQL to update the underlying table(s).
- Refresh the form
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
Date: Mon, 25 Apr 2016 15:40:09 -0700
Subject: [MS_AccessPros] Opening SQL stored procedure in datasheet view
How do I open a SQL stored procedure (SP) - e.g., named "usp_Proc1" - in Access datasheet view? This seems like a basic question, but I haven't been able to find a simple answer on the internet. The SP is a SELECT query. If needed, assume I have a connection string stConn.
The follow up need is how then to use that (and other) SPs as the recordsource for forms and reports.
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|