Pages

Search

Microsoft Word - 8.1 compatibility Brother MFC7860DW envelope address printing

Microsoft Word - 8.1 compatibility Brother MFC7860DW envelope address printing

8.1 compatibility Brother MFC7860DW envelope address printing

Posted: 21 Mar 2014 02:44 PM PDT

Unable to print  delivery and return addresses in correct positions on envelope (both #6 and #10). Does print delivery address upper middle of envelope and down approx. 1/2 inch. Does not print return address. Does not respond to manual repositioning using Font options. Manual envelope input to Brother MFC7860DW.This is not an envelope feed orientation problem. Same problem populating the address fields either from Word document or from direct input on  Envelope/Labels screen. Installed MFC August 2013 and had no problems until Feb. 2014.   Running Windows 8.1 64 bit, Office 2013 Home & Business. 

Brother Tech Support says it is an MS issue. Their Support page says that MFC unit  is 8.1 compatible.

Other computer on same local wireless network using Word 2010 and same Brother MFC does not have any problem.

Would appreciate help.

Word has stopped working

Posted: 21 Mar 2014 02:01 PM PDT

Safe mode is not working either.  I cannot print out existing docs, cannot open ones received, and cannot create new documents.  This happened suddenly.  How can this be fixed??  Need help!!

Text getting cut off and not showing in Print View, but will print correctly and show when Paragraph Marks/hidden format symbols are showing

Posted: 21 Mar 2014 12:25 PM PDT

I have a document that is being exported from a browser based database to Word.  I am using Word 2010.  The document has tables nested within tables.  When I look at the bottom of the page in Print Layout, the text looks like it is cut off.  If I turn on the paragraph and hidden character symbols, the text displays correctly.  If I print it the text displays correctly.  If I look at it in Web Layout or in Outline Mode, the text displays correctly.

The challenge is that the document then gets uploaded in an electronic documentation system where the document is often looked at electronically on the screen.  Print Layout view is the typical view clients are used to and they don't like to see the paragraph/hidden characters symbols.  In Web Layout and Outline Mode, headers, footers, etc aren't visible so that won't work for the client.

Is there a setting such that this text is visible in the Print Layout mode without the paragragh and hidden character symbols.

The external and internal table are set to break across the page.  In File/Options/Advanced/Layout Options, the "don't break wrapped tables across pages" is unchecked.  Also under Show Document content the setting "show drawings and text boxes on screen" is checked.

Any other idea?  I figure it is some sort of setting/checkbox deep in the bowels of Word that is causing this.

Thanks.

lost characters on Insert Symbol menu

Posted: 21 Mar 2014 12:17 PM PDT

When I used to go to Insert > Symbol > More Symbols and selected a font like Calibri, the Symbols tab on the menu would show a really large number of possibilities, with a drop-down on the right-hand side to select "Greek" or "Mathematical Operators" and such.  

Now somehow, the right-side drop down is gone, and the available character set for insertion is small, and has, for example, no Greek and no math. 

How do I get back to the way things used to be?

The picture below shows the totality of the available Calibri glyphs now.

How to automate CAPTIONS and control the numbering base on a chapter heading?

Posted: 21 Mar 2014 09:43 AM PDT

I have tried office.com suggestions on this but could not get it. I want my captions to look like Figures 5.1, Figures 5.2, Figures 5.3,..... I want to have full control of the numbering so that I can change the '5' to any chapter number that I am in.

In addition, I want to make this automatic for subsequent figures in each chapter.

Unspecified error /word/document.xml Line: 2 Column: 12402

Posted: 21 Mar 2014 09:19 AM PDT

Can somebody help me to open this document again?

I just made it this afternoon. I saved it and tried to open it again when this error occurred...

Unspecified error /word/document.xml Line: 2 Column: 12402

You can find the document here: 

https://www.dropbox.com/s/ubjt2tjqf7nhizt/Nele.docx

Thank you very much!

How to define a paragraph style that includes information icon?

Posted: 21 Mar 2014 09:13 AM PDT

Hi all,

I'd like to create a paragraph style for informational messages that is indented and includes an information icon anchored to the message's paragraph.  How can that be done?

Currently, I have to paste the information image into the document, resize it, set its text wrapping to "Through" (right-click on image\Wrap Text\Through), then manually use the mouse to anchor it to the message paragraph, which is a lot of work.  Here's what it looks like when editing:

How do I define this paragraph, including the information icon, as a style?

-matthew

WORD changes to split screen and single screen is desired.

Posted: 21 Mar 2014 08:51 AM PDT

I was working on a WORD doc last night and it suddenly went to  a split 4 screen. I must have hit something but I cannot figure out what to do to get the doc to go back to a single screen. Anyone, help please.

Keyboard shortcut to apply a specific custom style?

Posted: 21 Mar 2014 08:46 AM PDT

Hi all,

I want a way to apply a particular custom style via a single keyboard shortcut.

I've already tried adding a shortcut to invoke Format\Style..., but then I have to type the style name (called "Inline code").  That takes just too long, as I have many, many spots in my document where I want to apply the style.

Is there a way to assign a single keyboard shortcut to assign a particular custom style so that the style is applied with a single action/keystroke?

-matthew

Adding New Heading Levels

Posted: 21 Mar 2014 08:41 AM PDT

Word has 9 Heading levels. Is it possible to create more heading levels that will be pulled into the TOC when you generate it? I have a Heading Level 7 that is used for the Appendix sections and need to add sub heading levels within it. So Appendix C is Heading Level 7. Now want to add C.1, C.1.1, C1.1.1, etc. to nest under the Appendix C heading but the other heading levels are already being used for other Heading styles.

Does anyone have a solution?

Thanks ahead!

Office (word) does no longer open.

Posted: 21 Mar 2014 07:49 AM PDT

So far I have had no problems with Windows 8 or Word, everything worked fine and the way it should until the most recent windows update when it changed from Windows 8 to Windows 8.1. Now none of my Word programs will open, no matter which format they're saved in. Any ideas on what I can do to make it work again?

I appreciate it.

word 2010 page numbering error (WITH VIDEO LINK)

Posted: 21 Mar 2014 07:17 AM PDT

hello everyone so my problem is that if i add page numbers to any new, or existing word 2010 document, i cant format them, lets say i want to nuber pages latin numbers 1,2,3,4 and so on, everything seems to be OK, but then i want to change those numbers to Romian I II III IV V and so on, the only number is changed is the first one, i tried everything, even reinstalled my MS OFFICE 2010 copy, on my pc, heres video about it https://www.youtube.com/watch?v=iLjaZR0Rzko&feature=youtu.be

nothing is helping, but earlier page numbering all was working fine, i tried to reset ribbons to default, still no luck, please help me

Add commands to the Table right-click/context menu

Posted: 21 Mar 2014 06:55 AM PDT

I'd like to find out how to add the Split Table and Sort commands to the Table right-click/context menu.  This would seem to be a lot faster and easier than having to access the Table tab all the time.

Thanks for any/all assistance!!

I have a Problem

Posted: 21 Mar 2014 06:44 AM PDT

My computer is working fine, but I can not go to office 2013, like word, Excel, and many more.  The error code they gave my was 30033-27.

Page Numbering - Unique Customr Requirement

Posted: 21 Mar 2014 05:11 AM PDT

In the footer of the document my customer wants the page numbering to be on two lines:

Example:

Chap 1

Page 1

Yet the TOC page numbering needs to be "1-1".

Thanks!

VBA Word Field Codes

Posted: 21 Mar 2014 05:08 AM PDT

I am attempting to define a number of custom built field codes and assign values to them.

My attempt is ...

  Dim strPropertyName As String
  Dim strPropertyValue As String
 
  strPropertyName = "ProjectName"
  strPropertyValue = "My Special Project"
   
  ActiveDocument.CustomDocumentProperties.Add Name:=strPropertyName, LinkToContent:=False, Value:=strPropertyValue

However,this creates a run-time error with the message "The index into the specified collection is out of bounds."

What am I doing wrong?

The final solution will capture the values in a UserForm and write them to a table in a Word document.

Word

Posted: 21 Mar 2014 04:45 AM PDT

I can't open Word.  I get the error message 30169-22    What can I do? 

no longer able to open docx files

Posted: 21 Mar 2014 03:17 AM PDT

I use Word 2003 and have always been able to open docx files emailed to me. Usually I get a dialogue box warning me that some features will not be available, I click OK and the file opens. 

As of today I can no longer open any of the docx files I have saved to my laptop, even tho I have previously opened and worked on them without any trouble. I have tried going back to the original emails and downloading them again but no luck there. 

My Word 2003 files all open fine, just the newer Word versions have suddenly become incompatible.

Maybe this is a coincidence but there were a bunch of Windows "updates" downloaded two days ago.

Any idea what's going on here?

Changing Fonts

Posted: 21 Mar 2014 03:00 AM PDT

I regularly receive long Word documents from which I have to make several hard copies.  Unfortunately these come in a large font with large line spacing and use masses of paper and ink when printed.  The sender has repeatedly refused to alter her font and spacing and I wonder if there is a simple way of altering fonts, font size and spacing in the complete document in one go.

I know it can be done one page at a time but that is impractical for these long docs.

Any advice would be appreciated.

RayTJ

 

cannot start office word 2013

Posted: 21 Mar 2014 02:29 AM PDT

something went wrong, we couldnt start your program. Please try it again later. if it wont start try repairing office on control  program and features. I have tried but could not because the repair was not highlighted. Please help urgently

Linking excel data into a word userfrom listbox

Posted: 21 Mar 2014 02:11 AM PDT

Hi, a warning beforehand, I am using office 2003, but i can upgrade to 2010 if that makes things easier to solve.

I am trying to link an excel spreadsheet with a word userform listbox. I'm very knew to VBA so i will need a bit of help with it but here is what i would like to do:

  • I have a form in word with various text boxes.
  • When someone opens the form i would like a userform with a listbox to appear
  • From the list box i would like a list of names to dropdown (these names are on column 1 in an excel spreadsheet)
  • When they choose a name and click an "OK" command button i would like the textboxes on the form to autofill with information from the spreadsheet that correspond to the chosen name.

for example if "Dave" was selected, text box 1 on the form would fill in the name, box 2 the start date, box 3 the annual leave remaining etc, just for Dave:

Name Start Date Annual Leave Remaining (days) Annual Leave entitlement (days)
Dave 09/01/10 12 32
John 08/02/09 3 34
Bobby C 07/03/08 9 32
  • I would like to just have the names in the list box, i would like the rest of it to link but not be shown in the listbox of the userform
  • Finally, if someone updates the excel spreadsheet then I would like this to update the information that gets populated into the textboxes from the userform.

i have the form finished, i the excel spreadsheet, i know how to create a userform. not sure how to get it to pop-up when the document is opened and the rest remains a mystery to me. Any help would be very much appreciated.

Ollie

Fonts garbled on opening documents created in previous versions of Word

Posted: 21 Mar 2014 12:19 AM PDT

Whenever I open an existing document, the fonts do not display correctly. Also, when I open documents such as these, a lot of the the design themes are similarly garbled. As soon as I choose a different font for a document it is fine, but as I have to work with a lot of older documents, this is very annoying. Can anyone help please?

Problem Placing EPS files in WORD

Posted: 20 Mar 2014 11:29 PM PDT

I place a vector eps file in Word 2011 for Mac, everything looks and prints fine.

I save the file in both .docx and .doc versions.

Both files opened in PC Word 2010 have a slight cropping around the eps files both on screen and in print which I can't get rid of.

AutoCorrect in Microsoft Word 2010

Posted: 20 Mar 2014 10:59 PM PDT

Apologies if this has been asked before, but I would like to know if it is possbile to have Word automatically apply the AutoCorrect rules to a batch of text copied into it? For instance, if I copy something like, "Teh sentance is intentionally mispeled " into Word, is there a way for Word to automatically correct that to "The sentence is intentionally misspelled", without drawing a bunch of red squiggly lines?

Thank you!

Multiple document pages. No tool bar or ribbon i Word 2013

Posted: 20 Mar 2014 06:18 PM PDT

Somehow an important Word document was changed so that all four pages appear on the screen. there is no ribbon (or toolbar). If I click at top of screen, I can sometimes get the ribbon to appear overlaying the top of the document page. I have found no way to get my document back to a normal display. HELP

Strange copy and paste issue

Posted: 20 Mar 2014 03:33 PM PDT

I'm having an issue with the copy and paste functions with regard to Microsoft Office 2007 on an XP machine. Recently, I have been experiencing issues pasting tables from MS Excel 2007 to MS Word 2007. When pasting in Word using CTRL + V, a very small icon appears as an inserted image (it appears to be a palm tree). When I delete the icon and try the CTRL + C, CTRL + V functions again, the table pastes correctly.

Just want to see if anyone has had experience with this issue... copy paste eventually works on the second try, but I don't understand what's happening with this island icon thing (maybe its an easier egg and I've won some sort of prize???)

Microsoft CRM - CRM Test Environment

Microsoft CRM - CRM Test Environment

CRM Test Environment

Posted: 15 Nov 2004 09:34 AM PST

Matt,

Once I create subdomain, how to I setup CRm database?
Do I have to take the instance of databases?
Is it required another CRM license to install?
How it works?

Thanks,
Jipson



"Matt Parks" wrote:
 

E-mail error

Posted: 15 Nov 2004 07:59 AM PST

Nope. It went there the way it was. Any ideas where to go from here?

Thanks,
Sheri
"Matt Parks" <com> wrote in message
news:com... 
port to 
change. 
wrote: 
is 
Under 
mscrmmailserverurl. 

"Object Error" when printing reports

Posted: 15 Nov 2004 07:09 AM PST

Peter,

Thanks for replying.

I have installed all of the updates, including the one for XP/SP2 on the
client laptop and on the CRM server (Win2003). Yes...I have a printer
installed on the laptop and am able to print office documents from it without
problem.



"Peter Lynch" wrote:
 

Help for CRM Exams

Posted: 15 Nov 2004 05:27 AM PST

Peter. Do you have some example exams ? If you have it, please contact me.
Thanks again.

Daniel Rodriguez.
Argentina.

"Peter Lynch" wrote:
 

Slightly OT: Gold Vision export

Posted: 15 Nov 2004 03:23 AM PST


"Vass" <com> wrote in message
news:net.uk... 

Hi Vass,

Sadly, I thought you meant GoldvisionPro which is a GoldMine add on, which
would mean your source data would have been in GM - which it is not.
Sadly twice also, I thought you might have been migrating to MSCRM which you
are not, so that advice goes out the window.
Sadly a thrice time, this NG is specific to Micorosft CRM, so it may be
unlikely you will get any replies from others on this, but have a look for
other NG that might be more likely to assist you.

So you want to go to Maximiser.
If GVPro works on SQL, CAN you not use DTS if it uses SQL as its backbone,
or indeed maybe there is an export/import you can work around to get your
data out?
I was going to actually mention Scribe if you were into MSCRM, however I
doubt they do an adapter for Maximizer.
We also use a product called Inaport but thats NOT specific to maximiser
either.
IE I am all out of advice, sorry - but recommend you talk to a Maximiser
specialist/ng.

Indeed, I might recommend you rethink the applicatoin you want to move to,
but I'm bound to say that aren't I!

Cheers
Antoine

CRM and Citrix

Posted: 15 Nov 2004 03:01 AM PST

Chris,

Mutli-profile installs of SFO are not supported. MSDE is a part of it, but
there are also registry settings that are machine specific that would casue
problems.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Mon, 15 Nov 2004 13:43:08 -0800, "Chris" <microsoft.com>
wrote:

Yes, MS CRM works in a browser BUT my users want to use the full Outlook
client. Is THAT supported in Citrix/Terminal Services? I don't believe it is
and I really, really need this to work so if anyone has any info/suggestions
on how to get this working, please let me know.

I believe it won't work because MS CRM uses MSDE to facilitate offline
synchronization for mobile users??

Chris


"PJS" wrote:
 

conflict_CRMPub-

Posted: 14 Nov 2004 09:21 PM PST

Correct. The conflict_* tables are there to support the SQL replication
processing. You will notice they are all flagged as "System" vs. "User" tables
in Enterprie Manager.

A slight clarification on the "last update" comment. It's actually the "last
synched" update that wins. So given the following timeline:
- sales rep updates an Account while offline at 11:00
- someone else updates the Account via the web browser at 11:30.
- sales rep goes back online at 12:00.

The sales reps updates will override the update made by the other user.
However, updates are field level, so this will only be a problem if both users
update the same field (ie. Name).

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Mon, 15 Nov 2004 09:22:02 -0000, "Stephen Redmond"
<nospam> wrote:

This is to do with replication.

I believe that MS CRM does not handle conflicts and assumes most recent
change wins.


Stephen

"System.Xml.XmlDocument" <microsoft.com>
wrote in message news:com... 

CRM 1.2 on SBS 2003 fails

Posted: 13 Nov 2004 09:26 AM PST

But did the print the *updated* version of Chapter 15?


"Andrew M. Saucci, Jr." <com> wrote in message
news:phx.gbl... 

Sending Emails automatically

Posted: 12 Nov 2004 04:08 PM PST

Thanks for the help. I guess I will go with the manual rule.
Regards,
Mike

"Guy Riddle (Snapdragon)" wrote:
 

Custom CRM report using Crystal Reports

Posted: 12 Nov 2004 03:15 PM PST

I am using Crystal Reports 9.22

The problem is that Crystal appears to be misreading the datatypes so I
cannot join the two tables.


"Razorback" <microsoft.com> wrote in message
news:com... 
I 
s.attributevalue=a.accountcategorycode 
termonology). 
data 
and 
of 
source? 

How to restore access to user

Posted: 12 Nov 2004 03:04 PM PST

If support gave you the tool to check the AD/SQL synch, then they should be able
to help you figure out how to fix the discrepencies it found.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 12 Nov 2004 15:28:02 -0800, "acdmark"
<microsoft.com> wrote:

Hi Matt,

I know unfortunatly this was done without my knowledge and I am left to
clean it up. I also have ran the fix you speak about the Active Directory
Checker. It does check between the ad and sql. it reported the following:

Wruck, Vincent {C302B117-2DDE-4A31-BA35-6B63C573F064} is missing.
Manuck, Greg {1DCF74ED-86EA-4CF3-8334-514B7B99CE31} is missing.
Branco, David {B7118B81-E478-4029-BBCD-F5D6723F2BAB} is missing.
Innes, Dean {D67933BC-5333-49FD-B11F-5983E5609EFF} is missing.
How, Mark {F9F6BFEB-5235-4D36-B46D-CC4CB619D56E} is missing.
Kless, Maximilian {D7B728E5-349A-4008-B972-61018C7052C2} is missing.
Cairns, Simon {95F1C5B8-927D-47DC-B49A-A92782EBA06D} is missing.
Neufeld, Kevin {FBAD7473-7409-4AA6-B791-7865608D2B4B} is missing.
Bertrand, Jo-Lee {D51C9E99-FEB4-450B-9268-99EFAEC12837} is missing.
Benson, Tom {0427052B-771A-46EC-A7A3-543DD4BFF592} is missing.
Zelen, Mike {68CE8906-7F0F-4C1F-8A62-5251C1E901E1} is missing.
Porter, David {692F3917-0D71-4437-AC32-FD639F43AAC1} is missing.
MacLeod, Shannon {3A621208-A8BA-4E93-9C3A-B90A5463C3A8} is missing.
Hawe, Kevin {8A6CDB6F-D4FC-41C1-A0F1-D7CAA0DC0548} is missing.
Winter, Candice {8C83674C-77F0-4AE5-8EE1-762470BF6583} is missing.
Wallace, James {B987A275-62EB-4A5F-9B95-FA7D77B4A38D} is missing.
Wright, Ken {60FC0377-270E-4238-A2F1-C80486F33198} is missing.
Stuparyk, Kathy {2F204031-E236-4D19-813D-AAFBEE98A200} is missing.
Middleton, Shannon {D272FD47-57AD-447C-A799-929837294495} is missing.
Piepgrass, Brian {7AE50A3C-4901-4F23-9215-3F203521EB54} is missing.
ACD Miami, Test User {A0DD8AA1-A5B8-48B1-8B98-A1589DF1DAF9} is missing.

but other than reporting this it did not fix it. We have tried removing the
roles from the user through the ad and then adding them through the crm web
client still he gets the access denied error message. I am hoping this
security descriptor tool will work.

Mark

CRM Addin Checkbox won't stay checked

Posted: 12 Nov 2004 09:25 AM PST

Marlen

That worked perfect! Thanks for the help

CHarles

"Marlen" wrote:
 

Do I have to initiate an e-mail from CRM to have it tracked?

Posted: 12 Nov 2004 09:06 AM PST

If you use the SFO client to send the message, then it could be tracked. If you
just send it via regular Outlook, it will not be associated with the Contact.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 12 Nov 2004 09:06:05 -0800, "Ciani" <microsoft.com>
wrote:

Do I have to initiate an e-mail from CRM to have it tracked against a
contact, or can I simply send it from Outlook and have it attached to the
Contact?

Disabled MSDN Organization

Posted: 12 Nov 2004 09:00 AM PST

Changing the field back should have fixed this. Which field did you update?
Was it the IsDisabled column?

When you disable a BU that's about all that it updates is that column, so if
that's all that changed, this should have fixed it. Do you have a lot of daa in
the database? If not, then you might want to consider starting from scratch.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 12 Nov 2004 12:34:14 -0800, Francois lafortune
<microsoft.com> wrote:

Hi,

Thank you for the reply, I did this in SQL but the system still will not let
me in. Gives me a "User access is denied" error in IE and a "Snap in failed
to initialize" in Deployment Manager. I tried to reinstall again but I still
got the same error that it could not use the licenses and that I had to add
them manually. Unfortunately I cannot do that since I have no access. I am
trying to access with the administrator account that was set up to create the
server.

francois

"Matt Parks" wrote:
 

Remove Fields when export customization

Posted: 12 Nov 2004 07:58 AM PST

Yes it is. You can edit the file and remove fields if you choose. Just realize
that this may cause problems when you import if you have done something wrong.
If a field is being used on a form, then just removing the field from the list
of custom attributes would result in an error.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Fri, 12 Nov 2004 07:58:02 -0800, "Katyc" <microsoft.com>
wrote:

Hi,

It is possible remove the fields in xml file that create when Export te
customization?

Problem printing Custom Crystal Report

Posted: 12 Nov 2004 05:18 AM PST

Thanks for responding to my question.

My CRM server is Win2003, my DC is Win2000, and we are running Exchange 2003
on Win2003. SQL Server is running on my CRM server.

Over the weekend I discovered that when I launch the same custom report from
a toolbar button, it works perfectly...print and export are fine.

It is only when the report is launched from a button on the navbar that
menu/buttons stop working.

The behavior is the same inside or outside our firewall.

Regards,
Mike

"Dignity" wrote:
 

Delete Users

Posted: 12 Nov 2004 05:17 AM PST

It is not possible to Delete a CRM user - this is a design feature.
The process would be to:
1. Revoke the users license (so you can reuse it for someone else).
2. Reassign all records to another user (if required)
3. Disable the user.
Guy.
"Kim Lund" <net> wrote in message
news:phx.gbl... 

problem sending e-mail from web interface.

Posted: 12 Nov 2004 03:09 AM PST

Thanks Matt,
I checked the registry and find that crm connects to Exchange server with
Http (80)
I found that it fails because we forced to access Exchange server default
web site over https for OWA. we corrected it and it works now. thanks
alot.

Timucin Devirmis
com

"Matt Parks" <com> wrote in message
news:com... 

Problem with Crystal Reports

Posted: 12 Nov 2004 12:13 AM PST


Dear John (& anyone else),

I have been trying to gather more information about the problems caused on
Crystal Reports by running CRM on WS2003 while the domain controller is on
W2K Server, but haven't really found anything... and the reports are not
showing yet.

Can you please point me to any information about this issue so that I can
sort it out? Thanks in advance.

Regards,

Manuel


"John O'Donnell" wrote:
 

CRM 1.2 Crystal Reports Error: updateViewState failed

Posted: 11 Nov 2004 11:59 PM PST

I solved it: restarting the CRM server did the trick. Perhaps the following
description might help somebody else.

Our SQL Server database for CRM is located on another server that was
restarted yesterday. It is after this, that the problem occured.

I checked the Application Event Log of the CRM server and I found events of
the following type:
Event Source: MSCRMDeletionService
Description: Error: Can't connect to metabase.

Later these events occured:
Event Source: Crystal_CrystalAPS
Description: APS is unstable, shutting down immediately. Reason: Database
access error. Reason [Microsoft][ODBC SQL Server Driver]Communication link
failure. ODBC error:[Microsoft][ODBC SQL Server Driver]Communication link
failure

Even later, these occured:
Event Source: Crystal_cacheserver
Description: Unable to connect to cluster @VENUS.OMEGAPOINT.SE to retrieve
updated APS member list. Logon can not continue.

It turns out that Crystal Reports has a service named "Crystal APS" that
"provides scheduling, security and system management services".

I restarted this service and tried again. The user interface then warned me
that we had ran out of Crystal Report licenses (which is false, we DO have
licenses).

Since restarting the service at least changed the error message, I presumed
that it had something to do with the problem. Perhaps CRM needs to be
restarted completely to be correctly initialized, I thought. So I restarted
the CRM server and yes, it took away the problem.

Anyone using CRM addons to model relationships?

Posted: 11 Nov 2004 02:58 PM PST

Would this be an add-on we can use to manage our agent/channel program?



Ryan

"Jon Colesby" <Jon microsoft.com> wrote in message
news:com... 

Problem with Go Offline

Posted: 11 Nov 2004 12:38 PM PST

Hi Chris,

If you get that error from OSQL -E (the -E tells it to use the current users
windows authentication) then the problem is communication to the SQL Server
(also remember that the instance is important if not on the default for the
server, so OSQL -E -S Server_name\Instance_name).

Run c:\WINDOWS\system32\cliconfg.exe to check that the default connection is
TCP/IP (which is should be set to by the MSDE installation). If you try to
reset the default to Named Pipes, does it now work? If so, you probably
have a DNS issue.



Stephen


"Chris" <nospamchurleynospamatsecurespeeddotccnospam> wrote in message
news:phx.gbl... 

How to import MS Access data into MS CRM

Posted: 11 Nov 2004 12:14 PM PST

There is no programatic interface to creating fields within CRM other than
Deployment Manager. There's more to it than just creating the DB fields, there
is also a lot of metabase data and objects that are updated at the same time.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Sat, 13 Nov 2004 00:21:02 -0800, "Leo Rietbergen"
<microsoft.com> wrote:

Thanks Guy

I did read the Documentation and I am aware of the staps to be taken -
that's why I'm wondering if there is a way to generate new fields within MS
CRM automatically based on the input from MS Acces - as they are both
Microsoft Products and both handle the same database feelds structure (sort
feeld, lenght off feeld name off the feeld)
So if this is possible (whit a add-on) it would make it a lot easyer

regards
Leo

"Guy Riddle (Snapdragon)" wrote:
 

Data migration to CRM

Posted: 11 Nov 2004 10:08 AM PST

I would also recommend Scribe for integration with CRM. You can also use
their toolsets for the initial data load as well.

Brent Bassett
Center for Computer Resources

"Stephen Redmond" <nospam> wrote in message
news:phx.gbl... 
don't 
data. 

Restoring Server - Pulling up CRM

Posted: 11 Nov 2004 08:43 AM PST

Even so, I do not like relying on this backup approach. A safer backup approach
is to use the Database Maintenance Plans in Enterprie Manager to schedule
regular backups of the database and logs to the file system. Then, you know you
have a file that NTBACKUP can backup/restore w/o any problems. It is more
reliable and gives you more control over your backup options (not to mention
allowing you toschedule DB maintenance).

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Thu, 11 Nov 2004 18:52:31 -0600, "Edwin Garst"
<online.epconsystems.com> wrote:

Stephen,

Small Business Server 2003 comes with a wizard that schedules a full backup
every day. There is a new service in Server 2003, Volume Shadow Service
(VSS), that allows NTBACKUP to freeze a snapshot of open databases. The
backup usually works ok, except during very heavy activity. I have
successfully restored full systems without incident several times.

For more info refer to http://support.microsoft.com/?id=826936 .

Edwin P Garst
www.epconsystems.com

"Stephen Redmond" <nospam> wrote in message
news:%phx.gbl... 

Microsoft Works - Initial caps

Microsoft Works - Initial caps

Initial caps

Posted: 04 Sep 2008 01:36 PM PDT

Great, thanks for your reply.

Ken

"mmmary" <microsoft.com> wrote in message
news:com...

| Thanks, Ken -that did it!
|
|
| "Ken" wrote:
|
| > I have Works version 6.0
| >
| > Suggest you read about AutoCorrect in Help for your version.
| >
| > Ken
| >
| > Here is a snippet from my works help....
| >
| > Using AutoCorrect to correct errors as you type
| >
| > AutoCorrect gives you the flexibility to correct particular types of
errors
| > by setting correction options and to correct specific errors by using
the
| > AutoCorrect list of entries. The following are a few of the things that
| > affect how AutoCorrect makes corrections.
| >
| > Capitalization options AutoCorrect can capitalize the first word in a
| > sentence or the names of days of the week.
| >
| > "mmmary" <microsoft.com> wrote in message
| > news:com...
| >
| > | Hi, this is probably simple, but beyond me. In works Word Processor
when
| > I
| > | type a short line and press enter the first word in that line is
| > | automatically capitalized. I don't want the first word capitalized. I
| > have
| > | Works 9.0
| >
| >

Out of Memory in Works 4.0

Posted: 01 Sep 2008 09:52 AM PDT

You receive an error message when you are working in Works 8.5 or earlier
versions of Works: "Microsoft Works 8 has stopped working" or "Out of
Memory"

http://support.microsoft.com/kb/933828/


You could also download and install one of the free PDF writer programs.

I use Free CutePDF Writer. There are other free PDF writers, PrimoPDF as an
example, Google will turn up more.

I find it a great tool and have it selected as my default printer.

It is amazing how much paper I have saved using CutePDF Writer.

I do not know about you, but I used to print something only to discover the
printed document is not exactly as I thought it would print, readjust and
print again. Used up a lot of paper.

Now when I print something it is saved as a PDF document, which I open and
if it looks correct, I then print from there to the HP printer to put it on
paper.

Another feature of using CutePDF Writer is if document is sent over the
internet the document displays exactly as sent.


I suggest you install CutePDF Writer
http://www.cutepdf.com/Products/CutePDF/writer.asp

It installs as a Printer (This enables virtually any Windows applications
(must be able to print) to create professional quality PDF documents).

At http://www.cutepdf.com/Products/CutePDF/writer.asp you will see two items
to download, Free Converter (GPLGS8.15; 5.01 MB) and Free Download (Ver.
2.7; 1.54 MB).

Install is smoother if you install converter first.


Make CutePDF Writer as your Default Printer, this should solve out of memory
error.

Ken


"Sam Spade" <net> wrote in message
news:48be0809$0$20906$net...

| I'm using Works 8.0 and this problem started with my new HP printer
| Officejet J4550.

| "Ken" <Thanks> wrote in message
| news:%phx.gbl...

| > Out of Memory message is usually associated to printer.
| >
| > Did the problem occur after installing a new printer?
| >
| > What model is your default printer?
| >
| > Have you installed the latest driver for your printer?
| >
| > Ken
| >
| >
| > "zxcvar" <com> wrote in message
| > news:googlegroups.com...
| >
| > | Greetings! I had the same problem before I installed Worksy2K. With
| > | thanks.
| > |
| > | Ken wrote:
| >
| > | > Did you have this same problem before installing Worksy2K?
| > | >
| > | > Ken
| > | >
| > | > "zxcvar" <com> wrote in message
| > | >
| >
news:googlegroups.com...

| > | > | Greetings! When I want to use the Print Preview function , I get a
| > | > | message Out of Momory. I have installed the patch Worksy2K. My
| > | > | computer has one GB memory. CPU is 2.66 GHz with Windows XP
| > | > | installed. What I am doing wrong? With thanks.
| >
|
|

Microsoft Works 4.5 (.wks) spreadsheets -> OpenOffice

Posted: 01 Sep 2008 01:05 AM PDT



"none" <""erik"@(none)" wrote:
 

Thanks Erik for the info. I'm following more or less the same route you
have gone. I have a multi-boot system (W98SE (original), W2K (lots better
than W98SE), and Redhat Linux. I prefer Unix-type systems far and away over
Windows.

I have been playing some with OpenOffice, etc. on the W2K system.

Maybe the day I get a new computer I will have only Linux (or some Unix
variant) on it. In the meantime, the one I have had for many years keeps on
cruising along just fine.

Please do not laugh - Difference between MS Works 4.0 vs Ms Works 8or 9

Posted: 31 Aug 2008 06:24 PM PDT

You should upgrade to Works 4.5a.

As I understand the upgrade contains patches that address some version 4.0
problems.

I use Works version 6.0.

Some say version 4.5a is the best version, each version after that is a
downgrade of a great product.

Works 4.0 & 4.5 upgrade can be found here....
http://www.microsoft.com/products/works/downloads.mspx#EnglishY2K

Ken

"zxcvar" <com> wrote in message
news:googlegroups.com...
| Greetings! I live in the dinosour age. I have MS Works 4.0 and Office
| 97. I always liked Works 4.0. I have seen advertisement Works 9.0
| costing about Forty dollars. Is there much difference between 4.0 vs
| 9.0? I only work with Word processor part and spreadsheet part. I am
| not a heavy user. I use it for personal use. With thanks.

Strange file

Posted: 30 Aug 2008 11:33 PM PDT

If you want to e-mail it to me, I'll take a look and see if I can make
heads or tails out of it.



--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"st" <localdomain> wrote in message
news:eKxEDb$phx.gbl... 

Error message 802400D

Posted: 30 Aug 2008 10:00 AM PDT


Perhaps one of these from google search.

http://www.google.com/search?q=KB955428&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1


"justice" <microsoft.com> wrote in message
news:com...
| From Justice.
| Thanks for your comments but it seems like you I am still at a loss as to
| how to resolve this problem. Hopefully someone will send us the solution.
|
| "Ken" wrote:
|
| > See if this previous post helps.....
| >
| > ----- Original Message -----
| > From: "KaiL" <microsoft.com>
| > Newsgroups: microsoft.public.works.win
| > Sent: Wednesday, August 20, 2008 8:55 PM
| > Subject: RE: Updates won't install
| >
| >
| > I finally chat with HP support and they pointed me to this:
| >
| >
http://www.microsoft.com/downloads/details.aspx?familyid=458985C3-9C6F-4049-81CD-0D0389C81F11&displaylang=en
| >
| > downloaded the corresponding language update and followed the
instructions
| > to finish my update!! Why it has to be this obscure!! Someone dropped
the
| > ball.
| >
| > "Paul N" wrote:
| >
| > > I have the same problem. I have found the file WORKS8.MSI as a hidden
| > file
| > > in the MSWORKS folder on my Works Suite 2006 DVD but even if I put in
this
| > > path the update fails to install. Every time I restart my PC I get a
| > prompt
| > > to try to install the update again. Very tedious. Any ideas anyone?
| > >
| > > "UltimateSephiroth" wrote:
| > >
| > > > I also have this certain problem, though I have an Acer laptop. It
tries
| > to
| > > > access the path C:\AcerSW\OfficeTrial\CD2\ and open the Works8.msi
file
| > from
| > > > there. Obviously, the path does not exist nor the whole MS Installer
| > package.
| > > > :/
| > > >
| > > > "KaiL" wrote:
| > > >
| > > > > I have the same problem with my preinstalled Works in my HP PC. I
| > tried to
| > > > > search for the works8.msi file, but can't find it anywhere on my
pc.
| > > > >
| > > > > "unstresst" wrote:
| > > > >
| > > > > > Windows security update for WORKS won't install
| > > > > > ERROR details:
| > > > > > The feature you are trying to use is on a network rescourse that
is
| > > > > > unavailable to you.
| > > > > >
| > > > > > -[It wants to access the installation package: 'WORKS8.MSI]
| > > > > >
| > > > > > Below that it says use source:
| > > > > > C:/hp/tmp/src/MSWORKS/
| > > > > >
| > > > > > I'm clueless........
| >
| >
| > "justice" <microsoft.com> wrote in message
| > news:com...
| >
| > | I have been trying to resolve this problem for about two weeks. As I
do
| > not
| > | know much about computers finding solution is hard.
| > |
| > | I have received an aut update for works 8 number KB955428. I have
vista
| > home
| > | basic. Can you help
| >
| >

Works 9.0 to Small Business 2007 NO QUALIFYING UPGRADABLE PRODUCT

Posted: 28 Aug 2008 02:00 PM PDT

SOLVED. Spent the $45 to purchase a stand alone copy of MS Works 9.0 to get
the physical disk and file. Upgrade happened in seconds. Disappointed I had
to shell out another $45 because neither MS nor HP could offer a viable
solution.



"InNeedofHELP" wrote:
 

send a documentprocessed from microsoft works

Posted: 26 Aug 2008 07:33 AM PDT

You're welcome.

"jue" <microsoft.com> wrote in message
news:com...

|
| awe thanks Ken thats gret to know
|
| kind regards Jue
| "Ken" wrote:
|
| > Hi jue,
| >
| > Works word processor by default saves it's documents with .wps
extension.
| >
| > When .wps document is sent, receiver has to have either Works program or
a
| > ..wps converter to open it.
| >
| > Most if not all word processor programs can open a document with .rtf
(Rich
| > Text Format) extension.
| >
| > I suggest you save your c.v document with a .rtf extension, then attach
it
| > to your email.
| >
| >
| > How to save a Works document in another program format
| >
| > 1 On the File menu, click Save As.
| >
| > 2 In the File name box, type a name for the document.
| >
| > 3 In the Save As type box, select the file format you want.
| >
| > 4 Click Save.
| >
| > Ken
| >
| > "jue" <microsoft.com> wrote in message
| > news:com...
| >
| > | when i send a attachment via e-mail with a document attachement
completed
| > in
| > | microsof works ,the recipient can never open it why is this ? and how
do I
| > | solve the problem, I m trying to send my c.v
| > |
| > | kind regards
| > | jue
| >
| >

Saving a resume template

Posted: 21 Aug 2008 08:43 AM PDT

Re: How do I save as a finished document just as it appears in print
preview?

What I do is save it as a .PDF document.

This requires a PDF writer.

Search the internet for a 'free pdf writer'.

I use CutePDF.

Ken

"Dio" <microsoft.com> wrote in message
news:com...

| I am using Works 8 and need help on saving a resume template. When I save
it
| opens back up in template format. How do I save as a finished document
just
| as it appears in print preview?

Help sidebar printing too small

Posted: 19 Aug 2008 04:10 PM PDT

Ken wrote: 
Thanks for looking. Probably I would have been stuck anyway because this small
print problem has been something I've noticed for months. I can get around it
with some difficulty, and perhaps that is what I will have to do.

If I do find something I'll let you know.

Windows Vista error 8024002D

Posted: 17 Aug 2008 06:28 PM PDT

The problem is now solved :

1) At this time, MS chat doesn't work
2) Phone 1-866-727-2338 for on-line support with SECURITY ISSUES.
3) All security issues are free from the support cost ding that other
support incurs.
4) The tech will take control of your machine and download the missing file.
Only techs (according to him) have access to this file. After download, the
update will install.

