Search:

Type: Posts; User: Murgatroyd; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    167

    Thanks for your replies. However, unless I have...

    Thanks for your replies. However, unless I have misunderstood something, they do not appear to address my issue. The issue is not about multi-level outlining, it is only about losing the indent when...
  2. Replies
    7
    Views
    167

    Thanks for your reply. A test document is...

    Thanks for your reply. A test document is attached.
  3. Replies
    7
    Views
    167

    Numbered style indenting issue

    In Word 2010, I have a template with a set of styles including a group like this.

    - List Number = Numbered, Indent 0, Hanging 0.5 cm
    - List Number 2 = Numbered, Indent 0.5 cm, Hanging 0.5 cm
    -...
  4. Replies
    2
    Views
    110

    Thanks for your reply. I thought that there was...

    Thanks for your reply. I thought that there was just one blank page but then realized that Access had pushed the report onto other pages because of its size. By selecting a large page size, I managed...
  5. Replies
    2
    Views
    110

    Relationships report is blank

    We have an Access 2010 database containing 35 tables. A while ago I created a relationships setup. Today I printed a relationships report from it, which looked fine, then I made some changes to the...
  6. Replies
    2
    Views
    279

    I don't know whether clicking Undo (rather than...

    I don't know whether clicking Undo (rather than Ctrl + Z) can also trigger this issue, because it only happens occasionally, and I normally use Ctrl + Z for the undo function, and when it happens,...
  7. Replies
    2
    Views
    279

    Undo amnesia

    I use Word 2010 under Windows 7, and normally the undo function works fine; i.e., Ctrl + Z steps back through the last several actions, undoing them one by one, and Ctrl + Y steps forward again,...
  8. Replies
    4
    Views
    847

    Thanks for your further reply. I see that...

    Thanks for your further reply.

    I see that Outlook can filter read/unread messages via Search Folders, without having Windows Search installed.

    However, if I have numerous folders and want to...
  9. Replies
    4
    Views
    847

    Thanks for your reply. 1. I see that a "Read"...

    Thanks for your reply.

    1. I see that a "Read" column can be added from the Field Chooser to a folder view, but Outlook cannot sort by this column.

    2. In Outlook on my PC, I can click on Filter...
  10. Replies
    4
    Views
    847

    Sorting messages by read/unread status

    I am using Outlook 2010 on a server running Windows Server 2008 R2. I want to sort the inbox and other folders first by read/unread status, then by received date.

    1. I can sort by received date by...
  11. Replies
    7
    Views
    922

    OK thanks.

    OK thanks.
  12. Replies
    7
    Views
    922

    Thanks for your replies. Yes, the Access front...

    Thanks for your replies.

    Yes, the Access front end is linked to the SQL database back end by ODBC.

    I tried adding an extra criterion in the WHERE statement to specify a range of records by...
  13. Replies
    7
    Views
    922

    Delete query with joined tables

    In Access 2020, I have a delete query like this. (Access is a front end to a SQL back end database.)

    38679

    The SQL code is like this.

    DELETE dbo_Client.*, dbo_Client.NewClient,...
  14. Replies
    13
    Views
    886

    Thanks for your reply. I tried again and it...

    Thanks for your reply. I tried again and it worked this time ... must have had a typo before.
  15. Replies
    13
    Views
    886

    This method has a one-to-one correspondence...

    This method has a one-to-one correspondence between cells in the source and destination worksheets; e.g.,


    Cells(1, 1) = .Cells(2, 7)
    Cells(1, 2) = .Cells(2, 8)
    Cells(1, 3) = .Cells(2, 9)

    ...
  16. Replies
    13
    Views
    886

    Thanks, that works fine.

    Thanks, that works fine.
  17. Replies
    13
    Views
    886

    Thanks for your further replies, from which I'm...

    Thanks for your further replies, from which I'm now wondering whether there may be a simpler way to do what I need. Here is a cut down example of what I am trying to do.

    File A:
    37659

    File B:...
  18. Replies
    13
    Views
    886

    Thanks for the reply. It looks like the copy...

    Thanks for the reply.

    It looks like the copy destination cell in File A is set as Range ("A1") - is that right? Can it be "R1C1"?

    If I want to do multiple copies into various cells with various...
  19. Replies
    13
    Views
    886

    Syntax in macro

    I am creating a macro in File A to copy values from File B into File A, depending on a condition in File B. I tried this, but it doesn't work.

    Range("R1:C1").Select
    If "'File B.xlsx'!R2C2" = ""...
  20. Thanks for your reply. This did the trick in...

    Thanks for your reply. This did the trick in Windows 7 64-bit on my two laptops.
  21. Replies
    2
    Views
    686

    Thanks for your reply. I have since discovered...

    Thanks for your reply. I have since discovered the following also.

    Sub DeleteAllComments()
    ActiveDocument.DeleteAllComments
    End Sub
  22. Replies
    2
    Views
    686

    Macro code to delete all comments

    In Word 2010, I want to include a line in a macro to delete all comments in the current document. I tried recording a macro and using the "Delete all comments in document" function on the Review tab,...
  23. Replies
    7
    Views
    1,168

    Thanks again. I followed your suggestion and it...

    Thanks again. I followed your suggestion and it works fine. I couldn't find the VBA colour code for hex CCFFCC but found that Val = ("&H" & "CCFFCC") works.
  24. Replies
    7
    Views
    1,168

    Thanks for your further reply, much appreciated....

    Thanks for your further reply, much appreciated. The only thing I don't quite understand is why or whether both OnCurrent and AfterUpdate events are needed. The Status field cannot be edited in this...
  25. Replies
    7
    Views
    1,168

    Thanks for your reply. As I have not used events...

    Thanks for your reply. As I have not used events before and don't know what code to use, are you able to provide an example or suggest an online resource that shows how to do this? All I need is...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4