Reply:

Slow Login #2
I am having issues with a machine which does not host the Store Operations DB being slow to sign in. When the cashier signs in it thinks for about 10 seconds then lets you in to POS. They are on a 100mb network but suspect it is a comms issue backto thw SO. ...

Updating Accounts #2
I just upgraded to Money Plus Deluxe (Have XP) When I go into Money it states its "updating account" and my CPU usage is at 99% when I run Money. There are NO accounts that are being automatically updated as I do them all manually. The "updating accounts" icon stays up until I finally have to turn off computer because I cannot work on any other part of money as it says it is doing an online function. PLEASE HELP.. It also goes online to seek its own updates. Do you have SSL2 enabled in Internet Options? Do you have firewall software enabled beyond the XP firewall...

CRM 1.2 Leads & Searching
Hope someone can help - how do you search by Company Name field in the Leads view, as well as Name field (by default). On older leads people's names often get forgotten about, but the company name does not! Is there a way of selecting which fields are searchable? Thanks Afraid that you don't have this control in v1.2. v3.0 does give you the ability to pick which fields to search though. -- Matt Parks MVP - Microsoft CRM "Adam Carter" <adam.carter@vantageit.co.uk> wrote in message news:wIudnXImHfGWr57ZRVnyiA@pipex.net... Hope someone can help - how do you se...

GP Upgrade #2
We just upgraded to GP 10.0. We want the salesmen to be able to enter their own orders, but we don't want them to be able to change the unit price or the extended price on the order. Is there a setting I can use for this? Thanks Angie I might be wrong but I think thats a security issue. -- Craig "Angie" wrote: > We just upgraded to GP 10.0. We want the salesmen to be able to enter their > own orders, but we don't want them to be able to change the unit price or > the extended price on the order. Is there a setting I can use for this? > > Than...

Excel 2007
Hi all, We have a spreadsheet that was set up to link to a database via a system DSN. To simplify deployment of this, I'd like to change this to connect via the connection string below: DRIVER=SQL Server;SERVER=xxx;UID=xxx;PWD=xxx;DATABASE=xxx; I've done this for another spreadsheet, and it was easy (Data tab- >Connections->Properties), but in this next spreadsheet the Connection Properties for one connection are greyed out/disabled, so I can't change the string. Does anyone have any ideas how to enable these values again so I can change the connection string? thanks! ...

The connection was dropped by the remote host #2
All day I've been getting email stuck in the outbound queue with the below message recorded. Message delivery to the host '66.218.86.197' failed while delivering to the remote domain 'yahoo.com' for the following reason: The connection was dropped by the remote host. I've been able to send email to some domains but not all..... I've restarted the exchange 2003 server, flushed DNS Registered DNS Restarted DNS on DCs Reset our firewall... NSLOOKUP is good Pings by name resolve I can telnet to my mail server I can telnet to other mail servers. Can someo...

[ANN] Xinclude.NET 1.2 released
Hello! I'm glad to announce XInclude.NET 1.2 release. What is XInclude.NET ==================== XInclude.NET is free open-source implementation of XInclude 1.0 Working Draft of 10 November 2003 [1] and XPointer Framework Recommendation [2] written in C# for .NET platform. XInclude.NET supports XPointer element(), xmlns(), xpath1() and xpointer() (XPath subset only) schemes. XInclude.NET has been tested using The XInclude Test Suite under Microsoft .NET 1.0 and 1.1 on Windows 2000. Changes since 1.0 release: - Updated to new XInclude syntax and namespace according to new XInclude 1...

Faulting application dynamics.exe
I am not sure what is going on but there are times when this error occurs for users in GP 7.5... "Faulting application dynamics.exe, version 7.5.0.3, faulting module mfc42.dll, version 6.0.8665.0, fault address 0x000048ab." After getting this error, GP shuts down. I have been trying to pinpoint when it does not happen in a consistent spot. It also does not happen to all users. I also can not get this error to occur on the development machine. I have researched the heck out of this on the web but have found no resolution. The only thing that I can see different is the deve...