I have another machine WITH works 9 installed, This machine had no problem
with the update as it doesn't apply to this release.
-- end of advice-- now for what I will send to MS as to how I feel about
this issue:

1) When the error comes up, there is no prompt as to WHERE to get support
considering this is a security update.
2) Not knowing that this is a security update, one has to read carefully and
realise from the descriptions that buried in the MS support options on the
main page one can get support for this type of update.
3) Not knowing this is a security update, one browses Technet for a helpful
comment from the MODERATED forum. There is no reply from a MVP.
4) The total time spent is silly since the typical user (as myself) is
unfamiliar with the MS website and bounces between newsgroups, community and
various other places. Just where to go is problematic, and although I saved
some of the links, I still don't know where I got some of the stuff.

It would be best if when an update failed that

a) It knew this was a security update and gave one direct options for
on-line support after the normal re-install stuff which would happen due to
network issues etc.
b) There was auto-notification to MS when the log notices that a specific
update has failed more than 3 times for instance.
c) The phone support worked great and I was entirely satisfied. I was less
than satisfied though that the file was not available on the website instead
of asking for install disks or the 'browse' options.
d) I was really dissatisfied with the fact this was a KNOWN problem and
there was no posting that I could see that this was a KNOWN problem and MS's
fix was to phone support.


