Search results for query: *

Scrap that. The code I'm using is as follows: If Length ({SOP10100.PHNUMBR1}) < 10 Then {SOP10100.PHNUMBR1} = &quot;(&quot; & Left ({SOP10100.PHNUMBR1}, 3) & &quot;) &quot; & Mid ({SOP10100.PHNUMBR1}, 4, 3) & &quot;-&quot; & Right ({SOP10100.PHNUMBR1}, 4) Else If Left...

Took your advice res and currently I have this: StringVar fmtPhone; fmtPhone = Replace( {SOP10100.PHNUMBR1}, &quot;(&quot;, &quot;&quot; ); fmtPhone = Replace( fmtPhone, &quot;)&quot;, &quot;&quot; ); fmtPhone = Replace( fmtPhone, &quot;-&quot;, &quot;&quot; ); fmtPhone = Replace( fmtPhone...

I'm building a report in Crystal and it has fields which are being brought in from a SQL Server through an ODBC connection. One of the fields is phone1(for phone #). The numbers in the table are entered however the user sees fit, so they can look like '(000) 000-0000' or '0000000000' or...

Thanks to both of you for your time and help, but it's Zhavic who gets the cigar on this one!

&quot;MTNB&quot; is my ODBC connection.

I've narrowed it down to: SELECT SOP10202.&quot;CMMTTEXT&quot; FROM INNER JOIN &quot;MTNB&quot;.&quot;SOP10202&quot; SOP10202 ON SOP10200.&quot;SOPNUMBE&quot; = SOP10202.&quot;SOPNUMBE&quot; AND SOP10200.&quot;LNITMSEQ&quot; = SOP10202.&quot;LNITMSEQ&quot; Can anyone see a...

I've been called upon by the powers that be to fix this SQL query. Thus far no info shows up although it exists. The SQL query is odd looking because it was generated through Crystal Reports. I am at a bit of a loss with this one, any ideas? SELECT SOP10100.&quot;SOPNUMBE&quot...

You'll have to forgive me, I haven't finished my first coffee this morning! Slugs are passing my brainwaves. I've used your suggestions and everthing is great. Your posts are excellent and work 100%. Thanks so much for your patience and help. It is much appreciated. Sorry I took so long to grasp...

Not sure I understand how this: sCellValue = Adodc1.Recordset.Collect(0) will select the value of the cell in the selected row in the first column? I need to grab that value and set it to a variable so I can pass it to another frm. I'm feeling a little disorientated. Appreciate the help.

Private Declare Function ShellExecute Lib &quot;shell32.dll&quot; _ Alias &quot;ShellExecuteA&quot; (ByVal hWnd As Long, ByVal lpOperation As String, _ ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _ ByVal nShowCmd As Long) As Long Private Sub...

This one: sCellValue = Adodc1.Recordset.Collect(0) highlights the cell for editing. This one: sCellValue = DataGrid1.Columns(0).Value highlights the whole cell but unfortunately not the whole row. This happens with a single click.

Your first suggestion only highlighted the cell clicked on with a dotted outline around that cell only not the entire row. Using your second suggestion, my cells are setup as uneditable so even when the blue highlight shows up you cannot make changes. Chickens were counted before they...

Please ignor that last post. I was a little hastey to reply and figured it out myself. New ques: I have a select button under the datagrid and I need to get the cell value from the highlighted row under the column &quot;License&quot; using onClick(). Any examples out there?

YES! Thankyou! This: Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) DataGrid1.SelBookmarks.Add DataGrid1.Bookmark End Sub Does the trick. Is there anyway to make the whole line turn black? Currently the line highlights black except for the cell you clicked...

No luck all I see is a dotted line highlighting around the cell you select. Any other ideas? The microsoft link seemd to lead to alot of .NET applications. I can't seem to find what I want on there. Thanks

I have a datagrid with multiple rows and columns. I want to create a onClick() that will highlight(select) the entire row pertaining to the cell that was clicked on. Any examples?

This code is in the body of an asp page. I can't seem to get an alert box to fire when using an older version of Netscape (v 4.08). Not sure if I'm going about it right or not this is the first time I've tried to build a sniffer. Can someone tell me what I'm doing wrong? <script language =...

When I run this stored proc in QA no errors fire. But when the job completes, I get: &quot;Stored Procedure: TWO.dbo.aSph_IMSworkUIClient Return Code = -4 Query batch completed with errors.&quot; Can anyone tell me what this means? How do I fix it so it completes without errors? BEGIN...

Thanks for the help, Although I had to use the Package GUID inorder for it to run. DTSRUN / &quot;~GUID&quot; Something new everyday!

When building a job in the server agent, what is the proper syntax to exec a DTS package?