Search results for query: *

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

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

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

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

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

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

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

Hi, I have a form with a drop-down box, when the form is submitted the selected value is assigned to a Session variable, which is then used in the next asp page. When the user returns to the original form I want the drop-down box to set the selected value to that of the value from the Session...

I am trying to export the contents of the dataprovider into a SQL Server db and cannot find anything in the help files that explains the connection string and connection type properties for ExportToRDBMS method. Can anyone explain or point in the direction of a website that explains better the...

Using the Web Assistant wizard I have create a scheduled job to generate a web page, the web task itself works but the job doesn't, in the job history it says for Step 1: "There is no such user or group 'lbailey'. [SQLSTATE 42000] (Error 4604) Associated statement is not prepared...

Hi, Does anyone know about or has come across Overflow error's in Access? I can't find anything in MS KB. I originally got the error when trying to divide one recordset field (tabletype) by another, where the values were 0 (zero). I fixed that and now I get the error when using Automation with...