Search results for query: *

Does anyone happen to have a list of system requirements to run SBT Vision Point 2000 v10.0? I have searched online and have not been able to find them (most likely due to the fact that it has been discontinued for some time now). Thank you

ICPRIC.MARKUPCOST*(1+ICPRIC.PRCNTLVL2/100) AS [Mid Sales Price] this column has zero or blank values for many more lines than I am having problems with

Skip - yes, the code is msquery in excel, but what I'm trying to say is that when I actually open MSQuery and run the same query, it does not error - it only errors when it tries to write the data to excel. I have examined all of the data in the column, i have even tried to pull up each invoice...

try putting this (or some version of it) into your loop Dim str as String str = Cells(i, col_FacID).Formula if left(str,1) = "=" then Cells(i, col_FacID) = "=""" & str & """" end if

The column that it's having a problem with has a numerical type, and 0 is in fact a numerical type. If the records were invalid, then wouldn't there be a problem when doing the query in MSQuery as well, not only in Excel?? Below is a sample line of the data that causes it to error...

Hello, I am using VBA to query data from Access. I have figured out that I am getting this error anytime the query needs to return a line that has the value of 0 in column 17. The values are indeed 0, not null or blank and the same query works fine when I use MSQuery - the error only comes up...

Hello, I am using VBA for the first time and am trying to connect to my SQL database to create a report in Excel. And am receiving this error when i set oCon to a new ADOBD connection: run-time error -2147024770 (8007007e) automation error the specified module could not be found I do have...