News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Murgatroyd

    Forum Replies Created

    Viewing 15 posts - 1 through 15 (of 483 total)
    • Author
      Posts
    • in reply to: Account checking sequence #1593338

      Murgatroyd
      AskWoody Lounger

      PS: From some further experimentation, the account checking sequence does appear to follow the sequence in which accounts are listed in Account Settings; however, it is also affected by the server response time, as it appears to check one account at a time on each server.

      In my setup, I have four accounts (#1-#4) on one server, and one account (#5) on another server. The accounts were added, and are listed, in the sequence #1, #2, #3, #4, #5. However, when I check the mail, Outlook always prompts for the account passwords in the sequence #1, #5, #2, #3, #4. It looks like Outlook processes the accounts in the added/listed sequence, but because both servers have a similar fast response time, Outlook prompts for the first account on the first server (#1), then while waiting for that, it prompts for the first account on the second server (#5), then after those two passwords are entered, it proceeds similarly through the rest of the accounts (#2, #3, #4), which are all on the first server.

    • in reply to: Count ranges containing non-blank cells #1593336

      Murgatroyd
      AskWoody Lounger

      Thanks, that’s good.

    • in reply to: Account checking sequence #1593082

      Murgatroyd
      AskWoody Lounger

      Thanks for your reply. The thread that you indicate includes the statement: “Once you change the order of your accounts in Account Settings, then Send/Receive will process email in order corresponding to the order of accounts in Account Settings.”

      However, it does not work like that on my system. When I change the sequence of email accounts in Account settings, the accounts are *listed* in that sequence in Send/Receive, but when I check the mail, the accounts are still *checked* in the order that they were created, regardless of the order in which they are listed in Account settings and Send/Receive.

    • in reply to: Count ranges containing non-blank cells #1593080

      Murgatroyd
      AskWoody Lounger

      Thanks for your reply … sorry, the attachment is there now. I came up with a way to do what I want, but there may be a better way.

      =IF(COUNTA(Range1)=0,0,1)+IF(COUNTA(Range2)=0,0,1)+IF(COUNTA(Range3)=0,0,1)

    • in reply to: Account checking sequence #1593029

      Murgatroyd
      AskWoody Lounger

      Thanks for your reply. I looked into send/receive groups, but it appears that you can include/exclude accounts but cannot change the order in which they are checked. After some experimentation, it appears that accounts are always checked in the same sequence that they were created regardless of their naming or listing, so the only way to change the checking sequence is to remove all accounts and re-add them in the required checking sequence.

    • in reply to: Report margin issue #1590896

      Murgatroyd
      AskWoody Lounger

      The issue occurs intermittently, both when exporting and printing, and users do not change any printer settings. The default printer for all users is Adobe PDF, as there is no physical printer on the remote server.

    • in reply to: Report bit field format #1590875

      Murgatroyd
      AskWoody Lounger

      Thanks for your replies.

      I found that putting this

      ;”Active”;”Inactive”

      in the Format property of the field on the report does what I want.
      https://support.office.com/en-us/article/Format-Property-Yes-No-Data-Type-a6d416df-de31-4bed-a280-1c0e9841b39b

    • in reply to: Report margin issue #1590855

      Murgatroyd
      AskWoody Lounger

      The issue occurs “sometimes [i.e., intermittently] when exporting or printing to a PDF file [i.e., both]”.

    • in reply to: Repairing unplugged USB drive #1584227

      Murgatroyd
      AskWoody Lounger

      Thanks for your replies. I ended up using the TestDisk program to fix the problem, as described here.
      https://www.wintips.org/fix-you-need-to-format-the-disk-before-you-can-use-it-problem-after-improper-usb-unplug/

      The TestDisk program found and restored the inaccessible partition, and I was able to access everything on the drive again; however, there appeared to be a user permission issue. (This probably arose when I ran chkdsk at one point, which said that it reset something on all the drive contents.)

      Disk Management lists the drive OK (Volume = “Seagate Expansion Drive E:”, Layout = Simple, Type = Basic, File System = NTFS, Status = “Healthy, Active, Primary Partition”), with the correct size, and a disk check reported no errors on the drive, and I could access everything on the drive OK in Windows Explorer with Windows in safe mode, or in Command Prompt as an administrator with Windows in normal mode; the only issue was that I could not access the drive as an ordinary user with Windows in normal mode, so this appeared to be only a security settings issue. (This probably arose when I ran chkdsk, which said that it reset something on all the drive contents.)

      I tried the following commands in Command Prompt as an administrator.

      takeown /f e:* /a /r /d y
      (My understanding is that this gives ownership of everything to the administrators group, and it ran successfully.)

      icacls e:* /grant users:F /t /q
      (My understanding is that gives full access to the users group, and it ran successfully.)

      Now I can access everything OK as before.

      However, is there a way to reset the user permissions to a clean default setting, to avoid any further issues?

    • in reply to: Repairing unplugged USB drive #1584006

      Murgatroyd
      AskWoody Lounger

      Thanks. I was hoping someone could recommend a reliable/reputable (preferably free) disk recovery program.

    • in reply to: Repairing unplugged USB drive #1584001

      Murgatroyd
      AskWoody Lounger

      Thanks for your reply. Windows Disk Management reports as follows. (It is listed as E:, Disk 2, 1863 GB.)
      – Layout: Simple
      – Type : Basic
      – File System: RAW
      – Status: Healthy (Primary Partition)

    • in reply to: Repairing unplugged USB drive #1583974

      Murgatroyd
      AskWoody Lounger

      Thanks for your reply. The drive is a Seagate model SRD00F2, PN:1D7AP2-500 2 TB.

    • in reply to: Account checking sequence #1593264

      Murgatroyd
      AskWoody Lounger

      Thanks for your reply. Some further experimentation supports your suggestion. I will investigate further.

      PS: Hadn’t seen EBKAC, we use PICNIC: Problem In Chair, Not In Computer. 🙂

    • in reply to: Specifying the scope of a macro #1587089

      Murgatroyd
      AskWoody Lounger

      Hi Murgatroyd

      If you want to restrict a shortcut-key-assigned-macro to apply only to a particular book, you will need to add a line of code to the beginning of that particular macro.
      Something like..
      If ActiveWorkbook.Name ThisWorkbook.Name Then Exit Sub

      zeddy

      That works fine, thanks.

    • in reply to: Repairing unplugged USB drive #1584295

      Murgatroyd
      AskWoody Lounger

      For Users(Computer name)Users on my external HDD I only have permissions for Read & execute, List Folder contents and Read, so yours sounds about right.

      OK thanks.

    Viewing 15 posts - 1 through 15 (of 483 total)