Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ktchan741
  • Content: Threads
  • Order by date
  1. ktchan741

    Comparing Data

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

    Questions on DATAGRID

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

    Numerical Value

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

    Resizing Column Header?

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

    SQL Enterprise Manager Queries

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

    Question on MSDE

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

    What is .mdw?

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

    Main/Sub Form Questions

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

    Question on Multi-User Access

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

    Questions on Data in Form and Table

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

    Page Header of Sub-report

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

    Help on generating custom Reports from a query

    I need advise and help to generate a report from a query. I created two Tables, a query and a form: Table_Parts Table_Usage Query_Parts_Usage Form_Parts Table_Usage is a sub-form of Table_Parts in Form_Parts Table_Parts comprises of the Qty, Parts No (Prime and Sub) and Description. A prime...
  13. ktchan741

    Questions on data in Form and Tables

    I have created two tables namely Table_Drawing and Table_Sign. The Table_Drawing contains the following field: No, Rev, Title The Table_Sign contains the following field: No, Rev, Drafter, Checker, Approval I have created a form frmEntry with the Record source [Table_Drawing] and have the...
  14. ktchan741

    Search Recording Using A Form

    I am new to Microsoft Access. I created a Table called Table_Drawing containing data column Drawing_No and Rev. Can anyone advise how to create a Form that ask user to key-in the Drawing_No. If the Drawing_No is found in the Table_Drawing, the Rev available will be shown in the same form (in...

Part and Inventory Search

Back
Top