John Hax's Q&A profile

• Microsoft ISV Community Center Forums VB MACRO IN SHARED WORKBOOK(EXCEL)

  HI, PLEASE UPDATE ME HOW TO RUN VB MACROS IN SHARED EXCEL WORK BOOK THANKS, Aravinda ChassAA ~ I'm working to set up a resource library that utilizes macros to take a user through menu options. This resource library needs to be accessible as a shared workbook so that more than 1 user can be in it at a time. Please advise the best way to protect and share the workbook but still maintain the various vb macros. Description of set-up: There are multiple tabs within the workbook but only one tab displays at a time depending on the menu selection. It is set up to run with a topics menu, category menu for each topic, resource menu for each category, and a file menu for each resource. Step through example: The ma ...Show All

• Visual Basic how to parse a resume document

  in my windows application i need to parse a resume and fill the details in some text boxes and listboxes can any one help me how to solve this problem ahmedilyas wrote: AFAIK, you would probably need to use some MS Word Interop to read word documents. If its an RTF document then you can load this and do all your parsing etc... using the RichTextBox control, however the control will not read Doc files. I thought I would give you some head start on where to start looking from :-) AFAIK , can u help me a little moure plz ...Show All

• Windows Forms VB.NET - prevent bad user input

  Hi, How can I prevent the user to insert some caracters on a textbox I want to prevent letters, all non numerical. I want to allow inserting numbers, decimal separator, backkey(delete), arrow keys (left and right), etc. How can I "see" if the number inserted has alredy one decimal separator, and prevent the user to insert another Regards, Pedro Hi, I cannot confirm if the MaskedTextBox is the solution. I want to try still the textbox control. Besides, this textbox is binded to a DataSet. I don't want the user to insert a specific format... I just want to allow the user to insert a decimal number, but also want to "filter" and garantee a correct ...Show All

• Visual Studio Express Editions Unable to Sart Debug?

  When i finish writing some codes, i cant debug because i get an erro that reads: "Error while trying to run project: Unable to start debuggin The binding handle is invalid" help ...Show All

• SQL Server DataGridView: How can I update data in a DataGridView?

  Hi guys, Im having some issues understanding how to manipulate the data that is in my DataGridView The View is created by calling a stored procedure from VB code and works on two tables: people pswds The columns required from Table people are (personid, userid and sort). The columns required from Table pswds are (comment and activeuser). Table people is parent table while pswds is the child table. The Relationship works between both tables using primary keys from both tables: which is called personid in both. The link below shows the Relationship Diagram for the Two tables: http://cale.csd.anglia.ac.uk/~csd03ib/images/RelationTables.bmp The code for the Stored procedure can be found at the follow ...Show All

• Smart Device Development RFID with Keyboardwedge

  Hi, I have a Ipaq with rfid reader. When I am in notepad/word i can press a hardwarebutton and the id of the rfid tag will be entered by the keyboardwedge. So I thought oke lets do that in a c#program :) It works when i have a textbox with focus. My problem is that i dont have a textbox on the form and i dont want to put one because an user isnt allowed to see the id. I used the keypreview = true and a key_down event. When I scan the event is triggered but only once and i get a keycode=none . Does anybody know how to solve this or any other easy way to create an 'automatic' keyboardwedge Grtz Annihil8 You said in your original post that it works if your form has a textbox with the focus, b ...Show All

