Recent content by ktchan741

I have created a form using vb.net. The form has the following fields and a Datagrid: a. Revision b. Installation c. Part No d. Qty e. Description f. Change Rev (Field is Disable - autofill based on criteria) The form also has the command buttons: Save and Close For initial revision "-", I am...

cjburkja, the OnSave function is written. I tried your code but it does not work?? Is something missing?? Can u advise. Thanks.

I have created a form with a DATAGRID and the following entry fields: a. INSTL b. QTY c. PART NO d. DESCRIPTION I also created the following command buttons: SAVE and CLOSE. I have no problem in capturing the entry from the above field into the DATAGRID. However, is there anyway that the text...

PankajBanga, Thanks for the advise. Based on your code, I am able to ensure that user can only key-in a numerical value in the text box. However, the numerical value I key-in become 0 when it is shown in the Table and the printout. Any other question is there any way to control the number of...

I created a field on a form using a textbox. Can anyone advise how to make textbox accept numeric value (with decimal) only? Now, whenever I keyed-in a number with decimal (e.g. 1.130), only 1 appears, the decimal places disappear? Advise appreciated. Thanks.

Is there anyway to auto-resize the width of a column header? I have created a data grid using the following: Dim objTable As DataTable - objDS.Tables(0) objTable.Columns(0).ColumnName="First Name" objTable.Columns(1).ColumnName="Last Name" Upon execution, the column name (i.e. First Name and...

Can anyone advise what is SQL Enterprise Manager? Is there an equivalent (freeware or shareware) that has the same functionality of that of SQL Enterprise Manager? Appreciate advise. Thank you.

Can anyone advise if MSDE work only on Microsoft 2K server? Will MSDE work on Novell Network Server or NT Server? Recently, I have an application that is created to be used in MSDE 2000. But when it was installed on the Novell Network Server, it failed? Can anyone advise why? I am not a...

lupins, thanks for the advise. How can the .mdw file be created then? Does the .mdw file point to the .mdb file? I have an access application that is executed from a short-cut. It runs fine on the laptop. However, when the it is loaded onto the PC, the short-cut no longer work. I change the...

Can anyone advise what is .mdw file? What does it do? Thanks,

Hi, I have created a Form_A and Table_A, Table_B and Table_C. In Form_A, Table_B and Table_C are sub-form placed in a Control Tab in Form_A. Table_A is part of Form_A but not in the Control Tab. I have created a "CANCEL" command button. What I am looking at is to ensure that when I...

Hi, Thanks.

I have read the help file on multi-user access for MS Access but do not quite understand how to go about it. If the database is residing in the network drive: Can two different users access the database but different recordset at the same time? If different users are accessing the databse at...

Hi, Thanks again. I tried what you suggested. It is kind of messy really. What I am looking at is to ensure that when I click on the "CANCEL" command button, no data is saved in Table_A, Table_B and Table_C. Your code work perfectly with only Table_A in the Form_A. When I inserted...

Hi, I am using mainform/subform structures. in Form_A, Table_A is the main form Tabel_B and Table_C are the subform in the Control Tab. The three tables are related by the PNo that is in each Table. Thanks.