Search results for query: *

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

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

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

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

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

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

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#

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

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#

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

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

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

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

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

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

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

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

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

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

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