"tk" wrote:
 

Updates won't install

Posted: 15 Aug 2008 04:56 AM PDT

I finally chat with HP support and they pointed me to this:

http://www.microsoft.com/downloads/details.aspx?familyid=458985C3-9C6F-4049-81CD-0D0389C81F11&displaylang=en

downloaded the corresponding language update and followed the instructions
to finish my update!! Why it has to be this obscure!! Someone dropped the
ball.

"Paul N" wrote:
 

Uninstall Works Suite 2005 Setup Launcher

Posted: 15 Aug 2008 01:27 AM PDT

Go to Control Panel
Next go to 'Add / Remove Programms'
Click on related programms
Click on 'Remove/Change'
That's it.

"Simon" wrote:
 

Pre-installed with no uninstall options.

Posted: 14 Aug 2008 06:28 PM PDT


Don, Works is version 8.5, was installed from HD image on first-run. No discs
included. As for Control Panel & so on -

Mike, thanks for the suggestion. If this was an factory-level error, they
may have a standard fix. Then again, pre-installing an uninstallable Works
might cut licensing to dirt-dirt-cheap.

Thanks for responding, both of you. Appreciate it.

"rzr" wrote:
 

Download to Works

Posted: 13 Aug 2008 12:51 PM PDT

This writing process that i need to do my check point with.Yes this my
page.Kelly Szymanski

