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!

  • Congratulations strongm 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. toekneel

    populating dropdownlist programatically

    Thanks for the input. I have just finished polishing this on my own before your posting went up, and the solution was pretty much along those lines. The first important step was to "disconnect" the dropdownlist from any data source on the smart tag, so that "select a data source" was equal to...
  2. toekneel

    populating dropdownlist programatically

    The datasource I'm using here is a SQL Data Source based on a query in a lookup table. I would not want the value to permanently populate that lookup table. I'm not certain how I would populate the datasource that I'm using here. Essentially, what you've suggested is what I'm performing with...
  3. toekneel

    populating dropdownlist programatically

    I'm using Visual Studio 2005, VB... hope this is the right forum to post this question in. I have multiple dropdownlists that are populated from a lookup table. In that lookup table, the user is allowed to flag an item as inactive so that it does not show up any longer in future drop down...
  4. toekneel

    specified buffer size too large for file import

    ...2) put the data with the longer text at the top of the file. Tried that, but no effect. Other articles have suggested exporting the file to *.txt or *.csv, but neither of those are working with SQL Server. Other articles suggested making certain that SP4 is loaded. I can and did load that...
  5. toekneel

    Viewing actual SQL code sent to database via DataSources

    I guess that puts me back to square one, doesn't it! :) Any idea how to do this in Visual Studio 2005? I'm using SQLDataSources; attempting to read what the select statement is and hoping to be able perhaps to modify the SelectCommand for the SQLDataSource at runtime in order to pull this off.
  6. toekneel

    Viewing actual SQL code sent to database via DataSources

    ...exactly like I want to see it, which is how I would have built the query myself in code. I would have an end result that would look like Select * from TABLE where STATE = 'New Mexico' rather than Select * from TABLE where STATE = @Parameter This allows me to verify the exact way that the...
  7. toekneel

    Viewing actual SQL code sent to database via DataSources

    Thanks for the help. It still doesn't present it in the way that I'd like to see it- this is essentially joining what I had been doing before into one string- but it is easier to see and work with than what I had been attempting in VB.NET. I'll play with this and see if I can resolve my issues...
  8. toekneel

    Viewing actual SQL code sent to database via DataSources

    I can't say that I've ever heard of that. Is that embedded in Visual Studio? Will I find information there explaining how to use that? Thanks!
  9. toekneel

    Viewing actual SQL code sent to database via DataSources

    I'm working in Visual Studio 2005 with VB.NET. In the 2005 environment, you can work with GridViews and other helpful tools that do the work for you so that you don't have to build much code. That would be fine and good, but when problems arise, troubleshooting is difficult. Quite often I...
  10. toekneel

    SMTP_E_MAILBOX_UNAVAILABLE_2(550)

    I took this back to the group in our company that handles this. They had a change in the SMTP server that had not been communicated to me. I had been assuming that the issue was that the SMTP needed to know what user ID was attempting to send the mail, but I was wrong! When I changed the...
  11. toekneel

    SMTP_E_MAILBOX_UNAVAILABLE_2(550)

    I'm having an issue that I see often when I google it. I can e-mail a report within the company, but fail when attempting to e-mail outside the company with this error message: "SMTP_E_MAILBOX_UNAVAILABLE_2(550)". The e-mail addresses are verified as legitimate e-mails, but none of the fixes...
  12. toekneel

    Crystal Reports Windows\Temp files not deleting

    We've been wrestling with this for awhile and finally found the answer to the problem. Figured I should post it here so that others could reap the benefits. Our program was built in Visual Studio 2005 but we have also experienced this problem with deploying Crystal Reports in a Visual Studio...
  13. toekneel

    convert WordPerfect 10 QuickCorrect to Word 2003 autocorrect

    Here's the code that finally worked- loaded all 1924 entries in a nanosecond! (intA represents the row number, and I'm using column A for the code value and column B for the converted value) Public Sub sbAddAutoCorrect() Dim strCode, strConvert As String Dim intA As Integer For intA = 1 To...
  14. toekneel

    convert WordPerfect 10 QuickCorrect to Word 2003 autocorrect

    I've refined this code to this: Public Sub sbAddAutoCorrect() Dim strCode, strConvert As String Dim intA As Integer For intA = 1 To 1924 strCode = Cells(intA, "A").Value strConvert = Cells(intA, "B").Value With Application.AutoCorrect .AddReplacement strConvert, strCode End...
  15. toekneel

    convert WordPerfect 10 QuickCorrect to Word 2003 autocorrect

    Just to update progress here... this is my code as it stands: Public Sub sbAddAutoCorrect() Dim strCode, strConvert As String Dim intA As Integer For intA = 0 To 4 intA = intA + 1 strCode = Cells(intA, "A").Value strConvert = Cells(intA, "B").Value 'AutoCorrect.AddReplacement...
  16. toekneel

    convert WordPerfect 10 QuickCorrect to Word 2003 autocorrect

    I'm finally getting a chance to dig into this a bit more. The previous threads that I found did not answer my questions- the direction given did not work for me, as the initial Word Perfect file was not existent. I converted the list into a text file, working with Excel to pull it off fairly...
  17. toekneel

    convert WordPerfect 10 QuickCorrect to Word 2003 autocorrect

    I have not been able to find wtspllen.exe, either on the pc or on a google search. I can work at converting that file manually until/unless I can find that. Thanks for all of the input here- I believe this is giving me good direction for accomplishing this task! I will post my finding after...
  18. toekneel

    convert WordPerfect 10 QuickCorrect to Word 2003 autocorrect

    ...and for the last five years has amassed quite a large QuickCorrect file in WordPerfect 10. She's shifting to a new company now and is needing to move over to Word (we have 2003 already available, as well as 2007). How can I convert her WordPerfect *.uwl file into a Word *.acl file?
  19. toekneel

    deleting Crystal Reports temp files created in .NET application

    We are using CR XI- the problem still exists. I've tried scouring the knowledge base already, and I'm glad to hear that I'm not the only one who feels that way about the Business Objects support center in India... when I've complained to our reps they make me feel like I'm the only one who has...
  20. toekneel

    deleting Crystal Reports temp files created in .NET application

    My report file is just that- an *.rpt that is generated at run time when it is displayed in the report viewing tool. Therefore, I have no file name to delete the temporary report.

Part and Inventory Search

Back
Top