# Search:

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

Page 1 of 5 1

## Search: Search took 0.01 seconds.

by rvWoody
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...

by rvWoody
Replies
11
Views
149

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...

by rvWoody
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...

by rvWoody
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

by rvWoody
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.

by rvWoody
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.

by rvWoody
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...

by rvWoody
Replies
19
Views
1,814

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. ## Thread: Struggling with t-SQL PIVOT

by rvWoody
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. ## Thread: Access 2010 Query Filters - "Too few parameters. Expected 7"

by rvWoody
Replies
3
Views
462

### 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:
or
How to invoke a parameterized query using VBA
11. ## Thread: Struggling with t-SQL PIVOT

by rvWoody
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. ## Thread: Struggling with t-SQL PIVOT

by rvWoody
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...

by rvWoody
Replies
2
Views
271

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. ## Thread: Remove Automatic Update Warnings?

by rvWoody
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. ## Thread: Remove Automatic Update Warnings?

by rvWoody
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. ## Thread: I want Excel always on top

by rvWoody
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. ## Thread: Help with formula

by rvWoody
Replies
5
Views
1,264

### Try...

Try [tblValuations]![CreateValuation]>=[reportdate] and [tblValuations]![CreateValuation]<=[reportdate2]
18. ## Thread: I want Excel always on top

by rvWoody
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. ## Thread: I want Excel always on top

by rvWoody
Replies
10
Views
7,270

But let me briefly describe the pretty standard application. When access is opened it performs some actions (retrievals) on the...
20. ## Thread: I want Excel always on top

by rvWoody
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. ## Thread: I want Excel always on top

by rvWoody
Replies
10
Views
7,270

### Setfocus in unfortunately not a worksheet method!

Setfocus in unfortunately not a worksheet method!
22. ## Thread: How to convert a single field recordset into a VBA variable?

by rvWoody
Replies
4
Views
3,139

### :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:...

by rvWoody
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. ## Thread: How to convert a single field recordset into a VBA variable?

by rvWoody
Replies
4
Views
3,139

### @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. ## Thread: How to convert a single field recordset into a VBA variable?

by rvWoody
Replies
4
Views
3,139

### 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