Recent content by Cowper

Hi, thank you both LPlates and vb5prgrmr. :)! I've found out where I did wrong -- I didn't place a break point in the loop. What an idiot I am! As for LPlates' question about the major advantages/use of the Watch window, I can probably asnwer it by copying some words from the VB Certification...

Hi, I am preparing for VB certification exam and have a question about debugging Watch window. I hope someone can me some input. The following is the code I tried to use Watch window to monitor. However, every time, I add variables counter and intNum into Watch window. The value column shows...

Hi, I am reading a VB certificate exam book for my upcoming exam. There is one question about optimising an application that I don't understand and needs your help. The book says one tip for increasing performance is to cache properties in variables when you are using a loop. The reason is it...

Hi, I created a Access database. It has to use libraries, such as ADO 2.7, ADO Recordset 2.7, and ADO Ext 2.7 for DLL and security. However, it works fine on some computers at our office but not all of them. I tried to update DLL files, which sits in C\Program Files\Common Files\System\ADO...

Hi, I am wondering if anyone can help with this problem. I tried to use "UpdateBatch" method on ADODB recordsets. I set cursor type to adOpenKeyset and LockType to adLockBatchOptimistic. However, the method only updated the first record. For the following records, an error message with...

Hi, Could anyone help me with this? One of my colleagues lost five files and I tried to restore them from backup tapes, but all no good. I am wondering if there is a backup restriction on files saved certain levels down from the root file. Files I tried to restore has a path as follows: G ->...

Hi, I forgot to mention one thing when I first posted this note. I need code about how to use "acExportFixed", for example, how to define the argument and how to defind width in each field. Many thanks Cowper

Hi, Could anyone tell me how to find "sample code" that can export data from a table or a query to an existing Text file so users can read it from Notepad ? Many thanks Cowper

Hi, jbehrne Thanks for your advise. It works beautifully. Cowper

Hi, Could anyone help me with this problem? How can I make the size of a form unchanged? The problem I have is whenever I open a form and then click a button to open a report. If I maximize the report and then close the report, the original form or database window will be maximized as well...

Hi, johnodq Thank you for your advice. It worked! ;-) Cowper

Hi, WindowWizard The port name is LPT1. It's a typo. :-< Cowper

Hi, Could someone help me with this one? I tried to connect Canon BJC 2000 SP printer to my desktop computer which runs Windows 98. But, whenever I tried to print, there was an error message saying &quot;There is an error writing to LP1. Please check if the cable is conntected properly and the...

Hi, Could someone help me with this one? I tried to connect Canon BJC 2000 SP printer to my desktop computer which runs Windows 98. But, whenever I tried to print, there was an error message saying &quot;There is an error writing to LP1. Please check if the cable is conntected properly and the...

Hi, annsolomon and billpower Thank you to you both. I will do what billpower suggested first and take annsolomon's suggestion as a last resort. But, I have a question for billpower. Could you tell me more about how to use the Decompile function? If the address of my DB is G:\Access Files...