aero1's Q&A profile

• SQL Server maximum users logged in sql express

  we're planning to use sql express as our database server in our office. the database will consist of accounting, purchasing, marketing, sales, inventory, production and hrd tables. 80-100 users will use the system simultaneously in adding, editing, deleting, reports. i need some advice on the following: 1. maximum users that can log on to the database simultaneously 2. maximum size of the database tnx Hi, the maximum number of users will be most likely limited by hardware ressources not by a logical threshold, its around 32k users. maximum size of each database is 4GB. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic right click event...

  Hi, 1. I would like to get the handle of the menu which appears when the user right clicks in the slideshow window of powerpoint. I would like to do it in visual basic... 2. If the user choses an item from the menu which appears then how to get know which item is being chosed by the user. Plzzzzzzzz anyone answer atleast one of the question...... Thank you for your help. ...Show All

• Visual Studio 2008 (Pre-release) January Orcas CTP

  Does the January Orcas CTP that released last night have WPF support If no, when will we start seeing WPF support in the Orcas CTP's. Steve When to expect the Beta 1 of Orcas approximately (April, June ... ) Up to then: Can I use the November CTP of WPF & WCF on top of the January CTP of Orcas If yes, do I need to install .Net 3.0 and Windows SDK too If no, wich is the recommended (pre-release or free) VS version to try out WPF and Cider Thx, Jaga ...Show All

• .NET Development Table does not appear to update after UPDATE statement

  I am trying to update a table (asps) in MS access with the code below. However even though it complies and appears to execute, the table is not updated. Both ID and recID are double. I am working in ASP .NET C#. Any ideas Thanks private void Button1_Click( object sender, System.EventArgs e) { OleDbConnection conn = null ; conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source=C:\\Inetpub\\wwwroot\\WEB\\afterschoolprograms.mdb"); string strEditCommand = "UPDATE asps SET "; strEditCommand += " NAME = "; strEditCommand += " WHERE ID = "; using (OleDbCommand cmd = new OleDbCommand(strEditCommand, conn)) { cmd.Parameters.Add( ...Show All

• Windows Forms bindingsource.addnew and .haschanges

  I have a form that loads in a new state, but the user may decide not to add a new row, but will want to edit an existing row. When the form opens with no ID for the form, my code calls: BindingSource.AddNew() Even if no changes are made to the form, calling: DirectCast (BindingSource.DataSource, DataSet).HasChanges() This will always come up as having changed. Is there any way to find if there have actually been any changes after AddNew is called. Mark Dahl Gavin, Thank you for the response. I really appreciate it. However, the following code is run when the form loads: '// Header refresh If FormHelper.DBInt(FormID) > 0 Then EmployeeTableAdapter.Fill( Me .Emplo ...Show All

• Microsoft ISV Community Center Forums append excel data to text file

  I am going to have multiple excel files feeding one text file (each file will only append one line of data). Any suggestions Thanks The data in your XL file can be in a cell, or an autoshape, or a chart etc. Because you did not specify where that data lives, I assume you have it in cells. To get the text from a cell using VBA you write something like this: ActiveWorkbook.Sheets(idxSheet).Cells(idxRow,idxColumn).Text ,where idxSheet - index of the sheet you have the data on idxRow - index of the Row idxColumn - index of the Column Another option is not to use VBA at all: if indeed the data you have is only on Excel cells, you can add the excel document as an ODBC provider and connect to it as to a regular database, ...Show All

• .NET Development .NET 3.0 breaks printing subsystem on non-english XP / VERY ugly effects

  After installing .NET 3.0 on non-english XP two things will break parts of the printing subsystem: - parts of XPS are installed in English, i.e. unidrv.dll / unidrvui.dll / unires.dll etc. are non-localized As a consequence Printing dialogs of all unidrv.dll-based printer drivers show mixed output localized/english. And the default Input Tray is set to 'Automatically Select' even on a german XP which leads to strange effects like printers suddenly asking for paper in the Manual Tray instead of using Tray 1 as usual. - unidrv.dll / unidrvui.dll / unires.dll etc. are Windows Vista DLLs and incompatible with many XP Printer Drivers As a consequence some printer drivers will print all pages of multi-page documents on one sheet, all ...Show All

• Visual Basic Question from a newbie...

  Hello. I am interested in learning VB, but I do not know what edition I should get. Any suggestions THanks. Well you can start with VB Express, its a free full (limited in its features) product. Ideal for newbies. And after registering the product, you get the benefits of e-books, code samples and apperently videos also. And you have these forums if you need a hand. http://msdn.microsoft.com/vstudio/express/vb/download/ manual installation: http://msdn.microsoft.com/vstudio/express/support/install/   you also have MSDN as a resource, pretty much a "book" if you like, of all classes, examples, details about each classes and some starter kits also ...Show All

