Search:

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

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Found the answer here:...

    Found the answer here: http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/whats-this-blank-window/78af59e7-47be-4f28-9b17-0c140f555887
  2. Opening Excel 2013 XLSM opens XLSB? - can't hide

    I have a macro-enabled workbook that I created in 2010. It's in a folder at C:\aaa. After I upgraded to 2013, whenever I open the file, a second spreadsheet named simply "Excel," (I think it's my...
  3. Replies
    0
    Views
    53

    Exporting mail to Excel omits dates

    I'm trying to export my Outlook 2010 Inbox to Excel. Everything works, except for the fact that the Received Date field is omitted. There actually is no Received Date field in the Map Custom Fields...
  4. 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...
  5. Replies
    6
    Views
    562

    Thanks! Worked fine.

    Thanks! Worked fine.
  6. Replies
    6
    Views
    562

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

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

    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,...
  9. 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.
  10. A belated thanks to everyone! I went with...

    A belated thanks to everyone! I went with Rory's suggestion, which worked great.
  11. 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...
  12. [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...
  13. Replies
    6
    Views
    1,595

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

    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?
  15. Replies
    7
    Views
    883

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

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

    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...
  18. Replies
    5
    Views
    337

    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.
  19. Replies
    5
    Views
    337

    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.
  20. Replies
    5
    Views
    337

    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...
  21. 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.
  22. 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...
  23. Replies
    7
    Views
    799

    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.
  24. Replies
    7
    Views
    799

    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...
  25. 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...
Results 1 to 25 of 214
Page 1 of 9 1 2 3 4