Search:

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

Page 1 of 9 1 2 3 4

Search: Search took 0.02 seconds.

  1. Access 2010 - Creating a calculated field from a different table

    The attached screenshot shows a subform that allows for multiple records of the indicated fields. The Exams field is a calculated field: =[Hard_drives]+[Phones]+[devices]. There may be several...
  2. Replies
    6
    Views
    384

    Thanks! Worked fine.

    Thanks! Worked fine.
  3. Replies
    6
    Views
    384

    Thanks again, Wendell. I'm sorry, I'm running...

    Thanks again, Wendell. I'm sorry, I'm running Access 2010. I attached another screenshot. As you'll see the second row is gray and somewhat hard to distinguish. I didn't choose any special...
  4. Replies
    6
    Views
    384

    Thanks very much! it worked. While I'm on the...

    Thanks very much! it worked. While I'm on the subject, is there a way to make the secod row of the form either white like the first row or at least make it a shade that's no so dark? I attached a...
  5. Replies
    6
    Views
    384

    Help with formatting form field width

    I attached a screenshot of a subform as it appears in my main form. The subform has six fields, all of the same width. All but the first field are too wide, but I can't seem to make them narrower,...
  6. 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.
  7. A belated thanks to everyone! I went with...

    A belated thanks to everyone! I went with Rory's suggestion, which worked great.
  8. 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...
  9. [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...
  10. Replies
    6
    Views
    1,252

    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,...
  11. Replies
    7
    Views
    562

    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?
  12. Replies
    7
    Views
    562

    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...
  13. Replies
    7
    Views
    562

    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...
  14. Replies
    7
    Views
    562

    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...
  15. Replies
    5
    Views
    275

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

    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.
  17. Replies
    5
    Views
    275

    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...
  18. 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.
  19. 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...
  20. Replies
    7
    Views
    640

    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.
  21. Replies
    7
    Views
    640

    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...
  22. 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...
  23. 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...
  24. 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...
  25. 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.
Results 1 to 25 of 211
Page 1 of 9 1 2 3 4