Search results for query: *

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.

Because the conversion to text converts them into characters. Also, this ensures the precision and scale of the numbers are preserved. When importing data from anywhere, it's almost always safest to import everything as characters because you can do your validation against it in a staging area...

the db_owner role can do everything on the database, not the Server itself. If they need to manage users and roles, they need to be members of the fixed server role securityadmin. db roles are specific to a database. If after adding them to the securityadmin role and they are still unable to...

varchar. I believe the problem lies in the fact the data source are spreadsheets which come from Europe which are then converted into text files. I see no point in converting the data back into spreadsheet format only to re-format the numbers. I haven't found anything on the CONVERT function...

Is there a function to convert a number that's European (4.100,00 - dots in place of comma for thousands and comma for decimal point) into US (4,100.00)? I could do replace but that could cause problems and performance issues...

are you doing the cast before doing the condition (this is what it looks like from your statement above)? I'm not sure why you would need to convert it to a character first before comparing the values...