Creating a new field based on conditions
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no). I have
created a query that will return only the records for which insurance is
required but is expired/missing. My problem is that I want to create a new
field that is calculated based on the values in the other two fields in order
to make the resulting report more user-friendly.
For example, if GLRequired is True and GLExpiration is <Now(), I want the
new field to say...parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...Save formatted text from RichEdit control to rtf-file
How can I save the text from Rich edit control (2.0) to *.rtf , *.txt ,
I tried to get the buffer and putting the buffer to file, then saving
but the text in the file is something different.
Please let me know what to do?
Here is the Code I ma using:
mFile.Seek( 0, CFile::begin );
int iTotalTextLength = m_oChatMessageControl.GetWindowTextLength();
HWND focusWnd = ::GetFocus();
cBuffer2 = m_oChatMessageControl.GetSelText();
LPTSTR...Help with a formula..
I am trying to create a formula that will take information from a cell on one
sheet and combine it with text on another sheet. I know how to get the two
together. My problem is that I want the part that is brought in to be bolded
type. Here is what I have in the formula. ="we are pleased to submit our
quotation for "&(cell reference)&" according to the following
specifications." What I want to do is have the cell reference part be bold
type. Is there a way to do that? It doesnt work if I bold the cell.. already
tried it.. Any suggestions?
You'...Tracking Dates For Future Occurrences
Can this be done? I want to track a yearly review. I would like the date,
once entered - say 6/1/2009, to conditionally format to change yellow 30 days
before, then red 15 days before, and then to stay red until the date is
updated again for say 6/1/2010. Can this be done? I am new to all this,
In 2007 Also..
> Can this be done? I want to track a yearly review. I would like the date,
> once entered - say 6/1/2009, to conditionally format to change yellow 30 days
> before, then red 15 days before, and then to stay red until the date is...Having problem of Outlook not receiving new e-mails
I have been using Outlook for over 1 year with Comcast
Broadband. Suddenly last week, I received a message that
Outlook 2000 was experiencing a problem when receiving new
e-mails and was going to shut down. I re-opened Outlook
and it looked different and then it asked for me set up a
profile and I canceled it. But after that window coming up
a couple of times after it shut down, I decided to put in
a new name and then I could not get to my old e-mails and
it acted like a new set up. Then I really got frustrated.
I was eventaully able to get back to my old e-mails and
have been able t...Uninstalled Word 2004 test drive
I installed the "Test Drive" version of Microsoft Word 2004 on my
ibook, G2, 500 mhz, machine. I am running Panther. After trying it
for a couple days and becoming very frustrated with the program I
followed all directions to remove the program ... I removed only the
After uninstalling I could not automatically open any of my word
documents. I never "created" any using the test drive, but I can�t
open any of my documents created on my Word X version.
Trying to open these documents I received an error message:
"The operation could not be completed....An Outlook 2003 Problem
I just upgraded from Outlook 97 to Outlook 2003. However, when trying to
reply, forward, and compose with Outlook 2003, I got this error message:
"The messaging interface has returned an unknown error. If the problem
persists, restart Outlook."
The problem persisted. I restarted Outlook 2003, but it didn't help.
Any suggestions? Thanks.
How did you upgrade Outlook 2003 from Outlook 97?
Anyway If you use Hotmail or MSN mail,
check MSKB info below.
You receive a "The messaging interface has returned an unknown error " error message when you try to use Outlook to...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Sumproduct with multiple date criteria
Having a tough time with this one.
Column A = Start Date, Column B = End Date, Column C = Quantity.
Row A = Start Date, Row B = End Date.
I would like Row C to sum quantity from sheet 1 where ever the two date
The date ranges on sheet 2 represent the beginning and ending of a week
Column A Column B Column C
01JAN2010 24JAN2010 1,000
Row A 04JAN2010 11JAN2010 18JAN2010 25JAN2010
Row B 10JAN2010 17JAN2010 24JAN2010 31JAN2010
Row c 1,000 1,000 1,000 0
Do the Sheet 2 Star...Cell Format #4
Is there a way to have a cell format based on contents of an i
if(C1="Input",and(C3,Format $#.##),if(C1="% of Revenue",and(C5,Forma
I want the If statement to test a condition, return contents of th
correct cell and format automatically.
Any help is appreciated
bforster1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=26133
You can't change the fo...Trouble doing a formula for excel
I have a spreadsheet with the following
I would like to add 1 too the number to make unsorder00040.csv and so
I have try mid,right,left i can't seem to do it
"Jason" <Jason@discussions.microsoft.com> wrote in message
> Hi All
> I have a spreadsheet with the following
> A1: z:\data/pc32/tsheets\unsorder00039.csv
> I would like to add 1 too the number to make unsorder00040.csv and so
> I have try mid,right,left i can't see...Exchange Server 2000 Secuirty Setup problems
I have apply wrong setting to our exchange server 2000 . The wrong setting
as from exchange manager . mail store , I have apply everyone send as and
receive as access right, the group included remote access via offline sync.
This setting once apply , all user access other mailbox without apply access
right. I have try disable this setting, after all local office user no
problems, but a remote offline sync laptop user does not work . The error as
below: Unable to display the folder. Microsoft Outlook could not access the
specified folder location. The file C:\exchange\shawnb.ost cannot b...Formatting #13
How can i have codes in this form 00.00.0000.00, & i wanted to sum to the values below like next code, 00.00.0000(+1).00 I'm tired to format but always sum in the last 2 digits 00.00.0000.00(+1), what can i do
Someone can help me
How did you put 00.00.0000.00 in the cell?
Did you type 0 and then give it a custom format?
If yes, try changing your custom format to:
Then add 1, but make sure that the resulting cell also has this custom format.
This is really a funny formatted number with 2 decimal places now.
> How can i ...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...Help! Problem Referencing Excel 2003 in VB.NET
I am using Visual Studio 2008 Express Edition to develop some VB.NET
code that manipulates Excel files. I am developing on a Vista/Excel
2007 machine, but I need the code to work on an XP/2003 machine as
I initially set a reference to the Microsoft Excel 12.0 Object Library
and imported the Microsoft.Office.Interop.Excel namespace. This works
great on the VIsta/Excel 2007 machine, but it does not work on 2003,
which needs the 11.0 library. I get an error that says "Unhandled
Exception . . . Could not file or assembly
'Microsoft.Office.Interop.Excel, Version 12.0.0....copying formulas in vba
I was wondering if someone could help me. I am writing a vba script that
takes in data, analyzes it, and then copies the results to a new file. I am
having a problem with two things.
1) I am using a template for the new file so there are a lot of formulas
(sums and std) already defined and ready to use. However, there are some
instances where there is a random amount of additional data I have to put in.
So, I have to apply the same formulas to this new data. How do I copy
formulas from one cell to another (allowing for a change in row) in vba?
Lets say cell(1,4) has the form...conditional formatting in excel #3
how do you add a phrase to a field if the filed is blankl, also, can you have
a notifiction sent to you when a date on a spreadsheet has expired?
> how do you add a phrase to a field if the filed is blankl,
What "phrase" do you mean? A Comment? A value?
also, can you have
> a notifiction sent to you when a date on a spreadsheet has expired?
Maybe you can apply an open event (date to be tested being say in F1):
Private Sub Workbook_Open()
If Range("F1") < Date Then
MsgBox "Date expired"
...Duplicate personal folders problem
I have a problem with Outlook 2003 and I hope someone can help me resolve it
I imported a PST file from Outlook XP that was on a different machine, and
now I have two versions of Personal Folders in my All Mail Folders list.
They both have Deleted Items, Drafts, Inbox, Junk E-mail, Outbox, Sent Items
and Search Folders in.
One of them has an icon of a piece of paper with a clock to the top left and
a house to the top right.
The other one has an icon like a stack of files (like from a filing cabinet)
They are clearly referencing the same thing, as the Deleted Items both have
al...Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...Converting date from an external source
I am having an issued with converting a date from external data source. the
data has the timestamp in the general date form mm/dd/yyyy 00:00:00. I want
to convert the date to mm/dd/yyyy format so when i run a query for a single
day it will return the data for that date, I can currently return the data
but i have to set the parameter in the mm/dd/yyyy 00:00:00 format, i want to
simply return the data by setting the parameter in the mm/dd/yyyy format
Don't confuse how data is stored with how it is presented. As long as you
import the date into a field defined as a Date data type, you...Excel formula #24
What is the formula that brings back a zero for an empty cell instead of
0 0 #DIV/0!
"Dave" <Dave@discussions.microsoft.com> wrote in message
> What is the formula that brings back a zero for an empty cell instead of
> 0 0 #DIV/0!
...Formatting Linked Cells
I have a project to do. I have to create an input worksheet that is the originator of other worksheets that are linked to the input worksheet. Is there a way to have the linked cells shown as a blank cell if the data (especially text data) is not enter in the input worksheet yet.
(Don't use my reply address - it's spam-trap)
"MT" <MT@discussions.microsoft.com> wrote in message
> I have a project to do. I have to create an input ...Excel Problem #3
I have win2000 with Office 2000 in the network!
When i try to rename one excel file my computer make
restart. This hapening not to all files,and all files
there are in the same folder in the network!
What hapen,and what i can do so as to work out the problem?
I have all the required permissions on that network folder.
No one else has any of the files open.
They are not shared workbooks.
...Problems with MFC list controls
I have a large list control with many inventory control items displayed
within. When someone single clicks on an item, it displays information
about that item in another part of the dialog. I have a three-fold problem,
the master list has multiple columns in it, in order to make the selection
work properly, only column 0 can be selected, is there a way to make a valid
row selection if you select an item using any of the other columns? Second
issue is the highlight of the selection. Only column 0 in the list control
will highlight, is there a way to make the entire row highlight when an...