Reply:

Hyperlink on longer automatic
Word 2007 and Excell 2007, e-mail address no longer a hyperlink (automatically) as I type. Why? Also in 2007, where I go to to change the color and format of the hyperlinks (i.e. customize).- learning keeps you young Click the Office button, and then click Word Options. In the Proofing category, click AutoCorrect Options. On the AutoFormat As You Type tab, under "Replace as you type," select "Internet and network paths with hyperlinks." Click OK twice. To change the color of hyperlinks, modify the Hyperlink and FollowedHyperlink styles. -- Stefan ...

week update
is there any way to have a cell in excel update itself every week to show the first day of the week? say the week starts on a monday, the cell displays 23/02/09, retains this value thoughout the week and displays 02/03/09 the following monday thanks =TODAY()-(WEEKDAY(TODAY())-2) -- __________________________________ HTH Bob "Savio" <saviobabu@hotmail.com> wrote in message news:9b1f7be3-6927-46d0-bca3-f2248779cbee@w34g2000yqm.googlegroups.com... > is there any way to have a cell in excel update itself every week to > show the first day of the week? > say the week ...

SQL Update In Custom Add-In
So I've been trying to understand how to interface with the Database through an add-in I've been working on. What I need is to be able to query the database, and change a value or two. I need to be able to do this in code. I am working with vb6. I have figured out how to view DB entries by getting the recordset. i.e. recordSet = Session.OpenRecordset(Query,readonly) But I cant seem to figure out how to update it. I have tried changing the values i.e. recordSet.Fields("Status").Value = "In" and then "updating" the recordset. i.e. recordSet.update ...

template no longer blank
At some point I must have saved over a template so now when I open a "new" document the template appears with language. How can I delete this and return to a blank template? I've tried saving this to another file but have had no luck. See http://word.mvps.org/FAQs/AppErrors/BlankDocNotBlank.htm. -- Stefan Blom Microsoft Word MVP "baffled" <baffled@discussions.microsoft.com> wrote in message news:02A6D0A8-12EF-4730-8984-B3B56D4EE6CA@microsoft.com... > At some point I must have saved over a template so now when I open a "new" &...

How often do you download financial data?
I tend to download/update my bankstatements in Money once a day. Wondering if others do this or if its a weekly thing for them? I have mine setup for every 3 hours -- but this is only so I can be reasonably sure that all statements will have downloaded when I look at the file first thing in the morning. -- "BoDEAN" <jbo@aol.com> wrote in message news:lcgkjv8htndmkh0kf3j6hedjej17omq2m0@4ax.com... > I tend to download/update my bankstatements in Money once a day. > Wondering if others do this or if its a weekly thing for them? > > ...

Recipient update service #6
Hi all I have two exchagne 2003 servers in the sameadmin group and routing group, when i try to create a new repient update service on any one of the exchange servers i cant i get an error "invaild argument" what can i do to troubleshoot this issue? Thanks On Tue, 21 Jun 2005 12:53:01 -0700, "skip" <skip@discussions.microsoft.com> wrote: >Hi all > >I have two exchagne 2003 servers in the sameadmin group and routing group, >when i try to create a new repient update service on any one of the exchange >servers i cant i get an error "invaild...

Exploit I Frame Download in Outlook.pst
Hi, does anyone know how to rid my File outlook.pst in | C:/Documents and Settings/ /Local settings/ App | Data/Microsoft\Outlook Of the virus | Exploit.IFrameDownload. I have tried everything. When I | delete I have to recreate this folder but the virus | returns to it. I have stupid messages (about 10 a day | with attachments my antivirus states virus etc)Is this an | outlook problem because I get these messages directly | through my ISP (tiscali) also when Im on the net at | somebody elses house. AT THE MOMENT iT CURRENTLY SAYS | CANNOT START microsoft outlook as file acces is denied I |...

Automatic update
I would like to make an auto update so the user can get a newest version from my computer, but how can I copy exe files to user's directory and replace the old exe if this is in use. if I first try to delete "is in use" do I can't copy the new exe to user machine. pleas give an idea hoe to handle this, thanks in advance for your help, Eduardo Hello Eduardo, Thanks for your post. I'd like to share the following information with you: 1. When you fail to copy a file because the destination file is in use, I suggest that you can call MoveFileEx with MOVEFILE_DELAY_U...

