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. I am not sure if this should be posted here or in the SQL forum, but am trying here since it is dealing with VBA.
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 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.