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!

Register Log in
  • Congratulations derfloh 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: itlee
  • Order by date
  1. itlee

    Listing the ToDo folder from Outlook

    BomberMan2K, Can you post your code? What is not working? the assignment? or something else? First thoughts are the listbox needs to know what text to display in the list, the listbox checks the DisplayMember property to see if that is set to the name of a property from the assigned object...
  2. itlee

    PivotChart Requery in VBA

    I have a pivotchart form displaying data from a table that is updated periodically, but when the data is updated and I call requery on the form the chart is cleared! Does anyone know how to requery the chart without losing the layout? I have searched for over 2 hours on the net and cannot find...
  3. itlee

    uncommitted transactions in tempdb (SQL2005)

    Ok I found what was causing the "The current transaction cannot be committed ...." error, my sp calls another which in turn calls another sp and its the 3rd one that is erroring and then the first sp cannot rollback. But still I have the 2 open transactions in tempdb, but they dont seem to be...
  4. itlee

    uncommitted transactions in tempdb (SQL2005)

    I was testing a stored procedure which contained a explicit transaction (BEGIN TRAN) unfortunatly the sp errored and did not rollback the transaction and now the tempdb has 2 open transactions (i ran it twice before I realised) according to Activity Monitor, but DBCC OPENTRAN returns "No active...
  5. itlee

    Collections Advice Please?

    I am designing a sci-fi game and need to create a "map" of the galaxy (a 8x8 grid) that contains space objects (stars, planets, spaceships, etc) some of these objects contain no more than a name property, but some like the spaceships are more complex having methods as well as properties. What I...
  6. itlee

    Restored project claims file is new in VS2005

    I recently moved a project from one database to another. Then I "get latest version" of project and open in VS2005 which reports that 2 files are "new" and the tooltip claims the "item has been deleted on the server". Which they are not! they exist in the db and were retrieved when "get latest...
  7. itlee

    Testing Database Roles in development

    Thanks for your thoughts on this. I thought I would let you know how I managed to do this. I changed the connection string to use a SQL Server login and then just changed the db role this login belonged to to test each set of permissions. Lee. itlee. MCP\Analyst\Programmer\SQL\.NET\VB\C#
  8. itlee

    Testing Database Roles in development

    I need to test the security of the database roles I have created for a .net application by adding myself to a role and trying to access the data from the application. I have the dev db on my PC, therefore I am accessing the local sql server 2005 as part of the BUILTIN\Administrators group. This...
  9. itlee

    Finding a Ticket, Project, and PO system - HELP please

    take a look at AxoSoft's OnTime software, might be what your looking for. www.axosoft.com Lee. itlee. MCP\Analyst\Programmer\SQL\.NET\VB\C#
  10. itlee

    auto select new value in combobox

    I worked it out! I created a property in Form2 to hold the value of the new item. Then in Form1, after reloading the bindingsource, do a search on the bindingsource for the value from Form2.property to return its index in the list and assign that index to SelecedIndex of the combobox...
  11. itlee

    auto select new value in combobox

    I have a combobox on form1 with a button to open form2 where the user can create a new item for the combobox. both forms are databound to a database and when form2 closes the datasource for the combobox is refreshed. How can i pass back the id of the new item so the combox auto selects the new...
  12. itlee

    CrossTab - "column" names missing for rows

    I have a crosstab report (created in VS2005) defined as: rows: sample, code, country columns: yields, compounds summary fields: Min(results) and is displayed like: ---yield of metals--- arsenic lead nickel 01180 BHG03 Brazil 7.49...
  13. itlee

    error message i don't understand

    AtomicWedgie what was the solution? I am having the same problem after I moved my DTS package to another server, re-created the connection objects, and pointed the ExecuteSQLTask connection to the new connection. When I individually run the task it runs fine, but as a scheduled job it fails...
  14. itlee

    SerializationException "Member ReadOnly not found."

    I have a class that contains a subclass which have been serialized to a binary file. When I attempt to deserialize a SerializationException is thrown with the message "Member ReadOnly not found". My classes don't have a ReadOnly member, but do have one read only property. Both classes are...
  15. itlee

    FP VBA: deleting rows from tables

    Hi, I am trying to write some vba code (in FP) to build a table in a webpage populated with some filenames and summary information. However, I am struggling with the FP Page Object Model, there seems to be a deleteRow method, but this errors, possibly because it is only supported by the DHTML...
  16. itlee

    WorksheetFunction.Sum & AutoFilter - sums all values not the filtered

    cheers guys, I worked out that I was using the wrong function integer in subtotal earlier today, thats why I never got the correct figure. thanks for you input. ITLee. MCP\Dev\Prog\DBA\ITIL
  17. itlee

    WorksheetFunction.Sum & AutoFilter - sums all values not the filtered

    Thanks, gh61 Your suggestion helped, but what I have discovered is that you need to re-assign myrange after each filter: '1st Filter Selection.AutoFilter Field:=3, Criteria1:="1" Set myRange = ActiveWorksheet.Range("D:D").SpecialCell (xlCellTypeVisible) dblTotal =...
  18. itlee

    WorksheetFunction.Sum & AutoFilter - sums all values not the filtered

    I am using VBA to filter some data and I want to get a total for the filtered data. I have used: 'AutoFilter code here... Set myRange = ActiveWorksheet.Range("D:D") dblTotal = App.WorksheetFunction.Sum(myRange) However, this returns the sum of all the values not the filtered ones. Anyone...
  19. itlee

    FP VBA - Removing all attributes from TABLE element

    Ah-Ha, I have found my mistake. I have missed off the last argument of the removeAttribute method which defines the case of the attribute. So it should be booResult = fpTable.removeAttribute("ACCESSKEY", 0) which will remove for either ACCESSKEY or accesskey. If the last argument was...
  20. itlee

    FP VBA - Removing all attributes from TABLE element

    I am trying to write some VBA code to remove all the attributes from the TABLE element, so far I have got: Function RemoveFormattingFromTable() Dim fpPage As FPHTMLDocument Dim fpTable As FPHTMLTable Dim i As Integer Dim booResult As Boolean Set fpPage =...

Part and Inventory Search

Back
Top