SQL query updates inside workbook
This question has three parts, all related to an SQL query being run every time a cell in any workbook is updated . First of all, the only choice I seem to have is to turn auto-calculate off and manually calculate in any open workbook whenever this workbook is open. This is not workable as I have several calculations that 'need' to take place on their own, so I either have to close this workbook, or deal with the query running on every update, (not good for the database on the larger queries) Second, I cannot get the query to run on it's own. I've followed instructions I&#...

nero wont download
hi folks i have just upgraded my pc to a dell dimension e520 running on vista my partner has bought the same machine with no problems i am trying to download nero but the download will only go asfar as 20% then freezes i have contacted dell they say its the internet conection so i contacted virgin media (old ntl) they say the internet connection is fine any ideas And you are contacting the Great Plains Accounting group because?????? Try the vista group Mike "pat" <pat@discussions.microsoft.com> wrote in message news:8FAB3909-8DC5-4279-BB83-552B8BED476C@microsoft.com... &g...

two checking accounts data downloads to just one of the accts
I have two checking accounts with our bank and when I download transactions into Microsoft Money for either account, all the transactions go to only one of the accounts set up in Money. I was prompted for the first download to our "main" account. Then when I went to download for the other account, I wasn't prompted where to download to... and all the transactions went into the first account. Did that make sense? My bank required we switch to Money from Quicken, so I am new to this. Tried to search in users guide and online for help. Help would be much appreciated - ...

Cannot download the Upgrade because dial up internet
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I need to somehow get a hard copy of the Office 2008 update (purchased the program new, and irritating because there is an update that was not included). I use dial up (stop laughing . . .), and the download for the update would take nine hours. My connection will not stay on for that long, so I therefore need the update on a disk. How can I get this in a hard copy? On 4/8/08 3:43 PM, in article ee97dfc.-1@webcrossing.caR9absDaxw, "patrick2000@officeformac.com" <patrick2000@officeformac.com> wrote: >...

Getting Outlook 2003 to Download Header AND BODY of a Mail Like Outlook Express
A few months ago, I converted from Outlook Express to Outlook 2003, which I use against an Oracle Collaboration Suite IMAP server. Outlook Express worked flawlessly. I've still not been able to get Outlook 2003 to properly download all of my headers and bodies so that I can sync my mail and then unplug from the network and read the mail on a plane. I have configured my Send/Received Groups and changed the radio button for my IMAP "Inbox" folder to say (*) Download complete item including attachments", but if I do Send/Recieved, then unplug the network, all of the new mail ...

Purchased but no download
I recently received the new Taxcut 2005 CD in the mail and installed it. The confirmation email included an offer for a $29.95 rebate for MS Money 2006 Standard (which made it free). Using the link to the Microsfot Money Special offers page, I clicked on the "download" button and was taken to the page to sign-in to Passport. I then had to register with MSN to set up an account. After activating my purchase, the next page stated that I had successfully purchased Microsoft Money 2006 and would receive an email with rebate instructions and a download link. I received a confirmation e...

Scanner & Camera Wizard no longer works
Hi All, Whenever I'd plug my camera into my pc, the wizard would start and made downloading the pictures & any video files I had very simple. I have NO idea what has happened or what I did but all of a sudden the wizard no longer starts when I plug my camera in. I've tried the following; Open Explorer, found the camera, r/click and selected Properties, then selcted Event Tab and selected Start Microsoft Scanner and Camera wizard. Plugged my camera back in, turned it on and nothing... the program did not start. Opened Control Panel, Scanner & Camera, plug...

how to ignore DTD and NOT download it when ValidationType=none?
I'm trying to load and parse an xml file with XmlReader and have it completely IGNORE the DTD in the xml file. If I set "ValidationType = ValidationType.None" it STILL downloads the DTD even though it doesn't validate against it. I get an XmlException when I set "ProhibitDtd = true" because then no DTD is allowed in the doc. If I manually remove the DTD reference from the file then it works fine and does not download the DTD (obviously). How do I leave the DTD in the file but have XmlReader IGNORE it completely, including not downloading it? It doesn't seem...