Saving data #2
Hi all, I need to save data (results) from a base spread sheet program that i use on a weekly basis. i am in the middle of building this program, and have just discovered macros, but this, along with links is about my current knowledge of excel how can i automate to accumulate data from the base spread sheet (program) when i clear all data from the program to produce fresh results the following week, and to keep past data up to date and available for further use. Any help would be appreciated. legepe With a combination of formulas and dynamic named ranges, it is possible to just add the ...

Outlook 2003 Memory Hog
Should Outlook 2003 be using over 56,000k of memory?? ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ...

Unwanted Formula Display #2
I'm using Excel XP, preparing cost estimates. In my summary page, cell references display the name and total of each category, from the associated category page in the document. When I insert a new line for a new category, and "point and shoot" to assign the formula, e.g., ="A425", it displays the formula rather than the cell reference value, e.g., "Carpentry". I've tried formatting the cell as Text and General, copying another cell reference that is displaying correctly, and then editing the formula, and painting the new cell from one that is wor...

random number #2
how can i create a normally distributed random number and a random number that has a beta distribution i need these both to be integer outputs thanks for the help Use NORMDIST and BETADIST -- Gary's Student "agw8@kent.ac.uk" wrote: > how can i create a normally distributed random number > and a random number that has a beta distribution > i need these both to be integer outputs > thanks for the help I think you meand NORMINV and BETAINV. See my reply under the OP's repeat of this question. It is generally better to reply to your original thread with fol...

The merge process detected a mismatch ....
I receive the following message when going offline: "The merge process detected a mismatch ..." I can't read the rest because it goes by too fast. I am finding that contacts and appointments created in MS CRM are not syncing to outlook. Can someone please help? Thanks. There might be more information in the Event Viewer. Please take a look there and post the error here. With kind regards, Ronald Lemmen "Goodloe White" wrote: > I receive the following message when going offline: "The merge process > detected a mismatch ..." I can't ...

Cannot Start Outlook #2
I have just run the auomatic windows update on my local PC and now Outlook 2000 will not start. It just hangs at the splash screen. Outlook is configured to connect to Exchange. Other PCs on the same Lan which have not been updated can still connect. The updates installed were 824141, 823182, 826232, 825119, 828035, 828749. I have unistalled all of these updates and Outlook still will not start. Any ideas? Does it start if you run this command from the command line, go to Start > Run > type "outlook /safe" without the quotes but with the space before the Forward slash &...

2 Email domains w/2 Act. Dir. Domains - Same Forest
Hello, Scenario: We've had domain1.com (AD) setup and running in exchange 2003 for a year now w/mixed win2k and win2k3 servers - email domain name is the same, domain1. OWA works great and haven't had any problems. Our company is branching out into a new business segment and I've created a new active dir. domain within the same forest, domain2.local. It is NOT a child domain, but does sit under the same forest. I need to configure my front end/back end exchange 2003 boxes to do the following: -receive email for both email domains (domain1.com and domain2.com) -let users...

Search Multiple Worksheets #2
Is there a way to search trough multiple worksheets for a specific value? Other posts have mentioned to use VBA, but I have never used that before. If anyone can give me some advice on using that or a type of formula to perform that can search multiple worksheets. Thank You There may be other ways but, while holding down the ctrl key select each of the worksheet tabs you want to search in then select Edit|Find from the menu. Type in the value you want and it will go to the first instance of that value. Now if you are wanting to preserve a specifice value for reference or ???, then...

URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t work in conjunction with the entire module. It dies right afte copying and PasteSpecial Values It does not kill the temp file or loa the newly created sheet into an e-mail. Any Ideas -- Doctor ----------------------------------------------------------------------- DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=514 View this thread: http://www.excelforum.com/showthread.php?threadid=26863 You may want to post your current procedure. DoctorV wrote: > > Dave, Thanks for respon...

