Search results for query: *

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.

Hi Roy-Vidar, Apologise, your code work perfectly. I place the code in the wrong event. In Form_A, I further added a Tab_Control with field from Table_B and Table_C. Form_A now has field entry from Table_A, Table_B and Table_C where Table_B and Table_C are in the Tab_Control. I fill-in some...

Hi Roy, Thanks for the advise. The code you provided work if the form is "Dirty". However, if the user just happen to open the form and did not fill-in any entry and click on the "CANCEL", the code does not seem to work. Can you advise how to go about it? Regards.

I have created a Form_A based on Fields from Table_A. In Form_A, I have a command button called "CANCEL" and a command button "SAVE". The "CANCEL" button when click will run a marco that will close Form_A without saving any data. The "SAVE" button when...

Hi Duane, Once again, Thank you very much for the great advise and guidance.

I have created a Report_A and Report_B. Report_B has Page Header that will be printed on every page when I open it. However when I placed the Report_B in the "Detail" section of the Report_A, the Page Header in Report_B is not shown when Report_A is preview/printed. Can anyone advise...