The RANK() function Help says the REF argument can be an array. However, I can find no way to make it accept anything except a reference to a worksheet Range. For example, the ARRAY() function causes an error. Has anyone out there been able to make it work with anything other than a Range? TIA...
Thanks SemperFi. I have more questions. First, I need to clarify the requirement a little (sorry...)
My user wants connected list boxes like you see in the Access query design window, where there is a line connecting 2 tables visually showing the SQL Joins. To make it harder, the lines, as you...
Something like this works in Access VBA:
Dim oXL As Excel.Application
Dim oBook As Excel.Workbook
Dim oSheet As Excel.Worksheet
' Create a new instance of Excel and make it visible.
Set oXL = CreateObject("Excel.Application")
' Add a new workbook...
A user asked me: " would like to visually link items in two list boxes similar to the way the QBE interface in MS Access works. Does anyone have any ideas on how to do this?"
In other words, 2 list boxes connected by a line which links a single item in one list with a related item in...
Anybody know if there is any way to capture the pressing of the <alt> key in Excel 2k VBA the way you can in VB using the KeyPreview event?
Thanks in advance!
In Access 2k, trying to do an incremental search of an already-populated (and sorted) multiselect list box using a text box for the criteria. want to cause the list box to scroll to the first item that matches the characters in the text box. works when multiselect is set to none, but not when...
OOPS! Again. Good catch. Bummer.
I should have read Help:
"Before division is performed, the numeric expressions are rounded to Byte, Integer, or Long expressions"
...need for the DateAdd() step entirely.
With the Integer Divide operator, your formula works with no function calls at all, just pure math
Function GetWeekEnding(dDate As Date) As Date
WeekEnd = ((dDate + 5) \ 7) * 7 + 1
GetWeekEnding = WeekEnd
End Function
No criticism intended. (:>)
Not really an answer to your question, but I often use a very good freeware package called PrettyCode.Print located at
http://www.vbcity.com/page.asp?p=pcp_index
No nag screens, no expiration, very stable, and totally free.
It prints in color (a major irritation with the VB Editor) and works...
Can't get Fix((vDate + 5) / 7) * 7 + 1 to give the desired result.
but ((vdate + 5) \ 7) * (8 - vdate) works for me.
(note the divide is a "\" for the Integer divide operator, not the usual "/" standard divide operator. this is faster than a Fix() function call.)
Of course...
By default, the Access97/2000 querytimeout property is set to 60 seconds.
Is there any way to change the DEFAULT value for ALL new queries? We know how to change it for individual queries thru the properties dialog in design mode, but that is not an acceptable alternative in our environment...
And here's another twist (MUST set "Option Base 1" at top of Module):
Option Base 1
Function GetWeekEnding_a(dDate As Date) As Date
''' determines Sundays (Week Ending) date from _
any date entered into the table _
if entered date is already a Sunday, _
keeps the...
...'Original date argument, modified to next following Sunday
sDate = dDate 'Set date to argument date
vdate = Weekday(dDate) 'Gets integer of weekday of argument
GetWeekEnding = DateAdd("d", (vdate > 1) * (vdate - 8), sDate)
End Function
Is there a way to add a Tip Text to a Command Button on an Excel Worksheet (NOT on a button bar and NOT on a form - the button is directly on the worksheet)?
Command buttons don't appear to have the ControlTipText property when used this way.
Using Excel 2k, Office2k, Win2k
I recorded this but when I play it back, it fails with
Runtime error '1004': 'PasteSpecial method of Range class failed'. I can't locate the xlDataValidation constant in my Object Browser, but all the other "Paste:=" constants show up. Is this a known bug in Excel? Any ideas? Anyone...
The best I have seen is the Access-VB-SQL Advisor article by Brian Wells in the March 2000 issue, page 20-25, titled "Access Table Linking Made Easier".
See their web page for a download file of all the code:
http://advisor.com/doc/04778
You can download the code free, but the...
Looks like it should work, but since it doesn't you might try reworking your logic to move the "Set objOutlook" statement somewhere before you start looping, therefore only opening Outlook once. (That's the way the code in the FAQ example is written.)
For what it's worth, here's some...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.