Thanks. I will. In programing (do a bit of VBA) I always fight with var names. Too long vs. not discriptive enough.

Also, I see you point on...

thanks Sean for the tips.

unfortunately changing the names currently used would be quite a lot of work as it is not only tied to Access but several Visio floor plan...

Will try that. Found the Criteria window (right click the View and select DESIGN)

man, this interface is not very user friendly... Well I guess when it comes to...

I was thinking that...

I did comment it all out and try just the bare bones, and that worked.

I am not the best at the syntax for SQL, so it's...

tried that, but no. Still exact same error...

rf44 (5/12/2014)

---

For editing (changing) a stored procedure, you can:

1. Reload the file you saved when creating it (if you did so), then change the instruction "CREATE PROCEDURE" to "ALTER PROCEDURE".

2....

I'm still missing something. What if I need to go back and edit the stored procedure? How do I get back to it?

I had hit hte execute button,...

Should I not be able to see the stored procedure somewhere? I'm afraid to close the window that is is showing in. For example, I closed that window,...

Sean Lange (5/6/2014)

---

jdasilva (5/6/2014)

---

How does SQL get the value of the variable from the form in access?

In the example I am working on, I am polling the data for specific...

Sean Lange (5/9/2014)

No this would be the stored procedure in sql server. Then you call this stored procedure from Access using the code I posted for that side.

The idea is...

Sean,

I did look at this:

Yes make the variable portions of your queries parameters.

create procedure MyProcToGetSomeData

(

@LocID int

) as

select YourColumns

from YourTable

where Location = @LocID

but again, this is new to...

SQL is delicious (5/9/2014)

---

Sean Lange (5/9/2014)

---

jdasilva (5/9/2014)

---

Yes, and it currently is, but that query refines data based on...

Yes, and it currently is, but that query refines data based on a an office code selected from...

Have not started to play with doing this, but looking it over, it still seems like the work is being done from access, which is what is causing the slowdown....

rf44 (5/7/2014)

---

If you want to keep a query in Access, use a pass-through query:

Sub RefreshQuery(Byval Value As String)

' Name of the query in the Access database.

' Replace QueryName by the...