Recent content by Zukkster

Excellent. I found what I was looking for via one of firefytr's links. The magic word appears to be Add-ins. Once I knew this I had a dig around on the Internet and hey presto. The following link http://www.jkp-ads.com/articles/DistributeMacro00.htm was excellent at helping me through the...

What is the best way to distibute an Excel (2003) macro and a form that's associated with it? Version control, as it's own workbook What are the pitfalls and things to look out for? Are there any specific things I need to do with my code? I appreciate this may be a large topic, so links to...

What sort of DB are you connecting to SQL server? I think it maybe the ' quotes you've used in the WHERE clause of your VBA code aren't being picked up. In the past this has caused me problems from VBA to SQL server. It depends on how you've got your quoted identifier settings. Try """

4946, If you like that code and you need to do lots of connection to SQL server using VB(A) then I'd absolutely recommend a book called "SQL Server and ADO Programming" by Sybex. The only trouble with this code is that when you distribute the Access database, some users may not have the...

You are in the twighlight zone that is SQL to Access and took me some time to figure, but if I understand your question correctly I think this may help giving you the code to reference data from a SQL server table. The Public constant you will need to edit to connect to the SQL database you are...

One of my stored procedures uses the xp_cmdshell to export data usig the following code SET @cmdline = 'bcp reporter..' + @SummaryTableName + ' OUT "\\cmcukfs01\Userdata\Reporter\AccessApplication\Import Data\SummaryFile_' + @UserID + '.txt" -T -t "," -c' EXEC master..xp_cmdshell @cmdline...

I set off a query to update a table with a 40 million rows by referencing an equally big table. It's been running for a long time - over the weekend. I know if I stop the query it will take as long to undo as it took to run. The transaction log hasn't grown too big and when I look at the task...

I stupidly ran a big update query on a table over the weekend and when I got in on Monday it was still running and all the space had been used because it had created a huge transaction log and the tempdb was massive. Even more stupidly I stopped the query thinking that it wasn't working due to...

Without seeing the SQL code. I guess you are trying to construct a SQL statement by dropping the variable that; s stores as a curreny data type into a SQL string You can only concatenate string varaiables, you can't concatenate a curreny data type with a string data type. i.e. sting + string...

Yes if you try and pass in an integer variable to the SQL statement you will get a 'data type mismatch' error when you try and create the sting variable by concatentating text with an integer. Without knowing your user interface and how you are calling the procedure I guess you'll build the...

DECLARE @U nvarchar(255) DECLARE @SQL nvarchar(255) SET @U = 'user_id in (405,255,585)' SET @SQL = 'SELECT user_id FROM tbl_user WHERE ' + @U EXEC(@SQL) @U must alwas be a string variable, you could write the statement as SET @U = '405' SET @SQL = 'SELECT user_id FROM tbl_user WHERE user_id...

Are you just looking to filter your results on a sub query that selects the paramters of the main query SELECT * FROM table1 WHERE field IN (SELECT field FROM Table2) Rather than passing all the cases that as a list of possibilities you create a subquery. I may not have understood you clearly

Thanks SQLSister DBCC was the answer. It was a little more complicated than I expected ... so for the benefit of anyone experiencing the same problem. I had to go through a few stages before I could run the DBCC First I had to kick of any users so that I could put the database into single user...

I have a table that has just stopped working. When I try to run a query on it, it just runs and runs. I can't drop the table, I can't delete the data. When I go to the task pad view it says the table is zero rows but is 33,408 KB What could be wrong?

I'm trying to FTP data from and Access database using the iNet control. This uses the Microsoft Internet Transfer Control (msinet.ocx). This is a VB control and not an Access control. I have VB on my PC, so I can reference it fine and it works. The trouble is when someone who doesn't have VB6...