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!

Register Log in
  • Congratulations derfloh 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: *

  1. assiri

    Linking tables

    Hi, Thankx JB, I have the Table 01, Field2 values and field 3 values in my program(these values come to seperate variables variable1 and variable2)from user input. Please tell me how to get the primary key value relavant to Table1, field2 inorder to build the relationship with Table02 (in...
  2. assiri

    Linking tables

    hi, This may be a very basic question,but please help me.. I have two tables tablel01 and tabel02,which have one-to-Many relationship(table01 is "one" side) table01 table02 field1-Autonum field1-Autonum field2-Text...
  3. assiri

    Enter data into the same record using different forms

    hi, You are correct, -I have two forms based on the same table. -A user enters data for "FIELD2" and "FIELD3" in form1 -Then move into form2 and enter data for "FIELD4" -Though there are two forms user enter data into the same record -I have used two forms because,in form1 I have two list...
  4. assiri

    Enter data into the same record using different forms

    hi, --I have two forms named "Form1" and "Form2" and a Table named "Table1" --Table1 has the following fields Table1(field1,Field2,field3,field4) --When a user enter data into "form1" that data stores in the "field2" and "field3"("field1 is an autonumber field") -Using a "Next>>" button user...
  5. assiri

    Clear Checkboxes

    Hi, I have ten checkBoxes in a access form(Check1,check2...etc) and I want to clear all other checkboxes,when I select a perticular checkBox. As an example, If select Check2, all other checkBoxes should clear if they are selected. If I select check4,all other checkboxes should be cleared. (it...
  6. assiri

    Enter data in to a table

    -I have created two(unbound) list box in design view say , ListBox1 and ListBox2 -ListBox1 has four items -When click on an item in the ListBox1, 1.It filters some data stored in a field belongs to table1 and 2.Displays that data in ListBox2 using "additem method". -When a user clicks...
  7. assiri

    Disable a List Box item

    good idea,thankx
  8. assiri

    Disable a List Box item

    Ill describe the situation and objective briefly, -There are two forms named form1 and form2 -Form1 has a listBox and a command button named"Next>>" -Select an Item from the ListBox and Press the "Next>>"Button then form2 opens -Enter some data into the form2 and press the"Finish"Button in form2...
  9. assiri

    Disable a List Box item

    Is there ant method to disable or highlight a selected item in a List Box? ThankX
  10. assiri

    Using a Class module

    Thankx...., There is a compile error in the codes' second line, which I have shown below. Private m_Form As frmCol The error message states "user defined data type not defined" Tried to define "frmCol" data type using the {Type Endtype} statement but no good results.Please let me know any...
  11. assiri

    Using a Class module

    I wonder why this is not working for me!!! For the FINAL TRY please let me know any steps that I have missed in the process, 1)Opened a new form in design view 2)Added two command buttons 3)changed commandbutton names to (cmd1) and (cmd2) in properties sheet. 4)saved the form as (frmCol)...
  12. assiri

    Using a Class module

    Even though I change the file name to frmCol, I was unable to get the output.Anyway thankx Tony assiri
  13. assiri

    Using a Class module

    Still I was not able get the required output(message box,displaying the command button caption) please guide me if I have made any mistakes during the process.I did the following steps. 1)Opened a form in design view 2)Added two command buttons 3)changed commandbutton names to cmd1 and cmd2 in...
  14. assiri

    Using a Class module

    ThankX Tony
  15. assiri

    Using a Class module

    This is regarding the faq 707-4976,Understanding events (iv)A substitute for control arrays in VBA posted in this Forum. The aim is to handle two command buttons named cmd1 and cmd2 in a user form named frmCol. I put the following code in a class module named cCB and created a user form which...
  16. assiri

    Check box groups

    hi, sorry for insufficent information -There are six sets of checkbox groups ,each group having 4 check boxes.(Group1,Group2,Group3,Group4,Group5,Group6) -Group1 has four checkboxes(check1,check2,check3,check4) Group2 has four checkboxes(check5,check6,check7,check8) Group3 has four...
  17. assiri

    Check box groups

    I have to create six sets of checkbox groups in a MS Access 2003 form ex: set1 , se2 ,set3 ,set4, set5 , set6 each set has four check boxes ex:set1 has 4 check boxes set 2 has 4 check boxes set3 has... etc.. (all together there are 24 check boxes) One or more check boxes can be...

Part and Inventory Search

Back
Top