Reply:

Saving User Settings in Outlook...
Hello everyone, Does anyone know how to save the user settings for MS outlook 2003? Thanks to all who reply, Ismael The reason I would like to be able to save the user settings is so I'll be able to restore these settings should I need to in case I had to do a clean install of WinXP and office 2003 either on the same computer of on another newly bought computer. Thanks to all who reply, Ismael "Ismael" <I_Tena@hotmail.com> wrote in message news:ueqwqfaHGHA.2948@TK2MSFTNGP10.phx.gbl... > Hello everyone, > > Does anyone know how to save the user setting...

the user authentication passed to the platform is not valid 09-20-06
Anyone receive this error message in the CRM Outlook Client? "The user authentication passed to the platform is not valid." Thanks, Scott ...

Ho to make one field required based on critera of another field?
I'm creating a form and need to make the "comments" field required if the "code" field is =>20. I appreciate suggestions! Deadline Monster is lurking! User enters the job processing endcode value (numeric) into the "code" field. If the endcode is =>20, comments are required. (P.S. I don't know VB) Thanks! Star You would put your validation code in the Form's BeforeUpdate event. If Me.EndCode >19 Then If Len(Me.Comments & "") = 0 Then MsgBox "Comments are required" Cancel = True End If End If ...

Numbers in a text field-can I add them up?
Hi everyone! Using A02 on XP. I have a table of data with survey response fields that contain a 0,1,2,3,4 or 5. However, the fields are formatted as text, not numbers. I need to add up certain blocks (Items 1-6, Items 7-23, etc.) and then do some averaging. I cannot change the field types from text. Must I append to a new table or can I do something right in my query? I've got one field in my query like this: ES: [Item1]+[Item2]+[Item3]+[Item4]+[Item5]+[Item6] My result is: 553453 or 554444, etc. I want: 25 or 22, etc. I would really appreciate any help or advice. Thanks...

data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields called [ContactFirstname] and [ContactLastName]from my table There are however some customers for whom I do not have names and therefore instead I would like Sir/Madam to appear in the field in the form I think I have seen this done somewhere using ELSE? but can't find it Any help/ideas gratefully received Perhaps something like this: Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam") -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access use...

To write living will do I need special format
I just need to change and update a living trust You should consult someone with the appropriate legal knowledge in the jurisdiction in which you are domiciled. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "belladonna" <belladonna@discussions.microsoft.com> wrote in message news:F25A64CB-355F-44E9-A005-16AA61DA15A7@microsoft.com... > I just need to change and update a living trust ...

Constructing Hyperlink from the Database Record fields
I am working on a Windows XP environment using MS Office 2007 including Access 2007. I want to open a document from Access 2007 which I can easily do with Hyperlink type field. However since all the necessary information is already in the Database Record I try to avoid creating additional field which would be a Hyperlink type on the Form unless it is absolutely necessary. Below is the code that I have to construct the FullFileName which consisted of ServerName, Division, Unit, RequirementDirectory, FolderName and the FileName itself. As you can see the Database records has al...

How do I set the number format to Base 12?
I would like to change the number format on my spreadsheet from Base 10 to Base 12, eg. 12 bottles makes up 1 case. Therefore, if I were adding up three different cells 9 bottles + 11 bottles + 6 bottles, my result should be 2 cases 2 bottles if possible 2.2 in a case column. See http://www.cpearson.com/excel/fractional.htm for details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Andrew Moore" <AndrewMoore@discussions.microsoft.com> wrote in message news:893CABE9-37D7-4E6B-8A7E-A5E679C8C824@microsoft.com... >...

Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project. it gives me following error. I checked the current users, there are no users. Apart from me. There are some non PA users,i tried to remove them from activity. inspite of me removing them from activity, im geting the same error. Help !!! Ramakrishnan Hello Ram, There is a stranded user in PA000001 table. You need to clear this User/Project combination. Ajay "Ram" wrote: > Please see the subject line, when im trying to open a particular project. > it gives me following error. > > I che...

Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data into a simple text email. I have some problems and questions... 1) how do I get the columns of data to line up evenly when I copy the data to email text ? Keep in mind I need to be in simple text format, not HTML or rich text. Every time I do this, all columns become chaos and are unreadable. 2) Is there a simple way to automate the creation of an email from an excel file ? this is less important to me. Thanks in advance WxMachine #1. I think it may have to do with what email client you use, too. I copy and ...

