bessermt's Q&A profile

• Visual Basic How to access the 'table description' data using VBA in MS Access.

  I want to be able to use VBA to access the 'table description' data that I have entered in the properties form for each table I have created in my Access database. I can access the table names via the AllTables collection but this does not allow me to access the data I have entered as a 'description' for each table. Can someone help me with the code as to how I can extract and use the 'Table Description' data which I have entered via the Properties form for each table Many thanks... Michael Daly (31 Jan 2007) MichaelDaly, According to your VBA question, I just searched the related objects and method. I suggest you to read some of the information on CurrentData/CodeData Object on Access 2003 VB ...Show All

• SQL Server Having Problem with Report Parameters

  i am trying to generate a report based on 3 parameters age, location, ethnciity every thing works fine in data and layout tab, when i run the preview tab, it give me the option to input paramaters and then when i hit veiw report, it shows processing report.... (indefinite) time. i tried executing the query in data tab, it takes less than a sec. any ideas am i doing somethign wrong in parameters Raja, I'm going on the assumption you are using SQL as your datasource, If so, you can start a SQL profiler on the database you're using. In the profiler, you can watch the query statement from SQL reporting service being executed, It will reveal exactly what is being p ...Show All

• SharePoint Products and Technologies WSS3 cannot be crawled

  I'm getting this error on the server of WSS 3.0 The start address <sts3://ebs-sharepoint/contentdbid={d901caff-7863-40aa-8460-c3ef9132cb89}> cannot be crawled. Context: Application 'Search index file on the search server', Catalog 'Search' Details: Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content. (0x80041205) The WSS 3.0 is configured to use Kerberos and both the WSS Search and Timer service is running under a domain account. Any help. Thanks. Jason I had the same crawl error messages in Event Viewer. I have also changed the registry settings according to 896861. It did not work. I think the ...Show All

• Visual Studio Team System Duplicating Areas and Iterations

  Is it possible to copy an entire structure of Area (or Iteration) from one Team Project to another ...Show All

