Executing an UPDATE Stored Procedure
I have a very simple update stored procedure called "pricesupdate"
I need this to run on the open event on one of my forms.
To do this I use VBA. My question is, how can I run and update stored procedure from VBA?
I would have thought it be as simple as:
"DoCmd.OpenStoredProcedure....etc" but no, tried that and get error saying "Microsoft Access Cannot Find...." so whats the answer guys? This one is annoying me because surely it should be so simple....or am i wrong?
Thanks in advance,