Search results for query: *

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

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

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

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

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

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

good idea,thankx

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

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

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

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

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

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

ThankX Tony

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

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

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