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.

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

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

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

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

When I insert a new record on the form, and refresh record, the table will not reflect the change until I sort the ID column in the table or close and reopen the table to see the new record appear. and if I delete a record from the form, the "#deleted" appears in every field of that record in...

Hi, I put a undo change command button on the form, it only undo the very last change. The Task textbox will send data into field13 thru field35. If user enter Task once, and decide to undo change, the record will be deleted. If user enter Task twice, two separate data already get...

Hi, I use one command button to control 2 queries, after adding all completed records to archive file, it should delete completed records from the original file. I want to create a prompt message to alert user that there's no more completed records to move when they press the Move button...

Hi, I created a form based on this table, the first textbox is for RecordID entry. If user searched for a record, typed over the existing RecordID, closed the form and re-open the form. The record now has a wrong RecordID, and it can not be undone. Is there a fix to this problem? Is...

Hi, Thank you for your kind help, the timestamp works great, but the 2nd question still having problem. I meant to move the completed record to other table, so the record also need to be deleted from the original file. Thanks again. 1. If "Text18" text string contains more than just...

I created a form based on a table, one text box is to enter text string. I wish to add date/time stamp to the text box when user refresh records, can it be set up automatically? another problem: If user type " .... completed." in the text box and refresh record, that data get...

I created a form based on a table, the TASK text box on the form is to enter text string. When user presses refresh records, the text typed in the TASK text box should be transferred into the first blank field (starting from field 13 )on that record in the table. The program looks for the...