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 strongm 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: hmcheung
  • Order by date
  1. hmcheung

    Outlook XP and net folders

    Hi, I think you must use Exchage Server for sharing contacts from Office XP onwards. Check out this page: Microsoft OutlookR 2002 discontinues support for Net Folders http://office.microsoft.com/assistance/2002/articles/OlNetFolders.aspx Hope that helps~ Andy Cheung Please visit my WebCam...
  2. hmcheung

    how to delete all calendar events?

    Well, the duplicated records are in Outlook 2002, and I have a backup in a pst file which is good (no duplicate). what i want to do is to delete all records in outlook, and then import from the pst file again... Please visit my WebCam!! http://www.hmcheung.com/
  3. hmcheung

    how to delete all calendar events?

    Hi all, How can I delete all calendar events? It's because I've messed up with my pocket pc synchronization and many of my calendar events are duplicated, some triple. I have a backup .pst file and want to apply it but i'd like to clear all the mess away first. Any ideas? Thanks ! andy Please...
  4. hmcheung

    respond to mouse click in presentation

    Hi all, I don't know if this is the right place to ask this question, but it is related to presentation, which in turn is related to powerpoint. I saw some videos in this website: http://www.learnvisualstudio.net/ and when the are making a presentation, the mouse click actions are...
  5. hmcheung

    .NET Framework in Windows NT 4 SP6 & IIS 4

    ASP.NET is not working on IIS 4.0, you have to upgrade to win2k or xp. you'll be able to install the .net framework successfully but ASP.NET just won't be working. I've tried that with Beta 2 and it just can't display the page. Please visit my WebCam!! http://www.hmcheung.com/
  6. hmcheung

    decrypt a stor proc

    after I have encrypted a stor proc, how can I know the definition of it? I only want to prevent others to know the definition, but sometimes I've to refer to the definition myself, how can I decrypt it if I have totally forgotten the definition? Thanks... Please visit my WebCam...
  7. hmcheung

    cross join in VFP 6

    Can I use cross join in VFP 6? I tried it but the word 'cross' didn't turn blue and I can't get the desired result. Any ideas? thanks very much! Please visit my WebCam!! http://www.hmcheung.com/
  8. hmcheung

    What's window's locale?

    I read from book: Windows collation is based on the rules for an associated windows locale. What does this mean? What's the locale of Windows? Thanks! Please visit my WebCam!! http://www.hmcheung.com/
  9. hmcheung

    backup error 42000

    Anyone encountered an error 42000? When I use EM to backup my pubs database to a directory other than the default backup directory, I've got an SQL-DMO error (ODBC SQLState: 42000). It says 'Cannot open backup device 'D:\sql_backup\pubs.bak'. Device error or device off-line. See the SQL Server...
  10. hmcheung

    open dbf in excel 2000

    yeah thanks. *:->* so I have to do a import/export anyway if I'm using foxpro 6.0. Just wondering why for a 2.6 table I can open it directly in Excel 2000 but for 6.0 table I have to do an import/export? s-) Please visit my WebCam!! http://www.hmcheung.com/
  11. hmcheung

    open dbf in excel 2000

    Hi, I have a free table created in foxpro 6.0. I've exported it to a foxpro 2.X format. When I tried to directly open them in excel2000, only the one in 2.X format can be opened. the 6.0 one returns a wrong format error message. Is there any method to directly open a 6.0 format free table in...
  12. hmcheung

    How to change text dynamically?

    Hi, I have thumbnails in one frame, by clicking on the thumbnail, the photo will appear in another frame. Now I want to display a description for the photo in text (not in a text box or text field) at the same time I click on the thumbnail. How can I accomplish this? for the photo I can control...
  13. hmcheung

    text searching --

    Thanks! In fact I just found the usage of * from the book 'Inside SQL Server 2000'. And it can only be used at the end of the word, not in the front. therefore ' "Micro*" ' is OK but ' "*icrosoft" ' is not OK. for Oracle's context option, the same applies. I think the logic...
  14. hmcheung

    text searching --

    ...I've tried to use the wild card search but it can't return the rows I expected. Using the previous example, my query has changed to this: select * from table where contains (' "Micro%" ') but it still can't locate the record. neither can select * from table where contains ('...
  15. hmcheung

    text searching --

    IC... thanks.. but how can SQL server do this? what's the algorithm behind the full-text search? Coz I'm testing full-text index on a column of 255 length and 370,000 records. SQL Server is able to return just the relevant records in a bang. This is quite amazing to me and boss. I've tried to...
  16. hmcheung

    full text index collation problem

    I have a field that is full-text indexed. This field contains traditional chinese charaters and the collation of this field is set to 'Chinese_Taiwan_Stroke'. But when I query for a chinese word it says: Server: Msg 7619, Level 16, State 1, Line 1 A clause of the query contained only ignored...
  17. hmcheung

    text searching --

    ...string, but not a sub-string of it. For example, if one record contains the word 'Microsoft', this record will be returned if the query is select * from table where contains (' "Microsoft" ') but not select * from table where contains (' "Micro" ') Is there any way to...
  18. hmcheung

    error 8152

    I want to do this: update table_1 set col_1='ABC' + rtrim(col_2) but I get this: msg 8152 String or binary data would be truncated. the statement has been terminated. How can I get around this error? Thanks! Please visit my WebCam!! http://i.am/andycheung...
  19. hmcheung

    varray equivalent?

    Hi, Is there anything in FoxPro like the VARRAY datatype in Oracle? So that I can put, for example, more than one email address for each record in my employee table. Thanks! Please visit my WebCam!! http://i.am/andycheung
  20. hmcheung

    How to query for a list of physical location of all the databases?

    What should I do in QA to obtain a list all the physical location of DBs on my SQL Server? I mean the location for all the .mdf and .ldf files. Thanks! Please visit my WebCam!! http://i.am/andycheung

Part and Inventory Search

Back
Top