Search results for query: *

To update a table on a different database on the same server use the following update database_name.user.table set field = value where ... i.e. update database1.dbo.table1 set field1 = "TEST" where field2 = "TEST" Same applies for select statements etc. Hope this helps

Yep, already doing that, I think it's the saveas which is taking the time. I'm currently checking that folders and files exist using FileSystemObject, if I remove this and ensure all possible folders are created prior to running the app and just trap any errors where files don't exist, it may...

We have an application which uses .ole files to store free format notes, we need to convert these to Word documents, or better still strip the text out and insert into a database field. Using the OLE container control I can open the .ole files and save as word documents with no trouble, the...

I have created a word template which is populated at runtime from a SQL server database. The Word template has several check boxes relating to paragraphs of text. The check boxes are merely to indicate which paragraph the user is referring to and although VBA is used elsewhere on the document...

I have written a VB programme which produces crystal reports from a SQL server resultset based on criteria entered. This works fine apart from for 1 set of criteria, where the query never finishes. I have captured the query created and run it directly in the SQL query window again it doesn't...