I have written a VBA function that I have been using in various queries in Access. But I have a table on SQL Server that I want to be able to use it on via a Pass-Through Query, but I get an error...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello Vee Bee Actuarials
I have a spreadsheet to which I have added several command buttons, which run some VBA.
I've found that sometimes, when I click a button, the caption reduces in font size....
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
If my .CSV file has
"1","","3"
and Field2 (the middle one) is text with properties Required:Yes and AllowZeroLength:Yes, then why can't I import that record? Why doe...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
So, the new 45nm Pennryn chips have been out for a while (Dual Core = Wolfdale; Quad-Core = Yorkfield). The next set will be Nehalem (Quad Core = Bloomfield) and from what I've read the Extreme v...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have made a menu using VBA (within Excel) that allows me to go to different sheets of a workbook or different workbooks located at different subdirectories. For example,
Workbooks.Open Fil...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Suppose I buy a Computer. I want to be able to read and write to CD's. But the only two choices for the type of drive are 1. DVD-RW drive and 2. Blu-Ray drive.
Please comment on the likelih...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
What is XL array and how does it work? (Not VBA)
Thanks
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
starting yesterday, when i go to facebook here in the office, it looks funky, but my coworker's page is normal. we're on the same server at work. why would there be a difference? more important...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
for the life of me, i cannot get this to work...
here's the code i began with:
Code:
Sub BiSectionVolTR(index As Long)
Dim VolLBound As Double
Dim VolUBound As Double
VolLBound...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I often write statements like:
debug.print = "MyVar is equal to " & MyVar
I'd like to generalize this:
Function Message(v as variant) as string
Message = name(v) &am...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all. Running Windows Vista Home Basic. The Automatic Updates feature keeps bugging me to install a security fix for PowerPoint 2007. Even though I do not own a copy of Office of any year on thi...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello all
lets say I have the following numbers in 5 cells
1 4 3 5 2
But I want to get an average of the top three numbers , ie 3,4 and 5
How do I go about doing this...using the r...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
i was going to hijack another thread, but i think this really deserves it's own space.
i'm in a similar boat with the new house number about getting calls for someone else and the annoying aut...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I kind of like gator.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
it's almost all free, but what do you use the most? here's my list: KDE, vim, gcc, perl, open office, firefox, R, quantlib, boost, python, and irssi.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Handbrake [http://handbrake.fr/]> - convert your DVDs to movies playable on your Mac, AppleTV or iPod.
SuperDuper! [http://www.shirt-pocket.com/SuperDuper/SuperDuperDescription.html]> - create boo...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
you know how when the cursor is on a cell you can see the contents of that cell in that bar near the top of the screen...it's kind of like an address bar?
well, that thing disappeared on me and ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Last night, and again this morning, my speakers started making what are, to me, spurious sounds.
There's a short tone every few seconds, perhaps around high-c, and the rest of it sounds like...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Our house keeps getting phone calls from an extraterrestrial realm. At least I think so - the caller ID says "out of area." The few instances when I answer I get a faint voice asking for...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
My program needs to open a file before running thus has a waiting time upfront. I want to show a msgbox ("Please wait while...") without stopping the program. Any suggestions? Thanks.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
i'm trying to fix a problem on my parent's computer. the images that come up on ANY webpage in their Internet Explorer browser come up blurry. even if someone sends an email to their hotmail acc...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I have a column of about 3000 names and I want to isolate those that appear more than once. Is there a way to do this? Much appreciated.
Clam Chowdah
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Just discovered something annoying.
Let's say I have a access query
Select myKey, sum(myLongInt) as TotalLongInt
From myTable
Group by myKey;
where myLongInt is defined as a Long in ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Temporary Error (502)
We’re sorry, but your Gmail account is currently experiencing errors. You won’t be able to use your account while these errors last, but don’t worry, your account data and me...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
A simple version I know of is something like this:
Set xlApp = CreateObject("EXCEL.APPLICATION")
Set xlBook = xlApp.Workbooks.Open("excelfile.xls")
Set xlSheet = xlBoo...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
