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: markros
  • Content: Threads
  • Order by date
  1. markros

    How to save Excel 2010 with Memo fields

    In the thread184-1633357 I read about solutions but they don't seem to work for Excel 2010. The memo field is getting truncated. Do you know of any way to get Excel fully output the Memo field for Excel 2010? Thanks. PluralSight Learning Library
  2. markros

    MS Forms 2 Textbox and Unicode data

    In the closed thread184-1624353 I found a reference to MS Forms 2 Textbox control. By specifying the ControlSource property of this control, I can display data (which are varbinary) just fine. My question is how to save the input data? Thanks. PluralSight Learning Library
  3. markros

    Get number of copies correctly

    In this thread184-1538957 I see a very interesting code posted by Mike Cagnon. However, it doesn't correctly determine the number of copies. Can someone please check it and tell, what has to be corrected? Thanks. PluralSight Learning Library
  4. markros

    Is there a way to find max allowed size of the database?

    I am wondering if there is a way to figure out the maximum allowed size for the database using a query in SQL Server? As we know, the limit is 4GB for SQL Server 2005-2008 Express and 10GB for SQL Server 2008 R2 Express. I don't want to hard-code these limits, I want to be able to run a query to...
  5. markros

    How to find directory rights

    I see a similar topic discussed in this closed thread thread184-1586937 I do understand we can use a test file to find if the user has read-write access to the directory. I am wondering if there is another way to find this info (say, with Windows API functions)? PluralSight Learning Library
  6. markros

    CLR to MD%

    thread183-1268145 I thought I'll post a link to a great blog on this topic in case it helps someone [link ttp://blog.waldenl.com/2009/12/computing-md5-hash-of-varbinarymax-in.html]Computing MD5 for varbinary column using CLR function[/url] PluralSight Learning Library
  7. markros

    FileFormats for Excel SaveAs

    Hi everybody, In reference to thread796-1250892 I need to find all possible formats for SaveAs dialog. I'm googling for 5 minutes already and nothing useful yet come up listing all possible formats. Found this http://www.rondebruin.nl/saveas.htm but only a handful of formats listed there...
  8. markros

    Get UserID of currently logged user

    I found this thread855-1169200 (which is closed). How can I get UserID without a trip to a database? Thanks. PluralSight Learning Library
  9. markros

    Beautify - how to save?

    Hi, When I right-click and select Beautify from the context-menu, I always have to select UPPER case instead of Mixed case. How can I make this setting persistent? Thanks in advance.
  10. markros

    Congrats, Jeff!

    I see you published a new version of your article here http://www.sqlservercentral.com/articles/T-SQL/68467/ Congratulations!
  11. markros

    CTE performance

    I remember we had a discussion a while ago about CTE performance. Today's thread on MSDN http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/45c9f739-6aa2-4ffd-a9b3-69a8fb9b9be3 may help in understanding.
  12. markros

    Any way to use this information with Report Listener

    Re thread184-1538957 How can we use it with Report Listener? Thanks.
  13. markros

    Stripping out all non-alpha numeric characters from the field

    Hi everybody, I haven't worked with MySQL before, I worked with other databases (SQL Server, etc.). I have a task to remove all non-alphanumeric chars from the field. I've just installed MySQL tools, but I'm not yet sure how to connect to the server - need to check with my colleague here...
  14. markros

    Hierarchical CTE - can not make it to work :(

    Hi everybody, I could not figure out this problem - I need to show parents with their children ordered by RightsOrder declare @Test table (pk_rights Int, fk_rights int null, RightsName varchar(max), RightsOrder smallint, Description varchar(max)) insert into @test select 1...
  15. markros

    Simple way to find the differences

    Hi, I have two tables - one has ConfigID CategoryID FeeDescription Amount Taxable Selected fields I have a subset for particular ConfigID and CategoryID in another table. I'm thinking what would be the easiest way to compare them both and update the main table based on the changes in the...
  16. markros

    Grid with editable Yes/No field

    Hi, I'd like to be able to have a column in a grid bound to a logican field that would display "Yes or No". I also would like to be able to edit this field. If it would be only for display, it would not be a problem. Any ideas of how to make this field editable? Thanks.
  17. markros

    How to create a hook method

    Hello, I have a mover container class. It has 4 buttons (Move one, Move All, Remove One, Remove All) and also allows drag-drop. Move/Remove one calls this code * Move the highlighted entry in the source listbox to the destination listbox. This.parent.MoveOne(this.Parent.lstSource...
  18. markros

    How to force Outlook to send items from Outbox

    Hi, We have an application that sends appointments through MS Outlook using redemption to suppress the security warnings. Unfortunately, we seem to have a problem of items sitting in Outbox and not sent right away. We tried this code loFolder = loNameSpace.GetDefaultfolder(4) && Go to...
  19. markros

    Complex data structure - how to run the select statement

    Hi everybody, I have a table called RouteDetail that has RouteDetailCategoryID field and nID Field. RouteDetailCategories table has an ID field and a cDescription field which is a table name. Currently there are 3 records only in the Categories table. My question is - how should I try to...
  20. markros

    Understanding RI model

    Hi everybody, I'm guessing I have an issue with Database RI model, because I'm working with the old application. Ok, here is the question. Is it possible conceptually this model Child1 FKField Parent PKField1 Child2 FKField2 Parent PKField2 --------------------------- In my case I have a...

Part and Inventory Search

Back
Top