Bill Calkins's Q&A profile

• Visual Basic VB Upgrade Wizard problem

  Hi, Am having issues upgrading from VB6 to VB.Net 2003. I am getting error messages and the following output (the names have been change to protect the guilty ): < xml version="1.0" encoding="utf-8" > <UpgradeLog Upgraded = "True" > <Settings> <Setting Name = "LogFile" Value = "test.log" /> <Setting Name = "GenerateInterfacesForClasses" Value = "FALSE" /> <Setting Name = "ProjectName" Value = "test" /> <Setting Name = "OutputName" Value = "test.vbproj" /> <Setting Name = "OutputDir& ...Show All

• SQL Server Creating a Dynamic YTD calculation in MDX

  I have a YTD calculation that I want to make dynamic based on the real current date. This is the regular YTD formula: Sum ( YTD ([Date].[Calendar Hierarchy]. CurrentMember ),[Measures].[Planned Orders]) This is the YTD formula hard coded with the current date: Sum ( YTD ([Date].[Calendar Hierarchy].[Calendar Year].&[2007].&[2007Q1].&[2007-01].&[2007-01-30T00:00:00]),[Measures].[Planned Orders]) The hard coded date works but I need the date to be dynamic. I’m not sure how to get it to be based from the current date. I’ve been experimenting with using the NOW() function to return the date but I can’t get the syntax correct. Thank you. David ...Show All

• Visual C# Multiple Projects

  I have two projects under one solution. Each of these projects opens the same bound database, Is there any way I can use a common routine to assign the bound database and which app.config should it be in. Add a Reference to your data-access project to your other project (make sure it is a project reference). Now you can call public methods on the referenced project. Example: In Project 1: public static string GetString() { return "!"; } In Project 2, which references Project 1: public static void Main() { Console.WriteLine(Project1.GetString()); } ...Show All

• Smart Device Development Disabling Pocket PC /Smart Phone as Wireless Modem

  Hello Experts, I understand that, Windows Mobile phone can be interfaced with PC either through Activesync or WMDC or throgh making WM as a wireless mobile. I want to develop an application, which should stop my WM act like a wireless modem. Question: Is there any application interface which will help me to disable Wireless Modem connections. or is there any way through my program stop the access of wirelss modem, when my application is ON. ...Show All

• Visual Basic VB6 get function in VB.net

  Instead of using the get function in VB6, what would i use in VB.NET Perhaps if you state what your trying to do rather than translate the vb 6 code, there'd be a better .Net answer. But to answer your last question, #1 is the "filehandle" to the file you opened. ...Show All

• .NET Development Acessing serial port

  Does anyone know what permission is needed to use the System.IO.Ports class In other words What SecurityPermission is needed I am trying to build a WinForm control to run in a browser. Thanks in advance. PatC Hi pat I'm about to do the same as you, a winform in a browser that communicates with comport with a printer attached. Can you pls inform me how you did the winform Rob ...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

• Windows Forms Execute another form's Sub from a Dialog

  Hi, I'm new at vb2005 and this is my problem: Let's say I have a form with a Combobox filled from a dataset, and I want to show a dialog where the user might insert a new value for that Combobox. If the user hits the Ok button, the values are stored ok, but what would I have to do to reload the Combobox content as soon as the user hits ok in the dialog, so the new value appears on the list Thanks in advance.     I don't think you can add a new value to the combobox if the combobox has a datasource, bound to the dataset as you had explained. The only way to do so would be to add the new item directly into the datatable, adding a new row of data and filling in the appropr ...Show All

• SQL Server Trying subreports - does not work

  Hello colleagues, I have the following issue: I am trying to create a report with subreport this way: 1) create report 2) create subreport. Set parameter @AccountName in the SQL query (...WHERE account.name = @AccountName) and in the parameters collection - AccountName, data type string 3) place the subreport into the report and set parameters AcountID = =Fields!name.Value, so that the WHERE clause in the subreport should filter the content according to the field Fields!name.Value. So far, I suppose this should work. Nevertheless, I get this result in Visual Studio .net: An error occurred while executing the subreport ‘subreppp’: An error has occurred during report processing. Cannot read the next data row for the d ...Show All

