Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    8
    Views
    172

    Thanks. I clicked on the button, but it did not...

    Thanks. I clicked on the button, but it did not create a PDF.

    However, as I don't want to automate the file saving, I adapted part of your code into a macro to insert a hyperlink that works when...
  2. Replies
    8
    Views
    172

    OK thanks.

    OK thanks.
  3. Replies
    8
    Views
    172

    Thanks, I get the same result. However, in...

    Thanks, I get the same result.

    However, in rz-test-0.xlsx, if [A1] is changed, then the hyperlink in [C12] reflects the change, but in rz-test-1.xlsx, if [A1] is changed, then the hyperlink in...
  4. Replies
    8
    Views
    172

    Thanks for your reply. I tried your suggestion,...

    Thanks for your reply. I tried your suggestion, but the result was similar to before. The text was plain rather than blue underlined, but the link still wasn't retained in the PDF.
  5. Replies
    8
    Views
    172

    Hyperlink with different text

    I have a cell that creates a hyperlink by concatenating the contents of other cells, like this.

    =HYPERLINK("http://www.example.com?"&"name="&A1&"&address="&B1)

    When I save the worksheet as a...
  6. 1. Normally each job must be completed before the...

    1. Normally each job must be completed before the next can be started; however, sometimes an order can have two started jobs at the same time, but the result query should only list the *lowest*...
  7. Yes, I see how that works. Thanks for your help.

    Yes, I see how that works. Thanks for your help.
  8. For each order, jobs are completed sequentially...

    For each order, jobs are completed sequentially by JobType; i.e., regardless of whether an order has JobTypes 1, 2, and 3, or only 1 and 3, or only 2 and 3, the jobs are completed in numerical...
  9. Thanks for your reply. However, I'm not sure...

    Thanks for your reply. However, I'm not sure whether I'm following correctly.

    "CompletedJobs" will produce:
    OrderNo, JobType, Job Status, PreviousJobOperator
    1001, 1, 2, Tom
    1001, 2, 2, Dick...
  10. Getting a field from a "previous" record in a subquery

    I have an Access 2010 database with a Jobs table that includes these fields.
    - OrderNo
    - JobType (1 = Task1, 2 = Task2, 3 = Task3, etc.)
    - JobStatus (1 = Started, 2 = Completed)
    - JobOperator
    ...
  11. Replies
    3
    Views
    134

    Thanks for your replies. I see how this reflects...

    Thanks for your replies. I see how this reflects the ability of Access to display the code in different views.



    Yes the actual code has "Is Null", I just used "=" and "<>" as shorthand...
  12. Replies
    3
    Views
    134

    Query efficiency

    I have an Access 2010 query with a set of criteria like this.

    Code A
    ----------
    WHERE Field1 = null AND Field2 = 1 AND Field3 > 0 AND Field4 Between 1 And 2 AND Field5 <> 1234 AND Field 5 <>...
  13. Replies
    56
    Views
    1,563

    Thanks again. I have since struck a further...

    Thanks again.

    I have since struck a further issue. If you open this file, then open another spreadsheet (even one with no code, or even a blank new file) and press the left or right arrow key in...
  14. Replies
    56
    Views
    1,563

    I have unlocked an area (A20:B29) on the...

    I have unlocked an area (A20:B29) on the restricted area sheet for the user to enter notes.
    47839

    If the user copies one or more of these note cells (e.g., A20:A22) and pastes them inside the...
  15. Replies
    5
    Views
    180

    [SOLVED] I have now edited the question to be more precise.

    I have now edited the question to be more precise.
  16. Replies
    5
    Views
    180

    [SOLVED] Thanks for your reply. I found a macro that...

    Thanks for your reply. I found a macro that converts text boxes into ordinary text, and then I can save the lot as plain text, which does the trick.
    ...
  17. Replies
    5
    Views
    180

    [SOLVED] Text boxes and saving as plain text

    When I save a Word 2010 file as plain text, text boxes are excluded. Is there a way to save a document as plain text with text boxes included?
  18. Replies
    7
    Views
    224

    Thanks for your reply. All of the memo fields...

    Thanks for your reply. All of the memo fields contain well under 1,024 characters (the longest is 692 characters); however, on further investigation, I found that these fields are all being truncated...
  19. Replies
    7
    Views
    224

    Thanks for your replies, which led me to an...

    Thanks for your replies, which led me to an answer to the original question but raised a further one.

    1. Original issue: When I compared the output of (a) the query, (b) the report with the query...
  20. Replies
    56
    Views
    1,563

    Thanks again.

    Thanks again.
  21. Replies
    7
    Views
    224

    Thanks for your reply. The query uses just a...

    Thanks for your reply. The query uses just a single table (so no union) with no totalling (so no grouping), and the report has no grouping or sorting. The query does have a sort on one field (not one...
  22. Replies
    7
    Views
    224

    Report field sizing

    I have a basic Access 2010 report, with a simple query that just lists a handful of fields from a single table, and a report that just lists the query.

    The list includes four memo fields that...
  23. Thread: Hyperlinks

    by Murgatroyd
    Replies
    4
    Views
    127

    Thanks for this. I wondered whether it was...

    Thanks for this. I wondered whether it was possible to have the link on just one word rather than the whole cell, but this does the job.
  24. Thread: Hyperlinks

    by Murgatroyd
    Replies
    4
    Views
    127

    Hyperlinks

    Is it possible to add a hyperlink on text within a cell, and have it clickable when saved as a PDF?

    For example, if a cell contains "Click here to go to Windows Secrets Lounge", then can the word...
  25. Replies
    56
    Views
    1,563

    Thanks again. Just one further query: your...

    Thanks again.

    Just one further query: your comments in the code are very helpful; could you clarify also what the last part of the Worksheet_Change sub is for ...



    If Target.Cells.Count > 1...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4