A.Kahn's Q&A profile

• Microsoft ISV Community Center Forums VB to MSWORD BookMark

  Hi, I am trying to get a currency held in a VB variable from an access database to move accross to MSWORD and keep the decimal point and commas in the bookmark. If i try to transfer over 15.36 for example i get the decimal point, but for numbers like 150.00 once put into MSWord i get 150. Is there any way to keep the decimal places even if its 0 and add the comma's in automatically. It can be hardcoded in using strings but i think there must be a much simpler method of achieving the same result. ...Show All

• SQL Server transform Active X script to what?

  HI I'm totally new to integration services, I was savy with DTS but now having been told to get on with it in SQL 2005 I'm a bit stuck. I've got an ActiveX task which basically does the following:- Function Main() DTSDestination("Title") = DTSSource("Title") DTSDestination("Surname") = DTSSource("LastName") DTSDestination("FirstName") = DTSSource("FirstName") DTSDestination("OtherNames") = DTSSource("PersonCode") IF (IsNull( DTSSource("LastName") ) ) and (IsNull( DTSSource("FirstName") ) ) THEN IF Not (IsNull( DTSSource("PersonCode") ) ) then DTSDestination("Surname") = DTSSource("PersonCode") El ...Show All

• Windows Forms Suddenly I'm getting this error: The form referred to itself during construction from a default instance

  Hi, I'm getting the error below when I try to run my project. It's never happened before, and I don't understand what's caused it. Can anyone help please Thanks, Louise System.InvalidOperationException was unhandled Message="An error occurred creating the form. See Exception.InnerException for details. The error is: The form referred to itself during construction from a default instance, which led to infinite recursion. Within the Form's constructor refer to the form using 'Me.'" Source="FrontierIS" StackTrace: at FrontierIS.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 190 at FrontierIS.My.MyProject.MyForms.get_frmData() at FrontierIS. ...Show All

• SQL Server Modify the width column subtotal

  Hi, is it possible modify the width column subtotal Thanks in advance. I understood, but I can't modify the width property. When I modify, it come back to initial width. Somebody can help me Thanks in advance. Bruno Giminiani ...Show All

• SQL Server Error in Copy Database Wizard execution

  I've been moving databases to 2005 and have always received useful error messages regarding failures using the Copy Database wizard... until the database I am working on now - below is the entire error message - not very useful huh - any ideas on where to look for the problem (substituted xxxx for servernames etc) Thanks, Chris Event Type: Error Event Source: SQLISPackage Event Category: None Event ID: 12550 Date: 1/17/2007 Time: 11:13:02 AM User: xxxxxxx Computer: xxxxxxx Description: Event Name: OnError Message: The requested objects failed to transfer. StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer() at Microsoft.SqlServer.Management.Smo.Transfer.TransferData() at Microsoft.SqlServer. ...Show All

• Visual Studio Express Editions How do you save a file?

  I'm using: My .Computer.FileSystem.WriteAllText( "C:\Test.txt" , String .Empty, False ) to create a file, but how would I save it I want to save it programmatically, so I don't have to do any work :-) Same code. Just replace 'string.empty' with real text, such as Textbox1.Text. Put the statement in a button click event or form closing event or where ever. ...Show All

• SQL Server error when using IIF with sum()

  I have a field I need to have a count for, which is fine, but if that count is equal to nothing I don't want anything to print out in that textbox. It works if the count is equal to nothing BUT if the count has a value I get an error message. My logis is if count = "" then print nothin else print the count =iif( Sum(Fields!delStatusCount.Value, "dsDelStatusCount") = "", "", "DEL = " & Sum(Fields!delStatusCount.Value, "dsDelStatusCount")) Thanks The function sum will return a value. So you can not compare with a string ("") try to replace the string of just =iif(sum(x), x, ""). ...Show All

• Visual Studio Express Editions Need Help Please

  I am currently making a program which fixes errors with Disk Clean-up which some computers encounter. Which means editing the registry, Would anyone know a code which i could use to delete a section of the registry. Anyhelp would be amazing! Mitch which errors if you are talking about the security exceptions then no im afraid as its a Windows/Administrative department and nothing you can do to skip it, otherwise if there were I think we would all be attacked and have severe hackers/computers to repair. It's all on permissions and whether the user account has permission or not   edit: ok the code:   you need to create a new proejct and then import the namespace at the top of ...Show All

