Jump to content

Anne Troy

Member
  • Posts

    69
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    United States

Everything posted by Anne Troy

  1. Sorry for the late response. Use the format painter: http://www.officearticles.com/misc/format_...soft_office.htm
  2. Sorry for the late response. Why not keep it in Excel? http://www.officearticles.com/tutorials/or...osoft_excel.htm
  3. Sorry for such a late response. See my article: http://www.officearticles.com/misc/about_s...soft_office.htm
  4. Hitting Ctrl+Enter is a bit easier, and will do the same thing.
  5. Did you back this file up to a CD and then copy it? If yes, right-click the file name (in Windows Explorer) and uncheck Read Only and then try again with Outlook.
  6. Hi. Could we get the exact error message?
  7. Not positive, but try this: http://support.microsoft.com/kb/287623/en-us
  8. You can Insert-->Picture-->From File and choose to link it. Then hit Alt+F9 to turn on viewing of field codes. Alter the file names. When you want to see the pictures (AND they exist), hit Alt+F9 again to turn OFF viewing of the codes so you can now see the pictures. That's about the best I can offer off-hand.
  9. LOL. Glad I'm not using those long formulas. You *can* sum intermediate sheets. Try this: http://www.officearticles.com/excel/sum_th..._worksheets.htm
  10. Version? Seems similar to another question here, to which I posted this Technet Search link.
  11. There appears to be several known issues. Try this Technet Search to see if any of them will help you.
  12. You can probably work with something like this macro: http://vbaexpress.com/kb/getarticle.php?kb_id=38 If you don't ALSO want the value of cell A1 in the file name, just change the code to: Option Explicit Sub SvMe() Dim newFile As String ' Don't use "/" in date, invalid syntax 'Change the date format to whatever you'd like, but make sure it's in quotes newFile = Format$(Date, "mm-dd-yyyy") 'Or perhaps newFile = "myBook-"&Format$(Date, "mm-dd-yyyy") ' Change directory to suit your PC, including USER NAME ChDir _ "C:\Documents and Settings\ USER NAME \Desktop" ActiveWorkbook.SaveAs Filename:=newFile End Sub
  13. Army: You need VBA to do that. See Chip Pearson's site: http://www.cpearson.com/excel/colors.htm ~Navy
  14. Sounds to me like you have the field type set as a number/integer, and it should be text.
  15. Have you run detect and repair from the help menu? When's the last time you checked the size of your PST file? Perhaps it's getting large... over 2GB?
  16. Don't know about network deploy, but if you just want to remove the print button, hold the Alt key and drag it off. However, Ctrl+p is a printing shortcut, you can print from Windows using right-click, and the print preview dialog usually has a print button, etc...
  17. I don't know how to write it in code, but here it is as a formula: =IF(DAY(NOW())=2,TRUE,FALSE) This might help you use it: http://office.microsoft.com/en-au/assistan...1102181033.aspx
  18. I'm lost. Well, try Start--->Run and type: access.exe /regserver
  19. Looks like your exact issue? http://support.microsoft.com/default.aspx?...kb;en-us;870707
  20. Okay. I gotcha. And a few quick comments... IF you are using a DOT file, you can create autotext entries for your 50+ text lines. Then run macros that insert the autotext. That way, if your text changes, you can just recreate the autotext instead of modifying the VBA. http://www.officearticles.com/word/using_a...rosoft_word.htm Maybe something like this will help? http://visualbasic.about.com/library/weekly/aa021503e.htm (sorry about the popup)
  21. Stan: Check with your ISP. Not all ISPs will allow you to use a DIFFERENT SMTP server from their own, especially without logging into theirs first. This is likely NOT an Outlook "problem" issue, but your account setup. So, if you have, for instance, comcast.net, try using THAT as the outgoing on the account and see if it works. If it does, then try setting up your other SMTP, but use the More Settings button, Outgoing Server tab to log onto your comcast... Clear as mud?
  22. Sorry, no. I'm not a Windows person and was only trying to clarify. But now you know it's a Windows issue. Perhaps you can ask the forum leaders here to move your question. Good luck!
  23. 1. I'm not sure why you're using a macro in the first place? 2. When I make form field entries, I first have a blank one that is as wide as I want the drop-down to appear. Just use spaces to create the first one. (I actually create it last, then move it up to the first position.) I see. Maybe you want a conditional drop-down? Try this knowledgebase entry by fumei: http://vbaexpress.com/kb/getarticle.php?kb_id=5
×
×
  • Create New...