Jarek1979's Q&A profile

• Microsoft ISV Community Center Forums access - importing specific data from excel

  hello, i know this command to import data from excel to access : DoCmd.TransferSpreadsheet acImport, 3, _ "Employees","C:\Lotus\Newemps.wk3", True, "A1:G12" i know how to use this command, the only problem is i have a variety of excel files differ from each other in the upper-left and lower-right edges of the tabular data. is there any way i can get into the workbook and check this information thanks refael Hi Refael Not sure I understand your question, to see the data before importing is as simple as opening the files with Excel. If there is just a formating issue you could import into a temporary table, then us ...Show All

• Visual Basic Need Help In crystalreports

  I am using crystalreportviewer to show the crystal report and i am having one button at the form and for the click event of the form i am exporting this report as a pdf file. While exporting it is throwing a exception (Report.Export()) "Error in File C:\DOCUME~1\ADMINI~1.DEV\LOCALS~1\Temp\temp_9ee9495f-2895-4065-a9cd-18800698ea7c.rpt: Error in formula ...." but in the crystal reportviewer i m getting the report clearly. Please send me a good solution... Thankyou Sabari. Hi, I have solved that issue,I by mistake directly given crystal report as a argument. like this report.export(CrptMyrepor ...Show All

• Smart Device Development Hide Menu

  Hi, I’m working on a Pocket PC project in VB.net. There are a set of menu options that need to be provided. But certain menu options need to be “shown “only for specific applications. They need to be “hidden” otherwise. eg. Me.MainMenu1 Me . MainMenu1 .MenuItems.Add( Me .MenuItem1) Me .MenuItem1.Text = "File" I wasn’t able to find the “Hide” option, to hide “MenuItem1” Eg. File a Exit Options a ChangeMode File and Options are 2 MenuItems added to MainMenu1 . Exit and ChangeMode are their respective subitems. It is required that “ Options” menuitem be enabled only for a cer ...Show All

• SQL Server SQL Server express hangs installing on XP Pro

  After failing to get SSE to install on XP Home (and finding out that while support is claimed on the June drop it isn't there)  I upgraded today to XP Pro SP2.  I also removed all VWD, ASP.NET 2.0, and SQL components on the machine.  After the upgrade I made sure IIS was installed and working then tried to setup VWD again.  It got through the ASP.NET 2.0 install and the VWD install but hung on the SSE install when the progress bar was at 100%.  Before this was the same behavior I saw when trying to install SSE stand-alone and it was in the "Dectecting IIS" phase.   Once the hang occurs and I kill ...Show All

• Windows Forms Advice Appreciated : Building new Control Similar to TabControl

  Hi, I am developing a Control which is very similar to Microsoft TabControl, only it does not have tabs on the top. The control is called PanelControl and contains PanelPages. Looking at the TabControl and TabPage Controls using Reflector, I discovered the inheritance for TabControl and I have created my controls likewise. I am using VS2005 RC1 (Sept.)Whidbey, Please suggest any of the new designer feature in Whidbey.I plan to implement a PanelControlDesigner, and SmartTags once I get control working good. Please offer any advice you have. Can someone answer the following questions. 1. Should my PanelControl inherit from ContainerCont ...Show All

• Visual Studio SQLServer 2005\ Visual studio 2005

  Can someone tell me exactly which versions of SQLServer 2005, and Visual Studio 2005 I should use so that I can develop a web page with a reportviewer control on one machine and use Reporting Services on a different machine. Any links to downloads (i know files will be big). At the moment I have Visual Studio 2005 Standard Beta 2. I also have SQLServer 2005 Beta 2. The cds/dvds have no mention of ctps etc... By the way the error I'm getting is ''[MissingEndpointException: The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version.]" Thanks   Proble ...Show All

• Visual C# Variance and Contravariance with anonymnous delegates and inheritance

  Hello. I have read the "variance and covariance in delegates" definition. http://winfx.msdn.microsoft.com/library/default.asp url=/library/en-us/dv_csref/html/e6acad03-93e0-4efb-a158-8696d5eb4ecf.asp I wonder if maybe i could do the same using anonymous delegates, I guess it is imposible to apply co and contravariance in the return values, but why not use it on the parameters It does not say if  cant do it but the compiler does not let me do it. Does andybody know any way to do it class A{} class B:A{} delegate A myDelegate1(A a); delegate B myDelegate1(B b); class Sample1 {     voi ...Show All

• Windows Forms EnableDesignMode with collections (Troubles with serialization)

  Hello, My user control is quite similar to the TabControl: Ive got a collection of panels, and some buttons to switch between them. The panel’s collection inherits from ReadOnlyCollectionBase. In design mode I get access to the diferent panels inside de collection, and when I add a control to the panel and hit a button to switch panels everything is fine. Even when I return to the previous panel where I've placed a Label I can see it perfectly. However, if a debug my aplication every single control I've added to this panels disappear... If I close the form designer and open it once again, the controls have disappeared. Looking through the c ...Show All

• .NET Development Both Async and Sync reads from the same Network Stream? (EXTREMELY STUCK!)

  Hi guys I'm really stuck! I'm programming a network heavy app with a TCP client in VB.NET 2005. I need it to have an async read of the network stream so that it can react to any impromptu messages sent by the server but also SOMETIMES have a syncronous read when the client has sent data to the server expecting a reply. I can have the two (async and sync) reads working independantly, but as soon as I try to use both the app hangs. I've been trying to find a way to 'pause' the asyncronous read while the app waits for a reply, then restart the async read once a reply has been received but I've had no luck. Is there any way of do ...Show All

• Visual Studio 2008 (Pre-release) XAML, RenderTargetBitmap - picture disappears from image after load testing

  I'm developing a simple ASP.NET handler that returns image that is rendered using XAML on server side. The problem that after stress testing picture disappears from returned image (but empty image is still returned). The picture here is XAML canvas (I put it to the bottom of the message) with different shapes and glyphs (rectangles with gradient fill, lines and text with digits). I tested on Windows 2003 (two processors, four processors), IIS 6.0, .NET 2.0, WinFX RC (February CTP), emulated 250 concurrent users. I have the following code: public MemoryStream CreateImageStream(String xaml) { object obj = System.Windows.Mar ...Show All

• SQL Server encrypting data of config table

  hi. i need some help please. i had a problem with using configuration files in april ctp so i moved to sql server configuration which i found as a better solution for storing connection info since it can encrypt the password. this as far as i know as i'm moving from beta 1 version. when creating the database at the client's server, the configuration table needs to be created as well and the data manually inserted using insert statements. in this case, how do i enter the data in a way that is encrypted that's my question thanks I believe the question is just about writing data to an encrypted colu ...Show All

• Visual Basic How to halt a program???

  Let say i have two program called program A and program B, i run program A, but inside program A, i use [call shell(C:\....\programB.exe)] at the 2nd line of my codes in program A, how do i stop program A at 2nd line, until i finished running program B then only continue execute the rest of the code from 2nd line in program A Please help, if you dun understand wat im saying above, u can ask ...thanks a lot!!! You can use Process.Start from process A to start process B. This method will return a new Process object. You can then call WaitForExit on the returned process object to block process A until process B is done. Best r ...Show All

• Visual Studio Tools for Office Unable to invoke BCM(Outlook) events.

  I want to know that can I program the events in BCM(Outlook addin) like item_add event for adding contacts and updating them through item_update. Its not working for BCM at my end. Please guide me how could I achieve this task. Thanks in advance, Peeyush Agarwal Peeyush, I am glad you are working with BCM and Outlook. It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issues such as yours. Here is a l ...Show All

• Visual C# Date Time format from DateTime to String

  I have a popUpCalendar routine that I wanted to format the datetime to yyyymmdd in my text box with no "/".  My command is like this: string strDate = popUpCalendar.SelectedDate.ToString("yyyymmdd"); if the date is 10/25/2005  I get 20050025 in my text box and debug shows the same in the quick watch. However if I format it like this it works fine. string strDate = popUpCalendar.SelectedDate.year.tostring(); strDate += popUpCalendar.SelectedDate.month.tostring(); strDate += popUpCalendar.SelectedDate.day.tostring(); Any idea as to why the first is not working Try "yyyyMMdd". Lower case "mm" is minutes while "MM" is months. Se ...Show All

• Visual J# java (J2EE 1.4) convert to J#

  Hi, I want to convert my application in java (J2EE 1.4) to J# with minimum changes. Where can I get the script Thank's Alexei (I have tryed JLCA 2.0, 3.0 and it gives me about 100,000 errors becouse it convert to C#. I don't have a time for working on errors. I read that Java can be converted to J# with minimum errors.) Generally my experience doing this always leads me to running the J2EE code under Object Web or JBoss's free J2EE server and building either a webservice or RMI invocation layer to bridge the .NET code. This does assume that you have a good MVC design where you can easily seperate the backend J2EE components from t ...Show All