Search Results

Search found 40122 results on 1605 pages for 'ms access 2007'.

Page 58/1605 | < Previous Page | 54 55 56 57 58 59 60 61 62 63 64 65  | Next Page >

• Possible to create a sorted view of a column in one sheet on another sheet?

  - by Cumbayah

  Hi; I'm trying, in Excel 2007, to populate a column in one sheet with the data contained in a column on another sheet, so that I may provide another sorting on the data, related to that sheet only. I've tried to boil it down to being able to have a column on sheet2 automatically being populated with all rows from a column in sheet1, but I can't seem to do so. Any suggestions? Thanks in advance.

  Read the article

• Add Hyperlink to Cell in Excel 2007 Using Open XML SDK 2.0

  - by amurra

  I can't seem to find any documentation or code samples on how to add a hyperlink to a cell in Excel 2007 using the open xml sdk 2.0. I am using the following code, but is there a step I am missing? WorksheetPart workSheetPart = ExcelUtilities.GetWorkSheetPart(mWorkBookPart, "Program"); workSheetPart.AddHyperlinkRelationship(new Uri("http://www.google.com", UriKind.Absolute), true); workSheetPart.Worksheet.Save(); mWorkBookPart.Workbook.Save(); Then when I try and open the Excel document it says the file is corrupted because the relationship Id for the hyperlink cannot be found. How do you setup or create that relationship Id?

  Read the article

• Adding a UserControl within another UserControl in Sharepoint 2007

  - by DougJones

  I am using WSPBuilder to create and deploy my web part from a user control, as shown here. This works perfectly well, but I have added another user control to the project. I am adding it in page_init by going the Page.LoadControl("~/_controltemplates/MyControl.ascx"); route. It builds successfully, but after adding it to the page, I get The referenced file '/MyControl.ascx' is not allowed on this page. This control is in the ControlTemplates folder in the hive. In the web.config for this sharepoint 2007 site, all items within _controltemplates are listed as safe, as shown here <SafeControl Src="~/_controltemplates/*" IncludeSubFolders="True" Safe="True" AllowRemoteDesigner="True" /> How do I get the ascx file to be allowed on the page and get this webpart to display successfully?

  Read the article

• Unable to use XSSF with Excel 2007

  - by Tarun

  Hello All, I am having tough time getting to read data from excel 2007. I am using XSSF to read data from a specific cell of excel but keep getting error - Exception in thread "main" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.setSaveAggressiveNamespaces()Lorg/apache/xmlbeans/XmlOptions; at org.apache.poi.POIXMLDocumentPart.(POIXMLDocumentPart.java:46) This is my piece of code - public static void main(String [] args) throws IOException { InputStream ins = new FileInputStream("C:\\Users\\Tarun3Kumar\\Desktop\\test.xlsx"); XSSFWorkbook xwb = new XSSFWorkbook(ins); XSSFSheet sheet = xwb.getSheetAt(0); Row row = sheet.getRow(1); Cell cell = row.getCell(0); System.out.println(cell.getStringCellValue()); System.out.println("a"); } I have following jars added to build path - poi-3.6 poi-ooxml-3.6 poi-ooxml-schemas-3.6 x-bean.jar I could only figure out that "setSaveAggressiveNamespaces" has replaced "setSaveAggresiveNamespaces"....

  Read the article

• C#: Excel 2007 Addin, How to Hook Windows Activate and Deactivate Events

  - by user127490

  I am writing an Excel 2007 Addin. using VS2008 and .net 3.5, C#. I catched Microsoft.Office.Interop.Excel.Application's WindowActivate and WindowDeActivate events. It was surprised to know that WindowActivate and Deactivate only triggers when i switch between two Excel Windows. if i switch to notepad, i expect Deactivate to be triggered, but its not happening. same way from notepad if i switch to excel window, i expect Activate to be triggered but its not happening. It looks like the behaviour indicates windows are MDI-Child windows. Now what i want to do is get HWnd of Excel's Mainwindow and hook Window Activate and Deactivates using dllimport features. Can anyone guide to me on this. Regards

  Read the article

