Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: Table Headers

    by rvWoody
    Replies
    2
    Views
    218

    Table Headers

    38607

    Attached image shows a table that contains a column with sparklines. As I have no need to sort the sparklines (nor the data columns D to G, for that matter) I want to remove the inverted...
  2. Replies
    4
    Views
    517

    Thanks to all of you for your useful suggestions....

    Thanks to all of you for your useful suggestions. For sure: if it ain't broke, don't fix it, but repeatedly being remembered of that update almost made me feel guilty. It won't (probably) happen...
  3. Replies
    4
    Views
    517

    Remove Automatic Update Warnings?

    Last week-end, I installed an optional update (nvidia - Graphics Adapter WDDM1.1, ...), suggested by Windows Update. What a catastrophe! My system (Win7/32) almost immediately stalled every 10-15...
  4. Replies
    10
    Views
    6,295

    It didn't but in an unexpected way: In fact, the...

    It didn't but in an unexpected way: In fact, the form was displayed as it was laid out at design time. It happens to be a form where the controls are dynamically put in place when the form is...
  5. Replies
    5
    Views
    1,090

    Try...

    Try [tblValuations]![CreateValuation]>=[reportdate] and [tblValuations]![CreateValuation]<=[reportdate2]
  6. Replies
    10
    Views
    6,295

    Thanks rory: that did it. After reading your...

    Thanks rory: that did it. After reading your answer, the error message was clear and rather explicit!

    PS: If ever I switch to office 64-bit, would it be sufficient to change "user32" for...
  7. Replies
    10
    Views
    6,295

    @rory: thanks for your reply. Unfortunately, it...

    @rory: thanks for your reply. Unfortunately, it does not work.

    But let me briefly describe the pretty standard application. When access is opened it performs some actions (retrievals) on the...
  8. Replies
    10
    Views
    6,295

    Adding Select doesn't put Excel on top in the...

    Adding Select doesn't put Excel on top in the Office 2010/Win7 environment. Sorry.
  9. Replies
    10
    Views
    6,295

    Setfocus in unfortunately not a worksheet method!

    Setfocus in unfortunately not a worksheet method!
  10. :cool:My apologies to MarkLiquorman, Cronk: Yes,...

    :cool:My apologies to MarkLiquorman, Cronk: Yes, indeed, it did work (however unexpected to me). I was totally unaware of Access' DMAX function.
    Correct syntax was:...
  11. Replies
    2
    Views
    3,031

    What media is your database stored on? This...

    What media is your database stored on? This behaviour happens if your database is copied to a CD or DVD
  12. @MarkLiquourman: I'm not sure your suggestions...

    @MarkLiquourman: I'm not sure your suggestions works. As far as I understand, the DMAX function requires three arguments, one of which is an Excel range that represents the "database". Also, your...
  13. How to convert a single field recordset into a VBA variable?

    What is the most efficient way to convert a recordset that contains only one field into a VBA variable. In the following example I 'm looking for the highest expiration date in an access table. ...
  14. Replies
    10
    Views
    6,295

    I want Excel always on top

    I call Excel from within an Access Application with the following (pretty standard) code:


    The Access application is excuted in two possible system environments: either Office 2007 & Vista...
  15. Replies
    2
    Views
    2,808

    Yes that worked! It happens that the text in the...

    Yes that worked! It happens that the text in the footnote were I wanted to insert the link was not selected after all. I should have been more attentive to that.
  16. Replies
    2
    Views
    2,808

    Hyperlinks in Footnotes?

    Is it possible? (Office Prof -> Word 2010)

    When I create a footnote (References -> Insert Footnote) and then select some text in that note to insert a Hyperlink (Insert tab -> Hyperlink) the...
  17. Replies
    5
    Views
    1,241

    Thanks guys: once one sees the solutions, it...

    Thanks guys: once one sees the solutions, it becomes easier than I thought for possible!
  18. Replies
    5
    Views
    1,241

    SQL Query Problem

    An Access Database table contains basically two fields: a Date (RDate) and a Value (RCount). A sample table could look as follows:
    RDate RCount
    2/1/1999 1256
    5/6/1999 1954
    7/9/1999 2008...
  19. Replies
    14
    Views
    4,183

    Same for me - that's why I thanked voodoochile

    Same for me - that's why I thanked voodoochile
  20. Replies
    14
    Views
    4,183

    Where did you get that information? The KB page...

    Where did you get that information? The KB page lists under Prerequisites "To apply this update, you must be running Windows7" without any further qualification. Although it's true that the...
  21. Replies
    14
    Views
    4,183

    Susan writes: You should also ensure that you've...

    Susan writes: You should also ensure that you've installed KB 2502285 (info page), which fixes a potential BSOD after applying SP1. (Without the patch, antivirus apps can exhaust the space in the...
  22. Replies
    8
    Views
    16,557

    Rory, why should that be the case? If I enter...

    Rory, why should that be the case? If I enter the data manually into a spreadsheet range, then there isn't even a dataset and I still can create a pivottable.
  23. Replies
    8
    Views
    16,557

    The file is in the xlsm format, because it has an...

    The file is in the xlsm format, because it has an embedded macro. Nevertheless, I resaved it under a different name and subsequently reopened it, but to no avail. The option stays grayed out. The...
  24. Replies
    8
    Views
    16,557

    Nope, no protection. What do you mean by "VBA...

    Nope, no protection. What do you mean by "VBA sets a status"?
  25. Replies
    8
    Views
    16,557

    Slicer option disabled - XL2010

    I have a workbook that upon initialization pulls data from an Access database and then creates dynamically (VBA) a pivottable with that data. The application runs fine - no problem there. But when I...
Results 1 to 25 of 91
Page 1 of 4 1 2 3 4