Search results

hi accesshero, Your query works perfectly but i want to do it using subquery. Can you give some idea ?

Hi, I have a student table with stdno,stdname,stdmajor,stdgpa etc as columns. I need to create a Sql statement to find : For each major ----the stdno,name and gpa of student with highest gpa. The following stmt gives error,pls help SELECT StdMajor,StdNo,StdFirstName,StdLastName,StdGPA WHERE...

Hi, I noticed a problem in my current form say customer When i add education_ details through another form, it opens another window and i am able to add/save the details. Now on closing the form and returning to the original window the information is not refreshed ie it does not display the...

Hi, I am done with the form in access 2003 and now only need to make it look good.I have two questions -- 1. Is there a way to remove the extra blank record in form which is to insert new records. 2. How to change the background color of the command button ---Rosh

yes thanks a lot for the example. It solved my problem :)

Thank you all for your patience and help. God Bless you all !!!

hi, I have put After Update on option group as =[Forms]![F_AddNewMember]![Faculty subform].[Visible]=True But it doesnt show subform --Rosh

Hi, I have 3 option box- faculty,student, staff.All mutually exclusive. i have updated as per forum advice the following 1. On Focus in Faculty option : =[Forms]![Subform_Facuty].[Visible] 2. On Focus in Student option : =[Forms]![Subform_Student].[Visible] 3. On Focus in Staff option ...

Hi , I am still stuck.I feel i am near to answer but doing some mistake I get this error :The expression On Got Focus you entered as event property setting produced the following error:The object you referenced in the Visual basic procedure as an OLE object isnt an OLE object. Thanks so much...

Hi, I am not able to set the On Update Event of the option group as you mentioned. The option group has mutually exclusive options How do i set subforms visible and not visible for each option separately --Rosh

Hi, In my university database i have a member,faculty ,student and staff table. I have a new member form and depending on which member type (attribute)i want to display the corresponding faculty, student or staff table.All other subform should be hidden. Could you suggest some workaround --Rosh

Thanks so much

Hi, I am new to access, i have a insurance database with customer table and policy table.I have created a form which displays customer as well as existing policy info. I want to have 'add policy' so that it open policy form to insert new policy My problem is that when i add policy subform it...

Hi, I need to create a single form for insurance db(Access 2003)with customer info and insurance policy info. I have both customer(primary key=customer id)and policy table (primary key=policy id)in the db. Can somebody please help me in creating the form as one customer can have multiple...