Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pwomack
  • Content: Threads
  • Order by date
  1. pwomack

    Reference cell in datagridview

    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 =...
  2. pwomack

    Help with query

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

    VB 2008 and Lotus Notes

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

    Help with GridView

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

    Help with SQL problem

    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)...
  6. pwomack

    Help with dimensions when creating a cube

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

    Opinions on the "Budgeting and Tracking Multiple Projects" template

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

    Help with SQL Select

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

    Excel freezes when filtering a pivot table

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

    Workflow continues to send email after list item is deleted

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

    Automate printing of report

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

    What is the proper way to delete a user created library templete?

    Using Windows SharePoint Services 3.0 I mistakenly created several libraries and saved them as templetes. After clicking 'Site Actions...Create', I see the 'Libraries' list with Document Library, Form Library, Wiki Page Library and Picture Library. After Picture Library I see the three...
  13. pwomack

    Can't delete document library

    Using Windows SharePoint Services 3.0 I had a user who created a document library that does not display in the quick launch. In order to view the document library I must click the "View all Site Content" link. Upon clicking the document library I get the form for customizing the library...
  14. pwomack

    Cascading Combo Boxes

    I'm using Windows SharePoint Services 3.0. Is it possible to create cascading combo boxes with SharePoint Designer? That is, I want to populate values in a combo box based on a selection from a different combo box. I would have category, sub-category and sub-sub-category combo boxes. Thanks.
  15. pwomack

    Make bound form programmatically read only

    I have a Windows form bound to a SQL table. I don't use a datagridview, just individual fields. How can I programmatically make the form read only? Thanks.
  16. pwomack

    Windows SharePoint Services 3.0 (WSS) search not working

    I did a basic install of WSS 3.0 with all components on one server including the Windows internal database. I created 1 additional web application (in addition to the default web application). The search works for the web application I created. However, a search on the default web application...
  17. pwomack

    Linking calendars on subsites to main site

    Using Windows Sharepoint Servies 3.0 I have a Sharepoint site with subsites. Is it possible to link calendar items on subsites to a calendar on the main site? I'm looking to merge several calendars on subsites to one calendar on the main site. Thanks.
  18. pwomack

    method to convert fraction to decimal or float

    Is there a method to call in vb2005 or vb2008 that will convert a fraction to a decimal or float? The user will enter a number with a fraction such as: 18 3/8 I then want to convert the value entered to: 18.375 Thanks.
  19. pwomack

    Data Entry & Form Control

    I need to create an unbound data entry form for user input. The data would appear in grid format. I then need to read or reference the data in the grid line-by-line after the user completes data entry. The data would look like this: Seq Qty Width Length 1 5 16 8 3/4 2...
  20. pwomack

    License Question?

    Is it legal to purchase 1 license for SQL Server 2000 Enterprise and install the software on multiple servers in our company? The same question for SQL Server 2005 Enterprise. This question is not a joke.

Part and Inventory Search

Back
Top