• Windows Forms MissingManifestResourceException using images on controls

  I'm trying to set the Image property of a Button. In the designer it is visible, but when I run the project I get a MissingManifestResourceException at the line: this->button1->Image = (cli::safe_cast<System::Drawing::Image^>(resources->GetObject(L"button1.Image"))); the additional information for the exception is: Could not find any resources appropriate for the specified culture (or the neutral culture) in the given assembly. Make sure "panels.Form1.resources" was correctly embedded or linked into assembly . The file "panels.Form1.resources" does not exist, but I don't know why the program searches it. Yes, I renamed the form, I called it PanelsForm.h. If I right-click on the ...Show All

• Visual Basic What To Install From VB Installation CD To Let Users Run My Application And Not Enter VB

  The best way for me to do what I want to do is install on all PCs (using VB installation CD) the minimal requirements to run my application which uses VB 2005, ADO.NET to read/write to an Access database, and Crystal Reports. I ask you what, specifically, should I install on all these PCs from the VB 2005 installation CD After that the next thing I will do is I give each PC user a shortcut file (having a nice icon that says database on it) which runs the exact same executable on a shared drive. My application already has the capability to tell users if someone is already actually using the database via a warning message. The hope is that only one person will use the database at a time. There aren't many users so this sho ...Show All

• SQL Server How to Convert DBTIMESTAMP column VAlue to Particular Format in SSIS Package

  Hi i am Using Report_Date Column DBTimeStamp Data type. This isReport Date Taken From Current System Date from Varaible. I need Convert this Date Time Format to the Follwing Foramt . " TO_DATE(Report_date, 'YYYY-MM-DD HH24:MI:SS')" HOw to Achieve this one in SSIS Package . Any one give me a solution. You might also try just casting the DT_DBTIMESTAMP column to a string in the derived column transform and see if the result format is what you want. An expression like the following might work for you: (DT_WSTR, 50)[Report_Date] If the resulting format isn't precisely what you want, then you can use the functions Rafael mentioned to build exactly what you want. ...Show All

• Visual Basic urgent...datagird problem....

  In my window application,. i used datagrid only to display record from database.......How can i set the datagrid so that user cant select the row or colunm in datagrid This is to ensure user wont misunderstanding the function of the table( only can read, cannot do any operation) If i set it to enabled=false, the user wont be able to scroll down the datagrid......so wat should i do so that the row or column of the datagrid cannot be selected ...Show All

• SQL Server Loading data at Both Ends of a Merge Replication?

  Hi gang, We have a database that's using merge replication between two servers, and we need to insert a lot (about 1GB) of data into it. The servers, however, are separated by a 192k WAN connection, so it's impractical to rely on the merge replication to send the data across to the subscriber. Is there a way to insert the data at both ends I can get the data out there on a DVD or a laptop easily enough. Can I load the data into both copies of the database and tell the merge agent that it's not to be replicated Thanks, Matt Not directly. The easiest way to do this is as follows: 1. Drop the subscription. 2. Create a new subscription to a database that is local to the publisher 3. Load ...Show All

• Visual Studio .NET Framwork

  hi all, i have .Net Framework 1.0 , and want to shift on .Net Framework 2.0. should i have to install VS .NET 2005 or i can only upgrade my .NET Framework Tejas Kishanwala in order to use .NET 2.0 you need VS2005. you cannot create .NET 2.0 apps with VS2002/2003. you can install .NET Framework side by side without having to install one and remove the other, so you can still keep VS2002.2003 if you like and develop on them, but to use .NET 2.0, you would need VS2005 ...Show All

• Software Development for Windows Vista Disabling IMAPI in Vista

  Is there a way to disable the IMAPI layer in Vista for a particular device Unfortunately as much as the err " Power calibration error" aactually means that the hardware has failed, it doesnt always mean that, and most of the time it does not. The disabling of the imapi service in XP worked for my dvd burner, and a day after I installed vista the error is there again, but this time there is no service to disable. I am still looking for a solution to this problem as I know that my drive is functioning properly, as I have rebooted to XP and burned with success. ...Show All