Creating a Combination Bar Chart with 2 Lines
I am trying to create a bar chart with 2 line series. The Y-axis for the vertical bars would be on the left and the Y-axis for the 2 line series would be on the right (3 series were defined). The horizontal axis for all series are calendar months (Jan, Feb, etc.) Every time I setup the chart my chart only displays a single line, ignoring the other line series. The vertical bars come out fine. Any thoughts on what I am doing wrong? Thanks Bill Falzone Don't use the built in types. Make the chart using all columns. Select a series that you want to change (click on it right in th...

"TOOLS" menu missing from menu bar #2
"TOOLS" menu is completely missing from the menu bar in Publisher 2003. How do I put it back? Might try a "detect and repair" Meanwhile, right-click a toolbar, click customize, scroll down to built-in menus, drag the tools menu to your toolbar. -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Anil Gupta" <AnilGupta@discussions.microsoft.com> wrote in message news:5C7ADC1E-A6E9-4F01-8C06-01B92AC7B97B@microsoft.com... > "TOOLS" menu is completely missing from the menu bar in Publisher 20...

Vista, MS Access 2003 and MS ADO Ext 6.0 vs 2.x
I am running into an issue with MS Access 2003 installed on Vista. Apparantly in the MS ADO Ext 6.0 version either (format, round, or sum) is not in that DLL. However, when I link to v2.8 of the DLL, I don't have an issue. I am getting the following error message when running my query. "Function is not available in expressions in query expressions." Does anyone have other workarounds? I am distributing this application in an MDE format, so I was wondering if the end users may experience issues, if I link to my version of msadox.dll instead of the installed version. I tried s...

Inventory #2
How can I import an excel spreadsheet as inventory into Money...? -- Marie You're talking about the home inventory? It's not possible without using a macro (i.e., there's no import function). IMO, it's not desirable either, as the information is not easily usable in Money. I keep my home inventory in an asset account, which has the huge benefit of being a "normal" Money account. If you need to import the inventory, there are Excel to QIF converters available from third parties. I use the following: http://www.bigredconsulting.com/ -- "Marie" <...

Draft Folder problem #2
I'm running outlook 2000. My draft folder is called draft1. Can't seem to rename it! There isn't a folder named draft so what's happening? Isn't a big problem, but I should be able to solve it and I can't. Help. Thanks in advance Peter You could try to start Outlook from the run line with the /resetfoldernames switch. Start-->Run outlook.exe /resetfoldernames Reference: http://office.microsoft.com/en-gb/assistance/HP010031101033.aspx "Peter Brown" <peter.jennifer@gmail.com> wrote in message news:TErag.449$TF.2645@news-1.opaltelecom.net... &...

Printing on 2 sides of a page?
How can I print a 2 page spreadsheet on the front and back of the same sheet of paper? Using Excel 2008. Thanks! It depends on whether your printer supports duplex printing. Check your printer's features to find out. If it does, the setting will be available in the Print dialog. You can also do a "manual duplex" job by printing page 1 (or 'Odd pages'), flipping the paper yourself, then print page 2 (or 'Even pages')... If it's only 2 pages that might be the simplest approach. -- HTH |:>) Bob Jones [MVP] Office:Mac "Rick"...

Y Axis #2
I have two questions regarding the 'y' axis - in a normal line graph Firstly, how do i get the 'y' axis to appear in the middle of the graph IE to cross the 'x' axis at (0,0) instead of currently (in my graph) (-10,0) Secondly how do i plot the line "X =2" which should just be a vertical line on the graph? I'm using Microsoft Excel 2007 any help would be appreciated. Thanks Hi, Not able to test in xl2007 but from memory it should be the same as xl2003. For a line chart, select the x axis and open the format dialog. On the scale tab set Value (Y) axi...

Downloading process for Office Standard 2007 online
I experienced a severe computer failure and when it was repaired, I lost my installed programs. I need to get back on Outlook and Word, but only have the program key for the Office Standard 2007 program. How do I get to the screen where I can input my program key to get the process started? You need the Office installation cd in order to reinstall "Jack" <Clear@view.com> wrote in message news:8777DDC2-9BED-4B0D-8EC0-F1A35D5DE37C@microsoft.com... >I experienced a severe computer failure and when it was repaired, I lost my > installed programs. I need to get...