Recent content by mendesj1

thanks for the help , i tried what you showed me and now come up with a run time error 2471: the expression you entered as a query parameter produced this error : 'me.[date fixed]'

Me.Text11 = Nz(DAvg("[final whse-in diff]", "dbo_inventory", "[CAFETYPE]=" & Me.Text7 And "isnull(me.[DATE FIXED])=" & True And "isnull(me.DATE_IN)=" & True), 0) i am getting a type mismatch error with this. my question is: 1. is the syntax correct 2. Is my way of checking for a value to be...

dave thanks again worked fine

Run time error 13 type mismatch is the error i am receiving

I would like to convert 2013.11.13 which is a string into a date this is what i have so far but it's not working any ideas 2013 year 11 month 13 day of week Dim strDate As String, dteConvertedDate As Date strDate = 2013.11.13 dteConvertedDate = CDate(Mid$(strDate, 6, 2) & "/" &...

thanks for the help but i am still get a run time error incorrect syntax near the keyword 'or'

I am trying to pass the results of what is selected in a list box to sql through an ado statement, when i select one result i can pass the value with no issue, when i select multiple item i get a run time error incorrect syntax near ';' i am guessing it is passing the data as a csv to sql and...

Just some vba help i need to know how to get the sum of column 2 of a list box total bags is in the second column, i only want the total of bags of the ones selected I can get the sum of all the boxes but only want highlighted ones thanks so much Public Function SumListBox(sForm As...

the sp just runs a simple query set the result of the query to a variable (single result value) the returns the value, it gets down to .open in the vba code then i get a run time erro conversion failed when converting the nvarchar value (the result of the querry a -text-) to data type int...

thanks for the help but i am still not getting it to work, i can tell that the single value is getting returned to my record set from my stored procedure but have a problem setting it equal to a variable in vba

all i want to do is set the return value from sql "return @PoNumber" to a variable in vba the result of the query is a single value

Guys i need help with returning a single value from my sql stored procedure i want to call the sp with vba and return a single value all the code is below any help would be great. 'Access ADODB CODE Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim SQLServer As...

One more question, that works great but is there a way if the file does not exist I can create a pop up telling the user its not there instead of a vba run error

Thanks worked great!

Try to open a pdf with a button in a form using vba - i want it to take the data from me!comp_ID and insert it into the file location and then add .pdf on the end and open it with this i get a type mismatch run time error '13' Thanks for your help Dim strfile As String strfile =...