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...
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...
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...
I've been all over the internet looking for a resolution on this one, and have not succeeded.
I'm trying to import an Excel file into SQL Server 2000. It fails with the error message that "specified buffer size" is too small.
Here's what I have tried so far...
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.
It still doesn't put it 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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
My wife works as a medical transcriptionist, 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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.