HI EVERY BODY
I AM NEW IN HERE AND I REALLY NEEDS HELP IN THIS ...PLEASE HELP MR
*set up a spreadsheet to calculate the amount of french franc you can
buy.all the answers should be rounded to the nearest french franc .
you have 1� equals 9.2754 franch franc*
thanks a lot
firouz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35235
View this thread: http://www.excelforum.com/showthread.php?threadid=550105
email@example.com...How to prevent item changed in a CListCtrl?
I use MFC Visual C++ 4.2.
I have a CListCtrl in a Detailed View.
Below the CListCtrl there are a few CEdits to display the value of each
So it's kind of the data form.
I need to do like this:
If users has changed one of the CEdits BUT they haven't save the data and
they want to change the selected item of the CListCtrl to other item, a
confirmation message will appear to ask if the data they have been changed to
be saved or not.
There are 3 options:
Yes: the data change is saved and the current focus is on the item user
No : the data change is NOT saved and th...change date in a sql statement from a cell
I am using Excel 2007 I have a pivot table that gets refresh everyday. The
data from the pivot table is based on a sql statement, which the data is
connected to a AS/400 table. Here is my problem every morning I go in the
connection properties and change the SQLstatement (date) in the command
text. I don't want my user to do this. What other option can I do? I was
thinking change the date in a cell (A1) and somehow the SQL statement picks
up the new date or maybe some sort of parameter, but I am clueless in how to
do this. Any tips or website to visit I will a...Data labels: need value AND % change
I'm working on a series of column charts that show annual data for #
sold, $ volume, average price, median price, etc. I want it to show
the 2002 and 2003 values for each of these but I ALSO want to be able
to show the % change between the 2, so we can see trends.
So far, I only see that you can label the data with the value, or the
percentage. I haven't seen how you can show the values AND the %
change. Any ideas? I'd really appreciate it!
Message posted from http://www.ExcelForum.com/
Create the desired label in a separate column (the 2003 price
concatenated with t...Changing to Outlook
I have been using Outlook Express and now have Outlook. Have been able to
import address book and mail but emails are still coming to Express. How do I
change things so they come to my Outlook inbox? Thanks
You have to setup your account(s) in Outlook (Tools\Email Accounts in 2003)
and then quit using Express. You can also import your mail, address book,
and account settings from Express using the Outlook Import/Export tool
(File\Import Export...). Afterward, you should delect your account in
Express (Tools\Accounts\<select mail account>\Remove) so that you do not
accidently do...How change Sign-in Name?
I've been using Money for years. Recently I've changed my passport
account email address because the old one will no longer be available to
me in the near future.
When starting Money, I entered the new email address and password and
Money allows me to log in.
However, the issue is, the next time I start Money, the old email
address is back in there and I must enter the new email address every
time I start Money.
How can I change the Sign-in name to same the correct email address?
(I tried File/Password Manager and it will show the new address... until
I close and re-open mone...adding cross-functional flowchart changes page-layout
i would like to add to a "landscape" page a
stencil>flowchart>cross-functional flowchart shapes vertical.
when adding it the page converse automatically to a "portrait" page,
while it should remain "landscape"
the same happens if I add cross-functional flowchart shapes horizontal
to a "portrait" page. it changes into a "landscape" page.
can I avoid this?
I can't think of a way to avoid having the page orientation switch to
portrait when you drop the functional band shape out and pick vertical.
Visio automatically cha...Address fields left
Hi all, query solution I hope !
I have imported a csv address file into access : Address1 Address2 -
Some fields are blank followed by another blank
example : Text Blank Blank Text Text Blank
example : Blank Blank Text Blank Text Blank
example : Text Blank Blank Blank Text Text
How can I shunt all the fields left so as to remove any spaces
Use the Trim option. You havel LTrim, RTrim and Trim. The first removes
spaces to the left, the second removes spaces to the right and the last
removes spaces left and right. So in your query you could use something like
...automatic addresses in to:,cc: and bcc: fields, how to edit, delete, etc.
I don't know what it is called, but when you go to enter
the names in the To, CC, and BCC in Outlook they
automatically pop up. Very nice option. For example, when
I go to write Tara Lewis. I write Tara and it finds the
rest and pops/fills in the field.
Well, this name is in a list somewhere. Where is this
list, what is it called?
And this list is not the same as "contacts." I'm trying
to find out how to delete, edit, change, add in this list.
For example. My friend Brian has two entries. One correct
and one incorrect, spelled Brain. So when I write B - R
it puts u...Display middle name with Primary Contact field on Account screen?
How do I Display the middle name with Primary Contact field on Account screen?
Please help. We use the Primary Contact field on the main Account screen to
search and select a contact. The field then displays the First Name + Last
Name of the contact that was selected.
Can I make it show First Name + Last Name + Middle Name?
How do I do it? I will be very appreciative for any help I receive.
The CRM has one format for displaying contact names. you can set that
format in Settings-->Administration-->System Settings.
While First Name + Last Name + Middle Name isn&...Field text range problem
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
In my applescript, I need to find out if the user has put the cursor in a field at the time the script is run. <br>
There is no inField function and I can't seem to get a (start of / end of) text range of a field relative to the start of the document, for each field when looping through all the fields. <br>
I realize that text ranges contain fields. This makes it confusing that I am trying to find a text range or selection object that may be in a field. <br><br>Here is a little scr...Toolbar with different icon sizes
I am developing an Internet Explorer toolbar. Most of the buttons have
icon sizes of 16x16, but one of them has larger width (80 pixels).
Since a toolbar expects all icons to have the same size I have to do
something special if I want to add this button.
The solution that I am currently experimenting with is to make a
second toolbar which is a child window of the first toolbar. This
second toolbar contains only one button.
This seems to work a little. I can position it correctly, but the
problem is that the second toolbar is entirely black. If I move the
mouse cursor of it, it highlights a g...Compound Lookup Field Only Showing First Field
I am using a lookup field for name and the name is broken into two
fields - FirstName and LastName. When selecting the name from the
drop down, I see both first and last names, but after selecting, I
only see the first name. For visual reasons, I would like to see the
first and last names in the form. I am using Access 2007, but believe
this issue is in previous versions as well.
I am open to suggestions and appreciate your help,
> I am using a lookup field for name and the name is broken into two
> fields - FirstName and LastNa...Stencil file size
We have created stencils from Autocad files from some suppliers. They are
nice looking but are very slow when trying edit them in any way. Is there a
way to easily modify the Autocad files to simplify them without removing
detail to decrease the files size associated with the stencils? Are there
attirbutes or underlying details that can be deleted?
A few questions for you:
When you say stencils, do you mean you've actually created .vss files rather
than straight diagrams (.vsd)?
How many Masters does your stencil contain and what is the size of the file?
Also, wha...Changing Outlook 2002 email "From" field without the "on behalf of" text
I occassionally want to send emails from an address
different to my standard email account. I'd prefer not to
have to change the email account details on these
occassions. I have the "From" field in my New Mail
template which I populate with a contact showing the email
address I want the email from.
Unfortunately, when the email arrives it appears as
From: [mailto:myEmailAccountAddress] On Behalf Of
I've searched my Outlook settings and the MS site but
cannot see how to get rid of this undesired annotation
i.e. "[mailto:myEmail...Pick list width changes by itself...why?
I have some columns with the width 4. Sometimes the validation pick list is
wide like 40 and sometimes it is only as wide as the column. I already know
there's code to temp make the column wider when you click on it. But this
behaviour of the pick list sometimes appearing much wider than the column
makes me think there's something influencing the width of the pick list
itself. Is there some way to control the width of the pick list without
changing the width of the column or is what I'm seeing occur just an Excel
...How to change appearance of the links, pointing to subdocuments in the master document
I want to change the appearance of the links, which are pointing to subdocuments in the master document (Word 2003).
Specifically I want those links to look more descriptive with regards
to their contents - specifically making those links to appear like
those are entries in the Table Of Contents (like it would be looking
if those subdocuments were just paragraphs in the single monolitic
document). Please note that I DO NOT want to rename the filenames of
those subdocuments - I just want to change the appearance of the links
to those documents, in the way I already described above....Excel should have a "Change Case..." menu Item like Word!!
See the subject, I know you can set up a formula to do it I want a button!
PLEASE, for years I've just wanted to change case on the fly, YEARS!
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=3c7554c...Mail merge file sizes
Can anybody help me.
I have produced a 2 page document in Publisher 2003 and when I add mail
merge to it with a database of 500 addresses, when it generates I get the
1. It takes ages to generate (the green progress bar moves very slowly
across the screen as it applies the address to each document
2. The file sizes are at least 300mb for each 10 that it generates (the
original file size is less than 2 mb)
Any help would be appreciated.
This will help
The Registry Fix
for changing the Mail Merge Batch Size
Courtesy of KATMA
http://ed.mvps.org/Static.aspx?=Publisher/r...Change Display Order in Charts
I have an X-Y chart with a cloud of points and a line. When the chart plots,
the line is always hidden behind the cloud of points. Can I bring the line
to the top so it becomes visible? I tried making the line first and last,
but it always ends up behind the cloud.
Lines for a given chart group (group of data series) are plotted behind
points of that same chart group in an XY chart. However, you can change the
chart group by changing the axis on which the chart group is plotted. Make
the plot with one series formatted as markers only and another as lines
only, double cli...Set One Field based On Another Field
I think I have a pretty simple request. I am looking for some script to put
on an on exit field. Here is what I need it to do:
When a value is put in say $550, if this is greater than a specified limit
in the code I need it to set Field2 to Yes.
So if field1 > 500 set field2 = yes
Real world example:
I have a dollar amount of credit to give to a customer, I want to auto
populate the approval required field with a yes.
Your help is appreciated.
Try: IIf([Field1]>500,[Field2]="Yes") However if the field is a Bit data
type then IIf([Field1]&...Text Field Validation Rule for Date
I have a RESPONSE field on my table. This field is set up as a text
field (I do not want to change it due to specific requirements)-
however, I'd like to set up a validation rule to determine whether or
not it is a valid date: mm/dd/yyyy. What should I input in the
I do not think it is possible at table level but in your data entry form us
AfterUpdate event and IsDate function.
Build a little, test a little.
> I have a RESPONSE field on my table. This field is set up as a text
> fiel...How do I calculate the change in stock price in excel.
How do I calculate the change in stock price from the previous day.
Put yesterday's price in cell A1 and today's price in cell A2. In cell A3
put the formula:
> How do I calculate the change in stock price from the previous day.
...reduce size of mail store?
I've been gradually reducing mailbox limits and forcing users to archive to
reduce the size of the mail store. However it does not appear to be
shrinking. I thought daily mainteance routine would compress. Is there
anything to do other than an offline compress and defrag? I really don't
want to have to do that unless as a last resort.
Is your server running low on diskspace or are you having performance
Jason T. Parker
> I've been gradually reducing mailbox limits and forcing users to
> reduce the size of the m...How do I limit clients email attachment size
We want to set a limit on users attachments as it kill the bandwidth
available. Is it a group policy setting or is it a client config within
"spbembr" <firstname.lastname@example.org> wrote in message
> Hi All,
> We want to set a limit on users attachments as it kill the bandwidth
> available. Is it a group policy setting or is it a client config within
Seems that would be a quota setting that you would configure in the mail