Happy eLearning message boards

Currency Format in Mail Merge

sabbur — Fri, 18 Apr 2008 15:11:45 GMT

My Access database pulls from a Unix system where currency has 12 decimals. My query has all money set for currency and 2 decimals and it shows like this in Access. Merging to word all the decimal places show up. How do I get only 2 decimal places in my merge?

Forum: Microsoft Access

page numbering question....

slapdad — Tue, 25 Mar 2008 15:55:15 GMT

I have a 75 page document that I want page numbers on through page 48, then start the numbering sequence again with a sequence of F-1, F-2, F-3, etc. I can restart the numbering on the correct page and even found a way to number the pages based on chapters, but when I do that, it assigns a chapter header of "F" to the beginning of the new section. Is there a way to do this without calling in a rocket scientist?

Forum: Microsoft Word

Finishing my IF statement

pleephd — Mon, 24 Mar 2008 18:49:45 GMT

Hello

I was on the message board Monday (March 17^th) and someone was extremely helpful in showing me the correct way to write an IF statement that worked perfectly. First, I created a function that would allow me to compare various cells in a variety of ways. With people's help, I was able to create three different tables in one worksheet that ranked the top candidates for each table (table represents a review committee, which is supposed to come up with two top candidates). However, to make sure that people are being scored as unbiased as possible, I want to be able to look at all of the scores (from all 3 tables) and if any score is greater than one of the 6 top candidates my department wants to review that person's application again. Therefore, I want the formula to compare the top six scores (someone will be ranked 1 or 2 from each table) to all the other applicants. For instance, if another applicants score is equal or above the top six scores then, I want to print out (in another column labeled OWH review) OWH review. Conversely, if no other applicant is equal or higher than the top 6, then leave cell blank. However, I am unsure how to do this in Excel. Here is one of the tables are below for your review. Thank you.

	Committee Member Group A				Means	Rankings	OWH review	Final Rankings
Nominees	A	B	C	D
A	45	45	45	45	45	3
B	50	50	50	50	50	1
C	45	35	50	45	wait for conf call
D	45				45	3
E	45				45	3
F	45				45	3
G	45				45	3
H	45				45	3
I	45				45	3
J	50	50	50	50	50	1

Forum: Microsoft Excel

Usinf the IF function in Excel

pleephd — Tue, 18 Mar 2008 01:09:13 GMT

Hello

What I want to do is create a function that will allow me to compare various cells. For instance, we have people scoring applications and I want to see if raters' ratings are within 10 points of each other. If raters differ by 10 points I want to print conf call on my spreadsheet (so I can schedule a conference call for raters to discuss the 10 point difference). If raters are within 10 points then I want to print "compute mean" (so I will generate a mean for each applicant). I can get Excell to compare one rater against another (=IF(C3-C4>10,"conf call","calculate mean"), but I do not know how to make it compare all raters. For example, I have four raters and I want to be able to compare rater 1 to rater 2 and rater 1 to rater 3 and rater 1 to rater 4 and then rater 2 to rater 3 and rater 2 to rater 4; and lastly rater 3 to rater 4. Then if any rater dyad is different by 10 points I want to print our "conf call", but if there are no differences (by 10 points) then I want to print our "compute mean". I would really appreciate any assistance people could offer, I know that I am missing information concerning the IF function. Thank you.

Patricia

Forum: Microsoft Excel

reply pls

abdul123_shaik — Sun, 09 Mar 2008 12:35:28 GMT

i want 2 learn ms office

give me reply pls

Forum: Microsoft Word

Is there a way to embed a JPEG as a bound image (OLE)

LintyFresh — Sun, 03 Feb 2008 02:24:53 GMT

Hi all

I'm trying to insert an image so that it shows up on a form for each record.

First I made a table and included an OLE object as one of the fields.
Then I clicked Insert and then Object and browsed to a JPEG and inserted it.
Then I created a form based on that table, and inserted a bound object where I wanted the image to go.
When I clicked the view button, all I got was an empty square with the name of the file displayed instead of the picture.
Does this mean that I can't use JPEG images as an OLE, or am I doing something wrong?

Thanks

Forum: Microsoft Access

Mannnnn

MegaMan — Tue, 22 Jan 2008 18:42:14 GMT

Just realised hardly anybody replies in this forum... So my problem won't be solved...... booooohooooooo.

Where do you think I can find the answer to my riddle with micrsoft word.

Oh and my my name is Mega Man fear my rage... that about sums me up... YOU?

Forum: Introduce yourself

Microsoft word in FRENCH!!!?!???

MegaMan — Tue, 22 Jan 2008 17:24:00 GMT

I bought a second hand laptop from a friend. Turns out this friend was was from France and the Microsoft word she installed is completely French.

My French isn't so good, so I would like to know how you change everything back to good old English.

Thanks.

Forum: Microsoft Word

emote

sabarinarina — Thur, 17 Jan 2008 09:22:05 GMT

ABOVE: THE MANY FACES OF ME :D

Forum: Introduce yourself

Can't view pictures

GreenSpark — Tue, 08 Jan 2008 15:41:27 GMT

Word 2003, SP3

This one is driving me up the wall. I can't view or edit images in normal, web layout, or print layout. Only the placeholder box with solid anchors appears.

However, the image becomes viewable in Reading layout, and the editing tools become unlocked (not that this is very helpful in reading layout).

Has anyone come across this? It's most frustrating. I would like to have my graphics visible in print layout -- but I must have them be editable. I've hunted up and down for anwers, but cannot find a solution.

Thanks much.
GreenSpark

Forum: Microsoft Word

Macro Help

shonenknife — Thur, 03 Jan 2008 21:20:09 GMT

I want to make a macro that runs when ONE particular document opens. I found out how to make an autoexec, but it only seems to work with ALL documents. I just one a section of code to execute when just one particular document opens. How can I do that?

Forum: Microsoft Word

Odd/Even page numbers in header

Dap821 — Fri, 07 Dec 2007 17:36:43 GMT

I can not figure out how to alternated the words " page 2, page 3, page 4, etc. in the header of a document. No number on first page. I want the word "page" to appear as well. Any ideas?

Forum: Microsoft Word

Italics issue, never seen before, please help

lissa216 — Thur, 06 Dec 2007 14:48:26 GMT

We are having an issue with one PC in our office. When we type a word and it is in Times New Roman, Size 9, Italics it shrinks and the letters fall on each other...

When you change the font, it expands, when you change the size to 10, it expands, but back to Times New Roman, Size 9, Italics it shrinks again...

Any thoughts on how to fix this. it is not the char. spacing, that is set normal and thats what i thought it might be...

any help would be great! Thanks.

Forum: Microsoft Word

Converting Symbols

MJade — Sun, 02 Dec 2007 19:19:32 GMT

When I type common place symbols into word (Office 2007) i'm getting REALLY weird results. A foreward slash / becomes , an apostrophe (') becomes `` , square brackets are ^ and so on for almost all symbol keys.
I can't find a way to fix it. I've looked on Help, and in other message boards for people with similar problems and haven't been able to find anything. Autocorrect isn't doing it, my language setting is the same as always English (Canada).
Does anyone have any ideas? I'm getting REALLY frustrated.

Thanks

MJade

Forum: Microsoft Word

Access DB is not editable

qwerty — Thur, 29 Nov 2007 23:20:06 GMT

A user created an Access application and left our company. Now nobody can edit the MDB file. It still comes up and runs, but the regular options are not available from the menus. It seems that the user locked it in some kind of read-only mode. Does anyone know how I can edit this database?

Thanks.

Forum: Microsoft Access