Recent content by ProdAir

How do you use the MS Datagrid in access? I don't see any properties I can set to get data into the grid (like Datasource or something). Thanks in advance for any help you can give me.

Thanks for the star. If you need to enter a parameter value for a query in DTS, there are 2 ways to do it. Using the execute SQL task, you can do this: SELECT FIELD_LIST FROM VIEW_A WHERE VIEW_A.ENDDTE > ? and then click on the parameters Or using ActiveX script task, prompt the...

If you're running the package from EM, you can use an ActiveX Script task to prompt the user for input using the InputBox function.

I have an access app that uses a SQL Server db. Recently, I've had to change the SQL Server db (in the file DSN). I re-linked all the tables in Access after making the changes. However, the views are not showing any data. Is there a way to fix this without having to drop the definition in Access...

have you looked up the FOR XML clause in books online? Is this being pulled out of the server using an application or are you just gonna run the query in query analyzer and save the results in a text file?

I have an access app that uses a SQL Server db. Recently, I've had to change the SQL Server db (in the file DSN). I re-linked all the tables in Access after making the changes. However, the views are not showing any data. Is there a way to fix this without having to drop the definition in...

use the convert function. I don't have the codes to use but you can look it up in books online.

Create an Execute SQL task and put: EXEC 'stored proc' ? and then click the parameters button. Hope this helps.

I believe you need to give your union query a name i.e. (SELECT Name, MaxOfDateQC FROM vw_vendor_current_mech UNION ALL SELECT Name, MaxOfDateQC FROM vw_vendor_current_elec) AS tab1

Thanks for the stars and eventhough we didn't give you all the answers you needed, I'm glad it somehow got you on the right path.

This should be a VB post. Does the client have MDAC installed? Also, it would be better to just add that user to the DB and have him use trusted security instead of having to provide credentials either through code or through a logon screen.

off hand, without totally understanding what you want to accomplish, I would say the user-defined function is probably one of your major issues (dbo.fn_round). Also, you want to make sure the 5 tables have the right indexes created to work with this query. I didn't really understand your...

do you want the column to get automatically updated every time the value changes? If you do, then you'll need to create a trigger on the table.

you can also try CHARINDEX('1', ISNULL(columnname, '')) = 0

Oh, and there are no dumb questions. Thanks for the responses guys.