Search results for query: *

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

Hi, I converted an existing database from Access XP to Access 2000. After that, it worked OK for a while. Then, suddenly, I cannot open it anymore. Whenever I try to open it, an error message will pop up saying “Record(s) cannot be read; no read permission on ‘MSysAccessObjects’. Could anyone...

Hi marcs41 Thank you very much. It worked! :-) I don't know how I got these files sitting in my startup folders. I have a question to ask: what are DOT and XLT files? I looked at the file type and they seem to be word and excel templates. What do they actually do? Does that mean that we can...

Hi, I am having problems opening Office XP Word and Excel (Power Point and Access are fine). When I tried to open Word, an error message popped up saying &quot;Complie Error in hidden module: AutoExec&quot;. Likewise, when I tried to open Excel, an error message: &quot;Compile Error in hidden...

Hi, I have a problem starting up my computer. Everytime, I want to start the computer. The computer will either lock up itself or show up this message: &quot;While initialising device CONFIGMG: Windows protection error. You need to restart your computer.&quot; If I follow the instruction and...

Hi, sorry. I probably didn't make it clear in my previous message. I need to know how to write codes in MS Project to check if the destination (Excel) workbook is already open. Many thanks Cowper