Search results for query: *

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.

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

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

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

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

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

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...

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

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...

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...

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

Hi I put a command button to move 2 types of records. But have problem using MsgBox for user selection. I try to modify the system MsgBox, but it didn't sound right. How do I replace "yes" and "no" to "ARCHIVE" and "INACTIVE" option? Thank you for help. Private Sub MoveRecord_Click()...

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...

Hi, Originally, I put 2 command buttons which move 2 types of records to 2 separate tables. Now, I combine these 2 command buttons as one, and it has 2 selections, yes/no. If the user select Yes to move completed records, it works, but if they select No to move archive records, the...

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...

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...

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...

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

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...

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...