"Tess" wrote:
 

MS Works 6 and 7 will not open OE using send or email button on taskbar

Posted: 12 Aug 2008 09:35 PM PDT

OLEXP: "Send To" and E-mail Links Do Not Work with Outlook Express
http://support.microsoft.com/?kbid=306098

Also, in Windows XP: Control Panel, Add/Remove Programs, Set Program
Access and Defaults, Custom, Email and select Outlook Express.


--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"RDingman" <com> wrote in message
news:com... 

data xfer of CSV files

Posted: 10 Aug 2008 03:49 AM PDT

Hi Tom,

The comma and tab are called Delimiters or Separators.

Works version 6 recognizes either.

Strange that Works 9 doesn't recognize the comma.

Wonder if anyone else with Works 9 and Vista has the same result?

Ken

"Tom" <microsoft.com> wrote in message
news:com...

| Thank you Ken you are a GOD send! You really made me think.
|
| Xfering
| Fr. database to spreadsheet & spreadsheet to database worked.
| Fr. Word did not work.
| Fr. Notepad did not work.
| Fr. spreadsheet to Word did work.
| Large uneven spaces were made where the comma should have appeared.
|
| Reversing it:
| 1st try: Fr. Word to spreadsheet using (spaces) = did not work.
| It placed it all in one column.
| 2nd try: Fr. Word to spreadsheet using (Tab) = did Work. it Xfred it all
to
| (5) columns as intended.
|
| Result: Success!
| Works9.0 recognizes a ‘TAB’ as column break where as word8.0 and before
| recognizes the ‘Comma’ as column break.
|
| Now back to work. Thank you Ken!
|
|
|
| "Ken" wrote:
|
| > Hi Tom,
| >
| > You might want to try Drag and Drop to get info from here to
Spreadsheet.
| >
| > 02,Rooster,1975,Cogburn,x
| > 03,Tom,2008,Ken,xyz
| >
| > Both programs need to be open and screen sized so you can see them both,
| > highlight the above, left click and drag to Spreadsheet. Did it work?
| >
| > Can you copy/paste from Works Word processor to Spreadsheet?
| >
| > Can you copy/paste from Spreadsheet to Database?
| >
| > Just some thoughts for trouble shooting, if you are trying to discover
if
| > problem is with Vista copy/paste program.
| >
| > Ken
| >
| > "Tom" <microsoft.com> wrote in message
| > news:com...
| >
| > | Thank you Ken:
| > | You just confermed that the problem is in Vista and/ or Works9.0.
| > |
| > | Yes I did use cut and paste, to xfr. the data fr. notpad to the
works8.0,
| > | spreadsheet or database.
| > |
| > | * (Works6.0 thru 8.0 obviously funtion the same)
| > |
| > | The Help hint that you suggested Ken is exactly the same procedure
that I
| > | used for years, but it will not work with Vista Works 9.0.
| > |
| > | * This is another non-compatable problem with Vista.
| > | I wish my XP hadn't quiet!!!!
| > | * Vista is NOT TRUELY 'backwords' compatable w/ software or
procedures.
| > |
| > | Again Thank you Ken, Thankya kindly.
| > |
| > | "Ken" wrote:
| > |
| > | > Interesting problem.
| > | >
| > | > In XP Works8 data base, how did you transfer?
| > | >
| > | > Did you use copy/paste?
| > | >
| > | > Or
| > | >
| > | > Save as .csv file, then open file with database?
| > | >
| > | >
| > | > Try this, copy the following then paste into first field of at least
a
| > five
| > | > column database or a spreadsheet.
| > | >
| > | > 02,Rooster,1975,Cogburn,x
| > | > 03,Tom,2008,Ken,xyz
| > | >
| > | > The above will copy/paste into my spreadsheet or database, Works
version
| > | > 6.0, Windows XP.
| > | >
| > | > Ken
| > | >
| > | > "Tom" <microsoft.com> wrote in message
| > | > news:com...
| > | > | I used to write csv files in XP Works8 note pad. Strings of data
| > separated
| > | > by
| > | > | comma, ie; 02,Rooster Cogburn,1975,Rooster Cogburn,x.
| > | > |
| > | > | Then I would transfer the data CSV file to XP Works8 data base.
The
| > above
| > | > | line would be entered automatically into Five (5) separate fields
or
| > | > columns
| > | > | of XP Works8 database or spreadsheet.
| > | > |
| > | > | The same procedure does not work for me in Vista Works9.
| > | > |
| > | > | What is the procedure for Vista Works9?
| > | >
| > | >
| >
| >

