How can I make a sheet display data from another sheet based on date criteria?
Say I have an Excel workbook with 3 sheets (sheet1, sheet2, sheet3).
Each sheet has two columns (Date, Thing that happened on that date).
I would like to know if there's a way to have a fourth sheet, called
"on this date in history" (or whatever). It would consider today's
date and display each thing that happened on todays date in previous
years on each row.
So basically, if I open the workbook on May 11th, 2007 and go to the
fourth sheet, it would show me a list list of events that happened on
May 11th in previous years, and it would update for each day that I
vi...display just the first element in a field on a form
I have a .csv file that I import. The first 8 lines have important
information such as date, test parameters, etc. (1 parameter per line) The
remaining lines consist of 4 parameters per line separated by a comma; easily
read into Access. How can I display just the first element of "field1" on a
form? I do not wish to change this value. I have tried a Text Box with the
Control Source =[Imported_Table]![Field1].[column](1) only to get a
#name? What is the simplest way to accomplish this? Thank you!!!
On Mon, 12 Nov 2007 10:19:01 -0800, Rickm wrote:
> I have a .csv file ...Web Folders not displaying
I have users that want to access thier email via HTTP. Everything works great on the Intranet where the Exchange 2003 Ent Server resides. On the external side of my firewall i setup an alais that just redirects the traffic to the internal exchange 2003 box.
When a user comes in from the internet...they are authenticated and the folder listings show up...but the middle pane where the email actual are to be listed, don't show up. The messages reads
The folder can't be displayed. You don't have permission to perfor this action
If the user comes in thru the VPN...of course no pr...public calendar default settings
Using Windows XP and Office 2007
I have my default Outlook calendar and have created a second public calendar
that is shared with others on my Exchange server. The default reminder
setting for my default Outlook calendar is 1 hour. That seems to also be
the default reminder setting for the things I put on the public calendar.
However, the public calendar items do not need reminders. But when I change
the default reminder setting to "none," that has now become the default
reminder setting for my personal calendar as well.
Is there a way to set separate defaults fo...Tab Index Order, Setting With VBA
The code below is supposed to assign control tab index order.
However, it bugs out in the FOR loop of the sub
SetTabsInPhoneBookOrder: 'Run-time error 2184: The value you used
the TabIndex property isn't valid. The correct values are from 0
through 9. I don't recall where I got the code and the author did
include his email address. I've search for his name and searched for
ways to assign tabindex via VBA (Access 2002), without luck. Any
would be appreciated.
Thanks for looking,
Option Compare Database
Const CACHE_SIZE = 50
Sub Cachin...I have Office XP Developer...
....and want to install Publisher - but cannot find it anywhere on the CD
disks supplied. Is Publisher available on the Developer version & if so can
anyone point me in the right direction to install it - this is driving me
Sorry - first time on here so have now found the answer which appears to be
"unless you were dead lucky and got a super whizz special ltd edition
version" then it's not included.
I'm frankly appauled that, despite buying the most expensive version of
Office XP such a major programme should be excluded from the Developer
...need to download office 2003 to my windows xp
i have tried everything i know to find the office 2003 that my school says i
need to continue with my corses. however, all i find is the updates for
office 2003 . i dont need the updates untill i get the original , do i ?
You cannot use the updates without the original. And Office is not
downloadable. You need to purchase a copy. As a student there are some
great deals available to you. Try your school bookstore.
And BTW..this is a Dynamics GP (Great Plains) site.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tip...Navigate to a particular link doesnot display the text sometimes
Have used navigate method of IWebBrowser2 in a property
page to display the htm file. Debug prints shows the
correct path is given for a link ( eg path for one of the
hyper links path is C:/../team_typesENU.htm#aft) inside
htm file . Sometimes the contents of the file does not
get displayed .Contents are shown only when clicked on the
control itself or navigate between the pages. text is
hidden. anybody can let me know why is this happening ?
...Rolling out exchange configuration settings
I am interested in if anyone knows a way to script Outlook Exchange
We are in the process of rolling out exchange to our enterprise.
I'm looking for a way to script the settings so that we can easily
configure end users clients.
All users will be using their AD credential to access the exchange
Anyone know of a solution, script, suggestion?
Whitepaper: Configuring Outlook Profiles by Using a PRF File
Roaming Profiles and Multiple Users
Hal Hostetler, CPBE --...XP media center SP3 problems
Hi, I am working on a Gateway laptop running XP Media Center. It has SP2
installed. I have tried to install SP3 through automatic updates and it will
not complete. I turned off XP firewall and Avast anti-virus as suggested if
I was having problems. In this mode I get error code 0xD0000006. It
displays a message that the installation did not complete.
Prior to this I tried several times and it would install partially and then
I would get the message: Copy Error- Setup cannot copy the file "_" Ensure
that the location specified below is correct or change it and in...Outlook XP Cannot Access Exchange 5.5
We are currently migrating our outlook clients from 2000 to XP. But with
some users (1 out of 10) cannot access there mailbox, on our exchange 5.5
SP server, with Outlook XP. They get a dialog asking them for there
username and password. When you type in nothing happens no error, you just
have retype the password. If they use Outlook 2000 they can there mailbox
I have found MS KB 297781 "You Repeatedly Receive a Prompt for Credentials
When You Log On to the E-mail Server" But this seems to be only if access
with a pop3 account.
Is this a know problem?...Email changing fonts when sending out in Office XP 2002
email is changing fonts when sending out. does not
happen all the time just random. service pack has been
installed as well, still no change
...Setting up segmented bar graphs
I don't know if it can do it or if there is a program for it but I need
to know how to set it up in Ecxel. A segmented bar graph is when the
%'s are added up on top of one another.
Like I need male and female, and they answered yes or no. Well one bar
for male ,answers of yes and no %'s on top=100% and the same for
no 25% |
male...............Just in case
spiketheone's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...IF function help
I have a worksheet that someone wants to have all the
blank cells in the range display a "0" and the other cells
to display whatever is in them. I have tried to figure
out an IF function, but don't know what to put for the
false part. Is there a way to have it just display what
is in the cell as the false??
It should work for the situation described below.
>I have a worksheet that someone wants to have all the
>blank cells in the range display a "0" and the other
>to display whatev...Outlook Office XP
Out of the blue, a user is asked for user name and
password. after providing both they can get in, but
everytime they go back in, it prompts for the password.
what gives? help any one?
For Outlook 2000 or 2002 on Win 98, NT, or 2000:
For Outlook 2000 on Windows 2000:
For all Outlook versions on Windows XP (just ignore the parts that refer to
For in a NT domain
http://support.microsoft.com/?id=3216...Pasting sub sets.
Using Excel as a Db,
how may I copy / paste a sub set?
I currently get the entire Db pasting
when trying to copy/paste desired rows
(the others being hidden).
Before copying, use Edit / Go To.... Special, Visible cells only.
MS Excel MVP
"Rodney" <email@example.com> wrote in message news:OyGKvquyFHA.1252@TK2MSFTNGP09.phx.gbl...
> Using Excel as a Db,
> how may I copy / paste a sub set?
> I currently get the entire Db pasting
> when trying to copy/paste desired rows
> (the others being hidden).
>...VS2005 and XP manifest
I've imported a project from Visual Studio 2003 into VS2005. So far so good.
When building the UI project, it fails with a duplicate manifest. I had
defined in the resource file an include for a manifest for each platform so
that I get the new XP common controls, and apparently VS2005 creates a
manifest itself. I took out mine and then the compile was successful.
Unfortunately, my app lost the XP controls.
In looking at the manifest that VS2005 now generates magically, it has 2
entries for MFC dll's, but none for the common control DLL.
I created a new test project in VS2005, and i...Display one sheet or two userforms while code is vba code is running on another
I have VBA code that freezes and unfreezes windows on a worksheet
while it searches for the best presentation. Although it only takes
10 seconds or less to execute, this is annoying to watch, and I do not
know how to prevent it from displaying.
If I use application.screen update = false then the windows do not
freeze or I get an error. The same thing happens if I minimize the
worksheet. The same with the events = false application.
Tthis sequence of events is occuring as a part of a larger sequence of
operations, the total taking about 1-2 minutes to run at the most
depending ...Distribution Lists, How to Set up?
From time to time, I get messages from professional organizations and
others that is clearly sent to a distribution list, but only my name
appears in the To: field.
Can I do something like that in Outlook?
Checking the archives, I see that one recommendation is to put the DL
in the BCC field. I just tried a test using that method. It does keep
the dl addresses hidden, but it appears to put my email address in the
To: field for all of the recipients. That is, I included several
contacts in the dl and the email they all received had MY email
address showing in the To: field.
Is there some wa...Setting up a budget by percentage ...
I recently upgraded to Money 2006 but I can't find a way to set up a budget
by percentage of income (net or gross) rather than by dollar amount. Am I
missing something or is this indeed impossible. If it's impossible, does
anyone know if this feature is available in Money 2007?
It isn't possible in M06. You might like the "Savings and Spending Budget"
in M07. I still don't know that is supports percentage entry directly. You
can read up about it on the Money web site in the user's guide or in prior
postings over the last 60 days or so. Or you could investig...Can one set up a survey form on excel?
Can one set up a survey form (questionnaire) on Excel?
Yes you can?
> Can one set up a survey form (questionnaire) on Excel?
Check out Dave Peterson's code on Debra Dalgleish's website. It builds the
survey form with option buttons for you! There's also a sample workbook
there that you can download.
Does that help?
> Can one set up a survey form (questionnaire) on Excel?
...Redux: Wrong dialog displayed using derived classes
First of all, thanks for the help you all have given so far. But it's
still not working.
Because I have so many related dialogs, each with lots of code
processing the input, I've made a hierarchy of dialog classes derived
from CDialog. Each derived dialog has its own unique dialog resource. It
took some doing to get it all to link, so it's certain I derived my
When I activate a derived dialog at run time, the base class's dialog is
displayed instead of that of the derived one. Why, and how to fix it?
Thanks very much!!
Here is the class hie...Macro to change cells' display, Pounds, euro, dollars
I have a spreadsheet which I plan to protect all but a handful of
fields for the user to enter various money amounts. I'd like to include
a BUTTON in the spreadsheet that will force the display of any money
field to pounds, dollars, or euro. Mostly a cosmetic change, and I
don't want the user to have to select the fields to change since some
Is there any example like this using a button/macro?
Maybe like this, to change specific cells:
Dim rngCurrency As Range
Dim MyMsg As String
Dim myStyle As Integer
Set rngCurrency = Range("A1,B3,C...Archive settings
I think I have seen this question before, but I could not see an answer.
I wonder if there is somewhere a tool that would allow me to configure the
Archiving settings for my MANY .pst files in one single place. I do not talk
about the global setting, but the setting per-.pst file (which might be
different depending on the .pst file), without having me to open every
single .pst file properties.
does such a tool exist?
thanks for any pointer
The only archive settings that I am aware of in Outlook are the Global
setting that can be for all folders and the archive ...Outlook 2003: Copy Full Names to email display Names
I recently upgraded to Outlook 2003 from 2000.
I believe 2000 used to choose email addresses based on the Full Name
2003 appears to choose based on the Email Display name.
Most of my email Display Names are just the email addresses.
What is the easiest way to copy the Full Name to the email Display
What do you mean by "choose email addresses?" The Display Name has varied
with each version of Outlook, but it is of no consequence. What makes you
think it is?
"orbojeff" <firstname.lastname@example.org> wrote in message