Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    19
    Views
    1,500

    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
  2. Replies
    19
    Views
    1,500

    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.
  3. Replies
    19
    Views
    1,500

    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.
  4. Replies
    19
    Views
    1,500

    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...
  5. Replies
    19
    Views
    1,500

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

    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...
  7. 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
  8. Replies
    3
    Views
    385

    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...
  9. Replies
    3
    Views
    385

    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...
  10. Thread: Table Headers

    by rvWoody
    Replies
    2
    Views
    251

    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...
  11. Replies
    4
    Views
    560

    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...
  12. Replies
    4
    Views
    560

    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...
  13. Replies
    10
    Views
    6,879

    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...
  14. Replies
    5
    Views
    1,147

    Try...

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

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

    @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...
  17. Replies
    10
    Views
    6,879

    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.
  18. Replies
    10
    Views
    6,879

    Setfocus in unfortunately not a worksheet method!

    Setfocus in unfortunately not a worksheet method!
  19. :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:...
  20. Replies
    2
    Views
    3,345

    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
  21. @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...
  22. 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. ...
  23. Replies
    10
    Views
    6,879

    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...
  24. Replies
    2
    Views
    3,101

    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.
  25. Replies
    2
    Views
    3,101

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