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

    How to retreat serial # from the opering system CD

    Hi, I tried to reformat my laptop, but lost the original SERIAL # of the WinXP CD. Is there a way to retrieve serial # from my system ? Thanks.
  2. hu5

    windows XP freeze on first start up, reformat doesn't help

    Hi electronicsfreak, To respond your question, I completely erased it then install a fresh copy of windows XP. Your further feedback is greatly appreciated.
  3. hu5

    windows XP freeze on first start up, reformat doesn't help

    My Win XP freeze in 1-2 minutes when first startup, sometimes, it gives noise. Restart pc will resolve the problem. After I reformatted pc, the problem persisted. Is this a hard drive problem or some other parts? Thanks for your feedback. Hu
  4. hu5

    Firefox browser doesn't load

    Thanks dnevill for replying. I assume you are referring to Tools - Extensions, There's no extensions to remove, it's disabled - not compatible with Firefox 1.0.3 Hu
  5. hu5

    Firefox browser doesn't load

    Hi, After upgrading firefox at prompt, the browser failed to load. I uninstalled firefox, and reinstalled it, still not working. It's all blank except the browser border, and error message reads: can't not find this site... Thanks for any suggestion. Hu
  6. hu5

    combine every 2 rows (a record) into one row in Excel

    Thank you, Kevin and Ken, you've been very helpful and kind. The macro works now, must select the rows to be concatenated, and it will do the trick. Hu
  7. hu5

    combine every 2 rows (a record) into one row in Excel

    Kevin Thank you for the great code, it works with 10 rows even 20 rows, but when I change NumberOfRows = 20262, it ran a long time but didn't work at all. I tried with 10 rows again, it's not working either. I closed file & reopened, still not working. macro is enabled. Do you know...
  8. hu5

    combine every 2 rows (a record) into one row in Excel

    Ben, The formula =OFFSET(A$1,(ROW()-1)*2,0)&" "&OFFSET(A$1,((ROW()-1)*2)+1,0) works beautifully, but when I delete the original range A1:H20, I got #REF! error value in every cell range of A1:H20, and the new paste data are all gone. How do I fix this problem? Thanks. Hu
  9. hu5

    combine every 2 rows (a record) into one row in Excel

    for Kevin, Yes, your macro works, thanks very much. As I'm new with macro and would like to have more information. Although Each web page contains only 10 records, my files is as big as 15,000 records. I wish to cut 30,000 rows in half. This macro only works when select a row, and...
  10. hu5

    combine every 2 rows (a record) into one row in Excel

    Thank you all. It's a secure website requires login. But the example as follows: The format in Excel after copy from the website looks like the following, one records split in two rows, all columns have values in them. A B C 1 first...
  11. hu5

    combine every 2 rows (a record) into one row in Excel

    Hi, I copied a spreadsheet from a website, then pasted it in the Excel worksheet, it's a 10 rows table, but due to the key entry by the author, Excel made it 20 rows. Is there a way to combine every 2 rows (a record) into one row in Excel? Thanks. Hu
  12. hu5

    How to customize MsgBox

    ...records to move") = vbYes Then On Error GoTo Err_MoveToArchive_Click Dim stDocName1 As String Dim stDocName2 As String If DCount("*", "[certStatus]", "Status Like '*archive*'") = 0 Then MsgBox ("No more archive record to move.") Exit Sub End If ... else On Error GoTo...
  13. hu5

    combo box doesn't reflect the change from the other combo box's select

    I have 2 combo boxes, "findRecord" retrieves record based on "SRM No", the other "Type" which has several types like "Cert";"Report";"MSDS";".... Some records have duplicate "SRM No" with different types. for example: 114p Cert and 114p MSDS.... When user search the record with dup "SRM...
  14. hu5

    Combine 2 command buttons error message

    ...' Private Sub MoveToArchive_Click() ' On Error GoTo Err_MoveToArchive_Click Dim stDocName1 As String Dim stDocName2 As String If DCount("*", "[certStatus]", "Status Like '*completed*'") = 0 Then MsgBox ("No more completed record to move.") Exit Sub End If stDocName1 =...
  15. hu5

    One command button has 2 selection

    I put a command button for user to move 2 type of records to 2 separate tables: The caption is "Move completed/inactive records to archive". When user click the button, it should give 2 choices, "completed" and "inactive", like msgBox or pop-up. I don't know how to use the msgBox...
  16. hu5

    How to relate optionGroup box with combo box ?

    I set up a optionGroup box called Type which has 5 different type, and a combo box called FindRecord which shows 2 fields consists of SRM NO & Type. When user select a SRM NO(Text) to find an existing record, the type optionGroup should reflect the type automatically correspond to the one in...
  17. hu5

    text box doesn't reflect the change on combo box

    TheAceMan1 Thanks very much for your effort trying to help me out. This code still not working in selecting Dup SRM No., sometimes during selection in combo box, it will ask "delete record, y,n?". most of the time, if select unique SRM No, it works. Below is my table format, for...
  18. hu5

    text box doesn't reflect the change on combo box

    TheAceMan1, [SRM No] is not numeric, so it gives me a "data type mismatch" error. Thanks anyway.
  19. hu5

    text box doesn't reflect the change on combo box

    Hi, TheAceMan1 Thanks for your help, but I still have problem with the statement, Me!Type = Me!FindRecord.Column(1), depends on where I put it in the code, it either give me runtime error '3020': "update or cancelUpdate without Addnew or Edit" or keep asking me if I want to save record...
  20. hu5

    text box doesn't reflect the change on combo box

    I set up a form with a FindRecord combo box, which shows 2 fields, first one is ID, 2nd one is type. and also has a text box name: type. and I have a sort query for rowSource property for this combo box. There are duplicate ID with different type. for example: one 410v is a certificate...

Part and Inventory Search

Back
Top