Recent content by bitzgam

Thank you Guys for the responses. Now I understand. @MarkK you explained well thank you Sir :) @Thales sorry Sir I cant answer coz honestly I dont know the answer :) thats why im asking in the first place. Thank You again GodBless

Hello Guys hope your doing great Whats the difference with this relationship? How do they differ? Just confused :confused: See Attachment

Hello Everyone hope your doing good. in my form I have two combo box cboState and cboCity My question is: How to filter list of city in the cboCity in the corresponding State when selecting cboState example lets say I select California for State and in the cboCity all I can select is the...

Hello sir, on your combo box go to Data properties then click the Row Source and show the table tblPrjName and select the ID and the ProjectName field then on column bound set the property to 1 then on Format go to column count 2 and column width set it to 0 hope it helps

thank you very much Sir, now I know whats the purpose of Enforce Referential Integrity :) :D

Name your combo box Sir, let say cboSearch then go to your query which is the record source of your Form. In your Query go to the fieldname FirstName or LastName or a concatenation field let say ApplicantName then on the criteria type this Like "*" & [Forms]![FormName]![cboSearch] & "*"...

see attached files Sir Try edit information on Applicant1 and Applicant2 in there Voters-ID Thank you once again

Sir thank you for the response. I have a query (qryAddApplicant) and that query is based on two tables "tblApplicant" and "tblGovernmentRef". Let say on the query is has Firstname and LastName field from tblApplicant and VotersID field on tblGovernmentRef. My problem is I cant edit the...

Hello Sir, thank you for the response. in this particular problem i only have 1 form sir which is based on a qryAddApplicant My only problem is I cant Edit any Applicants GovernmentRef in a query if that applicant has no information in it.

Hello guys, I need some help. I have a form(frmAddApplicant) based on a query(qryAddApplicant) and that qry is based on two tables "tblApplicant" and "tblGovernmentRef". In the form I got a tab control(see attachment) when I add a new record, let say all the general information.and I forgot...

Thank You Sir for the quick response but really im new to access, can you show me any links for this tutorials? GodBless :)

Sir Thank you for the quick response but I'm new to Access, Can you show me any link for tutorials ? GodBless :)

Hello everyone I have a Main Form(frmApplicants) and sub form(frmApplicantsDetails) which the Data Entry set to Yes what I want is, if I double click the name of applicant in main form I want to popup the sub form along with the complete details of the applicant chosen in the main form. I used...

Hello Everyone, I am working this database about applicant application for the government.(Medical and Educational Assistance) Is it possible that I can link my database to another computer? coz I want to run it like this: *On the 1st computer I just want only the registration of Applicants in...

actually Sir the sub form(ApplicantDetails) is applicant details which the DataEntry set to Yes to be able to add a new applicant automatically. I just want that in my main form when i click the name of the applicant then the sub form(ApplicantDetails) will popup with their complete details...