vba-dev's Q&A profile
SQL Server SQL Server 2005 Express Management Studio
Hello, I have installed SQL 2005 Express Management Studio several times and It fails to completely install. I get a message that SQL Server Express 2005 x84 did not install properly. I tried to uninstall it and reinstall it but I get the same problem. My Visual Web 2005 Express Edition and Visual Basic 2005 Express gives an error when I try to add a new database. The error is: "Failed to generate instance of SQL server due to a failure copying database files. The connection will be closed. Does anyone know what I can do to resolve this My computer system meets the hardware requirements. Sincerely, Pam You ne ...Show All
Visual FoxPro Calculated properties not recording to table :(
Hi there Fox folk! I have series of cusotom properties that compute values on my form based on user data input. ( example: One computes the number of days between the current date and the date entered by the form user.) The calculations work nicely on the form, but I'm unsure as to how to get these values recorded into the same table that the rest of the user inputted values are going. The 'cells' where the results are displayed are tied to the properties via the Data/ControlSource setting. How do I pass these values to the table Thanks! Dave Thank you very much for replying! Here's what I ended up with...it's a little different ...Show All
Smart Device Development Resizing Screen Elements when MainMenu appears/disappears.
Hi all, I have an application that triggers the main menu on or off, and would like resizing certain screen elements to accomodate this main menu. Is there a function that can do this (maybe and event that is caught and resizing screen elements), or is do I have to do the resizing manaully Thanks Tryst ...Show All
Visual Studio Express Editions Whats with SQL Sever currently?
Ok, for some reason I am getting a dodgy message when I try and use SQL server inside Visual Basic 2005 express edition I get a funny error message: "Failed to generate a user instance of SQL Server due to a failure in the starting process for the user instance. The connection will be closed." I thought it was to do with the fault on Microsoft Connect earlier, but as that now appears to have been resolved I am not sure what to do. Is anybody else having the same issues Thanks, Luke Ok, sorted, for some reason I needed to log off and back on once microsoft connect was back up. Strange. Oh well. ...Show All
Windows Forms GetRaiseMethod
I have a button on a form. The click event is handled by a Procedure. Is there any way to get the name of the procedure, using Reflection for instance: Public Sub SaveData() handles btnSave.Click ' some code end Sub. I would like to be able to pass in btnSave as the control, and Click as the Event, and get back SaveData ...Show All
.NET Development SqlBulkCopy and Transaction Log Usage in SQL 2000 Database
I have a SQL 2000 database that is being stressed to see how performance is impacted by database size. The test harness can use 2 different methods for inserting records into 12 tables. About 30,000 records are created across these tables, with the largest number of records inserted into a single table is 6,000. For both methods, the records are identical in size and content. An INSERT stored procedure which contains 12 INSERT statements to copy records from "staging" tables into the "production" tables. Loading records into a DataSet object from the staging tables and then uses SqlBulkCopy.WriteToServer ...Show All
Visual Studio 2008 (Pre-release) how to create .xps files
can anybody know how to create .xps files programatically You probably want to start here . Pay special attention to the side bars. there is an XPS popup menu on the left and there are related links on the right. Articles and code samples for XPS documentations can also be found here Hope this helps. ...Show All
Windows Forms DrawGrid and SnapToGrid
Hi Is there a way to set the SnapToGrid and DrawGrid properties to false by default. I know that it can be done thru VS.Nets Tools -> Options menu. But i need to programatically set the above properties to false Actually I have a custom form which will be inherited by it's users. So when the user loads the form I want that these prop ...Show All
Visual Studio Team System Registering com during build
Hi all I'm trying to register a COM dll during the build process, my Regsvr32 is looking ok but it returns an error code of 3. However when I try and register manually (whilst remotely working on the server) it works absolutely fine. Any ideas Thanks Kev I needed to register a dll before the project was build. In the project folder I created a new folder 'lib' and copied the dll to the folder Opened the project file in the XML editor and added a new target block: <Target Name="BeforeBuild"> <Exec Command="regsvr32 /s "$(ProjectDir)lib\dsofile.d ...Show All
Visual Studio Tools for Office How to get/calculate the character width in MS Word?
BEFORE a lot of text strings are written to a Word file using Office Automation, I need to know the width of each string. Is there any way to do it Please note that office automation cannot be used, because the Word file is NOT available yet. Thanks. It's not really a VSTO related question, but besides that I think you are not in a position where you can determine the width of the string before knowing what font is used, the size of the font etc etc. Every font (except the fixed fonts) has its own width. A Verdana string can turn out to be of a different length compared to an Arial string. ...Show All
Windows Forms Double Click between Datagrid Columns to Expand Column
How does the datagrid know to expand the width of the column to the length of the content (text) in the column. I would like to programmatically mimic this behavior. My app allows the user to select the column that they would like to see and save the names of the columns as a custom view. I use the column list to hide a ...Show All
Microsoft ISV Community Center Forums Need help with opening and closing recordset objects
I recently converted my access application to an ADP and am having some errors with a simple procedure im trying to write off a click event. I think the errors have to do with how I am opening and closing the recordset objects. I know that is a bit vague but i wanted to see if anything stands out as incorrect. Please see below...Thanks. Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click Dim cn As New ADODB.Connection Dim rs1 As New ADODB.Recordset Dim rs2 As New ADODB.Recordset Dim strSQL As String Dim intUserid As Integer cn.ConnectionString = CurrentProject.Connection cn.Open strSQL = "select user_id from tblusers where ...Show All
Windows Forms Can I edit the deployment list of Publish Pane by MageUI?
I cannot find a way to add my own data files to the list shown by the "Application Files..." button on the Publish Pane. If I do all the thing in MageUI, I cannot benefit(like Prerequise..) from the UI of VS2005. Therefore, I would like to know the way to edit the deployment list of Publish Pane by MageUI. Or actually edit the manifest files generated by VS2005 in MageUI, and then reload it in VS2005. Any suggestion is appreciated. Dunno why the files are not getting placed inside the culture folders, maybe its a bug, try reporting it. In the meantime I guess you will have to move them manually. & ...Show All
Visual Studio Team System Enumerating through linked work items
In our TFS project, we have "customer" work items that are linked to "application" work items via a links control. I am trying to create a report where a user selects a customer and then a report of the customer's applications is generated. I am using the "current work item" fact and the "related current work items" fact to filter the target work items. I am joining the two tables on the "current work item_trackingleft" in the "related current work items" table to the "trackingId" in the "current work item" table. I filter the items on the "current work item_trackingright" to make sure only those apps linked to the customer show up in the jo ...Show All
SQL Server LOOKUP component does not have AlwaysUseDefaultCodePage property
Is there any reason for this It doesn't make sense to me. After all, we're hitting OLE DB sources with it - if the OLE DB Source component has this property, why not LOOKUP component -Jamie Hi Jamie, The problem here is that this particular property was added very late to the OLEDB source, furthermore, the lookup component handles its sql statement quite differently from the oledb source so it wasn't trivial to add it (not that it was trivial for the oledb source either its just that the oledb source was written in a way that was considerably more straightforward to add it than for the lookup). HTH, Matt ...Show All