Mell Install Question
We have MELL Installed on a Web Server. It is working fine and we have
several modules up and running and will be adding more and more..
When we first installed eLearning, we said 'NO' to the SQL Server peice of
the install. Now we'de like to have it log to SQL Server but am not sure
how to go about doing this. reun the install? uninstall and reinstall?? I
know there must be a way to implement SQL Server without having to reinstall
the whole thing !!!!
Can anyone help?
I have a chart with zip codes and a population rate.
I want to make a chart that has the rate on the x axis and the number
of times that rate occurs on the y axis.
I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1)
Label in G1 to read RATE (but leave it empty for now), label in H2 to read
Make a list of rates in G2:G20 (say)
In H2 =COUNTIF($B$2:$B$200,G2)
Copy down the row
Select H1:G20 and make a...URGENT:Concatenating 1000 cells into 1
I need to concatenate a 1000 cells into a single cell. Could someon
give me a macro to help me do that? Or if you have any ideas do let m
Message posted from http://www.ExcelForum.com
Dim c As Range, s As String
s = ""
'Amend range as appropriate
For Each c In Range("A1:A1000")
s = s & " " & c
s = Trim(s)
Range("B1") = s
"es9004 >" <<firstname.lastname@example.org> wrote in message
news:es9004.18brvb@excelforum-nospa...Exchange question #2
I have just taken over a medium size office, running Exchange 6.5 on Small
Business Server 2003, clients run Outlook 2003. My immediate problem is I
have two users who cannot send email to several specific addresses outside
the company. Everyone else can send to these addresses. When these two
people send email to the outside addresses, they immediately get an email
back stating that the address doesn't exist or something to that effect. It
appears to be bounced right back from the server. Does anyone have an idea
here? Thanks in advance.
Can you post the NDR?
Bharat Sune...Finding text
I'm recording a macro to use across multiple documents. One task of the
macro is to select a text string in the document and then take actions with
multiple occurances of that string. The "non-programmed" way of doing this
is to select the string, copy it, open the find box, and paste the string
into the find window and click "Find Next."
When I record these actions, the actual selected text gets saved into the
macro as follows:
.Text = " Selected text"
The next time I run the macro, in another file, wit...Drop down. *EASY* question!
BlankHiya everyone :)
I was just wondering if anybody could explain something reeeeally easy for
In Excel, I would like a two drop-down features in my columns of my
The first one (columnE) with the options 'yes' or 'no'.
The second one (columnD) with a list of names, eg.
Thankyou for ANY help you can give me!
"Do you know where you're going to?"
Data>Validation, choose a type of list, and then just type the values comma
(remove nothere from...Simple Simple Simple
Just started Excel (again) and need to make an easy speadsheet fo
calculating square inches.
Column A: Height
Column B: Legnth
Column C: Total Tags per 16 x 24
Column D: Cost per tag
Figures I know: each sheet cost me $9.98. each sheet is 16 x 24 inches
What I want to do is enter the Height, enter the Length and have th
total (sum) be entered into columns C and D.
I can't believe I forgot how to enter formulas. Any help will b
Message posted from http://www.ExcelForum.com
One Way, might be better ways but this'll work:
List the colou...Simple help with implementing Outlook-like GUI
I am an experienced unix programmer who sometimes has to do something
in the windows world, and always has newbie-questions.
Basically I want to write an application program that looks like outlook
in that it has nice icons down the left hand side that choose the
content of the main area in the right hand side.
So I started the MFC App wizard, and got me a SDI program with a
CLeftFrame (CTreeView) and a CMainFrame (CFrameWnd).
Then I prepared the following snippet of code to draw the buttons:
// Create a pushbutton
pmyButton = new CB...Experts Question
I'm writing a multi tool application, something like outlook.
I have an MDI application of course.
Inside the MDI the user may choose any of few Mini tools (something like
calendar,contacts,mail, tasks etc).
A mini tool may be an MDI - e.g. one of my mini tool is a resources editor,
which means that the user may first choose the "Resource Editor" mini tool,
and open/create many windows to edit.
Another mini tool will be "Scripts Editor", which the user may choose to
open many scripts views.
My problem is how to implement the switching between mini tools, I wanna pu...Hyperlink via indirect cell reference
I have workbook that contains a number of sheets. On a separate sheet I
would like to be able to insert a hyperlink so that I can jump to a specific
However, rather than inserting all of the hyperlinks manually (I will have
to replicate this over many workbooks) I wondered if there was a formula to
allow me to jump to a cell (say A1) in another worksheet, based on the name
of that worksheet being entered in a cell reference.
For example - a number of worksheets called "Sheet1", "Sheet2", "Sheet3",
In another sh...Simple hack to get $500 to your home. 06-05-10
Simple hack to get $500 to your home at http://uknews.tk
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side below search box, click on image
and enter your name and address where you want to receive your
cheque.please dont tell to anyone.
...Reference cell formats + content
How can I tell one cell to follow content AND/OR formating of another cell?
Here's an example:
=I am the <b>best!</b> (<b>...</b> means bold letters)
Returns: =I am the best! (without bold)
What can I do to tell A2 to follow:
- content AND formating of another cell
- formating only of another cell
- I'm using Office XP
- I'm using Windows XP
Not possible using formulas
"0-0 Wai Wai ^-^" <email@example.com> wrote in message
>...Fonts Inside of Cells
I am trying to change the font and size the displayed results of a
I have these four cells (A1, B1, C1 and D1) that I bring together into
another cell, A10. I would like the first reference to be 14 points,
bold and the rest to be 10 point non-bold,
What I have in A10 so far is:
This produces three line all the same font and size. (The IF statement
are to check if there is anything in the four cell,and remove th...Install question
can I have SQL Server 2008 Express with advanced services
with SQL Server 2008 Enterprise Evaluation installed on the same
On Fri, 30 Apr 2010 07:49:10 -0700 (PDT), Gilles Koffmann
>can I have SQL Server 2008 Express with advanced services
>with SQL Server 2008 Enterprise Evaluation installed on the same
You should be able to do this, have you tried and failed?
I am using Visual Studio 2003/C#
I created a new xml schema/xsd file (Project Create new item->Dataset)
I then added Elements to the schema using the designer
From the toolbox I then created an instance of my dataset.
I then dropped a grid (Infragistics UltraWebGrid) onto my form, and bound
the grid to my dataset.
At runtime, I configure the columns of the grid, get some records from the
Employee database (SQL Server2k),
and add some rows to the grid.
The user then enters some data into various cells of the grid.
I am now ready to update the database with the contents of the grid.
What ...Combining Text with Formula
Is is possible to have a cell contain text information and
then a lookup to another cell.
"The age of this person is " plus the result of another
cell that calculates his age so that cell would read:
"The age of this person is 72."
Thanks for any help you can give me.
=The age of this person is "&B1&"."
where B1 holds the calculation.
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com
"DebraAnn" <firstname.lastname@example.org> wrote in...Calendar in Cell Validation
I want to implement a cell validation such that when the user attempts
to input a date, a "list" box-like functionality pops up that has a
calendar and the user may then choose the date by picking with the
How would I implement this?
Try the following Web site.
This site's author covers this in a tutorial, but also provides downloads.
<email@example.com> wrote in message
>I want to implement a cell validation such that when the user attempts
&g...If cell is Bold then 1, if cell is Italics then 2?
I have a list of hundreds of cells, the cells are either Bold, Italics, or
I want those cells that are bold to result in 1 in another column. those in
italics to will result in 2.
Am I able to write a "if" function that achieve this? If not, what should I
Please kindly advise
One way, assuming data is in col. A:
1. Press Ctrl+F3.
2. Define the name "istyle" (no quotes) and in the "Refers
To:" box put:
3. In cell B1 put:
4. Copy the formula down.
5. If you'...Arabic text in Word
> Ce message est au format MIME. Comme votre programme de lecture de courriers ne comprend pas
ce format, il se peut que tout ou une partie de ce message soit illisible.
I am using the French edition of Word 2004 for Mac (version 11.3.8)
under Mac OS 10.4.11. When I paste Arabic text into a Word document, from
TextEdit for instance, it exits unexpectedly. If I write directly into Word,
the letters are not attached. Would you know how to solve this problem ? I
reprodu...Simple Query Wizard hangs
I am using Access 2003
When I initiate the "Simple Query Wizard", I am presented with the first
screen - "What fields do you want in your query"
When I click on the pulldown list to select a table, I get the following
"The expression On Get Focus you entered as the event property setting
produced the following error: the text you entered isn't an item in the list
* the expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro&q...Several Outlook Questions
I have Outlook 2003 with Service Pack 3 installed on my desktop and laptop.
First, I would like to syncronize my contacts and all my mail folders:
Inbox, Sent, etc. on both computers so that I would have that information on
Second, I would like to store all of my Outlook data--contacts, folders, etc
on my drive C: so that when I reconfigure my computer I don't have to backup
and restore this data which is such a hassle.
Can I do this and how?
2) By default the outlook data file is on your C: (Windows drive)
Backup, wha...tool bar missing
I accidentally moved the excel up so that the toolbar is above the screen.
How do I move it back down since I can't see the tool bar to grab it?
R-click it in the Taskbar, pick Move, press the Down Arrow key.
> I accidentally moved the excel up so that the toolbar is above the screen.
> How do I move it back down since I can't see the tool bar to grab it?
Goto the windows status bar at the bottom of your screen. Right-click the
Excel tab and pick Maximize.
Gary''s Student - gsnu201002
> I accidentally mov...Xch2k (SB edition) LOG and IFS question
Even I did the full backup with the Exchange server, the LOG and IFS
extension file still in the MDBDATA folder. How to purch? Thanks!!
I'm not sure what you are referring to regarding the IFS extension file.
As far as your full backup, how did you perform the backup? It must be done
using an exchange-aware backup program (such as NTbackup run from a computer
with minimum the Exchange management tools installed). It must also be a
full *online* backup, with all Exchange services running and all databases
M...VBA or Macro Help: Create new files based on dynamic text in a tab
I have 7 tables in a Word doc. Each table has a cell for "Owner". Suzy is
the owner in 4 of the tables, John is the owner in 3. I want to loop through
all possible owners (in this case, 2), find each table that belongs to them,
and create a new file for each owner. At the end of the macro, I'd have a
file called "Suzy.doc" with her 4 tables appended and one called "John.doc"
with his 3 tables appended. I could code this back in the day by looping
through a 'getOwner-readWordDoc-testCondition-writeRecord' loop-until-end.
But, I can...WDF Interrupt question
I'm sorry I just start learning windows drivers development. I'm looking at
Interrupt servicing in drivers in WDF. WdfInterruptCreate create the
interrupt object but where do we put the information about interrupt vector?
I noticed we can get vector by using WdfInterruptGetInfo, but where do we set
I think I have found where it comes from. From Hardware Resource list, which
is filled by PnP Manager.
On Mar 22, 12:56=A0am, mpefareo <mpefa...@discussions.microsoft.com>
> I'm sorry I just start learning windows drivers development. I'm looking ...