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

    Multiple page data entry form

    Hello, I need to build a multiple page data entry screen for users to enter information into the DB table. There are many fields I need to capture and store in a table. Some of the fields are multi line text field for the users to enter a few lines of text in a textbox. But right now, I...
  2. cctrinh

    How to restore a table in SQL server 2000

    Hello, Today, I accidently delete all the data from a table. I was wondering is it possible to restore a table's data from the transaction log. I don't want to restore from last night backup. I just need to restore the data for one table. I hope someone can give me some assistance on this...
  3. cctrinh

    Retrieving primary key value from the table i just inserted

    Is there a way to retrieve a primary key from the table that I just inserted using Transact SQL? I need to obtain a primary key from the table I just inserted so that I can use that primary key to insert into another table. Any help will be great. Thank you so much.
  4. cctrinh

    Tables defragmentation

    Hello, Can someone tell me which of the following DBCC command I should use to defrag a table in SQL server 2000? DBCC DBREINDEX or DBCC INDEXDEFRAG. I have more then a dozen of tables with an Extent Fragmentation of more then 90%. Also, can I use the two DBCC commands above to defrag table...
  5. cctrinh

    Users reset their own password

    You all have a good point. We all have to balance security and automated process. Orginally, I was wondering if there is any application that let a user change their own password by answering a screct question that they provided like many online web site do. If you forgot your password it...
  6. cctrinh

    Users reset their own password

    Yes, they are local user without admin. right. Are there any third party software allow them to do it like a password reminder.
  7. cctrinh

    Users reset their own password

    Hello, Does anyone know if there is way a user can reset his/her own password in AIX? We would like to have our users to reset their password when they forget it so they don't have to call helpdesk every time. Any help will be appreciated. Thanks
  8. cctrinh

    Mail forwarding rule not working

    Hi, Can someone help me. I try to setup an out of office rule in Outlook to forward all the incoming mail to my yahoo email account but it doesn't work. Please give some help. Thanks
  9. cctrinh

    Error Code 800a0cc1 mean?

    I got the following error code and don't know what it mean? Can someone help please? Thank you ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. /ASPTest/User.asp, line 21
  10. cctrinh

    Removing spaces between string

    I need help to remove spaces between the string. I used the Trim() function this remove the leading and trailing spaces. I need to remove something in between. Are there anyway that you can remove the spaces between the string. Any help will be appreciated. Thanks,
  11. cctrinh

    Setting up Session password for ARCserve/Open for Unix

    Hello, I am using ARCserve/Open for Unix version 2.2. Anyone know how to setup a session password for backup? I have setup a password protected for my backup. However, when I restore the backup from the DLT tape it does prompt me for a password to restore. I have setup a session password...
  12. cctrinh

    How to check the remaining disk space on the backup tape?

    Currently, I am running Arcserve on the AIX unix box. I can't look at the amount of disk space remain on my backup media. Is there a way you can see the disk space in Arcserve? Thank you in advance for your help.
  13. cctrinh

    How to check the desk space on the backup tape

    Currently, I am running Arcserve on the AIX unix box. I can't look at the amount of disk space remain on my backup media. Is there a way you can see the disk space in Arcserve? Thank you in advance for your help.
  14. cctrinh

    How to reset multiple text box in a form

    Thank you very much. It works perfectly. Nice work. Calvin
  15. cctrinh

    How to reset multiple text box in a form

    Hello, Can someone give me some help to reset multiple text box in a form. I know you can use the following code to reset one box but not multiple boxes. Are there any build in function to handle multiple text box. me.textbox1="" Thank for the help.
  16. cctrinh

    Copying data from one table to another table

    Hi, Can some show me how to write the codes to copy the data from one table to another. When I click on a button I want to copy the data from table1 to table2. Please help.... Thank you,
  17. cctrinh

    Forms Basics

    Make sure your form is link to a table that you want to record the data. Check the form properties again. In the text box properties make sure the text box are link to the correct field in the table. You can create a command button to update the record. I hope this will help.
  18. cctrinh

    Disable a command button when it reach the end of record

    It Really works, thank you very much. Your tip is very helpful. Just have a question. Why do you use the recordsetclone? appreciate your assistance.
  19. cctrinh

    Disable a command button when it reach the end of record

    Hi, I try to disable a command button when I get to the end of the record. The following is the code that I wrote. I declared the variable locally. Any help will be thankful. Cal Dim rst As Recordset Dim dbs As Database Set dbs = CurrentDb Set rst =...
  20. cctrinh

    Setfocus on form load

    How do you display a value in a combo box when the form load? Any assistance will be appreciate. Calvin

Part and Inventory Search

Back
Top