Search results

So I got it to work, part of it was the single quotes, part was just how I had the VBA setting up the parameters, then how the stored procedure was set up. Here is how I fixed it: VBA Code - 'set default connection/values Set CurrentConnection = AdoConnection() 'set AssetID value strAsset =...

So far I'm the only one replying... that is OK. I'm more than willing to go through this exercise if it helps someone out in the process:D! So I've redone my vba code, and I'm going to post my stored proc, because now I'm getting this error: "Error: -2147217913 Description: Conversion failed...

Okay, so at least a part of my dilemma has/had to do with the date, which I'm still trying to figure out how to write in. I found this link on ADO parameters that appears to look like it will work (Which I would share if I could at this point), now I just need to get the date piece right...

Not to mention it would be much easier and cleaner to do in VBA, something like: If Me.Column2 <> 1 Then Me.Log_UD_ID.Enabled = False Of course you would replace the value of whatever control you're actually working with, and the values you don't want them to be, etc.. I just used your...

Hey all, I'm having an issue getting a return value from a stored procedure that I'm calling from VBA. I've tried looking around for a solution, but can't seem to get it to work. This is what I have at the moment: Dim strDate As String Dim strWOStatus As String Dim CurrentConnection...

Just wanted to introduce myself real quick - I live in the US, and have been developing on Access for the past 6-7 years now (with VBA). My first ever use was developing a database application that the navy used to track medical separations. I've since done a little of this and a little of...