• Windows Forms Need to make a Basic code editor?

  Hie , I need to make a simple html editor.. but much like VS , or dreamweaver i want to display a list of tags according to what the user types.. i dont want to build my own intellisense or something.... i know.. that all i have to do is populate an invisible list via a database ...and then show it when the user types.. BUT 1. how do i KNOW the text the user is TYPING when he has'nt selected it... ....for eg ... if i type <script... how would i get to know this is what the user has typed (i hope i'm clear enough!).I also need to implement color coding. ....should i like run though the whole text 2. How would i get the x , y positions of the cursor... (i'm still new to C# and .NET).... of course i need the X , Y pos ...Show All

• SQL Server sp_OACreate in SQL Server 2005, Fails with 'Not enough storage is available to complete this operation'

  Hi all, I have created a small COM in C# so that I can programatically create and execute stored procedures with SMO. At this point the COM has nothing in it but just a test prototype. But when I tried to create the object as follows, I get the error indicated below. It is not a memory issue because I have adequate storage and RAM. Please Help! DECLARE @object int DECLARE @hr int DECLARE @property varchar ( 255 ) DECLARE @return varchar ( 255 ) DECLARE @src varchar ( 255 ), @desc varchar ( 255 ) -- Create an object. EXEC @hr = sp_OACreate 'SQLInterop.CsharpHelper' , @object OUT IF @hr <> 0 BEGIN EXEC sp_OAGetErrorInfo @object , @src OUT , @desc OUT SELECT hr = convert ( varbinary ( 4 ), @hr ...Show All

• SQL Server Express and Developer - performance counter errors

  I installed Visual Studio 2005 on my machine, which includes SQL Server Express. I then installed the Developer edition of SQL Server over the top, as that's the edition I wanted. I now get four errors in my Application event log whenever I boot Windows: MSSQLSERVER - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions. MSSQLSERVER - Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled. MSSQL$SQLEXPRESS - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the ...Show All

• Visual C# Cannot add FileSystemAccessRule when account type is a AD Group, works fine wiht AD Users

  We have a web application that creates directories, and needs to set permissions on those directories. The setting of the permissions works fine for users, e.g. @"BRADJOSS\Brad", but I cannot for the life of me get it to work with any groups. Specifically, I would like to have the local machine administrators to always have full control. I have tried the following in the Domain value for the new NTAccount call: LOCAL BUILTIN Environment.MachineName.ToUpper() [Our Corporate Default Domain] The slice of code looks like: string User = "Administrators"; NTAccount theAccount = new NTAccount(User); if (theAccount.IsValidTargetType(typeof(IdentityReference)) == false){ ...Show All

• Visual Studio Team System Download FXCop 1.32

  Hi , I want to download FXCop 1.32. Please send me the link. I ahev the link for FXCop 1.35 but I want FXCop 1.32. Thnaks and Regards, ChatanyA Agrawal Hi David, As i'm working around a code review of a .Net 1.1 web application with commerce server 2002, i'm looking forward using fxCop 1.32 version for this purpose. Unfortunatlly, I can't find it, can you help me to get that version (1.32 of FxCOP). The reason of use this version is the application's owner allows only the .Net 1.1 runtime to avoid any collisions with commerce server 2002 API. Thank you for your help. ...Show All

• Gadgets Non Editable Text in Spin control(textbox)

  I am using Spin Control (Javascript) in classic ASP Web application. Suppose i want to add Spin Control for seconds , I would like to display units in the spin box eg. 12 seconds where seconds is not editable but 12 is editable. I want to display 12 seconds in textbox. What could be the possible solution ...Show All

• Windows Forms Step by step instruction. Open Form2 from Button on form1 C#

  Hi, anyone able to tell me please how to.. Click on a Button i named Next on Form1.. it will then open Form2 page not as an extra page.. but as though its a new page on the same window. ty Hi, Woody There 3 ways: tabcontrol containing two tabpages, two panels in one form, two forms M1: Drag a tabcontrol in which lies two tabpages this .tabControl1.Dock = DockStyle .Fill; this .tabControl1.Region = new Region ( new RectangleF ( this .tabPage1.Left, this .tabPage1.Top, this .tabPage1.Width, this .tabPage1.Height)); Switch the panels by tabPage1.Hide(); tabPage2.Show(); M2: similar to M1, difference is previous use tabpage, here use panel. M3: To ...Show All

• Visual Studio 2008 (Pre-release) svchost.exe

  I received this error on my pc renning windows XP SP2:   The memory could not be read file name svchost.exe   then I can not access the network .how can I solve this matter. thanks  svchost.exe is the norton antivirus stuff. It si something wrong with your antivirus or internet security - that's why you are not access the network afterwords - system security does not allow it. Sorry, but I don't know how to solve it... ...Show All

• Windows Forms Parameter count does not match Parameter Value count.

  Parameter count does not match Parameter Value count. what does this mean...I am trying to update my sqldb...I have all the right parameters...why elese would this come up Tryin2Bgood wrote: Here is my Query for the Update or Insert...its a Save Function() When i insert a breakpoint it shows me the values of whats in the Database but if i add new values to the controls it never has what was added....Like the new data is not being sent at all..... public void Save() { if (_CustomerID == 0) { SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString,"Customer_Insert", new object [] { _CustomerCode, _Attention, _Class, _LoadType, _VehicleType, _TermNumber, _Status, _Commodity ...Show All