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!

Recent content by RobHudson

  1. RobHudson

    Textbox 2.0 Float Over MSHFlexGrid

    hehehe! No worries - I now the feeling ;)
  2. RobHudson

    How to truncate an oracle table from ms access

    I haven't done this in Oracle but have in MSSQL. I have historically used a pass-through query. This allows you to use Oracle (or MSSQL) statements direct through Access. You need to configure the query to use a connection string to your Oracle DB. Maybe the same ODBC you are using to link your...
  3. RobHudson

    Textbox 2.0 Float Over MSHFlexGrid

    Thanks everybody for your responses :) I wasn't aware that the good old DataGrid was unicode enabled - should have tried that really :$ Using the DataGrid solves it for me. @strongm: Out of interest, where is the Hwnd accessible from and with access to it, would you be able to force the...
  4. RobHudson

    Textbox 2.0 Float Over MSHFlexGrid

    I'm sure I'm not the first to have this issue, but I can't seem to find any advice :( I have a MSHFlexGrid and a textbox from the Forms 2.0 Object Library. I am trying to do the usual trick of overlaying the textbox on the grid to allow for editing. Unfortunately, the textbox is not shown over...
  5. RobHudson

    Access form controls via a different thread (BeginInvoke)

    Hi Jason. I did look at the AsynchronousExecutor example, but I couldn't understand it :$ The ISynchronizeInvoke (I had to change it to Control for the Compact Framework) made more sense to me so I used that. Cheers Rob
  6. RobHudson

    Access form controls via a different thread (BeginInvoke)

    Top man! I followed the first example in your FAQ and got it working! I did a little modding to get it working by adding: public delegate void Action(); And making the Perform call as follows: Perform.ThisAction(delegate() { txtLink.Visible = true; }).Against(this); I wasn't able to do...
  7. RobHudson

    Access form controls via a different thread (BeginInvoke)

    Hi I am trying to get access to form controls from a separate thread to that of the application. After some hunting I found this article: http://www.csharp411.com/manipulating-controls-across-threads/ which has helped :) As I have a number of controls that I need to reference and control I...
  8. RobHudson

    Using a function in CONATINS

    Thanks markos :) It's quite an interesting way of improving my routine. But I still have the underlying problem of not being able to use SUBSTRING inside a CONTAINS. They are using a LIKE and given the vast amount of data I am dealing with LIKE is extremely slow compared to the CONTAINS.
  9. RobHudson

    Using a function in CONATINS

    Thanks hmckillop. It is the 2nd scenario that I need to use where the filter is the column (or SUBSTRING on the column). Using the INNER JOIN gave a similar error message, I also simplified it by using (and getting the same error): SELECT *, SUBSTRING([MyCol], 2, 3) AS SubStringField...
  10. RobHudson

    Hyperlink in email not working

    It might have just been a typo when typed it in here but it should read: SET @Text8 = '<a href="c:\windows\system32\mstsc.exe%20%2Fconsole">Click Here For Action Log</a>' If that does not work, then I'm afraid I can not help :( maybe try and find a more email/html orientated forum. Good luck!
  11. RobHudson

    Using a function in CONATINS

    Hi I have a free text index set up on a column in my table. I need to use a SUBSTRING inside the contains but get the following error: Msg 102, Level 15, State 1, Line 15 Incorrect syntax near 'SUBSTRING'. This is an exmaple of the clause: AND NOT CONTAINS([mytable].[mycol]...
  12. RobHudson

    Hyperlink in email not working

    Is it becuase you need to HTML encode the " /console"? Something like: mstsc.exe%20%2fconsole I think %2f is "/" you may have to check...
  13. RobHudson

    RGB Colours Between Excel and Word

    Hi Tony Thanks for that :) I wondered whether it might be a palette issue. Interestingly (or not!), I still get the colour difference in 2007 as well as 2003. I'm guessing the solution is to add the colours to the Excel palette either way. Adding multiple colours to the palette - is it...
  14. RobHudson

    RGB Colours Between Excel and Word

    Hi I am using Word and Excel and need to set the colour of a series on a chart in Excel to be the same colour as the background colour of a cell in a table in Word. Here's the cunning bit... RGB(156, 186, 90) added to a table cell in Word produces a different colour in Excel (Word appears...
  15. RobHudson

    Window Media Player in .Net Compact Framework: How to?

    Hi all I was wondering if anybody has any experience of developing with WMP in DNCF? I've done some seraching but not coming back with much. The intention is to develop for Windows Mobile 6 and I need to use the Open URL feature that is available in WMP. Thanks for any advice/help ;) Rob
See more

Part and Inventory Search

Back
Top