HSCSydney's Q&A profile
Microsoft ISV Community Center Forums VBA and Access Noobie Questions
1. Our software developer created a software using VBA as a module in Access, We would like to let people use our software for 30 days then disable it until they enter in the right key code. Is there a way to do this We currently use a key generator to give them key codes but it only limits the number of records our software imports. I don't know how to give them full access for a time period. Is that possible If so please share! :) 2. We had another software company tell us they would like to get information from our software using an API but they said we need to migrate our VBA app to VB.Net or something like that so we can create an API. They use Java and netbeans I think. Is this true, It this the only way What program do you suggest w ...Show All
Windows Forms Using More than One language
Hey friends.. I want to show my project in more than one language I mean in German ,English,Chinese n all Can anyone tel help m ... thanks in advance byee or use the code in this post... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1202580&SiteID=1 Grtz Adriaan ...Show All
SQL Server SSIS Dynamically Naming Output Files
I've just started using SQL Server 2005 Integration Services and I've come up against a situation where I need to name output files dynamically (i.e. based on a timestmap). Looking through this newsgroup, and other web resources it looks like my only option is to use a Script Task/ActiveX Script Task to rename the file after it has been created with a generic file name. I was wondering if there was a different approach or if there was a way to pass in a variable to the file connection manager that I could append to the file name at run-time. Thanks Bill You can use a variable in an expression, as applied to the connection string property of your connection, e.g. @[User::FilePath] + "\\" ...Show All
Visual Studio Uninstall of an addin crashes Visual Studio
Hi. I have a native C++ addin for VS2003 that registers a bunch of commands and a custom toolbar. As an uninstall custom action I run a VB script similar to the one here: http://support.microsoft.com/ kbid=555322 However during uninstall I'm getting a Visual Studio crash dialog. The script itself works fine. It gets rid of the commands and the toolbar. The only problem is the crash. I reduced the script to just this: Set objDTE = CreateObject("VisualStudio.DTE.7.1") objDTE.Quit and even just this: Set objDTE = CreateObject("VisualStudio.DTE.7.1") But it still causes a crash. BTW, running the script alone causes no crash. Just when it is executed as part of the uninstaller. Any ideas what to do ...Show All
SQL Server still struggling with flat file into multiple tables
So here's the issue 16 flat files all fixed width. Some over 350 columns. Open flat file 1 extract id and go see if its in table 1, if true update table 1 with first 30 columns otherwise insert into table 1 first 30 columns. goto table 2, lookup id, insert/update next 30 columns...etc..etc..for 10 different tables So I've got my flat file source, I do a derived column to convert the dates, i've got a lookup for table 1, then 2 ole db commands, 1 for update if lookup successful, 1 for insert if lookup fails. How can I pass the id as a param into the update command so it updates where x = 'x' also I need a pointer on doing the next lookup, eg table 2, would I do this as some sort of loop . If you can help great, bu ...Show All
Visual Studio textchanged event on texteditor
How can I intercept the event triggered by the texteditor/textbuffer's text changing The VSPackage I'm working on is similar to the SynchronousXmlDesigner sample. If the user changes the xml from the codeview I want to know about it! Implement IVsTextLinesEvents interface which includes a method called: OnChangeLineText This method will be called whenever the text on any line changes. Once you implement this interface you jsut need to hook up the class that implements this interface with your text buffer doing somethign like this: IConnectionPointContainer connptCntr = (IConnectionPointContainer)vsTextLines; Guid riid = typeof(IVsTextLinesEvents).GUID; IConnectionPoint cp; connptCntr.FindConnectio ...Show All
SharePoint Products and Technologies _layout pages and masterpage
Hi All, I'm a bit confused here. Is it true that modifying the application.master (which I don't want to do) is the only way to change the masterpage for the _layout pages in Sharepoint 2007 In fact changing all the files themselves is not an option either because it's not supported I was told. So how's the correct procedure to change the _layout pages from your sitecollection Fred Nope, but I'd like to know that too. It's on the 'to learn' list. Themes are a part of ASP.NET 2.0, though, so they're not SharePoint specific - it just doesn't seem to be easy to force inheritance of a theme. Will let you know if I find out. ...Show All
Smart Device Development Exception in COM incorporating
Hi, when I start my project, I get this Exception: "System.Runtime.InteropServices.COMException(0x80040154)" occured in ManagedCOMClient.exe additional Informationen: COM object with CLSID '{67119DD9-681E-4D96-AC72-662D80686F21}' cannot be created due to the following error: Class not registered . Does anybody knows why this exception occures I use Visual Studio 2005 and tried to run on Windows Mobile 5.0 Pocket PC Emulator. I hope you can help me. Thanks in advance jojo82 You can add the COM dll as content file to your managed device project and set its "COM Register" property to "Register" and "Copy to output directory" property to "Copy if n ...Show All
Windows Forms move focus to next control,whaterver that control is--> at Form's level
I have many control in the windows form, some are custom controls from different "programming way". How can I set a method to change focus from one control to next one, when you hit enter key, so you actually have a controls ring including buttons, listbox, textbox, ... thanks in advance for your help, Edward I addition to SelectNextControl, Make sure all your controls are in Corrent Indices. Select the Design View of Form, View - Tab Order, It'll display some small labels on all of controls on your form, click one by one in order and it'll set right Indexes... Best Regards, Rizwan ...Show All
Windows Live Developer Forums Configure the 3d plugin
when i installed the 3d plugin, i got a dialog with detail-settings once, i chose 'high' and closed it, now i want to reconfigure it, but cant find a way to display the dialog again. helphelphelp Go to http://maps.live.com and choose Options . It's in there, under 3D view options. ...Show All
Visual Basic New Line
have a variable Public NewLine As String = Microsoft.VisualBasic.Constants.vbCr + Microsoft.VisualBasic.Constants.vbLf but when I try to write it gives me a null string ('',) along with the new line in the text file. I have tried: 1. Write(CurrentReportFileNum, NewLine) 2. Dim strWrite = (NewLine + "TEXTBOX") Dim strWrite = "TEXTBOX" Write(CurrentReportFileNum, strWrite, SlideNumber, CurrentDataTitle) 3. Write(CurrentReportFileNum _ , PtsLeft, PtsTop _ , (PtsRight - PtsLeft), Abs(PtsBottom - PtsTop) _ , TxtRotation, Label_Str, TxtAlignment, FontName, FontSize _ , FontBold, TextOrientation, Shaded, ForeColorRGB, NewLine) and they all give the null string after the line return. ...Show All
Windows Forms MDI windowlist formclosing bug
Hello, In my application, I have an MDI parent form and several MDI child forms. Wanting to allow the user to click the X on the child window and hide the window rather than close it, I implemented the FormClosing event handler as follows: if (e.Close Reason == CloseReason.UserClosing) { e.Cancel = true; Hide(); } This does hide the child window but when the user opens the window again, the windowlist is never populated again for that window. It is undesirable for my application to make new instances of the child forms each time one is displayed so instantiating a new form instance when I want to show the child form is not the solution. The code in the parent window to display the child windows does this: myForm.MdiParent = this; myForm. ...Show All
.NET Development Output the XSLCompiledTransform.
Question :- How do I get the results of the XSLCompiledTransform.Transform method into an XML.XMLreader object Hi, I ran into following situation when migrating my framework 1.1 codes to 2.0: Old situation (.net v1.1): ==========xslt file============= < xml version="1.0" encoding="UTF-8" > <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://www.w3.org/TR/xslt.html#strip"> <xsl:output method="text" version="1.0" encoding="UTF-8" indent="no"/> <xsl:variable name="SelectedStateId" /> <xsl:template match="Jurisdictions"> <xsl:param name="iSelectedStateId" select="$SelectedStateId" /> <script type="text/javascript" ...Show All
SQL Server how to save xml document in database table?
I have a db in Sql Server Express 2005. Into this db I have a table with an XML field and I want to save an XML document into this field through SQL. Any suggestion to do this operation Thank you Mirko There is a nice article about XML fields and SQL server. http://www.developer.com/db/article.php/3565996 However there is a problem on that article I'll paste the insert statements here: INSERT INTO Document (Description, DocumentStore) VALUES('Bruce''s poem', N'< xml version="1.0" > <Document Name="Poem"> <Author>Bruce</Author> <Text>The cat/is flat.</Text> </Document>') INSERT INTO Document (Description, DocumentStore) VALUES('Code ...Show All
Windows Forms Loading Image (Visual C# 2005)
Hey, I after these lines of code what should I put to make it load the image into a PictureBox openFileDialog1.DefaultExt = "*.gif" ; openFileDialog1.Filter = "Gif Images (*.gif)|*.gif|JPG Images (*.jpg)|*.jpg|TIF Images (*.tif), (*.tiff)|*.tif|PNG Images (*.png)|*.png|BMP Images (*.bmp)|*.bmp" ; openFileDialog1.InitialDirectory = "MyDocuments" ; openFileDialog1.CheckFileExists = true ; openFileDialog1.CheckPathExists = true ; Thanks :) umm, it works thoe... but one more question... I am doign the same thing for save but made it this: saveFileDialog1.OverwritePrompt = true ; saveFileDialog1.Filter = "Gif Images (*.gif)|*.gif|JPG Images (*.jpg)|*.jpg|TIF Images (*.tif), (*.tiff)|*.tif|PNG ...Show All