Grant Jenkins's Q&A profile

• Microsoft ISV Community Center Forums How do I execute code when I open a workbook?

  I need to know how to start a VBA script when I first open a workbook without having to do anything else to activate it. Any help on this would be greatly appreciated. Are you after the special facility hiding thus: In the VBA editor, with View / Project Explorer operational, find ThisWorkbook under M S Excel objects and double-click it. Change the left dropdown above the code screen to workbook and it will give you the outline of a macro which will auto run on opening. And here I was online trying to solve a problem caused by that very facet of VBA ...Show All

• Windows Forms Custom Folders in Click Once

  Hi, I want to use clickonce deploymnet. I have application where, inside bin folder I have folders which are required at run time. e.g. I have Reports Folder like \bin\Debug\Reports where I have stored all the RPT files which I called at run time . So I want that , this Reports folder should also get created at the same path where my exe will be installed. Is there any way through ClickOnce, along with exe, my custom folders also get created On Publish tab of project properties, there is option of ApplicationFiles, but it is not allowing to edit/Add. Can anyone suggest the way out of it ...... Thanks Vyanki Hi, Thanks for reply. I think there is some confusion abt my requirement. I just dont ...Show All

• Software Development for Windows Vista Service started very late in Vista?

  I have a service program with OWN_PROCESS, AUTO_START, no any dependency. This service works on Vista as well as w2k/wxp, except the Vista start it in a very late statement. In w2k/wxp, my service program can start before user logon. But in Vista, even the user has logon, it takes about 40 or more seconds before my service program start running. My PC is Celeron 3.0GHz, with 1GB RAM, I don't think it's the hardware's problem. Since my service is one part of the drivers for an input device, this is very important for me to load the service ASAP. Does any one know how to boost the load order for this type of services We ran into this problem, too, and just found the problem. If you have an ethernet card or interface that is c ...Show All