• Visual C++ Error LNK2019, linking error - please help

  I am currently writing a programme in C which is going to convert roman numerals to arabic numbers, now I don't need help actually writing the programme(I dont think. Though if you see anything obvious let me know!) But I get this error whenever I try and build the solution, I really have no idea why! If anyone can help I'd really appreciate it. 1>------ Build started: Project: roman numeral conversion, Configuration: Debug Win32 ------ 1>Linking... 1>converter.obj : error LNK2019: unresolved external symbol "int __cdecl romanArabic(int,int)" ( romanArabic@@YAHHH@Z) referenced in function _main 1>C:\Documents and Settings\Xin\My Documents\Visual Studio 2005\Projects\roman numeral conversion\Debug\roman num ...Show All

• SQL Server DTS/SSIS too many tables warning and subsequent error

  I need to bring over a large number of tables' records (200+ tables) with the Import/Export Wizard. The tables are being imported from MS Access. A separate script run previously will create the tables, so the DTS wizard is only to bring over the data from the Access tables into the empty SQL ones. First, I get the warning that indicates "a large number of tables are selected for copying, and the wizard may not be able to copy all the tables in a session. Select no to go back and unselect some tables, or select Yes to attempt to copy all the currently selected tables at one time". Well, I proceed with the DTS and it tries to validate and takes a fair bit, but then it errors indicating: "Error 0xc0202009: {2F0FABA0-5F4B-4 ...Show All

• Visual C++ Migrating to VC2005

  I am trying to migrate my C++ codes written using VC6.0 to VC2005 but having some problems. These seem very trivial, but I am just unable to get around it. When I use the statement "#include <iostream.h>", I get "iostream.h: No such file or directory" Then, I try, "#include <iostream>", which seems to work, only that now it gives a fatal error on "cout << "Hello World\n";", saying that "cout: undeclared identifier" Could someone please tell me what am I doing wrong here I am trying to build a simple Win32 console application. Thanks a lot... cool! That worked. So do I have to always have this "using namespace std;" thin ...Show All

• .NET Development How can I let a user select the location of a database?

  Hi, I've created a program that uses a database. The problem I have is that the drive names and or directory names change true time. How can I let a user select the current data base location when it has been changed Like: Dim path as string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=(path & Database.mdb) path = (get it from an file dialog box) Any idee I'm working with vb 2005. The connectionstring I use is made with the wizard of vb2005. It looks like your have the general idea, but it sounds like you want the users newly chosen path to persist over time, so you will have to save it somewhere. Here is how I would do it: 1. Create an entry in the Setting (Properties --> settings) with the name _ ...Show All

• Visual Studio Express Editions toolTip

  Any example on how to use the tooltip function you may need to be more descriptive but here is a simple example on how a tooltip is used: Dim theToolTip as new ToolTip() theToolTip.SetToolTip( Control , Text )   so if I wanted a tool tip on a textbox theToolTip.SetToolTip(Me.theTextBox, "This is a tool tip!" )   you could also say, show this tool tip when the mouse hovers of that textbox, by implementing the TextBox's MouseHover event, then place the code above in there, so when you hover over the control, it should show it. http://msdn2.microsoft.com/en-us/library/system.windows.forms.tooltip.aspx Does this help ...Show All

• Visual C++ Reverse Engineering c++ code to Visio UML

  Hi, I'm trying to reverse engineering my code written in MS VS 2003 in order to create a Visio UML diagram. Unfortunately not all the classes are extracted and the few classes that have been extracted doesn't have all the features. Is it possible to fix this problem or should I draw the UML diagram by hand Cheers Donatella Hello Which version of VS 2005 are you using Thanks Damien ...Show All

• Visual Basic Hello nooby here... needs a quick answer!

  Ello... I am in the middle of programming a game... ... again.. in visual basic... and I can't seem to find a way to make it check to see if a image is a certain image... Basically... what i want it to do... ... is when you click it... have it check to see which picture is up... Example (Red is the part I'm stuck on and can't seem to get to work I've tried so many different things its insane... but I'm sure one of you experts has the answer I'm looking for) : If Picturebox1.Enabled = true And Picturebox1.picture = ("C:\Picture.jpg") Then Picturebox1.Image = Nothing Picturebox1.load = (C:\Picture2.jpg") End If ANY help what so ever would be appreciated... Thank you all, Moveit Hi, this should do it: If Pi ...Show All