Search results for query: *

Using VB2008 in a Windows application. Currently this is what I use to reference a value in a cell in a datagridview: sOrderNo = Me.dgvOrders.CurrentRow.Cells(15).Value Is it possible to reference the cell value by using the column name? Such as, sOrderNo =...

Thanks, Borislav.

I have the following data in a table: order # OpCode Date 12345 50 5/17/09 12345 51 6/12/09 12345 52 6/27/09 I want to write a query that returns only 1 row; the row with the maximum OpCode for an order #. So, I want to return...

Using VB 2008 and Lotus Notes 6.5., and fairly new to VB.NET. I want to automate Lotus Notes within a Windows application. Similar to how SharePoint (WSS 3.0) automates the email client. In SharePoint there is an option to send a hyperlink to a document in an email. When this option is...

Place a textbox on your report and enter this syntax in the textbox. =String.Format("LiteraltoIdentifyYourParameter {0}", Parameters!NameofYourParameter.Value)

New to asp.net and using Visual Studio 2008. I have a GridView with a column named "Doc" that stores a UNC path for a document. I don't want this column visible, so I set the visible property to "False". I added a templete field to the GridView with a button that the user will click. I...

I'm using SQL Server 2000. The output should look similar to the "Part No" column of the test data. I did some Googling and stumbled upon recursive stored procedure calls. This may be what I need. http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

Thanks for your help on this. However, I'm still struggling. I need to start at the main part level (p1) and work my way down to the lower levels. I need to know all of the sub-parts for a part number. Subpart 's-s-s-sp1a1a' may be included (occurs many times in the sub-part column) in many...

I have a table with part and sub-part numbers such as: Part No Sub-Part No p1 sp1a p1 sp1b p1 sp1c sp1a s-sp1a1 sp1a s-sp1a2 sp1c s-sp1c s-sp1a1 s-s-sp1a1a s-sp1a1 s-s-sp1a1b s-s-sp1a1b s-s-s-sp1a1a s-s-s-sp1a1a There is a main part number (sp1)...

Never mind. I got it figured out. I needed to drag/drop the attribute from the Data Source View section into the atribute section on the Dimension Structure tab.

I created a cube with 7 dimensions using SSAS 2005. Five of the dimensions appear to have been created correctly when viewing them in the "Dimension Structure" tab. That is, I see the primary key attribute and a dimension field attribute in the "Attributes" section. For example, I see 2...

There is a debate going on in my company about the suitability of the SharePoint "Budgeting and Tracking Multiple Projects" template as a Project Management tool. The answer is probably, “It depends”. It depends on factors such as the complexity of the project and the number of resources...

Thanks, RiverGuy. I'm an admirer of your knowledge.

I have the following data in a table. select OrderNo, OptKey, JobDate from OptimizerJob order by OrderNo, JobDate OrderNo OptKey JobDate 123456 1414388210 2009-04-07 14:18:40.030 123456 306771073 2009-04-07 14:19:05.280 1234567 1184659209 2009-04-07...

Using Excel 2000 connected to a SSAS 2005 cube. I created a pivot table by selecting Menu...External Data...Get Data...OLAP Cube. I can drag-and-drop the dimensions into a pivot table. However, Excel freezes when I attempt to filter on any dimension by selecting the drop-down arrow to get...

The tasks no longer exist. They were deleted before the emails were scheduled to be sent. However, the user still received the emails after the 3 hour duration ended.

Thanks, Dinger. Maybe the solution is to manually terminate the workflow before deleting the task item? Is that what you mean? Is there any way to terminate a workflow in SharePoint Designer when an item is deleted?

* Update* I created 3 services requests and I see 3 workflows in progress in the 'Workflow settings' page. This is as expected. I deleted 2 service requests; however, the number of workflows in progress remain at 3. I would expect to see only 1 remaining workflow in progress. Is there some...

I'm using WSS 3.0 and SharePoint Designer 2007. I'm new to workflows. I've installed the HelpDesk template and created a workflow that starts automatically when an item is added to the service request list. The workflow has 2 steps: 1. Pause for 3 hours 2. I then have a compare field...

I have a 77 page report. One page per customer that gets emailed to the customer. What I do now is print each page individually to a pdf file using a pdf printer driver. So there are 77 pdf files. This is time consuming for me. Does anyone know of a way to automate the printing of the 77 pdf...