Search:

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

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Searching any part of all fields by default - Access 2010

    I seem to remember that earlier versions of Access had a setting to make the Ctrl+F search default to searching any part of every field in a form. Is there a way to do this in 2010? Thanks.
  2. A belated thanks to everyone! I went with...

    A belated thanks to everyone! I went with Rory's suggestion, which worked great.
  3. Quicken the use of fill handle - Excel 2010

    I may use the fill handle to add consecutive numbers to a field, e.g., A1=1, A2=2, A3=3, etc. This works great until I have thousands of records. I suppose that I could enter a forrmula to...
  4. [SOLVED] Lost formatting - form colors - Access 2010

    I attached a screenshot that shows three subforms that I embedded in my main form. As you'll see, the subforms basically are gray. They once were blue, using the typical Windows colors, but somehow...
  5. Replies
    6
    Views
    1,003

    Migrate settings to new profile

    I created a new user account and used Windows Easy Transfer to copy the Windows settings from an old account. Is there a way to transfer all of my Office 2010 Access, Excel, and Word preferences,...
  6. Replies
    7
    Views
    472

    Thanks again, Maudibe. This is great! Question:...

    Thanks again, Maudibe. This is great! Question: instead of commenting out the lines, can I just delete them from the module? Also, is there a way to make this module show up in my macro list?
  7. Replies
    7
    Views
    472

    Maudibe, you are indeed a genius! Works...

    Maudibe, you are indeed a genius! Works perfectly, even when I have a Base16 with two leading zeros, e.g., 009FF744DB2C09A27525CC2EBC5F52179BBB988A.

    However, I still have the problem going...
  8. Replies
    7
    Views
    472

    Thanks, Fred. Yes, Excel does retain the leading...

    Thanks, Fred. Yes, Excel does retain the leading zero when I paste a Base16 hash value into a cell, as A3 in my example. The problem is that the function apparently ignores that leading zero when...
  9. Replies
    7
    Views
    472

    Function to convert number base

    A few years ago, HansV was kind enough to suggest some code through which I could convert Base16 numbers to Base32 and vise versa. I am talking about SHA-1 hash values. For example, I would use the...
  10. Replies
    5
    Views
    249

    Thanks very much, Maudibe, that works! Is there,...

    Thanks very much, Maudibe, that works! Is there, however, a way to paint that format from the now-highlighted text in one cell to text in another cell? It would make it much easier.
  11. Replies
    5
    Views
    249

    Thanks, Paul. Yes, that removes the hyperlinks,...

    Thanks, Paul. Yes, that removes the hyperlinks, so I can do that if I can't highlight, which is what I prefer to do.
  12. Replies
    5
    Views
    249

    Highlight text string in cell

    I have a field that contains URLs, which are not formatted as hyperlinks. They look like this:

    h_t_tp://windowssecrets.com/forums/newthread

    I want to highlight a portion of the URL, so that...
  13. 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.
  14. 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...
  15. Replies
    7
    Views
    594

    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.
  16. Replies
    7
    Views
    594

    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...
  17. 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...
  18. 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...
  19. 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...
  20. 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.
  21. 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:
    ...
  22. Great idea! It'll be a lot easier to comprehend...

    Great idea! It'll be a lot easier to comprehend as a visualization.
  23. 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...
  24. 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...
  25. 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!
Results 1 to 25 of 206
Page 1 of 9 1 2 3 4