User Defined Required Fields
I have set several field on sub window Sales User-Defined Fields Entry of Sales Transaction Entry as "Required". If the user remembers to click User-Defined, then they become required. But if the user never clicks on User-Defined from Sales Transaction Entry, then they can still save the new document without the required fields entered. Does anyone know what I can do to fix this asside from continual user training? Your answer is VBA. You own Modifer, so you also have VBA enabled. You'll need to write VBA code to open the window (literally, push the button) then set th...

Conditional Formatting w/ a List/Icons
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list and the cell to display a green/yellow/red icon appropriately. Or, if possible, the user could just select the icon (instead of selecting text). Is this possible? Use Data Validation for the list. Type in Red, Yellow, Green as the list. This give the user the list to select from. Use Conditional Formatting for the fill part. Set three conditions, If Cell Value-"Green" (select a green fill), etc.. -- If this helps, please remember to click yes. "...

User Authentication Error
Hello All, I am running CRM 3.0. I have the system administrator role. When attempting to merge 2 account records I receive an error that states, "The user authentication passed to the platform is not valid." I cannot merge the records. If anyone can, please advise. thanks. Keith ...

Field mapping for Opportunity Products
Why I can't add some field mapping for OpportunityProduct system relation with Opportunity? I need to know the default pricelist that was assigned for an Opportunity when I am at OpportunityProduct form. ...

conditional format 04-15-10
Hi, I want the color of the text in cell B1 to change depending on the value in cell A1 How can this be done? I know I can do it with conditionale format for the cell itself but not for another one. Thanks JP Try this. Assume you want B1 text to change colour when the value in A1 is 5, select B1 and go to conditional formatting. In the condition, select 'Formula is' then in the empty space, type =A1=5 choose the font colour that you want. "Jean-Paul" wrote: > Hi, > > I want the color of the text in cell B1 to change depending on th...

Special format
How can I change the format from numerical to English?? e.g.: 420 to Four Hundred and Twenty Only It is called typing - UNBELIEVABLE or SEARCH and REPLACE but MS Office 2002 Chin support numerical to chinese: 123456789 -----> = &#19968;&#20740;&#20108;&#21315;&#19977;&#30334;&#22235;&#21313;&#20116;&= #33836;&#20845;&#21315;&#19971;&#30334;&#20843;&#21313;&#20061; =3D.=3D" Can anyone help~~ >-----Original Message----- >It is called typing - UNBELIEVABLE > >or SEARCH and REPLACE > > >. > ...

reply formatting in Outlook 2010
I set up my normal.email.dotm file to have 12 pts below each paragraph, which helps formatting issues when sending emails to people using gmail and other programs that interpret paragraph breaks differently than Outlook. That works just fine with new emails. However, when I reply to an email, even an html email, the formatting is not applied. I can fix this by choosing Format Text and then setting the spacing as per above, but this is a pain in the neck. Why don't reply emails use the same template? Is there a way to template replies so i can use the same formatting? thanks in advance, ...

How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
Hi This is driving me ABSOLUTELY NUTS! How can I keep the rows & columns of data that I am copying and pasting off a website (my own in this case!), into a spreadsheet... WITHOUT taking all the data formatting? If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep the columns (something that doesnt happen if I paste out of FireFox, fwiw). But it pastes with all the formatting & URLs etc - which I DONT WANT! OK, I can save as .CSV, close, 2 warnings, and re-open but when done REPEATEDLY this is a damned nuicance! Any suggestions? Ship Shiperton Henethe ship w...

