Search results for query: *

What is the best way for a SQL Server database to receive data from a DB2 environment? Currently we receive feeds from mainframe people on another floor in the same building. As far as I'm concerned this is inefficient since we have to have meetings and send emails back and forth to...

When I reboot my machine Word shows in the Processes list of Task manager. I noticed this just a few days ago. There's nothing in the Startup folder to make it open. Can anyone please tell me how to prevent this? thanks

When I close my MDI application I save all forms which are showing so I can have them show again the next time the application is opened. varUtilitySettings = GetAllSettings(appname:="My Utility", Section:="Open Forms") For bytCounter = LBound(varUtilitySettings, 1) To...

I have a VB 6 app where I would like to loop through all the Options of a Word 2000 object so I can view the values and change where needed. These are Options such as: AutoFormatAsYouTypeReplaceHyperlinks AutoFormatReplaceHyperlinks I'd also like to eventually loop through all the AutoCorrect...

I need to convert a decimal to a percent. Here is what I have: DECLARE @MonetaryValue NUMERIC(10, 3), @ReturnValue VARCHAR(5), @pValue VARCHAR(7) SET @pValue = '.125' SET @MonetaryValue = CAST(@pValue AS NUMERIC(10, 3)) SET @ReturnValue = CAST(CONVERT(INT, 100 *...

I dont' quite understand the below: 1.) Encapsulation 2.) Abstraction 3.) Polymorphism 4.) Inheritance I've probably used/created these before in my VB 6 experience (My company does not have .net) but I don't quite understand what each means so I'd like to give some examples of what I've done...

I want to write a SP that only returns certain rows when other rows are equal to 'Y'. Is there a way to do this and if so can someone tell me how? thanks much

We receive feeds where some columns have names but the rest go from field2, field3, field4....etc, field230. Not all these fields are filled and the number of filled fields is not known ahead of time. But we use all fields that contain data! To avoid the "Select *" I created a dynamic SQL...

Is there a way to copy nested bookmarks from one document to another? The BK does not exist in the Destination document. For instance: [Here is an example [sentence].] BKSource.Bookmarks(strBookmark).Range.Copy Set RangeDestination = BKDestination.Bookmarks(strBookMarkInsertAfter).Range...

In VB I am retrieving one to N number of values and would like to pass this to a Stored procedure as one parameter. Inside the SP I'd like to use the IN statement with this parameter. VB Code: StrDocumentNames = "'''" & Join(strDocument, "'', ''") & "'''" objExec.Open "EXEC spAIGDeleteRecID '"...

I get the following error when executing the below code: Error: An explicit value for the identity column in table '@TEMPDC' can only be specified when a column list is used and IDENTITY_INSERT is ON. (State:23000, Native Code: 1FA5) DECLARE @TEMPDC TABLE (RowId INT IDENTITY(1,1), State...

This issue is related to the problem I had at link: http://tek-tips.com/viewthread.cfm?qid=1532455&page=1 I'm using VBA in a Visual Basic 6 app. I want to Insert a bookmark between two existing bookmarks which look like: [Here is the first book mark's text of the BKDestination Doc which is a...

I have the following code inside a VB 6 app.: BKSource.Bookmarks("CopyMe").Range.Copy Set RangeInsertAfter = BKDestination.Bookmarks("PasteAfterMe").Range RangeInsertAfter.Collapse Direction:=wdCollapseEnd RangeInsertAfter.Paste This copies the entire contents of the bookmark including the...

I read that I can create a dynamic query by setting QUOTED_IDENTIFIER OFF. This is true and I was able to make string values on the fly and it works great! However, when I tried to turn the query into a Stored Procedure(Create Procedure) I got Error: Invalid column name '''. Is anyone...

I don't know if this can be done or not but I'm sure I'll find the answer here.... I am using SQL Server and have stored procedures but now I also need to access DB2 tables. Is it possible for me to retrieve data from DB2 tables using SQL Server? If so can someone please share with me on how...

I lost my network connection and with it my current work but I also lost the Icons which displayed what files I have checked out. I checked in the files and rechecked them out but the icons are still gone. In VSS the files are listed as checked out by me. I'm using VB 6. Can anyone please...

I created a couple DLLs and when finished I set them to nothing. I've been told DLLs don't have to be set to nothing, is this true? Why or why not? Thanks

First of all I just got Admin duites to SourceSafe because the previous guy quit. I found that I need to run Analyze but I keep getting an invalid Dos path error. Can anyone assist me in running Analyze. I already created a backup through the Archive menu. Here is the path of Analyze.exe...

Here's something I've never done before but have heard it's not easy. Here where I work I have been given permission to create a front end (VB 6) for someone in another department. What do I do to create the exe and deploy it on another machine? It'll probably start off on this individual's...

I create a document from a VB application. I have many document variables and bookmarks. In the footer I have {docvariable DocumentName} {PAGE}. Both these Fields display the correct value... The DocumentName shows the name of the value I pass to it and the PAGE is updated correctly by WORD...