Works Calendar Import ?

Posted: 09 Aug 2008 04:16 AM PDT

Jack, if you still have your Works 6 installation disk you may be able to
install it on your new computer, both version 8 and 6 can be on the same
computer as long as older version is installed last.

This way you could use your saved file with Works 6, then save it as .vcs.


Am curious, what happen when you tried to use the MSWKSCAL.WCD file that you
saved from Works 6 with Works 8?

Ken

"Jack Clayton" <co.uk> wrote in message
news:489e3a50$news.uk.tiscali.com...

| Thanks for great instructions Ken, I'm sure they would have worked
just
| fine!, but I don't have access to my old ver. 6 of works calendar, "hard
| drive faulty", and I have never exported data from it so no *.vcs file to
be
| found anywhere.
|
| Looks like I backed up the wrong files Dhoooo.
|
| Thanks again Jack
|
|
|
|
| "Ken" <Thanks> wrote in message
| news:ORXXW5h%phx.gbl...
| > Calendar imports *.vcs file formats. (vCal format)
| >
| > Use export / import.
| >
| > Open works 6, choose Export on File menu, select vCal format.
| >
| > Note: pay attention to your export, be sure to select all the info you
| > want.
| >
| > Move exported file to new computer
| >
| > Open calendar in new computer, choose Import on File menu.
| >
| > Hope this helps.
| > Ken
| >
| >
| > "Jack Clayton" <co.uk> wrote in message
| > news:489d7c87$news.uk.tiscali.com...
| >
| > | Could anyone please tell me if it's possible to import my "Calendar
| > Data"
| > | from Works 6 to my present Works 8 version, that came with my new
| > computer.
| > | I thought it was the MSWKSCAL.WCD file but no! works 8 wont have it!!
| > |
| > | TIA
| > |
| > |
| >
|
|

