Search results for query: *

I'm not exactly sure what they mean by the duplication issue either. In my opinion they tried and failed to mirror the data and now think it can't be done. So as the developer on the software side I'm now limited to receiving feeds from them consisting of the exact data I'm supposed to use...

Thanks Frederico, Please excuse my potentially elementary questions, I am VB programmer and have only written stored procedures and created my own DBs and tables and such on my PC at home. So the mainframe people can move the data to a temporary table (or view) and then move that data to SQL...

Thanks Simi, The data pulls are the mainframe people doing the SQL code on their side and providing us the feeds. I personally don't understand why this is done since we can do the SQL ourselves and cut out so much overhead like constant communication over what data to pull and formatting...

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...

I just noticed your reply linney. I'll download that and see what it does...looks useful. THANKS

I just did a "Detect and Repair" and that appears to have fixed it.

Thanks for the reply, aich69, but I use "Microsoft Outlook Rich Text" as the format and the check box to "Use Microsoft Word to edit e-mail messages" is not checked.

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

I just created an exe and it DOES work. I have the proper error routines included since the values won't exist in the registry the first time the app is run. Here's a snippet of the code: Dim varUtilitySettings As Variant Dim bytCounter As Byte Dim objForm As Form varUtilitySettings =...

EXCELLENT!!!!! thanks much

Thanks Tyson but I want to show the forms the next time the application starts. It appears your code just provides the names.

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...

fumei, thanks for confirming what I was afraid of. There are so many options I figured(hoped) there would be some kind of a collection.

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...

Yes, it should be done on the GUI but we receive data listed at field1, field2, field3, etc... as our column names. I'm trying to make it as dynamic as possible on the GUI without having to continually update the GUI code. So I am doing all the shaping on the SQL side and then simply have a...

Excellent! I had something similar to what you mentioned but then I screwed it up for '1'. Your code, however, has that covered! Thanks much gmmastros!

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...

In my VB code I'm always returning every column. If a column is equal to Y I'm doing something with the next column. If it's N I'm ignoring..... Code snippet: With rsSelectValues .CursorLocation = adUseClient .Open strSQL, gCn1, adOpenStatic If Not .EOF And Not .BOF Then...

bborissov, The Y/N columns are of the same type, the columns I may or may not be returning can be of different type. I currently use the front end and I'm beginning to think staying that way probably would be easier. I was just hoping there'd be a more efficient way through SQL....by not...