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

    Sending Error 0x800CCC0F, SMTP Service Restart in order to work.

    Mail are not able to send out. Task 'Bernard Email - Sending' reported error (0x800CCC0F) : 'The connection to the server was interrupted. If this problem continues, contact your server administrator or Internet service provider (ISP).' This is my Outlook Settings. Incomimg Mail (POP3)...
  2. bernardng

    Lock Cells with Specify Range If Cells contains value

    Hi, I have data in Range("A2:D3")inside Range("A2:D16"), when button is pressed this range should be locked. and Range("A4:D16") should unlock. Everytime update button is pressed, the program should check Range("A2:D16"), and count which rows contain data, if row 1 & 2 contain data it should...
  3. bernardng

    How to set up WSS extranet access?

    Currently my sharepoint server is running on MS Window 2003 Standard Edition, with WSS + WMSDE. My sharepoint site work fine on locally(Intranet). I wonder how do we set WSS to access via extranet? Do we need ISA Server 2004? or SPS 2003? We have Fortigate Firewall Installed behind this server...
  4. bernardng

    Find 2 Match Words Then Cut Selected data to..

    I need to write a coding to identified the specified row is stated Completed or Not Completed, If Completed the selected row will cut and paste to Completed Task (Next Sheet), Not Completed will move down to bottom. I have wrote a coding with using FIND method to searching the Completed word...
  5. bernardng

    Cut selected data frm sheet1 paste to sheet2??

    In Sheet1, I have data in A2:F2, follow by G2 have checkbox1 (using Control ToolBox VBA),similiar data in A3:F3 and G3 have another checkbox2. A4:F4 and G4 have another checkbox3 Example, If checkbox1 box is untick, the Range("A2:F2") is Select and Cut to A14:F14 (First Row) If checkbox2...

Part and Inventory Search

Back
Top