Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AccordingToDale

    change datatype in a replicated table

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

    Connect to Sybase Server - vai VBA

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

    Test for Empty String() Array

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

    Email Worksheet Selection as Body

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

    Loop Through a Query to Find Particular Values

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

    Multidimensional Arraylist

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

    Save Visio Diagram as Webpage

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

    Check if Folder Exists

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

    Merge Replication with SQLCE error

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

    Treeviews and Images

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

    Adding a Method Description

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

    Restore MSDE db from VB app

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

    Restore MSDE db from VB app

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

    find a row in a datatable with a compound key

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

Part and Inventory Search

Back
Top