Search results

thanks alot, your answer was pin to the point, but is there any way that we could populate the access lookup wizard with multiple values on our form so that it should not be in the form of combo box (we have to click on the combo box then select values and then press ok) rather it should be...

if this information can't help you please let me know

ok sure, in my form there is a field named select your hobbies, under this field we have multiple option such as Cricket, football, volleyball, soccer, baseball and etc. so the user may select cricker, football and soccer as his hobbies, of course these values should be stored in access table...

thanks for your quick response, this is not a multiple value field values, but it is only one field having list of options from which a user can select multiple values, but all those values related to one field say Hobbies, because a person may have more than one hobbies

Dear colleagues i have searched the web alot but couldn't find my answer, Let me clear what problem i faced, i have a form named Member, this form has field named hobbies, this field has multiple values selection i.e. a user could select football, cricket, listening to music and etc. these...

it doesn't work assume my subform name is loan which is on loan page of the tab this subform loan has a field named as MemID and i want to refresh this MemID whenever i select a specific group on the main form...my scenario is that when ever i select a specific group on the main form, on the...

Hello Every one hope you all are doing well! i have a problem in requery function i cant requery a subform from main form i have a table say table1 and a tab control say tab1 and in this tab control i have four pages on each there is a subform i want to refresh one of these sub-forms field, i...

ok let me shed light on that....we have seen bank account statements which shows list of our withdrawals and deposits same thing i want to show list of loans and list of repayments for a specific member...for better example i have attached an word file of what i want

Plz refer to summary sheet query in the attached db

Hello Friends Hope you all are doing well i have a bit problem in a query i have groups and members tables in which each group is formed from no. of members, each member can take loan and will return this loan in a no. of installments so here my problem is when i run the query to retrieve no. of...

Thanks Alot JHB for your nice and fruitful reply

hello friends wish you all are happy and healthy!!!! Dear friends i have a problem in form creation i have two forms one is group form which is the parent form and woman form which is the child form when i enter data in these child and parent forms individually there is no error but when i...

i really appreciate ur endevour.... thanks again for your nice and ontime reply

Thanks for the nice reply i have created two combo box of countries and their cities, but when i select a specific country its respective cities doesn't appear in city combo box, so i attached an example of my db in this reply plz explain my error in this db

Hello my dear sincere and lovely friends hope each one of you are doing well!!! i just had a little bit difficulty...let me explain my scenario i have a list of groups these groups each have their list of members each member takes loan and repay the loan in a no. of installments my problem is in...

ok plz let me attach my db sample go to school servey then filter master table by a specific incident number then check the tab election relates incident, you will not see any record for that master table record, now go down of the sub form tab and press unfilterd command of sub form then u...

Yes, i want to show one record on the main form at a time and i may modify the sub form records related to the main form record

Yes you are very correct....but when the master form is filtered, the sub-form also gets filtered and i can't see records related to my master record, and when i press unfiltered button on the sub form the records related to master record gets appeared on the sub form

Assume i have a school servey form, this form has two subforms election threats form and election incidents form... i already have a number of schools entered in my database now if i try to filter school main form for a specific record i should get that specific record and its related data also...

Hi Dear friends and colleagues!! Hope my greetings find each one of you healthy and successful, i have faced with a problem while i was filtering my main form.....my problem is when i filter the main or parent form the related sub-form also gets filtered how to manage the main form so that when...