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 Rhinorhino 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: *

  • Users: zatch
  • Content: Threads
  • Order by date
  1. zatch

    e-mail warnings

    Hello - Does anyone have any thoughts as to how one would e-mail a list of warnings and/or e-mail an entire log file? I am trying to notify myself when the OnWarning event fires on a package. I can not figure out to access the log files. Thanks. Mitch
  2. zatch

    Any Thoughts?

    Hello - I'm using SSIS to download/process text files. I have a 99% completed project. There is one small step which I cannot figure out how to do. I'm hoping you have some suggestions. When a file fails to process or has validation errors, I want to e-mail a user group and notify them...
  3. zatch

    Get attachments from Exchange?

    Hello - I'm just curious to see if anyone has ever had (or has) any ideas about how one would tap into an Exchange Server and grab message attachments using SSIS and/or .net. I'm just looking for a solution where I don't have to have a mail client (Outlook) running on a server at all times to...
  4. zatch

    Datagrid LinkButton

    I have a datagrid - datagrid1. At runtime, I am adding a ButtonColumn (Link Button) like so: Dim bc As New ButtonColumn bc.HeaderText = Format(dr.Item("PAYMENT_DATE"), "Short Date") bc.DataTextField = Format(dr.Item("PAYMENT_DATE"), "Short Date") bc.Text = Format(dr.Item("PAYMENT_DATE")...
  5. zatch

    Rebind Datagrid

    Is it completely necessary to update the database and refresh the dataset which the grid is bound to in order to get the datagrid to rebind to the dataset? sqldataadapter.update(sqldataset) sqldataadapter.fill(sqldataset) datagrid.databind I'd like to make changes only in the dataset itself...
  6. zatch

    control disposal

    I have a form with eight textbox controls on it. I have the following procedure which should delete each of the textboxes. What it really does is delete every other textbox on the form. I click a button to call the "Clear_Tbox" procedure and what I'm left with are Textbox2, textbox4...
  7. zatch

    SQL Server Going Nuts!

    On Sunday evening I restarted our SQL machine (which is running on MS SBS 2000 along with Exchange.) Until the last hour or so (Wednesday, noon) CPU usage stays between 15 and 30 percent normally. Now, all of the sudden, the processor is bouncing all over the place - from 5 to 100 and...
  8. zatch

    Trim 0's

    I have varchar field whose data looks similar to this: 0000345 0023456 0123456 0000001 What I need to do is "trim" the zero's from the beginning of each record. Any help is greatly appreciated. Zatch
  9. zatch

    Keep datagrid from refreshing

    I have a datagrid which I allow the user to update the data within. Unfortunately, after about a minute or so, the datagrid refreshes itself and the user loses all of the data which they had updated. Anyone seen this happen before? I would like to just shut off the datagrid refresh if...
  10. zatch

    External Mail Issue

    Thanks in advance for helping out a DNS newbie. We have AD domain with domain name = x.local. Within this domain is a mail server that hosts the domain y.com (not the same domain as the AD.) We have a few users that work on notebooks and I'd like to give them access to Exchange Server through...
  11. zatch

    Skipping Hidden datagrid columns

    I have a custom datagrid with hidden columns (.Width = 0) When I tab through the datagrid, the cursor stops in these columns even though they are hidden (disappears.) I can't seem to find a way to make the tab skip these columns. Anyone have a good method of accomplishing this? Thanks.
  12. zatch

    Everything Disappeared!

    I have a form with many controls on it. All of the sudden, no controls are visible on the form except for the Menu. Completely blank otherwise. It looks like the code is still there for all of the controls, and all of the controls are available in the Properties Window but missing from the...
  13. zatch

    Update Query

    I'm a beginner with SQL queries, so any help would be greatly appreciated. I have the following select query which basically calculates the invoice amount for the client for next year depending on the number of current employees they have: SELECT employer_plan.employer_unique...
  14. zatch

    Start Information Store

    I was trying to stop and start the information store service. It failed and is now in "Stopping" status. How can I restart this service?
  15. zatch

    Insert to two related tables

    I need to run a query which inserts to two related tables where the parent table has an identity field. Table A - Employer Employer_Id (Identity Field) First_Name Last_Name Table B - Employee Employer_Id (Foreign Key) First_Name Last_Name I have no problem selecting and inserting the data...
  16. zatch

    Dataview Dates

    I am displaying values from a database on my form with textboxes which pull data from a dataview. I then update the data in the textboxes to update the dataview and eventually the dataset. This works fine for everything except when I try to update date fields to null. When I try to update a...
  17. zatch

    Replace files?

    I have built a .NET app which clients access from a file server. The app runs mostly fine for all users on the network. The problem is that I cannot replace the files while others are using it. I was under the impression that with .NET framework and No-Touch deployment (which I am probably...
  18. zatch

    Error Message - Index was out of range.

    I am getting an error that reads: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index." I have my main form, which I'll call form1. On form1 I have a button that launches form2. form2 is setup to search our database and...
  19. zatch

    dataview rowfilter

    This seems like it should be easy, but I just can't figure this one out. In the example below, I have been successful in filtering out rows where [call_due] = (today). What I really want to do, however, is filter where [call_due] is null. I'm sure the answer is simple, and I hope someone can...
  20. zatch

    Crystal Checkbox?

    Is there a way to show boolean data as a checkbox in the version of Crystal Reports included with .NET? I don't see any option in the designer nor do I see people talking about one. Any knowledge is greatly appreciated. Zatch

Part and Inventory Search

Back
Top