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 Wanet Telecoms Ltd 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. DiegoErnesto

    The assembly * could not be found at..."

    Hi; I changed the project for excel VS 2003 to VS 2005; when I try open Excel file doesn't execute dll; appear: "the message The assembly * could not be found at or could not be loaded" I install Service pack 1 to Office 2003, Office 2003 PIA, install for office 2003 KB907417, but nothing...
  2. DiegoErnesto

    How I create function for Excel from Shared Add-in...

    Hi; I create Shared Add-in for excel; but, I don't know how create function. I want use: =Test(param1, param2) Thanks.
  3. DiegoErnesto

    Slow partition process when fact table has more than 1'000.000 records

    Hi; Please; when I have the fact table less than 1'000.000 records the process take time 6 min. but when the fact table pass this amount the process take time 45 min. Analysis services 2000, enterprise edition, SP3A Windows 2003 Before; I didn't have problem in windows 2000. What happend...
  4. DiegoErnesto

    Change Mousepointer

    Hi; try with Application.Cursor Hope this helps. bye-bye..
  5. DiegoErnesto

    Conditional formatting...How do I know cell status?

    Hi, again... Try, with below code, but not work with conditional format, only common format... For Each singleCell In Range("Data").Cells InteriorColor = singleCell.Interior.Color MsgBox Str(InteriorColor) Next if you will have another idea... Bye, bye and thanks...
  6. DiegoErnesto

    Conditional formatting...How do I know cell status?

    Hi. I have a excel workbook that contain cells with many different conditional format, and I have a macro that scroll all cells but I can not recognize individual status cell (ColorIndex: Red or Green) and take different walk. Thanks...
  7. DiegoErnesto

    using different hierarchies for different user

    Hi did you try setting Database Roles?
  8. DiegoErnesto

    orderby clause with primery key

    Hi; trader.id doesn´t have in select fields...
  9. DiegoErnesto

    Use SQL statement with ADODB.Recordset ????

    You have two options... 1.- creating the string correctly: CString sSQL; sSQL.Format("INSERT INTO other_info(card_id) VALUES ('%s')", m_editbox1); recordset->Open(sSQL); 2.- use parameter pointer and your methods CreateParameters and Append... Good luck...
  10. DiegoErnesto

    How do I send message when I edit Tree view?...

    I have a app when the user edits a node of tree view it should send a message to indicate that node change... I have implemented the "ON_NOTIFY_REFLECT(TVN_SELCHANGED, OnSelchanged)" How do I active this event?. I try with "SendNotifyMessage(TVN_SELCHANGED, 0, 0)" but this...
  11. DiegoErnesto

    TreeView, ListView and Forms

    try with sample from MSDN Visual C++ 6.0 "DAOVIEW: Database Browser" it's exactly like you want... Good luck...
  12. DiegoErnesto

    What is the user network to assign permission to do backup?

    Anyone know user network assigns permission to do backup network drive... Permissions assign full control to disk to: Administrators group but isn't permit... when assign full control to everyone... work! what is the user? thanks...
  13. DiegoErnesto

    How do I recover cubes from physical files?

    I have a big problem... The disk crash and I have only the backup of the disk that contains data directory; but I don't have .CAB of the cubes. What do I do??? please help!!... Thanks
  14. DiegoErnesto

    Need help with sp_executesql and the Keyword IN ()

    Hi; when you use sp_executesql with parameters is not equal to concatenate string. If you try the statements below verify this. The advantage is that sp_executesql more efficient because it generates execution plans that are more likely to be reused by SQL Server. declare @list varchar(50)...
  15. DiegoErnesto

    Do I need a complex select?

    Hi hortensiam; update <table> set <field> = '<string>' where <field> is null Bye...
  16. DiegoErnesto

    SQL SELECT DISTINCT returns duplicates...why???

    Hello Peter; Try This: SELECT t1.IPAddress, t1.LogID, t1.Domain, t1.Browser, t1.WebAddress, t1.PageLoaded, t1.Parameters, t1.DateCreated FROM tblLogs t1 (SELECT DISTINCT TOP 100 IPAddress, max(DateCreated) as DateCreated FROM tblLogs GROUP BY IPAddress ) as t2 WHERE...
  17. DiegoErnesto

    Problems when copy from HTML table to Excel 97

    Thanks Brian56; The problem is with a few users that work office 97, and now I don't have solution.
  18. DiegoErnesto

    How do I refresh a page in other frame?

    Hi rac2 Thanks. but, it's a report .asp and this take the month from session variable; I want to change month, this changed the session variable and refresh report. And this report is variable. Thanks, for you help.
  19. DiegoErnesto

    How do I refresh a page in other frame?

    Hi folks; I have an application WEB that display information of a month selected and report type from menu frame. The body frame display the report. I want to change the month from menu frame and to refresh the report in body frame. Thanks.

Part and Inventory Search

Back
Top