• Windows Search Technologies Search Toolbar rearranges new IE windows (cascading)

  Hello, when Search Toolbar is installed and i use the "new window" entry of IE6 then the new window will be rearranged like cascading windows in the Visual Studio Editor (to the right and to the bottom). Is there any way to change this behavior I would prefer the original IE6 method where the new window will be only shifted to the right. Thanks Wolfgang ...Show All

• Visual C++ Pointer Arithmetic Gone Awry

  I suspect I'm missing the obvious here, but I'm having trouble calculating the address of a variable length of characters that follow a structure (pkt_file_desc). When I do the math by hand, I get the result I expect. The debugger does not agree. Far be it for me to disagree with a debugger. Any help would be appreciated. Thanks, Johnny. struct pkt_hdr { char magic ; __int64 length; unsigned char hash[16]; unsigned char id[16]; unsigned char pkt_type[16]; }; struct pkt_main { pkt_hdr header; __int64 slice_size unsigned int rf_count; }; struct pkt_file_desc { pkt_hdr header; unsigned char id[16]; unsigned char file_hash[16]; unsigned char short_hash[16] __int64 leng ...Show All

• .NET Development ASP.net Web Site Administration Tool doesn't work at all

  ASP.net Web Site Administration Tool doesn't work at all This is first time i click on it then i would get "an error was encountered. Please return to the previous page and try again" I have visual studio 2003 and 2005 installed both the 1.4+ and 2.0 framework are installed What can i do I have the same problem... http://forums.asp.net/thread/1461276.aspx   ...Show All

• SQL Server can a database be made full after 15 entry's

  Hello guys I was wondering if it would be possible to make a database full after 15 entry's and how would I go about doing that if it is possible I was given the following code but it seems to be giving me a bit of trouble Dim theSqlCommand as new SqlCommand(" SELECT COUNT( columnName ) FROM tableName ") theSqlCommand.Connection = new SqlConnection( connString ) Dim theNumberOfEntries as new object theNumberOfEntries = 0 theSqlCommand.Connection.Open() SqlDataReader theDataReader = theSqlCommand.ExecuteReader(CommandBehaviour.CloseConnection) if theDataReader.HasRows Then theNumberOfEntries = theDataReader.GetValue(0) End If theSqlCommand.Connection.Close() 'We have retrieved and stored the value of the qu ...Show All

• SQL Server migration from sql 2000 to sql 2005

  Hi I am trying to migrate Databases from MS SQL 2000 (server A) to MS sql 2005 (server B). The problem i have when i use database copy wizard is that it gives an error and the login will not be migrated . I tried backup and restore of the databases as well as detach and attach.All cases the logins will have a problem. For example say for database intranet all the tables stored procedures etc gets migrated but under security >>users (say intrauser) i double click user and the the login name wont appear .and when i try to close the window it says login name must be specified(SQLmanagerUI) Please help. Hi .. thank you very much for the reply...... when i executed sp_change_us ...Show All

• Visual Studio Express Editions crease or degrease indent

  How can i get to deacrese or increase the rich text box And how do i in name of god add a table to my rich text box You will have to encode the table yourself....which means that you will have to get some indepth knowledge of rtf formatting codes: http://www.biblioscape.com/rtf15_spec.htm Here is a sample that inserts a two row and three column tableinto an rtf box (and nothing else)...it is a painstaking process but it is what works.... Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Button1 . Click Me . RichTextBox1 . Rtf = "{\rtf\ansi\deff0{\fonttbl{\f0\froman Tms Rmn;}{\par \trowd \trqc\trgaph108\trrh280\trleft36" & _ ...Show All