Search results for query: *

thnx for the reply. got me pointed in the right direction. for anyone interested.... -- step 1 -- create a temp column in table to hold data -- while altering schema exec sp_repladdcolumn @source_object = 'Table_Name' , @column = 'Temp_Column_Name' , @typetext = 'ntext NULL' ...

hey, been a while since i've been here - new job doesn't let me spend time on forums. anyway... what i need: alter a column by changing from nvarchar(500) to ntext. (simple, right?) the issue: the table is part of a merge publication. can i alter the column w/o dropping the publication? if...

well, some figured it out! ;>) must be monday or something. d

recursion is definitely the way to go. something like... Sub doOutline(hierarchyDepth As Integer, lastRow As Long, _ objSheet As Worksheet, objApp As Excel.Application, _ testValue as long) Dim currentlevel As Long Dim ix As Long Dim topRow As Long Dim bottomrow As...

i'd give you a start if i could figure out how!!!

fantastic. thanx. d

i already checked there -- i have it bookmarked ;>) i think i might be missing something though. i cannot find either ADO or ODBC as a reference to add to my project (i'm assuming i need to add a reference). so i can't create a connection object. thots? d

Are you making any references in you code to this addin? And if so, are you cleaning up? e.g. dim o as object set o = new object ...do whatever o.close set o = nothing d

Hey-o, Anyone have a clue how to connect to a Sybase Server via VBA? (This would be from Excel 2003.) d

Actually, I don't think it resolves at all. I just tried it out. Was just sort of one of those... "hmmmm.... I wonder if this works!" D

Unfortunately this only tests if the variable is an array, but not if the array is empty. What I think I will end up with is: In some function I'll call an validation function If validateArray(Attachment) Then 'do something end if then... Private Function validateArray(arr...

Try something like: ' Resolve each Recipient's name. For Each myRecipient In newMail.Recipients myRecipient.Resolve Next D

Any idea how to test if an Array has any elements? (Other than trapping the error.) In other words, if you try to get a value from an Array (or for that matter, try to get the UBounds) that has no elements, you get an "Subscript Out of Range" error. How do you avoid raising that error? This...

Found something that works perfectly. Thought I'd post the code in case anyone one else wants it. Sub sendRange(ByVal rngeSend As Range) 'Sends a specified range in an Outlook message and retains Excel formatting '************************** 'http://www.danielklann.com...

Hi all, Not much of a VBA guy, but... In Excel you can select a range and email that selection. The selection is 'pasted' (formatting intact) in the body of the email, not sent as an attachment. What I want to do is accomplish that through VBA. I can send a workbook as an attachement, but I...

i am dealing with 3 recordsets. each containing anywhere from 2 to 15 records. depending on the number of records and the values returned makes all the difference as to what i do with the data. the query is also dynamic, based upon user input. it's actually very straight forward to loop...

ahhh. got it.

Hi, I'm not a big VBA or Access guy, so... Anyone know how to loop through an MS Access Query in VBA? This is for a code module in Access. What I need to do is loop through the Query and write certain values to an Excel Worksheet. The writing to Excel is no problem, but I have no idea how...

did you ever get this to work? Dale

[blush] kisses?!?! glad it worked. :>) Dale