Search:

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

Page 1 of 19 1 2 3 4

Search: Search took 0.02 seconds.

  1. Hyperlink formula to long file names that include commas

    I have pdf files that have long, convuluted files names. As an example,

    "445,046 Amolder,Klaus,,409291,09-02-2008.PDF" is the value of cell A2.

    I am using the following formula in A3:...
  2. Replies
    5
    Views
    1,692

    Subform data sometimes missing

    In a user's Access database, the data is in one .mdb file and the form and reports are in another. There is a customer form with two subforms (one of them is for Orders). The data in the subforms...
  3. Running macro disrupts links on option buttons

    In an XLSM Excel 2007 workbook, there are macros that hide or unhide various rows via a user form. Rows include option buttons in groups of 3. When the macro is used to hide rows, then unhide them...
  4. I am looking for a way to apply a new envelope...

    I am looking for a way to apply a new envelope style to documents that are already saved.

    Unfortunately, I am working with an office that does "Save As" instead of templates/new documents. The...
  5. Replies
    2
    Views
    550

    I'm using the following in a control source on a...

    I'm using the following in a control source on a report to express a running total in hours and minutes, even if the total is greater than 24 hours:

    =Int([txtrunsum])*24+DatePart("h",[txtrunsum])...
  6. Replies
    1
    Views
    934

    From Outlook 2007, when I insert a hyperlink to a...

    From Outlook 2007, when I insert a hyperlink to a bookmark in a Word document, the hyperlink will open the document but not move to the bookmark. I'm using Insert | Hyperlink, selecting the document,...
  7. Replies
    1
    Views
    1,523

    The Label1 and Label2 labels on my Access 2007...

    The Label1 and Label2 labels on my Access 2007 database display the same text as the first item on my Switchboard ("Add new customer"). I have changed the captions. They look right in design view...
  8. In the weekly calendar view of a public folder...

    In the weekly calendar view of a public folder calendar, my tasks display at the bottom. I would like to display a public tasks folder instead. Hoping someone will have a suggestion for handling...
  9. Replies
    3
    Views
    1,046

    I have a user who has Outloook 2003 SP3 set to...

    I have a user who has Outloook 2003 SP3 set to empty the Deleted Items when he exits. It has suddenly stopped working - the items remain. There have been no computer changes. I have had him uncheck...
  10. Replies
    13
    Views
    3,739

    If you want to use the HURows macro, you should...

    If you want to use the HURows macro, you should change

    If Worksheets("Sheet3").Cells(RowCnt, ChkCol).HasFormula And Cells(RowCnt, ChkCol).Value = "" Then

    to

    If...
  11. Replies
    13
    Views
    3,739

    Wouldn't that become irritating after a while?...

    Wouldn't that become irritating after a while? It'd mean you wouldn't return to the cell you last visited on Sheet3.

    That's a very good point! I'll wait and see if it becomes an issue.

    I have...
  12. Replies
    13
    Views
    3,739

    Thanks so much - that works really well! And I...

    Thanks so much - that works really well! And I like your sample data "ha!"

    Another wish: I had added Range("A1").Select in my Sheet 3 macro. Can I insert that into the Sheet2 macro somewhere so...
  13. Replies
    13
    Views
    3,739

    I'm not having much luck at making the Sheet 2...

    I'm not having much luck at making the Sheet 2 macro work. I did goof up when I said the changes would be on Sheet 2, Column D. The changes are actually made to Column G (the formula displays text...
  14. Replies
    13
    Views
    3,739

    Should the code look only at Sheet2!D10 or at a...

    Should the code look only at Sheet2!D10 or at a range of cells (e.g. column D)?

    Column D
  15. Replies
    13
    Views
    3,739

    That works great! Thanks! Do you have any...

    That works great! Thanks!

    Do you have any suggestions for triggering the macro if Sheet 2 is modified? Maybe it could run if the file is saved or something like that?

    Thanks again!
  16. Replies
    13
    Views
    3,739

    I have a formula on Worksheet 3 that looks at a...

    I have a formula on Worksheet 3 that looks at a specific cell on Worksheet 2.
    =IF(ISTEXT(Sheet2!G10),Sheet2!D10,"")

    On Worksheet 3, I want to hide any rows that have "" instead of text. Here's...
  17. Replies
    7
    Views
    1,368

    The autotext option is interesting! How is the...

    The autotext option is interesting! How is the userform set up to pull autotext?

    Your comment about maintaining is a good one to think about, too, as the forms are currently in Word 2003. It's...
  18. Replies
    7
    Views
    1,368

    That wouldn't be easy. It would require VBA, and...

    That wouldn't be easy. It would require VBA, and in that case you might as well use a userform created in the Visual Basic Editor. Userform controls have Visible and Enabled properties that let you...
  19. Replies
    7
    Views
    1,368

    I'm wondering if there is a way to use the same...

    I'm wondering if there is a way to use the same form for multiple purposes. It's a loan form and a lot of the form fields are the same, but depending on the type of loan, some areas can be left...
  20. Replies
    1
    Views
    473

    I have a form used to enter parameters for a...

    I have a form used to enter parameters for a query that flow through to a report. The parameters for this form/query/report are based on years. I want to build a similar form/query/report for months....
  21. Replies
    3
    Views
    407

    Re: Make Report Text Box Variable Info (2007)

    I like both ideas! In my case I have a form that is used for the parameter values, so I can use the second idea of using a form. That will make is very easy for the end user and only a little more...
  22. Replies
    3
    Views
    407

    Make Report Text Box Variable Info (2007)

    I'm looking for some suggestions for an end user who wants to be able to customize a text box on a report, for example including current info, without having to go into design view to modify the...
  23. Re: Display Main Report if Subreport Has Data (2007 SP1)

    This works really well, and takes into account that there may be new names as years go by, ensuring that the new names get a statement, too.

    Can you explain the nz function?
    ...
  24. Display Main Report if Subreport Has Data (2007 SP1)

    I have found lots of posts regarding having a subreport display when there is no data, but how about the reverse?

    I am setting up a report that will display contributions from previous years in...
  25. Re: Subreport Prompting Parameters Multiple Times (2007 )

    That will work perfectly. Thank you so much!
Results 1 to 25 of 451
Page 1 of 19 1 2 3 4