Search results for query: *

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

Hey-o, Anyone have a clue how to connect to a Sybase Server via VBA? (This would be from Excel 2003.) 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...

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

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

Is it possible to create a multi-dimensional arraylist (not an array)? Dale

Anybody know how to save (publish) a Vision Drawing as a web page through .NET? I have a little app that takes various files formats (all MS) and converts the files into an HTML format (or version thereof). This is done through com objects, so converting a Word or Excel file is relatively...

Howdy, I know this is not all that complicated, but experiencing a bit of brain fade today... How do I check if a folder exists, and if not then create it? Dale

Howdy, Not sure this is right forum, but... We have developed an app for Pocket PC that uses SQLCE as the backend. It uses Merge Replication to synchronize with the main SQL Sever authenticating with Active Directory via an IIS box. Our IIS box went down and we are in the midst of replacing...

Hey there, Does anyone know if you can use images in a treeview, but only for certain nodes? As an example: - root node (no image) | |- child node (with image) So far I've only managed all or nothing. Dale

Howdy all, This is more a curiosity than a need.... Is it possible to add a description to a method so when you are coding and you reference that method you know just what that method does? As an example, if you are using an intrinsic .NET method, say object.New(), when you type the '.' you...

This may be the wrong place to post this, but... I have a VB.NET app that connects to an MSDE db. The app has an option to backup the db, which works very well. Essentially, I disconnect the app from db, use osql to create the backup via a script file, then re-connect the app to the db. I am...

This may be the wrong place to post this, but... I have a VB.NET app that connects to an MSDE db. The app has an option to backup the db, which works very well. Essentially, I disconnect the app from db, use osql to create the backup via a script file, then re-connect the app to the db. I am...

I have a dataset with several datatables created at runtime. One of these tables has a compound primary key (2 columns). The problem I am running into is deleting rows from this datatable. I'm not sure how to pass the compound key. What I have been using for datatables with a single column key...