Search:

Type: Posts; User: Jimmy-W; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thanks again, Paul;! I have to find a source to...

    Thanks again, Paul;! I have to find a source to learn some basic VB, particularly to do formatting tasks. I tried Kutools, but it doesn't support some of the stuff that I need.
  2. Now I want to set cell widths

    I'm returning to this thread, as I have a similar issue. I want to set the cell width across multiple tables, each of which has two cells, perhaps to 4". I played around with Marcopod's macro for...
  3. Replies
    7
    Views
    383

    Thanks! Sorting the query didn't work, but I...

    Thanks! Sorting the query didn't work, but I added a date header to my report and sorted that way. Then, the PDF picks up the Access report in that order.
  4. Replies
    7
    Views
    383

    Sorting a report based on a date field

    I have a report based on a query in Access 2010. The query/report has several date fields. After I produce my report, I convert it to PDF. I want to have the final report/PDF records sorted by one...
  5. Marcopod, you are a genius! Thank you both. I...

    Marcopod, you are a genius! Thank you both. I think that every table has the same style. I create an html report that contains tables, each of which includes a graphic and text description in a...
  6. Keeping rows of multiple tables from splitting across pages

    I know he basics of keeping my entire table on one page. However, I have 50, 1-row, 2-column tables, with 2 tables per page. I think that the way to do this is to uncheck the table option that...
  7. Rule to exclude certain addresses from read receipts - Outlok 2010

    I elected to request read receipts by default. However, there is one address for which I do not want receipts. Is it possible to create a rule so that receipts are not requested from a particular...
  8. Thanks very much, Steve and Maud, for your usual...

    Thanks very much, Steve and Maud, for your usual splendid advice! I went with Maud's suggestion, which worked perfectly.
  9. Using IF to find a text string within a text string

    I think that I may have to use FIND or another function with IF, but I want to find the number 5434579711 in strings like the following:
    ...
  10. Great idea! It'll be a lot easier to comprehend...

    Great idea! It'll be a lot easier to comprehend as a visualization.
  11. Exactly! I cannot tell whether ID 2 in Example 1...

    Exactly! I cannot tell whether ID 2 in Example 1 was edited. You also are spot on with respect to your observation in Example 2. All that I can do with respect to a case like Example 2 is suggest...
  12. Thanks, Maudibe. I see what you mean and yes, it...

    Thanks, Maudibe. I see what you mean and yes, it works great! However, I think that I might not have adequately explained what I'm really trying to accomplish. I have an existing user login/logout...
  13. Thanks again, everyone. I do want to try RG's...

    Thanks again, everyone. I do want to try RG's code, and I placed the module in the sheet object. See the screenshot. No joy!
  14. Thanks again, everyone. First, for some reason...

    Thanks again, everyone. First, for some reason that must be user error, I can't get the macros to list or run in my .xlsm book. See the screenshot.

    I think that we still have somewhat of a...
  15. Thanks, guys. The MAX function in D3 reports an...

    Thanks, guys. The MAX function in D3 reports an error of Formula Omits Adjacent Cells. The IDs are set and and every time entry originally is entered in that order. Some were edited later. ...
  16. Thanks! Yes, that seems quick and easy. ...

    Thanks! Yes, that seems quick and easy. However, I just found that I should use the =OR function instead of =AND. =OR(C3<C2,C3>C4). Also, I'm trying to consider whether the out-of-order dates can...
  17. Function to find out-of-order dates (Excel 2010)

    I need a little help to see whether I'm doing this correctly, and attached a sample spreadsheet. Column A (ID) is a sequential number, like a primary key. It cannot be changed and is updated every...
  18. Replies
    14
    Views
    1,010

    Thanks, and sorry that I missed that. I edited...

    Thanks, and sorry that I missed that. I edited the path, too. Still, however, no joy. The target files are unchanged.


    Option Explicit

    Sub Traverse()
    Dim zFile As String
    Dim zPath...
  19. Replies
    14
    Views
    1,010

    Thanks again. I have to be doing something...

    Thanks again. I have to be doing something wrong, but I ran the code from your docm, and no edits were made to the target files.


    Option Explicit

    Sub Traverse()
    Dim zFile As String
    ...
  20. Replies
    14
    Views
    1,010

    Thanks, Paul, but I'm afraid it didn't work. I...

    Thanks, Paul, but I'm afraid it didn't work. I posted the edited code below, but all that I did was change the extension to *.doc and add Call insert_tags. I changed the target file names to...
  21. Replies
    14
    Views
    1,010

    Thanks. First, I'm not a power user of macros...

    Thanks. First, I'm not a power user of macros and VBA. The macros are stored in Normal.dot. The code is below, and I also attached a screenshot. I simply found the original code at...
  22. Replies
    14
    Views
    1,010

    Thanks very much. I replaced the code as you...

    Thanks very much. I replaced the code as you suggested. The only change is in the line where I called my macro:
    Call insert_tags 'Call processing routine (EDIT THIS!)

    When I run the...
  23. Replies
    14
    Views
    1,010

    Module help - editing all files in a folder

    I found the following macro and have tried to run it on a folder. It's supposed to call another macro named insert_tags, which will search/replace/insert text in a file. The module below quits at...
  24. Well, you're correct. I don't know what I was...

    Well, you're correct. I don't know what I was doing wrong, but it does work as you said. Thanks.
  25. Thanks, but I did do that and found that the...

    Thanks, but I did do that and found that the number icon was not available unless I started at the second row.
Results 1 to 25 of 194
Page 1 of 8 1 2 3 4