Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    7
    Views
    1,144

    Thanks for your further replies. After some...

    Thanks for your further replies. After some experimentation, I managed to get the result that I wanted, by creating a crosstab query to display the scores for each Name in columns, and a total query...
  2. Replies
    5
    Views
    292

    Thanks for your replies. I tried deleting all...

    Thanks for your replies. I tried deleting all connections from Manage Wireless Networks and re-adding this one, and I keep changing the password there to the new one when it reverts to the old one,...
  3. Replies
    5
    Views
    292

    Old wireless password keeps returning

    I just replaced my old wireless router with a new one. I gave the new one the same name (SSID) as the old one, but a different password. The new router works fine, but sometimes after disconnecting...
  4. Replies
    7
    Views
    1,144

    Thanks for your reply. I gather I will need to...

    Thanks for your reply. I gather I will need to use a crosstab query in Access, but I am hoping for some help with setting it up.
  5. Replies
    7
    Views
    1,144

    Query to sum and average scores

    I have a table in Access 2010 with data like this (the score field contains one of five values, A-E).

    [Event], [Name], [Score]
    1, Tom, A
    2, Dick, E
    3, Harry, B
    4, Dick, D
    5, Harry, B
    6, Tom,...
  6. Replies
    50
    Views
    2,602

    Yes ... 20% to make it bugproof, 80% to make it...

    Yes ... 20% to make it bugproof, 80% to make it foolproof. :)
  7. Replies
    50
    Views
    2,602

    Thanks again, RG. This file works OK; in fact, it...

    Thanks again, RG. This file works OK; in fact, it allows more extensive multiple pastes than an ordinary file!

    Multiple pastes in ordinary file:
    - Ctrl+V: Yes
    - Right-click > Paste: Yes
    -...
  8. Replies
    50
    Views
    2,602

    Thanks again, RG. This file works OK. I...

    Thanks again, RG. This file works OK.

    I changed the message from "Paste operation Probited" to "... prohibited", and I noted the same differences as before between an ordinary file and this one...
  9. Replies
    50
    Views
    2,602

    That is actually what I was looking for as well;...

    That is actually what I was looking for as well; my problem is more often caused by users pasting data into Excel from outside than by cutting/copying/pasting from within Excel itself.
    ...
  10. Replies
    50
    Views
    2,602

    Yes, I guess there's no reason to prevent...

    Yes, I guess there's no reason to prevent multiple pastes via Ctrl+V outside the blocked range, and that would keep things consistent with the normal behaviour in an ordinary file.
  11. Replies
    50
    Views
    2,602

    Thanks, this works fine. The changes seem to be...

    Thanks, this works fine. The changes seem to be to do with enabling/disabling CutCopy mode (i.e., whether multiple pastes are possible)? I noted the following differences between an ordinary file and...
  12. Replies
    50
    Views
    2,602

    Yes that works now. Many thanks again for your...

    Yes that works now. Many thanks again for your help.
  13. Replies
    50
    Views
    2,602

    1. Thanks, that fixed the Ctrl+V issue. 2. I...

    1. Thanks, that fixed the Ctrl+V issue.

    2. I see the code has "CellDragAndDrop = False" in Auto-Open, and "CellDragAndDrop = True" in Workbook_Close; however, the file disables the drag-and-drop...
  14. Replies
    50
    Views
    2,602

    1. I tried it in a trusted location, and it...

    1. I tried it in a trusted location, and it worked OK with the Enter keys and with right-click, but Ctrl+V was blocked from pasting everywhere, not just in the specified cells.

    2. The file...
  15. Replies
    50
    Views
    2,602

    Thanks again, your help with this is appreciated....

    Thanks again, your help with this is appreciated.

    1. When I opened the file the first time, I got a "Protected View" warning, and when I clicked on "Enable Editing" and tried pasting, the code...
  16. Replies
    50
    Views
    2,602

    Thanks for your replies, Zeddy. That works for...

    Thanks for your replies, Zeddy. That works for me. As you say, it doesn't prevent drag/drop or autofill, but in my case, users are (hopefully) unlikely to do that. However, is there a way to specify...
  17. Replies
    50
    Views
    2,602

    Thanks for the clarification. I tried this, and...

    Thanks for the clarification. I tried this, and it works with right-click, but not with Ctrl+V or Enter. I have attached my test file FYI ... am I doing something wrong?
  18. Replies
    50
    Views
    2,602

    Thanks for your reply, RetiredGeek. However, I'm...

    Thanks for your reply, RetiredGeek. However, I'm a bit confused ... can you clarify which of the four blocks of code mentioned above I need to use, and where they go ("Worksheet Module", "Standard...
  19. Replies
    50
    Views
    2,602

    Thanks for your reply. However, I don't want to...

    Thanks for your reply. However, I don't want to disable right-click altogether, as that includes other options that I want to remain enabled (e.g., Insert Comment). I only want to disable pasting...
  20. Replies
    50
    Views
    2,602

    Disabling paste into cells

    I have a worksheet created in Excel 2010 that includes a couple of columns with data validation, but if users paste data into those columns, the data validation doesn't work (and the formatting also...
  21. Replies
    5
    Views
    606

    Thanks for your reply. Yes, that works fine.

    Thanks for your reply. Yes, that works fine.
  22. Replies
    5
    Views
    606

    Thanks for your replies. Every order record...

    Thanks for your replies. Every order record always has four corresponding notes records, so Wendell's suggestion of getting a notes date/time value from one of the four notes records for each order...
  23. Replies
    5
    Views
    606

    Grouping fields in report header

    I have Access 2010 as a front end linked to a SQL database back end. I have a report with two tables ("Orders", "Notes") joined on a common field [OrderID].

    Each record in the Orders table has...
  24. Replies
    18
    Views
    1,290

    Many thanks, I've got it working now.

    Many thanks, I've got it working now.
  25. Replies
    18
    Views
    1,290

    I tried running the macro in a new document, but...

    I tried running the macro in a new document, but nothing happened to the List Number 1-5 styles. The only thing that happened was the paragraph with the cursor in it changed to "List Paragraph" style.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4