• Unique ID for MS Word 2007 paragraph

  - by Ganish

  I am writing large MS Word 2007 documents, which are often being changed. I have to number paragraphs with stationary unique numbers, that will not change while changing the documents. The numbers should be unique, and will not change even if previous numbers are deleted. The order of the list is not mandatory, and addition of a new number before existing numbers is possible (for instance: the sequence 1, 4, 3 means that paragraphs 1-3 were written, then #2 was deleted, then #5 was added. #3 was not affected by the later editing) The mechanism should be internal to the document, as I am working on line and off line. The numbers are allocated to every document individually. Since I don't know to program under MS Word, I'd appreciate getting a complete solution.

  Read the article

• Line numbering per paragraph in Word 2007

  - by WaelJ

  How can I use line numbering in Word 2007, but for each paragraph? (By line numbering I mean the one from Page Layout/Setup, not regular list numbering) So something like this: 1 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. 2 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat 3 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat

  Read the article

• MOSS 2007 BDC Profile Import fails for a few users

  - by Hobber

  We have set up a BDC Profile Import for Sharepoint 2007 and it works well for 99% of the users. A handful fails with the "Exception occured when calling into BIL connector for import from non master data source" message in the crawl log, though The ULS logs reveal the following information: Exception Profile Import: Exception occured when importing user: '[redacted]\[redacted]'. Microsoft.Office.Server.UserProfiles.PropertyInvalidValueException: Invalid Property Value: Could not find SID corresponding to input account name I have confirmed that the user has a sharepoint profile matching the username is a valid domain user exists in AD Can anyone help med troubleshoot this?

  Read the article

• AJAX is reloading page on a SharePoint site (SharePoint 2007 AJAX-enabled)

  - by Josh

  I have an AJAX-enabled SharePoint 2007 site. I have also created a user control that has an interactive ajax form. It obviuosly works like a charm locally, but I am trying to get it working on the SharePoint site. The problem is that once I load up the user control on to an aspx page inside SharePoint, the form (which has ajax), causes the page to reload every time a postback occurs. Can someone help point me in the direction of debugging this? - I really need to eliminate the page refreshes and have the ajax work correctly in SharePoint. I read that the ScriptManager has to be in the SharePoint masterpage, but that did not work either... Page still reloads everytime. Thanks.

  Read the article

• how to automate upsizing from Access to SQL Server?

  - by Arne

  Hi, I need to automate the migration from an Access (2003) to an SQL Server DB (2005 or 2008). The upsizing should be done automatically as part of a build process. I need that because there are 2 versions of the software, a single user rich client and a web version. Access DB is used for single user to minimize setup effort, SQL Server to improve performance and scaling with many simultanious users. Access should be the "leading" DB, meaning devs do changes in Access DB and those are propagated to the SQL server within the build process. Many changes will occur, so doing it manually is not an option. I am new to the Microsoft world, so I dont know appropriate tools for that. What tools can I use and how? I know how to do it (by clicking) with the upsizing assistant. Perhaps I can automate that somehow? Thanks in advance for your answers. Cheers, Arne

  Read the article

• Retrieving Data from SQL Server within Excel 2007

  - by Russell Giddings

  I have the following requirements I have relational content stored in a SQL Server 2005 database. I want to retrieve this data, transform it and display it in an Excel 2007 document. I would like this to be pulled from within Excel at the click of a button. As far as I can tell I have the following options... Create a view in Sql Server and reference it within a pivot table using a data connection. Create an Excel workbook using VSTO and create a web service which the workbook pulls data from Create a web service and use JScript with XMLHTTP request objects I currently only have a little experience of any of these methods (I'm very familiar with SQL Server although not pivot tables, I've created many web services although I've never used VSTO and I've used javascript extensively, but never in the context of Excel manipulation). Would you recommend one of the above approaches or is there a better way to do this?

  Read the article

• XPath does not pass brower compatibility checks in InfoPath 2007

  - by drivendevelopment

  Why do the targetField attributes below fail the browser compatibility checker in InfoPath 2007. Is there another way to write the statement so that it will work on Browser Enabled forms? <xsf:ruleSets> <xsf:ruleSet name="ruleSet_1"> <xsf:rule caption="Rule 1" isEnabled="yes"> <xsf:assignmentAction targetField="my:group1/my:group2[1]/my:field3" expression="my:field1"></xsf:assignmentAction> </xsf:rule> <xsf:rule caption="Rule 2" isEnabled="yes"> <xsf:assignmentAction targetField="my:group1/my:group2[2]/my:field3" expression="my:field2"></xsf:assignmentAction> </xsf:rule> </xsf:ruleSet> </xsf:ruleSets>

  Read the article

• FBA site owner encounter access deny in sharepoint 2007

  - by intangible02

  I created a sharepoint 2007 publishing site first using windows authentication, then extended it to another site using FBA. I created a FBA user and set it as site collection admin as well as top site owner. I also make application pool which the FBA site is running in to run with a user account which is within administrator group. But I encounter access deny error when browsing certain links using this site owner account. Is there other settings I need to configure? I found in the web.config, the impersonation is set to true. How does this affect the access rights?

  Read the article

• Generated Word 2007 prints scrunched up

  - by Brad

  Our website generates Word 2007 documents from database data by creating the xml, zipping it and sending it as a MIME attachment. Usually, this works fine. On occasion, the document will look fine on the screen, but not when printed. The letters end up scrunched together. Here is an example. This is a 1 page document, the first page is a scan of the document printed correctly, the 2nd page is a scan of the same document printed with the problem. Here is the original document. Has anyone ever seen anything similar? I cannot figure out if this is a bug in the code that generates our XML, a bug in the printer driver or a bug in Word. Any ideas would be greatly appreciated. Please note that this document does not contain any real data other than public information, but disregard the contents - this is not an official document, and only meant to illustrate our problem.

  Read the article

• Building a Com addin for Office 2000 / Office 2007

  - by Stuart

  I am struggling to find a straight forward guide to creating office addins using VSTO and VB.net. Specifically I would like to know how to be able to create a addin/ dll which can either be referenced from VBA in the form:- Addin.method(argument) or Addin.property = X Or which would install its own custom toolbars/ ribbon interface to an aspect of office for example Word. I've checked MSDN and in terms of legibility and usability of the explanations I have drawn a blank so far. I currently have a requirement to create at least one addin for Office 2000 to run and manipluate SQL and then a suite of addins for a customized Office 2007 (Word) set-up.

  Read the article

• Code for adding Content Controls Word 2007 C#

  - by AProgrammer

  Hey all, I was wondering if anyone has any idea how I can add Content Controls to a Word Document (Office 2007) from the Document Task/Action Pane via C#. The goal is the following: I want to have categorized information in the Task/Action Pane and have the user fill out the info there. Once they have filled out that information they'll click on a button and it will insert content Controls into the Word Document that has that Data. The reason I want to use Content Controls is because the data will be bound to a database. Is this possible? I would like links that do this without WordProcessingML or OpenXML. There has to be a way to do this via server side code and such that doesn't require long blocks of ,, etc. Thanks!

  Read the article

• moss 2007 workflows

  - by nav

  Hi, I'm new to MOSS 2007. I need create a workflow to look at a document's review date (a select list predefined to values of 3 , 6 or 12 months) and send an email if the review date has passed. So the workflow needs to get the documents review date then convert this to date time add to the created date if greater than current date send an email. Can anyone tell me if this is possible to do using SP designer to create the workflow? I'dd be grateful for any pointers. Many Thanks, Nav

  Read the article

• Using [delphi] MadExcept errorhandling with MS Echange Server 2007

  - by Tony

  I currently use madExcept.MailAsSmtpClient to send my bug reports. However a couple of large clients have upgraded to Exchange Server 2007 and we can't get the SMTP support for our app configured (the app runs on individual workstations so the messages aren't all coming from one IP. We can configure an authenticated account in exchange and access it via SMTP from other clients but it rejects madExcept for some reason). So I have two questions 1) has anyone successfully configured that combo ? or 2) is there an example somewhere of how to use the madExcept.UploadViaHTTP option?

  Read the article

• Set Pivot Items from Cell Range? Excel 2007

  - by Ben

  I have developed code which identifies the multiple item selections from a Pivot field and writes the list of items to a table. I then wish to take this contents of the list and use it to populate a number of other Pivot Tables on other tabs. I currently have the ability to do this for single Pivot items selections, but I need to do this for multiple selections. If I select multiple items in the Pivot Table and attempt to pass these selections to the other Pivot Tables it creates an error because it sees only hte text "Multiple Items" instead of a list of each item that was checked in the upstream Pivot field. I need some VBA code that allows me to use the list to set another Pivot Field's selections. All the Pivot fields in question here are page fields. I am using Excel 2007. Any help is appreciated. Thanks!

  Read the article

• Virtual PC 2007 as programming environment

  - by Gern Blandston

  I'd like to create a VM in Virtual PC 2007 for use as a development environment/sandbox for an existing ASP.NET application in Visual Studio 2005/SQL Server 2005 (and VSS for source control). I'm thinking that I need to create a 'base' copy of the environment (with the os, Visual Studio, and Sql Server), and then copy that to a 'work' version that I do actual development in. I would be sharing this VM with one or two other developers who would be working on different parts of the app. Is this a good idea? What is the best way to get my app/databases in and out of the VM and the changes I make into VSS? Is it just a copy from the host location to the VM share and back again? How do I keep everything synchronized? Thanks!

  Read the article

• Trouble with creating WPF window extended on the title area (like Office 2007/2010)

  - by Rikker Serg

  I want to make WPF window extended on the title area (like Office 2007/2010). I implemented DwmWindow (see DwmTest.zip) where I put required stuff. Commonly, it works fine except one disgusting thing: the window appears as white rectangle (see DwmIssue.png) and after a few second this rectangle disappears and the content of the window is shown (see DwmIssueCorrect.png). This bug is essential only for my window. If I remove this lines it works fine (without it aero will not showed on title): HwndSource mainWindowSrc = HwndSource.FromHwnd(handle); if (mainWindowSrc != null) mainWindowSrc.CompositionTarget.BackgroundColor = Colors.Transparent; NativeMethods.MARGINS margins = new NativeMethods.MARGINS(0, 50, 0, 0); NativeMethods.DwmExtendFrameIntoClientArea(handle, margins); How can I eliminate this white rectangle? (To run a sample DwmTest.zip WinVista/7 with DWM enabled and .NET 4.0 is required. To compile sample you will need Visual Studio 2010)

  Read the article

• Export Sharepoint 2007 Custom List as RSS File

  - by matt

  Here's our scenario: We've created a sharepoint 2007 calendar on our intranet site We want to run a daily job to export a subset of the events to an rss file Another job will move the rss file to our public web site We have some funny restrictions where we can't simply publish the rss feed to the public. We have to go this export route. I'm not clear on how to accomplish step 2. Ideally, we wouldn't have to write a lot of custom code to accomplish this. Thanks.

  Read the article

• Sharepoint 2007 and <!DOCTYPE html>

  - by Kondor

  Greetings... I'm trying to get my Sharepoint 2007 site to render in Standards mode when browsing in IE. Since makes every browser that I might be worrying about do just that, I decided to use it. I've read here and there that Standards mode could cause unwanted behavior to some OOTB functionality and style (fly-outs, calendar items, etc...), but can't find a full list containing error reference and ways to correct it. So, I'm looking for any kind of info and guidance on the matter... Just trying to avoid endless clicking through my app and hopping that some one altruistic by nature has gone through testing hell already and is willing to share. Thanks...

  Read the article

• Make SharePoint 2007 List View read-only

  - by FireSnake

  I need to deploy a new List View for the standard List View Web Part in MOSS 2007 via the object model (the list already exists, a new view should be added). I need and want to make this list view read-only. This is because saving changes to the view would corrupt modifications made to Header/Footer. How can I do that via the object model? I looked at the content db, the read-only flag (0x20) is stored with the view and could technically be updated using calls to proc_GetAllWebPartsOnPage and proc_UpdateView[Properties]. NOTE: The database interface and all mentioned stored procs are all documented by Microsoft. Is there ANY way to do that via the object model, because I would strongly prefer that?

  Read the article

• Need help with Excel 2007 Formula - Many to many update

  - by Monica

  I'm experienced with database development, but not so much with Excel. I'm looking for help writing an Excel formula that would help my client's spreadsheet behave like a database. This is what I'm looking to do, but I can't figure out how to write it in Excel 2007: "If Q4 (on sheet 2) contains A2 (on sheet 1), append A1 (on sheet 1) with Q5 (on sheet 2)" Some factors: 1) This formula may find multiple instances of A2, so it should not stop after finding the first match 2) The values, as they are created in A1, should be separated with comma and space 3) This is a many to many relationship between Q4 and A2 Thanks for any help with this. I've tried vlookups, match, if statements, but they all fall short in one way or another.

  Read the article

< Previous Page | 54 55 56 57 58 59 60 61 62 63 64 65  | Next Page >