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

    References

    I called Microsoft using one of our MSDN incidents. Basically Office is designed for interactive usage and they do not recommend automating it with an unattended application. They also do not support Office being installed on a server because it is not designed to work on a server. Here is a...
  2. KreativeKai

    References

    I have a windows form application written in VB.NET 2005 which opens Excel, imports a text file into a worksheet and e-mails it to the end-user. Everything works fine when it is on my own system, but when I put the executable file on the server along with all the other files in the bin\release...
  3. KreativeKai

    Excel VBA to VB.NET conversion

    Thanks for your help. I couldn't get your solution to work, but your feedback is appreciated. I found a solution at: http://gotdotnet.com/Community/MessageBoard/Thread.aspx?id=363074&Page=1#363383 Thanks again. Lost in the Vast Sea of .NET
  4. KreativeKai

    Excel VBA to VB.NET conversion

    I have the following code in Excel VBA that I'm trying to convert to VB.NET: Workbooks.OpenText(Filename:= _ "C:\temp.txt", Origin:=437, StartRow:= _ 1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, TAB:=False, Semicolon:=False, Comma:=True _ ...
  5. KreativeKai

    Datagrid focus or lack of focus?

    I tested this and tried to type once this code was executed and had no luck. I put a breakpoint in to the program above the suggested logic to make sure it was being executed. It is being executed and it is the last line of code other than an End If and a End Try that is being executed. Any...
  6. KreativeKai

    Help debugging runtime error

    Usually I go back to the code and make sure every Sub has Try Catch logic. Usually you can find out where your application is failing and the program will report the error under your control. In my catch I do the following: Catch ex as Exception dim strRefInfo as string strRefInfo =...
  7. KreativeKai

    Datagrid focus or lack of focus?

    I want the cursor to actually be in the cell as if the user was to start editing it. DataGrid1.CurrentCell = New DataGridCell(0, 1) doesn't do this. I want the client to click on the treeview entry and after I load the appropriate data from SQL into the datagrid, I want to put the cursor in...
  8. KreativeKai

    Datagrid focus or lack of focus?

    With the datagrid I get the message "'Rows' is not a member of 'System.Windows.Forms.DataGrid'" Thanks for the suggestion. Lost in the Vast Sea of .NET Visit my website at www.komputing.com
  9. KreativeKai

    Datagrid focus or lack of focus?

    Here is the code I've used which works. DataGrid.CurrentCell = New DataGridCell(0, 0) SendKeys.Send("{TAB}") SendKeys.Send("{TAB}") SendKeys.Send("{TAB}") SendKeys.Send("{HOME}") Like you said, this just doesn't seem like the best way to get focus on a datagrid. Does anyone have a better...
  10. KreativeKai

    Datagrid focus or lack of focus?

    I have an application that has a treeview setup. Depending on the node selected on the treeview a datagrid is loaded with appropriate data from SQL. At this point the treeview shows with the node highlighted and the datagrid is displayed with the data. I want to have the cursor positioned in...
  11. KreativeKai

    Combobox question

    Thanks for the suggested link, but I'm not subscribed to experts-exchange so I can't see the solution. The article looks like it is more geared towards changing the color of the item selected. I'm actually interested in having the drop down list show active employees in the list as bold and...
  12. KreativeKai

    Combobox question

    I have a program which reads a series of employee names and ID numbers into a dataset and then sets the datasource of a combobox to that dataset. Below is some of the logic: .cbxEEName.DataSource = ds.Tables("EmpmastTbl") .cbxEEName.ValueMember = dt.Columns("EmpID").ToString...
  13. KreativeKai

    Events and Windows NT

    Microsoft has been working with us for a few days with a MSDN call. The information that has come out of their research is that service pack 6a along with framework 1.1 and the patch for 1.1 is not enough. The version of user32.dll (which contains the win32 ComboBox) is not up to date to...
  14. KreativeKai

    Events and Windows NT

    Yes, we've actually double checked the framework service packs and they are the same as the XP machine. The NT image is 4.0 SP6a with framework 1.1 and all the patches. Any other suggestions? Lost in the Vast Sea of .NET Visit my website at www.komputing.com
  15. KreativeKai

    Events and Windows NT

    I have coded a combo box to auto complete based on a collection of names that I load. The combo box is working great in Windows XP, but when we run the same application in NT the events for the combo box don't seem to all work. Are there some events that do not work in NT but work on 2000 / XP...
  16. KreativeKai

    Text Completion for a Combobox

    Thanks for the sample!! It was a little more complex than what I really needed. I found some good advise and samples that I used from gotdotnet.com. Here is the link: http://www.gotdotnet.com/Community/MessageBoard/Thread.aspx?id=309355&Page=1#310071 All the samples everyone gave me and the...
  17. KreativeKai

    Text Completion for a Combobox

    I have a combobox populated with 1300+ names. I want to make it easier for my data entry clerk to enter the last name, and it pulls from the list. I found the following link: http://support.microsoft.com/default.aspx?scid=kb;en-us;320107 This knowledgebase article lists some code that...
  18. KreativeKai

    Question on UNION syntax

    Well, I’ve posted my question on two message boards and received several suggestions. First of all Thanks for all your feedback and help!! Below are the two approaches that I’ve received and I’ve tweaked them to get the result set I was looking for. Table one includes everyone on our...
  19. KreativeKai

    Question on UNION syntax

    I'm new to SQL and trying to understand what is most likely a simple question. I'm trying to use UNION to pull together a result set of Name and Employee Number. Unfortunately there are duplicates in the two tables. The UNION syntax is supposed to weed out duplicates, but I have this situation...
  20. KreativeKai

    Treeview question

    This might be a simple question, but I can't seem to find an answer... I have a tree view with several parent nodes and three child nodes under the last parent. For all the parents I can change the individual forecolor using the following: .Nodes(1).ForeColor = System.Drawing.Color.Black How...

Part and Inventory Search

Back
Top