I have converted my Access backend to a SQL Server 2000 backend and am in the processes of redoing the frontend to make it more efficient. The frontend is still Access.
I posted this in Forum 705 also, but it was suggested that I try it here.
I need to add a record to a SQL table through VBA with data that is input by a user on a form. I currently have it setup and working with an INSERT INTO statement in VBA, but want to change that. I want to setup a stored procedure in SQL and pass it values from VBA. I took the Microsoft 2073 class and have been searching most of the day trying to come up with some sample code on how to do this, but haven't had any luck yet.
Maybe my brain is just fried for the day, or not, but could someone give me some guidance on this.
Thanks for your help.
I posted this in Forum 705 also, but it was suggested that I try it here.
I need to add a record to a SQL table through VBA with data that is input by a user on a form. I currently have it setup and working with an INSERT INTO statement in VBA, but want to change that. I want to setup a stored procedure in SQL and pass it values from VBA. I took the Microsoft 2073 class and have been searching most of the day trying to come up with some sample code on how to do this, but haven't had any luck yet.
Maybe my brain is just fried for the day, or not, but could someone give me some guidance on this.
Thanks for your help.
