I have defined three tables, Stores, InventoryItems and StoreItemRecords. My StoreItemRecords table has foreign key columns (StoreID, InventoryItemID) that "point to" the primary keys of the Stores (StoreID) and InventoryItems (InventoryItemID) records. The columns are named the same between the tables. If I run a query like this: SELE...
I am doing Dialog box development in CRM 4.0. Opening the dialog box through this line:- JavaScript="window.showModalDialog('http://localhost/CinmarPages/BatchPurchaseOrderChange.aspx', window, 'dialogHeight: 400px; dialogWidth: 600px;help:0;status:0;scroll:0'); crmGrid.Refresh();" On the Ok button of this dialog box the code written i...
I am currently working in a C# application which has a class which will generate an excel file. Everything went smooth. The data populated on the excel sheet has 'Times New Roman' has font. I would like to change it to some other fonts (Calibari). How can I do that programmatically. ...
Trying to install and utilize Office 2003 (or 2007) Update: Redistributable Primary Interop Assemblies on Windows Server 2008 R2 for a Legacy Application that requires PowerPoint. Microsoft claims neither 2003 or 2007 PIA words on 2008 R2. Does anyone know a workaround to configure and enable the PIA (ideally 2003)? ...
At wife's workplace, they use a Word template file with a customized strip of editing commands in MS Word 2003. This includes some macro VBA commands to create customized tables and stuff. They want to migrate to Word 2007, but the strip of commands does not follow and they cannot find it. Any ideas how to migrate a strip of commands ...
Given the following which can be loaded into MS SAPI 5.1: <GRAMMAR LANGID="409"> <RULE NAME="top rule" TOPLEVEL="ACTIVE"> <OPT>hello</OPT> <P>my name is fred</P> </RULE> </GRAMMAR> How can I do the same programmatically, specifically with regard to the optional element. I would guess it is done here: sta...
I want to ask some question, which about that" Create a Query which accept two parameters,Restaurant and Category, and display results showing Branch, Category, Description, Date, Quantity, Price and Total Sales, where Total Sales is calculated as Quantity * Price. How can I do that? Please help me,thanks ...
how can l do that "Create a Form and save as “Sales by Branch and Category” which accept two parameters,Restaurant and Category, and display results showing Branch, Category, Description, Date,Quantity, Price and Total Sales as defined by the query “Sales by Branch and Category”. That is to create a Form that accesses a Query instead of ...
Hi, Is there a way to geocode a table of addresses so that latitude and longitude columns can be updated with the correct details. Ideally I would like a system that will operate every so often, geocoding any address that did not have a lat / long. Currently there are areound 30,000 addresses in said table. Thanks in advance Edit Th...
Hi, I have existing application which uses Sql server 2005 as a backend. It contains huge records, I need to join tables which contain 50K-70K. Client m/c is lower hardware. So, can I improve its performance by using MS Access as a backend? I also need to search operation on access file. So, which one is better for performance. Queryin...
Hi, Can any one please assist me on how to display label values of potential(15,13) shown in the following image link MS Chart Image in the legend which is currently showing #VAL. Actually not only the one point,can suggest on how to display the label values on each point in the legend. To get the values of important,critical points ...
I have an entity generated from my database that contains one table. When i make changes in the DB i obviously would like these changes to reflected in my model. My current approach is to delete the item from the designer and then right-click - update model from database. This works for me at the moment. Is there a different approach t...
Can I write MS Word document using iTextSharp library? If yes, please give me sample code. ...
Can anyone explain how this constraint functions and how its affects insertion of records into this table? Running win sql 2k5. Having issue with trying to insert data. ALTER TABLE [dbo].[ws_shiptable] ADD CONSTRAINT [DF_ws_shiptable_ps_processed] DEFAULT (0) FOR [ps_processed] ...
How can I convert HTML to Word Document in ASP.NET? Please tell me a free tool. ...
I have a word file () which has many text fields and a startup macro, which, when word file is opened sets, values to fields from file properties ?! So basically, I need API that can convert MS word (MS Office XP) to PDF. It would be great if API had a startMacro function(), but I know that is not gonna happen. I have tried Apache POI...
Hi. I have jquery modal that works perfectly fine. But after closing this modal and clicking on accordion control(MS ajax) fires Jscript runtime error Microsoft JScript runtime error: Sys.ArgumentTypeException: Object of type 'AjaxControlToolkit.AccordionSelectedIndexChangeEventArgs' cannot be converted to type 'Sys.Ca...
I work on a project I want to use team build I create a build difineation the trigger gated check-in and everything is OK, but when i check in the code the build fail and I face the following error C:\Program Files\MSBuild\Microsoft\VisualStudio\v10.0\WebApplications\Microsoft.WebApplication.targets (177): Unable to copy file "bin\OTS.R...
Senario: Open an account in CRM 2011 beta and click on activities on the left navigation pane, you will now see activities of the selected account and now have two filter drop down lists on the top which allow you to view activities of the account or sub accounts of this account. Is this filter drop downs something customizable or is i...
1. whether sitescope is able to monitor for database failover? 2. whether sitescope can monitor MS SQL 2005 Analysis Services which uses olap/mdx data manipulation? ...