clint 2's Q&A profile
Visual FoxPro Why the datas from the .dbf file (table) on the form are not displayed?
Hi all Need help very badly.. I purely have no idea where i go wrong. I'm trying to get the datas (such as CHEVSINSMZ 100,CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102, etc) from the table (.dbf) display and then trim into "CHEVSINSMZ 100 & 101 & 102 itself. What i get the result on {.xdf_bl.value= OutPutSTring} of the form is (1)_________ when testing this form. Why cannot the datas be shown on the text field when searching for the value in the .dbf _-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-_ tnfjob is the name of the table. Jt_hblno is an attribute of the table (.dbf)in the form. It is like something that originally contains CHEVSINSMZ 100,CHEVSINSMZ 100, ...Show All
SQL Server YTD
Hi, In my Time dimension, there are 8 different hierarchies exists, including calendar and fiscal calendars. There are Time utility functions created through BI wizard. { edited to incorporate drill down to lower levels of the hierarchy } But this is not working fine in all situations. if i apply 2 filters for week and year, the MTD and YTD shows N/A only. So my question is how to modify the MDX to handle all the scenarios. here is the code for YTD i have used.' ( [DIM CALENDAR].[Calendar DIM CALENDAR Calculations].[YTD], [DIM CALENDAR].[AS_OF_DATE]. Members , [DIM CALENDAR].[CY_YEAR].[CY_YEAR]. Members ) = Aggregate ( { [DIM CALENDAR].[Calendar DIM CALENDAR Calculations]. DefaultMember } * ...Show All
.NET Development datarow array to excel what am I doing wrong?
Dim XL As Microsoft.Office.Interop.Excel.Application Dim xlwb As Microsoft.Office.Interop.Excel.Workbook Dim xlsheet As Microsoft.Office.Interop.Excel.Worksheet XL = New Microsoft.Office.Interop.Excel.Application xlwb = XL.Workbooks.Open( "C:\tryout.xls" ) xlsheet = xlwb.Worksheets(1) XL.Visible = True Dim pPK As DataColumn = RcsDataSet.Tables( "Customers" ).Columns( "CustomerID" ) Dim cFK As DataColumn = RcsDataSet.Tables( "InvoiceDetails" ).Columns( "CustomerID" ) Dim rel As New DataRelation( "CustomerInvoiceDetails" , pPK, cFK) RcsDataSet.Relations.Add(rel) Dim myArray() As DataRow For Each dr As Dat ...Show All
Microsoft ISV Community Center Forums On Error not catching problem with a web query
Why does "On Error" not seem to work in this case Once every few hundred iterations, there will be a failure, timeout, or resource not available error on the last line which invokes .Refresh BackgroundQuery:=False. Any insights would be much appreciated. Regards, Brian code excerpt........................... On Error GoTo query3error With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://finance.yahoo.com/q s=" & ticker, Destination:=Range("A1")) .Name = "q s=" & ticker .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = False ' ...Show All
Visual Studio Express Editions Unusual install question
I was wandering what I would have to do to beable to put the main folder (C:\Program Files\Microsoft Visual Studio 8) on a removable drive and beable to use it on another computer without actually installing it so it doesnt show in the installed programs list in control panel/add and remove programs. Something thats being looked at is having VS on a USB key - so that you can debug apps on machines which dont require VS to be installed - its all self contained on USB key - plug in have VS, remove and VS is gone. ...Show All
Visual Studio .Net web application help system
Dear sir, I am doing webapplication. Now i am planning to implement the help system in my project. So I am excepting some suggestions from you. Thanks all. regards vijil jones. Hello vijil - unfortunately about all you can do for a help system for web applications would be to experiment with some creative uses of DHTML to hide/display information to the user or plain html <a href> links. There are no off the shelf help systems for web applications provided by Microsoft. Some 3rd party vendors like Component One Doc-To-Help, Macromedia RoboHelp, MadCap Flare, Innovasys HelpStudio, etc. may provide some more comprehensive web-based help solutions that you can explore. Sin ...Show All
Visual Studio Tools for Office Hands-on-Lab 04
Hi, I am new to the VSTO, tried to learn VSTO with the Hands on Lab. I finished Lab01 - 03 without any problem. But for Lab04 Ex.3 , I got problem at the following code (Method Items_ItemAdd ): Dim customerContact As Outlook.ContactItem = bankFolder.Items.Find(filter) 'I add this line by myself Messgbox.Show("Debug Point Here") I think its logic is trying to get the Contact item from the "Bank" Folder. But on my machine, it doesn't work. It stopped but no error occur. The next line didn't run actually. (I tried to copy the Lab04 codes from Lab05 in order to make sure no typing error, but still no luck) Please help. Andy Ho Sue, I see. Thanks ...Show All
SQL Server Filter Tables According to User
Hi, Im new to SQL Server and Im having trouble to decide wich is the best way to filter the tables that one user can read and write. For example the table Sales as a field named Branch (SMALLINT) with values 1 or 2 (the store that made the sale). User "A" can see and write only records where Branch = 1. Im developing a windows program that shows all the purchased orders in a DataGridView. So should I make the filters (permissions) in the program or in the SQL Server . I hope I made my self clear (my english is not so good) I could make a table that lists the branches that a user as access to: UserID Branch. Then the program can read and store in a variable the Branch values for the user that log on. Then all ...Show All
SQL Server Reporting Services Failed Install
Hi all, I have an SBS server that I tried to installed SQL Server 2005 Express edition for some testing/dev work (non-production server here) and although SQL installed, the reporting services component failed with the following. -------------------------------------------------------------------------------- Machine : RAND Product : Reporting Services Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation. -------------------------------------------------------------------------------- Machine : RAND Product : Microsoft SQL Server 2005 Reporting Services Product Version : 9.1.2047.00 Install : Fail ...Show All
Visual Studio Tools for Office Getting item scope on PropertyChange event
I have an event handler for a ContactItem that fires on the PropertyChange (which is wired up when a new contact window is opened--e.g. I am monitoring what changes in this window). private void Inspector_NewInspector(Outlook.Inspector inspector) { Outlook.ContactItem ci = inspector.CurrentItem as Outlook.ContactItem; if (ci != null) { ci.PropertyChange += new Outlook.ItemEvents_10_PropertyChangeEventHandler(ci_PropertyChange); } } void ci_PropertyChange(object item) { MessageBox.Show(item); // displays the name of the property (item is of type string) //what contact ...Show All
Windows Forms Check If sql Server Exits
hi is there a way to check if sql server exist when creating and installer (i want to create an installer for a program and during setup i need the installer to check if sql server exits ) http://msdn2.microsoft.com/en-us/library/4awx1f1d(d=ide).aspx This articles explains it better than I could. My settings were : RegKey : SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion Root: vsdrHKLM I did not have a value. You can look for version information under the above key as I believe it has a Version number at SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CurrentVersion HTHs, James ...Show All
Software Development for Windows Vista Windows SDK Documentation
Hello, If you have the Windows SDK and Visual Studio installed, you can help me. Please tell me if your Windows SDK documentation is integrated with your Visual Studio 2005 documentation. Thankyou. Because mine isn't. Assistance appreciated. I did a clean installion of Visual Studio on Vista RC2, and I installed the following additional items in the order shown. installed VS2005 sp1-KB918525-X86-Beta-ENU installed MicrosoftR WindowsR Software Development Kit for RC 1 of Windows Vista and .NET Framework 3.0 Runtime Components installed Microsoft Visual Studio Code Name Orcas Community Technology Preview – Development Tools for .NET Framework 3.0 - vsextw ...Show All
Visual Studio 2008 (Pre-release) Problem with using user control in Expression blend
hi, i am reading the sudoku demo from http://msdn.microsoft.com/coding4fun/gaming/puzzle/default.aspx In the third article i was reading, works fine when i download and run project in visual studio 2005 with WPF extensions installed. But when i open the same project in Microsoft Expression Blend it give me error that in showing the user control on the designer as Cannot create instance of SudokuBoard. but i can run the project there too. i just cant see the designer there with the user control. the problem may be due to the fact that usercontrol needs the constructor with arguments and expression blend is unable to do that. It seems it is unable to create control with the backend code. Can any one suggest why ...Show All
SQL Server Need Editable full Backup and Restore
Hi there I just want to create Stored Procedure which will do following thing i) Create a text file, which will have a Schema Script(including all the constraint & others, for a database(by passing Parameter) ii) the same file must also have, all the data from the selected database tables,in again plain text format (could be CSV, or Tab SV, etc...) I mean to say, the file should be act as the full backup of database, in plain text. The same need to be done in the reverse order,this SP will do following things i)Open ...Show All
Visual Studio Team System error when I build (This access control list is not in canonical form and therefore cannot be modified.)
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 10/27/2006 6:18:23 PM Machine: BIEL Application Domain: /LM/W3SVC/2/Root/Build-4-128064467018759100 Assembly: Microsoft.TeamFoundation.Build.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727 Process Details: Process Name: w3wp Process Id: 4684 Thread Id: 8716 Account name: AAC\XXXXXX Detailed Message: This access control list is not in canonical form and therefore cannot be modified. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/eve ...Show All