Search results for query: *

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, 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, 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, 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 "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 "There is an error writing to LP1. Please check if the cable is conntected properly and the...

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, 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 "Complie Error in hidden module: AutoExec". Likewise, when I tried to open Excel, an error message: "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: "While initialising device CONFIGMG: Windows protection error. You need to restart your computer." If I follow the instruction and...

Hi, I need some help. I try to open an Excel workbook to display task schedules saved in MS project. Does anyone know how to write codes to check if the Excel workbook is already open? Many thanks Cowper

Hi, Could someone tell me where I can find free MS Excel VBA references from websites? Many thanks Cowper

Hi, I want to creat a report similar to what you can see from Gantt Chart. However, the difference is that it lists out tasks according to resources. For example, the report should look like this: Dec. 11 Dec.12 Dec.13 Dec.14 Dec.15 Dec.16 Adam --Go Camping--...

Hi, I want to create a report that will list out a supplier's information based on a supplier's ID. In other words, the report's Recordsource should change according to supplier ID (I think it should be a SQL thing). However, everytime I ran the codes (listsed below), the error message popped...

Hi, I want to create a report that will list out a supplier's information based on a supplier's ID. In other words, the report's Recordsource should change according to supplier ID (I think it should be a SQL thing). However, everytime I ran the codes (listsed below), the error message popped...

Hi, I just found a job as a database designer, mainly Access stuffs. Could anyone tell me which Microsoft certification I should try to get? Thanks Cowper

Hi Can anyone tell me how to use ActiveX Controls, such as List View and Tree View in Access? I know in Access 2000, we can insert these two controls into forms but how can I link these controls with tables and queries? How can I add/delete items from these controls? Thanks Cowper

Hi, Can anybody tell me how to use List View and Tree View controls in Access as we do in VB? For example, how can I link List View and Tree View control with tables or queries? How can I add/delete items to these controls? Thanks Cowper