• Windows Forms Print Preview problem(Bug)

  Hey, I have this code in the PrintDocument control under the PrintPage event: private void printDocument_PrintPage( object sender, PrintPageEventArgs e) { RtextboxUC thisrichtextbox = GetCurrentTextBox(); //Start printing text and store last letter... checkPrint = thisrichtextbox.Print(checkPrint, thisrichtextbox.TextBox.TextLength, e); //Check if there should be more pages if (checkPrint < thisrichtextbox.TextBox.TextLength) { e.HasMorePages = true ; } else { e.HasMorePages = false ; } } There are no errors, but when I test it on my program and click print preview...when it opens the PrintPreview dialog It shows the dialog that is telling you how many pages it is det ...Show All

• Visual Studio Team System TF30177: Team Project Creation Failed - Windows Sharepoint Services 2.0 SP2

  I am getting the following error when trying to create a new Team Project. The problem appears to be related to setting up the SharePoint Portal site for the new Team Project. I was able to successfully set up several Team Projects previously. I have searched the message boards and have done the following based on guidence found there: Given NETWORKSERVICE Account permission to access STS_Config_TFS in SQL Server 2005 Run 'stsadm -o upgrade -forceupgrade' Repaired .NET 2.0 Nothing has seemed to work. I have not seen the specific error code (0x81070550) referenced anywhere. Any help would be appreciated. 2007-02-20 12:45:01Z | Module: WssSiteCreator | Thread: 9 | TF30267: Exception: System.Web.Services.Protocols.SoapException: Excepti ...Show All

• SQL Server Execution Plan Creation: Freezing of SQL Server 2005 Management Studio Application

  From time to time...while using SQL Server 2005 Management Studio Application the entire application will 'freeze' during some specific activities. Primarly this happens while using the GUI Tool to rebuild all of the indexes or when you are having SQL Server also create the execution plan of a set of queries while executing the queries. It happens consistently and on several different machines here in the office. Is a new version of the Management Studio tool planned for a release in the next few months What can be done now to get around the problem Thank you. ...cordell... Management Studio isn't supposed to block user input even when queries are running, so any long freezes would be a defect ...Show All

• Visual Studio Express Editions Using button to browse a image file and load into database

  Hi im a begineer. the following is what I do. I created a database table and 1 of the field i put it as varbinary(MAX) let call this field "SmallPhoto" I drag the picturebox from the toolbox to my form1 and i drag a button to my form1 too. Now I need to configure that when i click on the button i can open an explorer to search for an image file and load into the picturebox, and click on the save button to save this image file to the database. Please advise how to do it as i am running out of idea. yep, lastly i had been watching the video clip from visualstudio.net for solution too... thanks in advance what doesn't work you really have to explain :-) for the last 2 DateTimepicker events, you are not assigning the Da ...Show All

• Visual C++ CSting construction

  hi guys I am using VisualC++ 2005 IDE. in one MFC project, I use the following code but there is a error. please tell why this happens. thx code CString lpszText=" error"; error is error C2440: 'initializing' : cannot convert from 'const char [38]' to 'ATL::CStringT<BaseType,StringTraits>' 1> with 1> [ 1> BaseType=wchar_t, 1> StringTraits=StrTraitMFC_DLL<wchar_t> 1> ] 1> Constructor for class 'ATL::CStringT<BaseType,StringTraits>' is declared 'explicit' 1> with 1> [ 1> BaseType=wchar_t, 1> StringTraits=StrTraitMFC_DLL<wchar_t> 1> ] Hi, u can also do like, make it ...Show All

• SQL Server Deadlock at trigger

  a trigger need to insert or update record at the other table in high traffic environments however, the deadlock happens; ie, a trigger running twice at the same time want to need to insert record at the table. i trid to change isolation as SERIALIZABLE or REPEATABLE , but i cannot solve the problem. i guess the "while loop" affects the result because i try to cancel the loop and execute smoothly. How to solve the deadlock Thx ----------------------------- i used the following commands to change isolation level: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE begin transaction commit transaction ----------------------------- the code are as follows: declare setskuCursor cursor local static for select item, qua ...Show All

• Software Development for Windows Vista How to succeed in getting Vista Startup?

  Hello everyone, I have a big problem that my program will be blocked of Windows Vista's Windows Defender. The UAC setting is on and I found it so stange that both my program and Spyware Doctor need UAC confirmation to run, but why does not Spyware Doctor get blocked but only mine get blocked A process elevates if manifested to do so, or it is detected as an installation. For this reason it is recomended that all applications have a manifest to correclty indicate the execution level. To give you the history and the over all picture: Your application is getting blocked becase vista has a new feature is to help users so they will not have 100+ applications running in the system tray. Common users don't know h ...Show All

• Visual Basic compatibility with spanish xp

  i have an application written in VB6.....will it run on spanish xp ...Show All

• Windows Forms Problem with an OCX file in a windows service?

  Hi all, I was converting a windows application to a windows service. The problem is with an ocx file. The windows application is using a server.ocx file and I created an instance of that ocx control by drag n drop from tool box in that windows application. Now when I tried to convert that application to a service I couldnot use that ocx file by drag n drop. Then, as an experiment to use that ocx file, I added a windows form in to the windows service project,added the ocx control and handled all the events of the ocx control in that form. Also I added two public functions called Initialize() and UnInitialize() and I called these functions in the OnStart and OnStop methods of the service. Then I am getting the following error in ...Show All

• SQL Server TSQL to know all the databases present in an instance and their sizes and used size

  hi, i want to knwo the t-sql Hi, This should get you started: select sys.databases . name , sum ( sys.master_files . size ) size from sys.databases inner join sys.master_files on sys.master_files . database_id = sys.databases . database_id group by sys.databases . name Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• SQL Server How should you Document the SSIS packages?

  Well - we havent done it with DTS packages - but now that we are moving to SQL 2005 and SSIS & .Net (from SQL2K & asp) - it sounds to be as a good idea to document. How should I get started on creating documentation for SSIS packages You could try this: BI Documenter http://www.bidocumenter.com/Public/Default.aspx I have never tried it so I'd be interested in your feedback. -Jamie ...Show All

• SQL Server SQL Query help

  i have table "clubinfo" with following fields and data. ClubID FranchiseCode StartDate EndDate ------------------------------------------------------------------ 786 AAAAAA 2005-12-14 15:20:43.340 2006-06-14 14:40:53.270 786 BBBBBB 2006-06-14 14:40:53.270 2006-08-21 14:24:28.060 786 CCCCCC 2006-08-21 14:24:28.060 NULL above three rows describes franchise AAAAAA started on 2005-12-14 and sold on 2006-06-14 to BBBBBB so franchise BBBBBB started on 2006-06-14 and sold on 2006-08-21 to CCCCCC and Endate for CCCCCC is NULL so its a current franchise i wanted to write a sql query that will find franshisecod ...Show All