• .NET Development how to relate 2 databases?

  I want to be able to create a single database that contains all of my common information accross my applications. For each application, I want it to have its own database. How can I do this How can I relate my data from one database to another To answer your question about “relating”: create table Common.Base ( ID int not null primary key ... ); create table App1.Derived ( BaseID int not null foreign key references Common.Base( ID ) // additionally it is a good idea to specify: // on delete cascade // on update cascade ... ); where Common is your common schema and App1 is th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Texture2D.getData Woes!

  Okay, so I've already read through a couple of the threads here on the same issue, but nothing helps my situation! I'm trying to capture the texture data so I can do some collision detection on it. Texture2D entityA = resourceManager.getTexture(a.CurrentAnimation); uint[] bitsA = new uint[a.currentWidth*a.currentHeight]; entityA.GetData<uint>(0, a.CurrentFrame, bitsA, 0, bitsA.Length); a is the entity passed to my collision detection. a.CurrentAnimation is the name of the sprite sheet containing the current frames for this animation. a.CurrentFrame is a rectangle representing the clipped part of the current animations sprite sheet (e.g. a rectangle that clips out which frame we want to use. Now this code always fails at teh getData ...Show All

• Windows Forms DataGridView CellValidated not fireing when expected.

  When is the cell validated event suppose to be fired I have a simple form with a DataViewGrid and a button (among other things). Sometimes when the user edits a cell then clicks the button, the CellValidated event is called After the button event is called. In this case the Button_Click event is called, which saves the data and clears the grid and apparently after the grid is cleared, then it calls CellValidated. This of course is a problem because the cell in question no longer exists. The order of events in the trace is basically Button_Click(...) DataGridViewRowCollection.Clear() DataGridViewRowCollection.ClearInternal(...) OnClearingRows() OnClearingRows() set_CurrentCell(...) SetCurrentCellAddressCore(...) EndEdit(...) CommitEdit(... ...Show All

• Visual C# MarchalAs multidimention array

  This is for a single byte array x [MarshalAs(UnmanagedType.ByValArray, SizeConst=SERIALNO_LEN)] byte[] x What happens when x is a multi dimentional array what should SizeConst be I am guessing the product of the two dimentions. For a multidimentional array i get an index out of bound error because it is assumed that SizeConst is one dimentional. so instead of a 7x4 multi array i get a 1x28. How do I MarshalAs multi-dimentional arrays to pass to unmanaged code ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Texture Alpha channel problem?

  Hi all, I created mesh.box object with my game. The mesh has a texture. I want to set the mesh alpha channel 80%. How to change a mesh alpha channel for c# Below is my source code. //create mesh object boxMesh = Mesh.Box(renderer.Device, 100,100,100); //========================================== //on paint renderer.Device.SetTexture(0, texture); boxMesh.DrawSubset(0); //============================================ Best regards, Best thing for your purposes is to set the Material’s alpha channel to 80% instead of texture’s. It’s much more efficient as you don’t have to lock any resources. Then, use the propper AlphaBlend mode in DirectX to redirect the AlphaBlending to material’s alpha. Hope this h ...Show All

• Visual Studio Team System Rules.xml

  I'm sure you guys don't think about issues that are so obvious nobody would every write code that way. I've found out recently that there is a lot of bad code out there that could be easily caught in FxCop. In any case please consider adding the following rules to FxCop. I've written them myself and found too many violations to count. Anyway here we go. 1) Don't call ToString() on a String. I've found that some developers put .ToString() on the end of almost everything. This only catches part of the problem but is a good start. 2) Use Type.FullName instead of Type.ToString(). This is still the developer problem of always putting ToString() on the end of everything. I've also found that this finds a bunch of problems where the code is ...Show All

• Visual Studio Express Editions Custom shaped Form?

  I'm wondering is it possible to have a form that isn't a square I want to have a form with a menu sticking off the side, so that it would stick out. Is this possible I got it working, but is it possible to use another image type instead of bitmap Bitmaps have massive file sizes especially when you got a decent sized form, my bitmap image is already over 1mb, thats about 1/4 of my total project size. Is it possible to use jpeg instead ...Show All

• Visual Studio Team System Using Excel as a DataSource for coded web tests

  I have a web test which is databound. The backing datastore is an Excel spreadsheet and this works. However, if I turn that test into a coded web test the tests fail to run (note the tests don't fail, they don't even execute). If I remove the DataSource attribute from the coded test then I can get the test to run. The DataSource attribute looks like this: [DataSource("DataSource1", @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\Starbuzz\Starbuzz\testdrivendata\CoffeeMakerTestData.xls;Extended Properties='Excel 8.0'", DataBindingAccessMethod.Sequential, "Sheet2$")] And I get the following failure Error WebTest1Coded WebAppTest Could not run web test 'WebTest1Coded' on agent 'MACHINENAME': Ob ...Show All

• Visual Basic backgroundworker

  Hi All, First, I am not sure if I have posted in the proper forum. If not I apoligize. My issue is , regarding the background worker, if I call the reportprogress method I get the following error below from the form that contains the backgroundworker control. Anyone have any ideas System.Reflection.TargetInvocationException was unhandled Message="Exception has been thrown by the target of an invocation." Source="mscorlib" StackTrace: at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, ...Show All

• Visual Studio Tools for Office Applying Formatting to Excel columns programatically

  I am coding in VB.net (VS2003). The output of my program is an Excel spreadsheet. Everything works except some of the formatting. I have: ws.range("J").NumberFormat = "0%" and ws.range("K").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-"" _);_(@_)" where ws is dim'd as a worksheet The formatting syntax is copied from a VB6 program. However, I am coding in VB.net (VS2003) and it is giving me runtime errors: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC. at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyB ...Show All

• SQL Server How can one Connect (remotely) to SQLExpress which is installed on "Windows XP Home"

  Hi all, I have to deal with a private network of laptops which are all equiped with preinstalled "Windows XP home" I've installed SQLExpress on one of these, but I cannot connect on it from the rest of the laptops. (I've successfuly done this with "Windows XP profesional" though, and local connections work fine as well). I've already setup the SQLExpress to accept conections throuigh TCP/IP but I can not think of something else. (Security comes to mind, but I do not know how to resolve it on "Windows XP Home"). Thank you Ioannis Hi Ioannis, Did opening the firewall solve this issue for you Regards, Mike Wachal SQL Express team ---- Mark ...Show All