Change fonts in calendar

Posted: 08 Aug 2008 07:20 AM PDT

Re: Is it possible to increase the font or change the color of print


Not that I know of within calendar program.

However you might try Exporting as HTML, open exported file and print it.

Ken

"frank2004" <microsoft.com> wrote in message
news:com...
| Is it possible to increase the font or change the color of print
| so I can hang the calendar on the wall and still read it?
| --
| frank2004

choose

Posted: 06 Aug 2008 07:40 AM PDT

This message is posted twice, one with attachment Hydro.wdb, the other
without. For those who do not see the attachment, your newsgroup server is
deleting it. If you access this newsgroup with outlook express news reader
via one of Microsoft's servers, msnews.microsoft.com or news.microsoft.com
you will see the attachment.

Hi Dave,

Attached database, Hydro.wdb, Ranking Report will find who is in 1st, 2nd
and so on place. The ranking is accomplished by sorting Points from highest
to lowest, if there is a tie for a place, the report will find it then sort
the ties in alphabetical order.

When you open Hydro.wdb, choose Report under the View menu.


Note: formulas used to find ties were copied from Kevin James DupeFind.wdb
example. It also uses Choose formula.

Ken

"Dave" <rr.com> wrote in message
news:%233x4XIU%phx.gbl...

| Ken,
|
| No problem, yes I did see that.
|
| Dave
|
| "Ken" <Thanks> wrote in message
| news:uF%232oLM%phx.gbl...
| > Hi Dave, just realized, think you are talking about formulas in
Database.
| >
| > HLOOKUP and VLOOKUP, cannot be used in the Database.
| >
| > Forget about my previous Vlookup attached suggestion.
| >
| > Ken
| >
| >
| > "Dave" <net> wrote in message
| > news:ueUGtRH%phx.gbl...
| >
| > | Ken/Mike,
| > |
| > | The values in R3A now correspond to the high point system for the MACH
| > | inboard hydro group, that is 100 points = 1st place & 95 points = 2nd
| > place
| > | & etc down to 12th place. These numbers in R3A are added & math is
done
| > to
| > | them, so a change to these numbers/values would create other problems.
I
| > | only though you could possibly make the formula I have a lot smaller
by
| > | using CHOOSE instead of IF. Thanks for your ideas, looks like a winter
| > or
| > | off boat racing season project.
| > |
| > | Dave
| > |
| > | "Michael Santovec" <net> wrote in message
| > | news:%23t0i6OB%phx.gbl...
| > | > For the type of data that you have, Choose isn't the right function.
| > For
| > | > that, you need an Integer from 0 to 12 for R3A.
| > | >
| > | > I also notice that you are using = for 100, 95, 90, etc. Are those
| > the
| > | > only possible values for R3A? If the value comes up as 99, the
result
| > | > will be blank. Is that what it should be? Or should 95 to 99 be
| > "2nd"?
| > | >
| > | > One option would be to use the VLOOKUP or HLOOKUP command.
| > | >
| > | > See that attached spreadsheet for an example
| > | >
| > | > These commands do a greater than or equal to search.
| > | >
| > | >
| > | >
| > | > --
| > | >
| > | > Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
| > | >
| > | >
| > | >
| > | > "Dave" <net> wrote in message
| > | > news:#phx.gbl...
| > | >> I'm a little bit confused on how to use the CHOOSE command. I now
| > have
| > | >> the
| > | >> IF command in a field & I would like to replace my IF command with
| > | >> CHOOSE.
| > | >> In field Res31A I have:
| > | >>
| >
"=IF(R3A=100,"1st",IF(R3A=95,"2nd",IF(R3A=90,"3rd" ,IF(R3A=85,"4th",IF(R3A=80
| >
,"5th",IF(R3A=75,"6th",IF(R3A=73,"7th",IF(R3A=71," 8th",IF(R3A=69,"9th",IF(R3
| > A=67,"10th",IF(R3A=65,"11th",IF(R3A=63,"12th","")) ))))))))))"
| > | >> I could use some help. Thanks, Dave
| > | >>
| > | >>
| > | >
| > | >
| > |
| > |
| >
|
|

PDF

Posted: 05 Aug 2008 06:29 PM PDT

Thanks to both of you - I've forwarded your replies on to my friend.

"Joy" <net.NO_SPAM> wrote in message
news:%phx.gbl... 
Subscribe to: Posts (Atom)