Question about what "Home" means in the Home and Student Edition
I was wondering if someone could answer a question for me please.<br>
I am seriously considering buying the "Office 2008 for Mac - Home and Student Edition" and I want to check what is allowed by the EULA.<br>
I like the 3 licenses because both my wife and I have a Mac and would be able to use Office 2008.<br>
However, both of us receive both "work" related email as well as "personal/home" email (we each use one email address for everything). Also, occasionally we might write a �work...How do I create a bell curve? I have my z, p, std. dev., mean,etc
I am trying to take my std dev, mean, z, p, Confidence level, etc...plot and
shade areas using excel.
See the ShadedNormalDensityCurve workbook at
- Mike Middleton
Decision Analysis Add-ins for Excel
"Brian" <Brian@discussions.microsoft.com> wrote in message
>I am trying to take my std dev, mean, z, p, Confidence level, etc...plot
> shade areas using excel.
...Help creating a script in SQL or Calculated field in Crystal
How do I take this script and manipulate it to give me one long string with
static text as well as SQL data in specific positions within the string.
Positions / Data:
1-3 / 173 (Static text)
4-6 / spaces
7-10 / "X_UPR30300"."YEAR1", (has to show up as 2007. Showing up as 2,007)
11 / 4 (Static text)
12-22 / "UPR00100"."SOCSCNUM"
23-57 / "UPR00100"."LASTNAME"
58-92 / "UPR00100"."FRSTNAME"
93 / "UPR00100"."MIDLNAME"
94-120 / "UPR00102"."ADDRESS1"
121-148 / &q...Help Creating A Formula #2
I need to make a formula for alook up. The first spreadsheet i
inventory, the second one is pg 103 strapping. I want to enter the fee
and inches for pg 103 on the inventory and have it look up the feet an
inches on strapping chart and enter the appropriate gallons in column
Attachment filename: p & g 101 strapping.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=50210
Message posted from http://www.ExcelForum.com
...macro for comparing fields in two work books
I have two excel spread sheets (say A1 & A2). A1- is the master sprea
sheet and A2 is smaller spread sheet with very few details.
Suppose Column B in A2 has 100 partnumbers and Column C in A1 has th
superset of partumbers (1000) and corresponding details for each par
number, I need to:
1. Check if all the 100 part numbers in A2 has a corresponding match i
2. Extract the info for the matched partnumbers from A1 and list in
3. Even if there in no match A1, let's say for 40 of them, it shoul
still list those parts in the new sheet.
Can anybody help me with t...Looking for Easiest Way to Create Report
We need to create a report from our accounting program which contains about
200 .db files. I have determined that the required information is contained
in only 3 of those files.
Out of those 3 files I need about 30 fields of data.
The end result is that those 30 fields of data have to be placed into an
existing excel spreadsheet in specific columns which has 97 total columns.
For example one db file contains data which has to be placed into column c
of the excel spreadsheet. another db file has data which has to be placed
into column z of that same spreadsheet and so on
Th...Creating a Browse for Folder
I have seen programs where there is an edit field for defining the location
of a file and then to the right of the field is a button with 3 periods on
it which when clicked brings up a browse for folder file box where the user
can choose a directory and file and then it is populated in the edit field.
Is there a custom control to use for this or do I have to develop this
Take a look at SHBrowseForFolder and CFileDialog. You probably want CFileDialog.
Ajay Kalra [MVP - VC++]
"William Gower" <firstname.lastname@example.org> wrote in message
news:Olf0wrmk...Does Multi-Field Index Work For Date/Time Values Only
I created a MS-Access DB table with the following 3 columns:
ColID - PRIMARY KEY
Col1 - Number
Col2 - Date/Time
Next I created a multi-field index using Col1 & Col2. I entered the
following row in the 1st row:
Next when I tried to add the above row again, as expected, I wasn't
allowed to enter the same row. Next I entered the following 2 rows:
Both the rows were accepted. After this I deleted the 3 records, went
back to the design view & changed the data type of Col2 from Date/Time
to Number keeping the multi-field index...CONCATENATE text to create a formula to be evaluated
I am wanting to concatenate a set of text to create a formula. I have done
The result is: =MAX('2009'!A3:A65536)
....but it treats this as a text string when I try to use INDIRECT
Cell O1 contains the year minus 1. In this case O1 = 2009. All of my
worksheets are named as a year e.g. 2007....2008....2009...2010. I am
entering this on sheet 2010.
Now the real question: How do I make another cell evaluate this string as an
actual formula and spit out the highest number for ...dynamic field content of parameter combobox
I have to filter my Crystal 9.0 report with a parameter combobox field in
Microsoft CRM. The data for this parameter field has to be loaded out of a
database field dynamically. I have found the possibility to load database
field values in a parameter field but this will not be dynamically. If there
is a change in the database content the parameter field content will not be
updated. I hope to create a combobox control is no problem.
Is there a way to turn this into reality?
Thanks for your help
...Deleting a single character in a text field
In one of my tables i have a field that has a text values like '123.23123' i
would like , to delete the full stop. How can i do this. I cant do it in
excel as the number of records that i have is over 200000.
> In one of my tables i have a field that has a text values like '123.23123' i
> would like , to delete the full stop. How can i do this. I cant do it in
> excel as the number of records that i have is over 200000.
Create a update query, use
Replace([yourField], ".", "")
as new value.
--> stefan <--
...Creating Formula with Embedded Variable ID
I need to create a single formula for my workbook that references cells from various tabs (over 20) in another workbook.
I want to copy this formula into multiple tabs within my workbook.
My workbook and the external workbook have the same number of and identically named tabs.
I want to embed a variable into the formula that will take on the name of the tab that the formula is copied to.
I imagine the formula would look something like this:
='K:\Sales Reports\[Ohio Team, Mar-21-2004.xls]variable_identifying_the_tab_goes_here'!D1
I know I can use the following formula to derive th...Creating Purchase order worksheets in HQ through rules
I would like put some code in a web service in order to create a purchase
order work sheet.
Could I access to work sheets logic using qsrules to construct a worksheet?
I looking for a method like QSRULES.CreatePOWorkSheet
...Creating a e-mail contact list which has "undisclosed recipients"
Can anyone help me with a contact list for my e-mail which
does not disclose all recipients names.
I would like to send an e-mail regarding company
information to several people which answers questions, but
I don't want everyone to know who I am addressing it to.
You need enter the names under the Bcc option when you address the email. That way, each recipient will only see their own name, but the email will go to everyone.
Actually, the recipients won't see their own name in the To field. They
will only see what the sender puts there, if anything (some ISPs require
that you...Migrating E5.5 Mailboxes with ADC created disabled accounts to to E2K3
I am getting to the end of my migration but still have all the resource
mailboxes with ADC generated diabled accounts in AD to migrate. I'm not
sure how to proceed with this. Can I just enable the accounts in AD migrate
the mailbox and disable it again or do I have to create a whole new account
in AD delete the ADC generated account and re-attached the new account to
the mailbox in E5.5 then migrate it to E2K3?
You can use the accounts it created.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"JoeAHM" <joseph.gonzalez@a...Creating navigation buttons on a worksheet
I'm trying to link togethor different pages on excel so i can navigate to
them from each page.
Also does anyone know how to create a drop down menu in excel?
Many Thanks in advance
Maybe by using a hyperlink:
using the =hyperlink() worksheet function:
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
ryan_...Creating opportunity using CRM api
Looking for an example of how to load the crm api to create an
opportunity using C#. I'm way new to this and have downloaded the CRM
3.0 sdk but not sure how I access the information it contains. What
I'm hoping to find is an example of creating an opportunity with just
the necessary information so I can build on it from there.
I appreciate any help!
When you install the SDk you will notice there is a help file in the
installed directory of the SDK, I think it is crmsdk3_0.chm
Open the helpfile and search for create, there are lots of examples
let me know if you get s...Installing CRM on 2003 Web Edition
Has anyone installed CRM 1.2 on Windows Server 2003 Web Edition. The
implementation guide is says it is a supported OS,
I am planning on attaching WS03 Web Edition to an SBS 2003 server. I know
that the supported configuration has everything on the single SBS box, but I
would much rather put some things on other boxes. I am also planning on
putting SQL Server on its own box as well.
Any comments on this configuration?
Beware that SQL Server cannot be installed on a Web Server edition !
Microsoft Business Solutions Support
Ce message est fourni...Validating two fields
I am trying to create a database in which some of the fields should be
mandatory only under certain conditions.
In my "Type of Injury" column, I want the user to be required to enter a
value in this column, only if the value in the "Type of Document" column is
"Nursing Report". Is this possible? I am only just beginning to teach
myself Access, so please bear with me. Thank you.
Put a validation rule on the *table* (not field.)
2nd example under the the Validation Rules for Tables section here:
http://allenbrowne.com/Validati...Adding Fields and Tables to MSCRM
Is there a link or some reference on the ability to add fields to existing
tables in the CRM database and/or adding complete tables to the CRM
database?? I am asking this from the point of view relating to other
existing CRM products (saleslogix, frontrange - shh). From what I have
played with so far from playing with my SBS2k/MSCRM install is I my need to
have a MS developer skillset.
Using the schema manager in the deployment Manager MMC snap-in, you can add
fields to the existing tables. However, there is no way to add new tables.
"Robb D" <robbd@eproductscons...I'm trying to display the next month in a text field
I've gone through all the forms and can't seem to get the code straight for
displaying the next month on a text field on my form.
I just want the entire month name and nothing else and I have been struggling
DateSerial(Year(Date()), Month(Date()) + 1, 1)
but its showing the day and year too and thats not what I need.
Thanks in advance!
>I've gone through all the forms and can't seem to get the code straight for
>displaying the next month on a text field on my form.
>I just want the entire month name and nothing else...Mail (outlook 2002), 'To' field, general question
Why do some names of some messages in the 'To' Field appear with single
quotes in my Sent Box? I'm using Outlook 2002.
I'm sure there's an easy explanation but it stumps me.
...How do I create an A3 size document using Windows 7
A3 is not listed in the pre-set schedule of document sizes in Windows 7
(unlike previous versions of Windows).
How do I create such a document using Windows 7?
Does your printer support A3? Word/Windows will display the paper sizes
supported by the default (or currently active) printer.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"A3 documents in Windows 7" <A3 documents in Windows
email@example.com> wrote in message
> A3 is ...Changing the names of fields in tables after creating other object
I just leaned about the naming conventions after I have created my tables,
reports and several queries. Can I change the name of fields in my tables
(to remove the spaces and give them unique names ie not just last name but
childlastname) without destroying the work I have done in queries, reports,
Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)
Possibly. If you are using a newer version of Access, say 2003 or 2007 AND
you have Name Autocorrect, and all it's options, enabled, it MIGHT work. I
found it somewhat buggy.
Before you...creating a multilevel numbering sysem
I'm trying to create a multileve numbering system
ex: 100, 100.1, 100.1.1, 100.2, 200, 200.1, 2001.1, 200.2, and so on. I
would like to have at least 3-4 tiers under each number that would
And you want this in Publisher?
I don't think so...
Mary Sauer MSFT MVP
"v" <firstname.lastname@example.org> wrote in message
> I'm trying to create a multileve numbering system
> ex: 100, 100.1, 100.1.1, ...