Use whatever you like best, and add Analyst at the end.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

I think I remember hearing that C# was sort of an afterthought that was thrown into the mix to pacify the C++ community. :(( .NET was written for VB. :)

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

I'm kinda thinkin' you want it to look like this:

BOREC wrote:

WHERE (Priimek LIKE '''%' & @NAME & '%''')

Tom

What Yortw said: It may be too heavy a solution for you, but MSMQ (Microsoft Message Queue) using transactional queues should provide this functionality. That functionality is built into MSMQ.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Important note: For EACH of the entries in those 2 sections: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC Drivers The (Default) value must show (value not set). If it has any other value, such as an empty string, the drivers that were installed subsequent to that one will not list in the ODBC Administrator's Drivers list.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Microsoft Dynamics formerly Microsoft Business Solutions covers a lot of territory. Their primary products are accounting solutions such as Great Plains, Axapta, and Navision, though that isn't the entire list. CRM is also a Dynamics product, as is Business Portal. They are all integrated to some extent with Office products such as Outlook, Excel, and Word, and they come with built in support for SharePoint Services. There are a great many ISV or 3rd party products being developed for them as well. Most of the work in the field is with these ISVs or in integration and customization for the end users. You don't have to know the product you are working with, but having some knowledge of it is a big advantage. There is a large support community for those who work with it, and Microsoft provides a lot of support as well.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Will it go away if you turn off your monitot?

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Leave home? Why would you do that?

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

I'll be number 8.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Create a new Group based on the formula.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

inqno=" & txtInqNo.Text & ")", You didn't include the character identifiers ( ' ). Try: inqno='" & txtInqNo.Text & "')",

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

I didn't think you were running it down. Those who do are VERY VERBOSE!

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

http://www.space.com/scienceastronomy/astronomy/sombrero_galaxy_000304.html[^] My favorite - The Sombrero galaxy, voted Hubble's best. It's a good desktop background for a laptop, because it looks cool re matter which monitor it's stretched out on.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

How about Visual Cobol. Some vendor was giving out Visual COBOL CDs at the VSLive SF 2001 event. Mine is still floating around here somewhere. I even loaded it long enough to look at it. At the time I was working on a VB interface for an AS400. While I currently use VB 2005, I spent too many years doing too many really cool things with VB (3 through 6) to ever run it down. jgasm - You've got to keep up your spirits. I went through a downsizing 2 years ago. I know how depressing the idea of looking for work (at age 58) can be. Don't be shy about looking for work out of town. Tele-commuting is a very viable option these days.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

There are better methods for diong this, but maybe this will help some. *********************** declare @cmd varchar(300), @file varchar(255) set @file = 'C:\temp.txt' set @cmd = 'type ' + @file create table #temp (f_All varchar(255)) create table #temp2 (f1 varchar(10), f2 varchar(50), f3 varchar(10), f4 datetime, f5 varchar (10) ) insert into #temp EXEC master..xp_cmdshell @cmd insert into #temp2 select substring(f_all, 1, 3), substring(f_all, 5, 12), substring(f_all, 18, 7), substring(f_all, 26, 10), substring(f_all, 37, 3) from #temp where f_all is not null select * from #temp2 -- GROUP, SORT, SUMMARIZE, AND USE IT HOWEVER YOU NEED IT. drop table #temp drop table #temp2 **********************

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

There is nothing wrong with your code. Try proving to yourself that "condition met" is actually True when it is tested, and that image2 is actually what you think that it is.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

You can only change a bound DataGridView Cell's value if it's underlying Data Field is NOT Read Only. Make sure that you are using a DataSource that can be updated.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Dim msgResult As MsgBoxResult = MsgBox("Do you want to SAVE this record?", MsgBoxStyle.YesNoCancel, "DATA HAS CHANGED") Select Case msgResult Case MsgBoxResult.Yes ' Save Data Case MsgBoxResult.No ' Clear the form Case MsgBoxResult.Cancel ' Do nothing End Select

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Create the stored procedure to return the data from the query that you are using. CREATE PROCEDURE [dbo].[MySelectProcedure] @Parm1 int AS SELECT * FROM MainTable MT LEFT JOIN MyOtherTable OT ON MT.KeyField1 = OT.KeyField1 WHERE MT.MyParmField = @Parm1 Add parameters if you need them. When you are defining a new report in Crystal, you can select a stored procedure exactly like selecting a table. Add your stored procedure as the datasource. If you used parameters in it, they will show up in your parameters list in the report. Well written stored procedures are absolutely the BEST datasource that you can use for a Crystal Report.

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia

Does your format really have "nn", or is that just a typo?

Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia