Search results for query: *

Is there a way to create a data view to only show projects assigned to the user? Thanks, Kevin

Hello All, I am trying to create a calculated column using an existing column that contains dates. The statement is as follows : IF([start date] > 6/30/2010, "FY11", "FY10") However, sharepoint does not seem to be reading 6/30/2010 as a date and keeps giving me FY11 as the return value even...

Hello, I am using a combo box to lookup records in a form based on Vendor ID. If the user enters a vendor ID that is not in the table the form defaults to the first record in the table. How can I have the form display a pop-up notifying the user that the Vendor ID is not in the system and...

Hello All, I am running Office 2007 and can use SUMIFS to sum all IF statements. However, my collegues are running on 2003 - How do I create a similar statement in excel. I have tried using nested IF's but it did not work. My SUMIFS statement is here: (SUMIFS('Sheet 1'!A:A,'Sheet 1'!X:X,"5...

Is it possible to inform all members of a document library when a document is posted? Thanks

I do not see the incoming email option in the settings for task lists. Is it possible for users to send documents via email to a project task list in MOSS 2007?

Hello All, I am trying to move multiple folders that exist in a document library (MOSS 2007) into a new folder created within that same document library. How can I do this? Thanks.

I have an excel document containing merged cells. However, when text entered into a merged cell overflows into a larger space than the merged area the cell does not expand. All merged cells are wrapped. Is there a way to have the merged cells expand when needed? Thanks.

Hello All, I have two sections in a five page word document. The footer of the document contains the page number. The first section has three pages and is numbered 1-3 of 3. The second section is numbered 1-2 of 2. Is there a way I can remove the page numbers from the footer of the second...

Hi, I have a very complex swim lane diagram in igrafx and re-creating the whole thing in Visio would be a complete waste of time. Is there a way I can convert the igrafx document to a Visio document? Sotware being used: iGrafx FlowCharter 2006, Visio Professional 2003 Thanks.

Hello, I am working with a purchase order table that has a field called [CreateDate]. Each [ItemNumber] might have multiple purchase orders with a different [CreateDate]. How can I run query to only show the records for the last created puchase order for each item? Thanks, cordeiro82

Hello All, I have a future orders table that contains a date field [datedue]. The table is refreshed everyday, and the dates begin with the day of the refresh onwards. I would like to create an additional field that is populated with the following text: "Today" for min[datedue] (which would...

Hello, I currently have a Query that calculates the number of days that an order is late using Now()-[tableX].[DateX] The problem with this is that the number returned is the count of calendar days and not business days. Is there a way to count only business days (Mon-Fri)? Thanks, Cordeiro82

Hello, When I reference a blank cell in excel the new cell shows 0. Is there a way to leave the new cell blank if the referenced cell is blank? eg: A1 is blank; Currently if in B1 I enter =A1 it shows a 0; Is there a way to show B1 as blank if A1 is blank? Thanks, Cordeiro82

Hello All, I have a microsoft word document with textBox1 at the top of the first page. textBox2 - textBox5 is located in various places throughout the word document. How can I get the document to populate textBox2 - textBox5 with what was entered into textBox1? Thanks, Cordeiro82

Hello All, I imported several shipment text files into a single Access table in order to query them for a distribution analysis that I am doing. The table has about one year of shipment data and has 16 fields and over 788,000 records. All the fields imported as text and when I try to change...

Hello All, How would you make the visibility of txtboxA dependant on a value in txtboxB, so that txtboxA is only visible when txtboxB displays the value "Yes". thanks, kevin

Hello all, I have two combo boxes on an excel form and would like to filter combo Box 2 based on the value selected in combo box 1. Is there any way to do this? Thanks, K

Hi, I want to create a form with a text box that prompts the user to enter the path of the spreadsheet they want to import into access. However, I cannot figure out how to get Access to read and import the selected file once the path has been entered. Any help would be appreciated. Thanks, K

Hello All, I have a form (form1) that pulls data from a table (table1). I also have a second form (form2) that has several command buttons. Form1 and Form2 are not related in any way and no relationship can be established. Table 1 only has 6 records, and each command button in form2 is...