Exchange 2K: Controlling incoming email formats....
Question... AFAIK (and correct me if I am wrong), Exchange natively only lets you control message formats for messages that are downloaded to POP\IMAP clients. For security reasons, I would like Exchange to convert all incoming\outgoing email from\to external domains, as well as INTRA-domain email , to plain text format. In other words, I do not want to see anymore html email on my server going in and out, just plain text. Is there a setting for this for Exchange to handle this natively? If not, what (if any) 3rd party solutions are out there for this? Thanks, George Here's the Re...

SQL-Dynamics V10 Users
I have some messy stuff going on with Dynamics and SQL users. I have users that are users in the databases, but not in Dynamics, and users in Dynamics that are not in SQL. Is there a script or anything to run to straighten this out? Right now it is manual process where I have to go user by user, check in dynamics and which companies they use, then go to SQL and check each database... Any suggestions? -- Doug Why can't you do this through the user interface? Did you resore a backup of Dynamics of something? As far as I know, the only way to create a GP login is to do it throu...

Lock Out Users for Maintenance
Is there a way to temporarily lock out all but the "sa" user? This would be very helpful when tasks such as Check Links is running. Mike, I guess the easiest way is to revoke users access to the company. Regards, -- Mohammad R. Daoud MVP, MCP, MCBMSP, MCTS, MCBMSS Mob: +962 - 79 -999 65 85 Great Package For Business Solutions daoudm@greatpbs.com http://www.greatpbs.com http://mohdaoud.blogspot.com/ "MikeWal" wrote: > Is there a way to temporarily lock out all but the "sa" user? This would be > very helpful when tasks such as Check Links is runni...

Formatting in the formula bar
When i type in a number into a cell in my worksheet, say: 42.99 Excel automatically rounds it to 43. Which is what i want and what i set it up to do. However, the number in the formula bar also rounds to 43. Normally i thought the formula bar stayed at 42.99 and only the spreadsheet cell rounds to 43. I am using Excel 2000. Please help asap as i need the formula bar to stay at 42.99 so i remember what the original number was!!! Hi maybe you have checked 'Tools - Options - Calculation - Precision as displayed' -- Regards Frank Kabel Frankfurt, Germany Beccy wrote: > When ...

Using 'like' on a user prompt
I want to prompt the user for a value to use to filter a form. Here is my command with the WhereCondition: docmd.OpenForm "test", acNormal, , "LastName=[Enter a Last Name]" I want to use the WhereCondition as a "LIKE" criteria. Variations on the WhereCondition itself that I've tried include various combinations of LastName LIKE %...% LastName LIKE *...* LastName LIKE [%...%] LastName LIKE [*...*] You get the idea... No luck so far. Any thoughts? On Thu, 27 May 2010 21:52:50 GMT, "RicDon" <u60397@uwe> wrote: >I wan...

Form Formatting
I have a subform (datasheet view) in a form where I want to make one column a different color. I can go into Design view and change the color but it doesn't change in the form view. This form was made ages ago with an automatic format and now I can't get away from the automatic format. Help! "DSmith" <donna@DONTSPAMresxrn.com> wrote in message news:eQARsjI6KHA.4508@TK2MSFTNGP06.phx.gbl... >I have a subform (datasheet view) in a form where I want to make one column >a different color. I can go into Design view and change the color but it >doe...

Conditional format a column
Hello, I am comparing numbers in column b and column c. In column H, I've written an if then statement stating something to the effect that the "B is greater than C" or "B is less than C" as the case may be. I'd like to format the cells in H with red coloring where B is less than C. I've been able to do it with a single cell using conditional formatting, but need help with a column of cells. Could someone give me directions? Thanks in advance, Ellen Ellen, Select your cells in column H to be formatted. Best not to select the entire column by click...