Money 2006 download
Well, I'm sure everyone has ran into this after they downloaded Money 2006. The Money 2006 rebate page tells you to "Click on View Subscriptions" in your MSN Billing statement to print out your "Reciept" to attach to the rebate form. Problem is, unless you are using some kind of MSN service you have no "View Subscriptions" in your billing.microsoft.com billing account.. just some credit card info and a list of what downloads you've purchased. So, I called Money support.. they sputtered around and finally they told me to attach a printout of my &qu...

Online account updates #2
I have several accounts with one bank that provides online services. Currently, I am able to receive updates on 3 out of the 4 accounts. Money does not recognize the 4th account at the institution (I am afraid I caused this error when setting up the account in Money). Is there a way to modify the settings on only this account so updates can again take place? I tried turning off, and then on, online services to the institution and all 4 accounts were recognized, but when transactions were downloaded the registers for each account had duplicates and were off balance. Any help would...

URLs in Outlook 2007 no longer active
Using Windows Vista Business Edition with MS Office 2007 / Outlook 2007. A few weeks ago, Outlook was working fine ... notification messages from PHPBB included a clickable URL. Clicking the URL (blue & underscored) would open a PHPBB webpage containing the PHPBB message itself. Then after removing expired Anti-Virus program and installing AVG Free Anti-Virus ... the notification messages from PHPBB are no longer active, but still present and it still works on other PCs with the same Software installed. If the URL string is copied & pasted into an IE7 address bar the correct ...

Serializing concurrent updates
Hi all! I would have a question regarding serialized updates. We have a table as follows: CREATE TABLE MyTable ( ID INT NOT NULL PRIMARY KEY CLUSTERED, Value INT NOT NULL ) INSERT INTO MyTable VALUES ( 1, 1 ) There are two types of transactions for the MyTable table. Writer transactions and reader transactions. The writer transactions are very short and they only update values in the table as follows: DECLARE @tmptable TABLE ( Value INT NOT NULL ); UPDATE MyTable SET Value = Value + 1 OUTPUT INSERTED.Value INTO @tmptable WHERE ID = 1; I.e. each writer incre...

Scanner Download?
Is there a Download that will let me use my scanner (and perhaps ad an icon) to scan documents directly into Outlook? On 30 Apr 2004 09:36, "DaveB" <anonymous@discussions.microsoft.com> wrote: >Is there a Download that will let me use my scanner (and perhaps ad an >icon) to scan documents directly into Outlook? Directly into Outlook as what? E-mails? Journal items? Attachments? What Outlook folder do you hope to store them in? -- -Ben- Ben M. Schorr, MVP-OneNote OneNote FAQ: http://home.hawaii.rr.com/schorr/Computers/OneNoteFAQ.htm SchorrTech Blog: http://www.thesp...

problems with recent windows update
I work for an internet technical support company, the last 3 days I have seen an abundance of people calling because now they are only allowed to get to certain sites. most sites that require a login give page cannot be displayed, yet other are coming up, after so many complaints with the same issue and involving different sites I think it may be due to an update, any info would be greatly appreciated. i think you'd better go back to your job working at McDonald's. itbeme wrote: > I work for an internet technical support company, the last 3 days I have > seen ...

Updating Canadian securities with pocket pc for money
Hello. I am using Money 2004. The desktop version updates the prices of my securities with no problem. I downloaded money 2004 for Pocket pc. When I update the price of my securities on the pocket pc, weird things happen... 1. The list of investments shows an investments saying invalid symbol with a bunch of square characters underneth. When I scroll down the list and then back up, the squares disappear and I get a market value. But this market value gets repeated for many of the investments. 2. When an investment does not say invalid symbol, it shows the correct quantity but the shar...

Updating using groupby
I have two tables and I want to update one with values from the other. I have a membership table that holds the MemberID and Email and a Registration table that holds a RegistrationID, Email, and a blank field for the Memberid. What I would like to do is to match the email addresses in both tables. When there is a match I would like to update MemberID field in the Registration table with the MemberID from the Membership table. However, if the email address in the Registration table is used more than once, I do not want to use it. So for the example data I have below my results in...

download message twice
can anybody tell me why I get the same message twice at the same time? Turn off AV scanning in Outlook. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After furious head scratching, Ric asked: | can anybody tell me why I get the same message twice at the same time? ...