Recent content by wuwang

It works. Thanks PHV.

Hi, I'm trying to copy paste a table with structure only using DoCmd CopyObject but I received type mismatch error. The command I use is : appAccess.DoCmd.CopyObject "new table", acTable, "old table" Is the CopyObject method that I should use? Thank you for your help!

Hi Dale Watson, I should apology to you and other peoples who has been helping me a lot for my 'improper' reacting. Believe me, I DO APPRECIATE the help from you all. Now I know how to issue a STAR. Thanks again.

Hello, I grab data from EXCEL and write to a text file. I want to put the log_in ID as part of the text file name (user DOESN'T NEED to provide his log_in ID when he uses EXCEL application). How to "memorize" the log_in ID and grab it to the text file name? (I was told to use...

Hello, I have one more question need help. Once my text file is created, how to have this file with read-only atrribute so the other people won't change anything in the text file. I need code example. Your help will be very appreciate.

Hi Skip, It works. Thanks for much. YOU ARE GREAT.

Hello, I read file from EXCEL and write into a text file. The output in the text file is SQL statments and the output have double quote in tne beginning and in the end. How to get rid of the double quotes in begin and in end???? For example, the output in text file is: "Update table1...

Very sorry to confuse you. Please disregard about my first question about the digit "3". A typo in my code.

Thanks guys. I hope you don't mind I have more questions about this issue. What's the meaning of 3(the first digit) from the output : "Update_testfile32901024911.txt" Is it possible to avoid the "3"? Besides, if there is a function to force the time with East time? The...

Hello, I tried to use the following code (from EXCEL to text file) to add system time (eastern time) as part of my .txt file name. So the file name should be Update_testfile3_systemtime.txt Open ThisWorkbook.Path & "\Update_testfile3" & Now - Int(Now) &...

Hi, I want to write data from EXCEL to a text file. I would like to have the file name like Update_testfile3_systemtime.txt I used: Open ThisWorkbook.Path & "\Update_testfile3.txt" & systemtime & ".txt" For Output As #1 Do you have idea that which function I can use...

Thank you a lot for your great idea. I used the code If InStr(1, vData2, &quot;.&quot;) <> 0 Or Abs(vData2) > vData2 Then ................. and it works well. Thank you again.

I careated a form in EXCEL. I want to put the code in the form. This code will cleanup the background color in the worksheet once the form initialized.

Hi, I want to validate data to make sure it is NOT either decimal or negative number. I used &quot;If Not IsNumeric(vData2) Then .....&quot; but it didn't work well. Is there any other function I can use in EXCEL 97? Thank you in advance

Thanks Chris. I put the code like this Workbooks(&quot;xxx.xls&quot;).Worksheets(1).Interior.Color = vbWhite But I recieved a error said &quot;Object doesn't support this property or method. Mine is in EXCEL 97.