Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    11
    Views
    149

    @Rory: this is indeed an elegant way to achieve...

    @Rory: this is indeed an elegant way to achieve the desired result. Congratulations.

    However, I have to stick with a (modified) UDF. As you observed the NULLs spoil everything. To further...
  2. Replies
    11
    Views
    149

    Thanks for your replies. I was already afraid...

    Thanks for your replies. I was already afraid that no compact solution could be found within the set of Excel functions. What further complicated the issue was the presence of Nulls in the data set...
  3. Replies
    11
    Views
    149

    Counting inequalities

    Following table was pulled from an SQL Server data base and shows dividends paid over the past years.

    42847

    I want to count how many times the dividend was at least equal or greater than that...
  4. Replies
    19
    Views
    1,814

    I can't insert a symbol into a Name. I get all...

    I can't insert a symbol into a Name. I get all shades of Grey :( - see attachment

    41658
  5. Replies
    19
    Views
    1,814

    zeddy, I do consider a named range as a...

    zeddy, I do consider a named range as a reference. I do agree that the use of a name is less error prone.
  6. Replies
    19
    Views
    1,814

    Thanks again to all: copying a reference to a...

    Thanks again to all: copying a reference to a spreadsheet cell that contains the symbol and constructing the formula around it in the formula bar does the job.
  7. Replies
    19
    Views
    1,814

    Thanks to all for replying so quickly. The...

    Thanks to all for replying so quickly.

    The most straightforword solution would be the use of Maudibe's suggestion: =IF(ERROR.TYPE(A1)=2,"∞"), but if I try to insert the ∞ symbol (from the math...
  8. Replies
    19
    Views
    1,814

    The road to infinity

    Is it possible to represent the symbol for infinty as result of a calculation? I want someting like this:
    IFERROR (some calculation, "Symbol for infinity")
    The following article seems to suggest...
  9. Replies
    3
    Views
    553

    The more generic question can be solved by using...

    The more generic question can be solved by using dynamic SQL. Interpreting some googled results, I put the following reminder to myself together:

    Generic Approach

    1. Define an SQL variable...
  10. You must add a Parameter object before executing...

    You must add a Parameter object before executing the query. Examples of how to do so can be found at:
    VBA,ADO connection an query parameters
    or
    How to invoke a parameterized query using VBA
  11. Replies
    3
    Views
    553

    Yes, I did and got the same error. Following...

    Yes, I did and got the same error.

    Following code did circumvent the problem:

    SELECT Code,
    Name,
    ISNULL([2012],0) as [2012],
    ISNULL([2013],0) as [2013],
    ISNULL([2014],0) as [2014]
    FROM...
  12. Replies
    3
    Views
    553

    Struggling with t-SQL PIVOT

    Following code works perfectly with my SQL Server 2008R2 data base:

    SELECT Code,
    Name,
    [2012] as [2012],
    [2013] as [2013],
    [2014] as [2014]
    FROM (SELECT C.Code,C.Name,D.DivYear,D.Amount...
  13. Thread: Table Headers

    by rvWoody
    Replies
    2
    Views
    271

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

    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...
  15. Replies
    4
    Views
    571

    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...
  16. Replies
    10
    Views
    7,270

    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...
  17. Replies
    5
    Views
    1,264

    Try...

    Try [tblValuations]![CreateValuation]>=[reportdate] and [tblValuations]![CreateValuation]<=[reportdate2]
  18. Replies
    10
    Views
    7,270

    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...
  19. Replies
    10
    Views
    7,270

    @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...
  20. Replies
    10
    Views
    7,270

    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.
  21. Replies
    10
    Views
    7,270

    Setfocus in unfortunately not a worksheet method!

    Setfocus in unfortunately not a worksheet method!
  22. :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:...
  23. Replies
    2
    Views
    3,651

    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
  24. @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...
  25. 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. ...
Results 1 to 25 of 103
Page 1 of 5 1 2 3 4